Local or Nearby Urgent Need Sr ETL Developer
Core
Designing and implementing data integration, data warehouse, and business intelligence systems for a Healthcare Payer Enterprise Data Foundation.
Role type
Senior Ab Initio ETL Developer
Builds
High throughput initial historical and daily incremental ETL jobs, data warehouse load routines, and operational data stores.
Domain
Healthcare Payer / Data Warehousing
Deliverable
production ML models | product features | dashboards & analysis | research | client delivery | infrastructure | physical/clinical work
Required skills
Ab Initio ETL tool, SQL, UNIX shell scripting, DB2, Cobol, XML, MQ/MB, Columnar databases, Data modeling (3rd normal form, dimensional modeling), Data quality, Data profiling, Data lineage, Metadata management, Business intelligence reporting, Rocket shuttle, TOAD, IBM Data Studio
Preferred skills
Health Insurance (Payer) domain knowledge, HL7, Claims/Enrollment/Benefits Administration data models, Big Data technologies (Sqoop, Hive, Impala, MapReduce, HDFS, NoSQL, Kafka)
Responsibilities
Create ETL design documents, patterns, interfaces, code, configurations, jobs, mappings, transformations, enrichments, cleansing, and data warehouse load routines; Implement Q Rep change data capture and replication; Profile data and implement data quality standards; Create unit and integration test cases; Resolve system and performance test defects; Review business requirements, logical/physical data models, data dictionaries, data flow diagrams, solution architecture, and ETL specifications.
Seniority
Senior, hands-on IC