Ab Initio / ETL Developer
Ayishika Deb Choudhury, MBAUnited StatesSENIORPosted 2h ago
SQLStored ProceduresUnix Shell ScriptingAb InitioETLControl-MGitLabJenkins
About the Role
We are seeking an experienced Ab Initio / ETL Developer to join an Agile team focused on building healthcare applications and implementing new features.
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
• 12+ years of experience in ETL development
• Advanced SQL development skills including complex query design and optimization
• Proficiency in Unix Shell Scripting for automation and operational support
• Expertise in Ab Initio for ETL design and development
• Experience with enterprise scheduling tools like Control-M
• Knowledge of source control and CI/CD practices using GitLab and Jenkins
• Understanding of healthcare data security and compliance standards