Database Analyst
Core
Maintains Informatica Data Quality and Data Cleansing infrastructure, executes data profiling/cleansing strategies, and manages data conversion/migration testing for CCH data systems.
Role type
Senior Database Analyst (Data Quality & Migration)
Builds
Data profiling strategies, cleansing routines, data dictionaries, and logical/physical data models for CCH data.
Domain
Data Management / Data Quality / Data Migration
Deliverable
production ML models | product features | dashboards & analysis | research | client delivery | infrastructure | physical/clinical work
Required skills
Informatica Data Quality administration, Unix/Linux shell scripting (bash/ksh), data modeling (Erwin/Visio), SQL/PL/SQL, data profiling, data cleansing, test case creation, defect management
Preferred skills
Oracle RDBMS (11g+), complex SQL/PL/SQL development, data conversion/migration planning, technical presentation to business clients
Technologies
Informatica Data Quality, Informatica Data Analysis, Erwin, Visio, Oracle RDBMS, Unix, Linux, bash, ksh, SQL, PL/SQL
Responsibilities
Maintain Informatica Data Quality software and infrastructure; Elaborate data profiling and cleansing plans; Perform ad-hoc data profiling of CCH data sources; Maintain data dictionaries and logical/physical data models; Execute data conversion/migration testing and validation; Write and review test cases; Assist in defect management and resolution planning.
Seniority
Senior, hands-on IC