Sr. ETL Developer
Core
Designing and implementing high-throughput data integration, data warehouse, and business intelligence systems for DB2 sources and targets.
Role type
Senior ETL Developer (Ab Initio)
Builds
Operational Data Stores, Data Warehouses, and Data Marts
Domain
Health Insurance (Payer) / Data Engineering
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Ab Initio ETL, SQL, UNIX shell scripting, data modeling (3rd normal form, dimensional), DB2, RDBMS, Cobol, XML, MQ/MB, Columnar databases, data quality, data profiling, data lineage, metadata management, business intelligence reporting
Preferred skills
HealthCare experience, HL7, Claims/Enrollment/Benefits Administration data models, Big Data technologies (Sqoop, Hive, Impala, MapReduce, HDFS, NoSQL, Kafka)
Technologies
Ab Initio, DB2, Cobol, XML, MQ, TOAD, IBM Data Studio, Rocket shuttle, Sqoop, Hive, Impala, MapReduce, HDFS, Kafka
Responsibilities
Creating ETL code for data ingestion and extraction; developing initial historical and daily incremental ETL jobs; ensuring high data quality in data integration and warehouse interfaces; working with BI reporting tools
Seniority
Senior, hands-on IC