Ab Initio ETL Developer
Capgemini•Atlanta, GA
•$85,786 - $92,651•Hybrid
About The Position
We are seeking a highly skilled and hands-on Ab Initio ETL Developer to design, develop, and optimize scalable data processing solutions. The ideal candidate will possess deep expertise in Ab Initio, strong SQL skills, and proven experience building high-performance ETL pipelines in enterprise data environments.
Requirements
- Strong hands-on experience with Ab Initio ETL tool
- Expertise in: Graph development
- Ab Initio components and parallel processing concepts
- GDE (Graphical Development Environment)
- Solid experience in SQL and relational databases (Oracle, Teradata, SQL Server, etc.)
- Good understanding of data warehousing concepts and ETL best practices
- Proven ability to design and optimize ETL workflows
- Experience working with large-scale data processing systems
- Strong skills in troubleshooting, debugging, and performance tuning
Nice To Haves
- Experience working in distributed and high-volume data environments
- Exposure to Unix/Linux shell scripting and job scheduling tools
- Familiarity with cloud platforms such as AWS or Azure
- Experience in data migration or modernization projects
- Understanding of Agile methodologies
Responsibilities
- Design, develop, and implement robust ETL workflows using Ab Initio, ensuring high performance and scalability
- Build and maintain Ab Initio graphs using components such as Reformat, Join, Partition, Sort, Rollup, and Lookup
- Utilize the Graphical Development Environment (GDE) for efficient ETL development, testing, and debugging
- Develop complex data transformation logic and ensure data integrity across multiple systems
- Integrate ETL pipelines with relational databases using advanced SQL queries
- Optimize ETL processes for performance, scalability, and reliability
- Conduct root cause analysis and troubleshoot production issues and data inconsistencies
- Collaborate with cross-functional teams including data architects, DBAs, and business stakeholders
- Support deployment, tuning, and monitoring of data pipelines across environments
- Ensure compliance with data governance, data quality, and security standards
Benefits
- Medical, dental, and vision coverage
- Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
- Life and disability insurance
- Employee assistance programs
- Vacation: 12-25 days, depending on grade
- Company paid holidays
- Personal Days
- Sick Leave
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
