Ab Initio Architect/Subject Matter Expert (SME)

Credence has an immediate need for a Ab Initio Architect and Subject Matter Expert (SME) to join our team supporting the modernization of an existing DoD system to the Ab Initio platform. This position will work closely with cross-functional teams to provide strategic direction, technical expertise, and ensure the solution meets the specific needs of the government. This position is based in Credence’s corporate offices located in Tyson’s Corner in McLean, VA.

• Develop and document high-level conceptual data process designs for the migration and modernization of legacy DOD systems to the Ab Initio platform. Write efficient, maintainable, and scalable ETL code for data extraction, transformation, and loading processes.
• Lead the design and implementation of end-to-end ETL workflows within the Ab Initio platform to optimize data flow, system integration, and performance. Work closely with project teams to ensure seamless migration of data from legacy systems to modernized environments
• Work with business analysts, technical teams, and DOD stakeholders to gather and analyze system and data requirements. Develop System Requirement and Functional Requirement Documents to guide the design and implementation of Ab Initio-based data solutions.
• Analyze existing legacy data workflows and propose improvements for performance, scalability, and efficiency within the Ab Initio environment. Address any performance bottlenecks and optimize processing times
• Lead the extraction, transformation, and load (ETL) process design, ensuring the accurate transfer of data from legacy systems into modernized DOD environments. Utilize Oracle SQL, Ab Initio, and other technologies to facilitate data conversion and integration
• Create and document design specifications for ETL processes to ensure code auditability and maintainability. Perform functional and unit testing of ETL code to identify and resolve errors. Document testing results prior to code handover to testing teams
• Participate in technical peer reviews to ensure adherence to coding standards, design principles, and performance best practices. Ensure compliance with Enterprise Informatics software development life cycle and ETL code standards
• Design and implement automated job schedules to ensure timely execution of ETL jobs. Work to improve ETL process automation and enhance the efficiency of job scheduling
• Ensure that all designs and solutions meet the necessary security and compliance standards required in a DOD environment, including FISMA, NIST, and other applicable regulations
• Provide on-call support on a rotational basis to troubleshoot and resolve issues in the ETL processes. Proactively monitor and maintain data integration jobs to ensure system stability and optimal performance.

• 10+ years of experience in enterprise data integration, specifically with Ab Initio and related tools.
• Minimum of 7 years of experience in data integration, architecture, and ETL development, with at least 5 years focused on Ab Initio.
• Proven track record of leading and executing similar modernization efforts for Federal government systems or large-scale enterprise data platforms.
• Strong understanding of system architecture, data modeling, ETL processes, and integration strategies.
• Experience in designing and implementing complex data workflows, data pipelines, and transformation logic.
• Proven expertise in designing, developing, and implementing complex ETL solutions using Ab Initio, Unix Shell Scripting, Oracle SQL, and Control-M.
• Strong ability to troubleshoot, optimize, and maintain Ab Initio-based solutions.
• Excellent problem-solving skills, with the ability to think strategically and solve complex technical challenges.
• Up-to-date with the latest trends in data integration, governance, and Ab Initio technologies.
• Strong communication skills with experience in interacting with senior stakeholders, technical teams, and clients.
• Experience with cloud-based Ab Initio platforms and integration with AWS, Azure, or similar environments.
• Extensive experience across the Ab Initio suite, particularly with GDE, Co>Operating System, and EME for development and metadata management
• Familiarity with orchestration components like Conduct> are highly preferred
• Familiarity with Agile methodologies and working in an Agile development environment.
• Knowledge of Federal government regulations and compliance standards related to data systems and security.
• Certifications in Ab Initio are highly desirable.

Minimum Education: 

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

#Credence #veteranemployment #militaryspouse #milspouse #hireavet #militaryveteran #militaryfriendly #transitioningmilitary #veterans #militarytransition #militaryfamilies #msep #militarytocivilian #military #federalcontractingjobs #defensecontracting #defenseindustryjobs