Jobs → Engineering → Ab Initio / ETL Developer

About the Role We are seeking an experienced Ab Initio / ETL Developer to support enterprise healthcare data integration, warehousing, and reporting initiatives. This role involves building healthcare applications and implementing new features while adhering to best coding standards. Key Responsibilities • Design, develop, and maintain scalable ETL and data integration solutions • Develop and optimize complex SQL queries, stored procedures, functions, and database objects • Create and maintain Unix shell scripts to automate data processing and operational workflows • Build and support Ab Initio data pipelines and ETL processes • Perform data validation, reconciliation, and quality assurance activities • Troubleshoot production issues across SQL, ETL, and Unix environments • Collaborate with business, analytics, QA, and development teams to deliver high-quality solutions • Support end-to-end SDLC activities including requirements, development, testing, deployment, and production support • Utilize enterprise scheduling tools such as Control-M for workflow management • Follow source control and CI/CD best practices using GitLab and Jenkins • Ensure adherence to healthcare data security and compliance standards Requirements • Engineering Degree – BE / ME / B.Tech / M.Tech / B.Sc. / M.Sc. • Advanced SQL development and complex query design/optimization • Stored procedures, functions, views, and triggers • Common Table Expressions (CTEs) and complex multi-table joins • Query performance tuning, troubleshooting, data validation, and reconciliation • Shell scripting for automation and operational support • Batch processing, file handling, job monitoring, and troubleshooting • Scheduling, workflow automation, environment, and process management • ETL design and development using Ab Initio • Graph development, optimization, data transformation, and integration • Performance tuning of ETL processes, production support, and troubleshooting