Ab Initio Developer

Job Summary 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. Key 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. Education Bachelor's degree in Computer Science, Mathematics, Engineering, or a related technical field. Clearance Requirement Ability to obtain and maintain a Public Trust clearance as required by the contract. Skills: sql,data integration,data warehousing,ab initio,integration,etl,public trust,greenplum,amazon s3