Ab Initio ETL Developer – Metadata Hub

Job Summary

We are looking for an experiencedAb Initio ETL Developer with8+ years of hands-on experience in enterprise data integration and ETL development. The ideal candidate will have strong expertise inAb Initio, with exposure toAb Initio Metadata Hub, data integration, data transformation, and enterprise data warehouse environments.

The candidate will be responsible for designing, developing, testing, and supporting complex ETL workflows and data pipelines. This role requires strong technical skills, problem-solving abilities, and the ability to work closely with business analysts, data architects, QA teams, and other technology teams.

Key Responsibilities

• Design, develop, test, and implement complexETL workflows using Ab Initio.
• Develop and maintainAb Initio graphs, plans, scripts, components, and applications.
• Work withAb Initio Metadata Hub for metadata management, data lineage, data discovery, and impact analysis.
• Analyze business and technical requirements and translate them into scalable ETL solutions.
• Develop data extraction, transformation, and loading processes across multiple source and target systems.
• Perform complex data transformations, cleansing, validation, aggregation, and reconciliation.
• Develop reusable ETL components and frameworks following enterprise development standards.
• Optimize Ab Initio jobs and workflows for performance, scalability, and reliability.
• Troubleshoot ETL failures, data quality issues, production incidents, and performance problems.
• Perform unit testing, integration testing, regression testing, and support UAT activities.
• Conduct source-to-target data analysis and mapping.
• Work with relational databases and write complexSQL queries for data validation and troubleshooting.
• Develop and maintain technical documentation, data mappings, ETL specifications, and operational procedures.
• Participate in code reviews and ensure development follows established coding and documentation standards.
• Work closely with Data Architects and Data Engineers to implement enterprise data integration solutions.
• Coordinate with QA and production support teams during deployments and release activities.
• Monitor ETL processes and proactively identify and resolve data processing issues.
• Support production deployments, batch processing, scheduling, and post-production validation.
• Participate in Agile/Scrum ceremonies, sprint planning, backlog refinement, and technical discussions.
• Provide technical guidance and mentoring to junior ETL developers when required.

Required Skills

• 8+ years of experience in ETL/Data Integration development.
• Strong hands-on experience withAb Initio ETL.
• Experience developingAb Initio graphs, plans, components, and workflows.
• Exposure toAb Initio Metadata Hub.
• Strong SQL skills and experience working with relational databases.
• Experience with data warehousing and enterprise data integration concepts.
• Strong understanding of ETL architecture, data modeling, data transformation, and data quality.
• Experience with batch processing and enterprise scheduling tools.
• Strong troubleshooting and problem-solving skills.
• Experience working in large enterprise environments.
• Excellent communication and collaboration skills.

Preferred / Nice-to-Have Skills

• Experience withAb Initio EME and metadata management.
• Experience with data lineage, impact analysis, and metadata governance.
• Experience with Unix/Linux shell scripting.
• Experience with Oracle, DB2, SQL Server, or other enterprise databases.
• Experience with Control-M or similar scheduling tools.
• Experience with Agile/Scrum methodology.
• Experience with CI/CD and enterprise deployment processes.
• Exposure to cloud data platforms such as AWS, Azure, or Snowflake is a plus.
• Experience in financial services, banking, insurance, or other large-scale enterprise data environments is a plus.

Education

Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent professional experience.