Ab Initio Developer

Capgemini • Tampa, FL

1d • $85,786 - $105,908 • Hybrid

About The Position

We are seeking a highly skilled Ab Initio ETL Developer with strong experience in data engineering, ETL development, and metadata management. The ideal candidate will have hands-on expertise in Ab Initio tools, Python-based data pipelines, and working with large-scale datasets in a financial services environment.

Requirements

• Strong experience with Ab Initio tools, including Conduct>IT, Continuous Flows, and Metadata Hub
• Hands-on expertise in ETL development and optimization
• Proficiency in Python for data engineering tasks
• Strong experience in Oracle, SQL Server, or other relational databases
• Advanced knowledge of SQL, PLSQL, and shell scripting
• Experience with data modeling and performance tuning
• Familiarity with data governance, data lineage, and metadata management
• Proven ability to lead code reviews and enforce development standards
• Experience in financial services domain (mandatory)
• Exposure to Agile/Scrum methodologies
• Basic knowledge or awareness of AI tools and machine learning models

Nice To Haves

• Strong analytical and problem-solving skills
• Excellent communication and stakeholder management abilities
• Ability to work in a fast-paced, collaborative environment

Responsibilities

• Design, develop, and maintain ETL workflows using Ab Initio (GDE, Co-Operating System, EME, Conduct>IT, Continuous Flows, and Metadata Hub)
• Implement Conduct>IT, vectors, and metaprogramming techniques
• Work on PDL, resource pool management, and dynamic lookups
• Build scalable data pipelines using Python for processing and automation
• Perform data modeling, database design, and performance tuning
• Work with large datasets in relational databases (Oracle, SQL Server, etc.)
• Develop and optimize shell scripts and advanced SQL/PLSQL queries
• Optimize Ab Initio graphs for performance and efficiency
• Ensure adherence to data governance, lineage, and metadata management practices
• Conduct code reviews, enforce best practices, and ensure high-quality deliverables
• Collaborate with business stakeholders to understand and translate data requirements
• Troubleshoot production issues and implement long-term solutions
• Provide technical leadership and mentorship to junior developers
• Ensure compliance with data governance, security, and regulatory standards

Benefits

• Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed