Sr. Ab Initio Data Integration (ETL) Engineer
Core
Designing and implementing data integration solutions for data warehouse and business intelligence systems, specifically maintaining ETL processes for statistical claims data delivery.
Role type
Senior Ab Initio Data Integration (ETL) Engineer
Builds
ETL processes and data pipelines for the Care Coordination Technical Infrastructure (CCTI) data warehouse
Domain
Health Insurance (Payer) / Claims Administration / Data Warehousing
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Ab Initio (GDE, Co>Operating System, EME), Unix/Linux shell scripting (Korn, Bourne, Awk, Sed), SQL, Control-M scheduling, system troubleshooting, system documentation
Preferred skills
Ab Initio extensions (Query>It, Conduct>It, Express>It, Continuous flows, Metadata Hub), Health Insurance (Payer) domain knowledge (Claims, Enrollment, Benefits Administration)
Technologies
Ab Initio, Control-M, Unix/Linux, SQL
Responsibilities
Provide day-to-day maintenance and development support for ETL processes, evaluate ETL processes to generate and maintain system documentation, assist with troubleshooting system and application performance issues
Seniority
Senior, hands-on IC