AbInitio / ETL Developer

Job Title Ab Initio / ETL Developer

Experience - 8+ years

We are seeking an experienced Ab Initio / ETL Developer to support enterprise healthcare data integration, warehousing, and reporting initiatives. The ideal candidate will possess strong expertise across SQL development, Unix Shell Scripting, and Ab Initio ETL development, with SQL being the primary skill requirement.

The successful candidate will be responsible for designing and supporting data pipelines, optimizing database performance, automating data processing workflows, and delivering high-quality data solutions within a healthcare environment.

Candidates must demonstrate proficiency across all three skill areas, with the following priority order:

1. SQL / Stored Procedures (Most Critical)

• Advanced SQL development
• Complex query design and optimization
• Stored procedures, functions, views, and triggers
• Common Table Expressions (CTEs)
• Complex multi-table joins
• Query performance tuning and troubleshooting
• Data validation and reconciliation

2. Unix Shell Scripting

• Shell scripting for automation and operational support
• Batch processing and file handling
• Job monitoring and troubleshooting
• Scheduling and workflow automation
• Environment and process management

3. Ab Initio

• ETL design and development using Ab Initio
• Graph development and optimization
• Data transformation and integration
• Performance tuning of ETL processes
• Production support and troubleshooting

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.

Educational Qualifications: -

Engineering Degree BE / ME / BTech / M Tech / B.Sc. / M.Sc.

Technical certification in multiple technologies is desirable.