Ab Initio Developer

About the role

We are seeking an experienced Ab Initio Developer to design, develop, test, and maintain enterprise-scale ETL and data integration solutions. The ideal candidate will have deep hands-on experience with the Ab Initio suite, strong SQL and database integration skills, Linux/Unix scripting experience, and a solid understanding of data warehousing concepts. This role will also provide technical leadership to project teams and contribute to the delivery of secure, scalable, and high-performance data integration solutions.

Responsibilities

• Design, develop, test, and maintain ETL graphs and applications using Ab Initio 4 and the full Ab Initio tool suite, including GDE, Co>Operating System, Express>IT, DQE, Continuous Flows, and Amazon S3 utilities.
• Develop and maintain ETL frameworks supporting data auditing, data reconciliation, batch processing, and real-time interfaces.
• Automate, schedule, monitor, troubleshoot, and optimize ETL jobs for high-volume data processing.
• Integrate relational databases, including DB2, SQL Server, PostgreSQL, and Greenplum.
• Develop automated data-loading solutions from multiple source systems into BI/MI systems.
• Apply data warehousing principles and design patterns, including star and snowflake schemas.
• Participate in the complete Ab Initio development lifecycle, including requirements analysis, design, implementation, testing, performance optimization, and code migration.
• Apply software quality practices including unit testing, TDD, performance analysis, and continuous integration.
• Provide technical leadership, guidance, and mentorship to junior and mid-level developers.
• Gather requirements and collaborate with technical, business, and cross-functional teams to deliver effective data integration solutions.
• Contribute to technical design decisions, architectural recommendations, and technical roadmaps as needed.
• Prepare technical documentation and conduct knowledge-transfer sessions.
• Ensure data integration solutions comply with applicable security, privacy, and data management policies.

Required Qualifications

• Deep, hands-on experience with Ab Initio in complex enterprise ETL environments.
• Strong experience with Ab Initio 4 and its associated tool suite.
• Strong SQL skills and experience integrating relational databases such as DB2, SQL Server, PostgreSQL, and Greenplum.
• Strong Linux/Unix scripting experience for ETL automation and data migration.
• Solid understanding of data warehousing concepts, including star and snowflake schemas.
• Experience across the Ab Initio development lifecycle, including analysis, design, implementation, testing, and code migration.
• Experience with software quality practices such as unit testing, TDD, performance analysis, and CI.
• Strong communication skills with the ability to effectively communicate with both technical and non-technical audiences.
• Bachelor's degree in Computer Science, Mathematics, Engineering, or a related field.
• Prior experience working in a federal agency or public-sector environment.
• Ability to obtain and maintain a Public Trust clearance as required by the contract.

Preferred Qualifications

• Experience contributing to architecture recommendations and technical roadmaps.
• Experience working in Agile project environments.
• Strong understanding of Agile terminology and methodologies.
• Familiarity with modern software development tools and methodologies.
• Experience providing technical mentorship and guidance to development teams.