Ab Initio Architect & Subject Matter Expert
$130k - $140k/yr
Expert
Bachelor's
Dayton, OH, USA+1 moreMore locations: McLean, VA, USA
HybridHybrid role based in the corporate offices in McLean, VA or Dayton, OH.
Data & AnalyticsData Engineering
About the job
Requirements
- A bachelor's degree is required.
- At least 10 years of experience in enterprise data integration, specifically with Ab Initio and related tools.
- At least 7 years of experience in data integration, architecture, and ETL development, including at least 5 years focused on Ab Initio.
- A 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 designing and implementing complex data workflows, data pipelines, and transformation logic.
- Expertise designing, developing, and implementing complex ETL solutions using Ab Initio, Unix shell scripting, Oracle SQL, and Control-M.
- Ability to troubleshoot, optimize, and maintain Ab Initio-based solutions.
- Experience with cloud-based Ab Initio platforms and integration with AWS, Azure, or similar environments.
- Extensive experience across the Ab Initio suite, particularly GDE, Co>Operating System, and EME for development and metadata management.
- 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.
- Must be eligible for a security clearance.
Responsibilities
- Develop and document high-level conceptual data process designs for migrating and modernizing legacy systems to the Ab Initio platform.
- Write efficient, maintainable, and scalable ETL code for data extraction, transformation, and loading.
- 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 with project teams to ensure seamless data migration from legacy systems to modernized environments.
- Gather and analyze system and data requirements with business analysts, technical teams, and stakeholders.
- 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 in the Ab Initio environment; address performance bottlenecks and optimize processing times.
- Lead ETL process design to ensure accurate data transfer from legacy systems into modernized environments, using Oracle SQL, Ab Initio, and other technologies for data conversion and integration.
- Create and document ETL process design specifications to ensure code auditability and maintainability.
- Perform functional and unit testing of ETL code to identify and resolve errors, and document test results before handing code over 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 for timely ETL job execution, and improve process automation and job-scheduling efficiency.
- Ensure designs and solutions meet DoD security and compliance standards, including FISMA, NIST, and other applicable regulations.
- Provide rotational on-call support to troubleshoot and resolve ETL process issues.
- Proactively monitor and maintain data integration jobs to ensure system stability and optimal performance.
Desired Qualifications
- Familiarity with orchestration components such as Conduct> is highly preferred.
- Certifications in Ab Initio are highly desirable.
- An active Secret clearance is preferred.
About the company
Credence provides management, engineering, and technology solutions to the Federal Government, focusing on helping government programs that are complex and technical. Its work is delivered through an independent and objective approach, acting as a trusted partner to customers and teaming partners to achieve mission goals. The company differentiates itself through a track record of recognition in the government contracting space, a culture that emphasizes employee empowerment and a values framework of Trust, Partnership, and Success, and a commitment to delivering measurable outcomes for clients. Credence aims to support government missions by providing high-quality services that ensure project success, while also giving back to the community through charitable involvement and volunteerism.
Company Size
501-1,000
Company Stage
N/A
Total Funding
N/A
Headquarters
Vienna, Virginia
Founded
2005
Get referred to Credence
See people who can refer or advise you
Simplify's Take
What believers are saying
- DLA extended Credence's AI/ML work through September 2026, preserving revenue visibility.
- HigherGov shows a $999,999,999,999 Alliant 3 ceiling, creating massive downstream capture potential.
- Revelio Labs counted 1,795 employees in March 2026, supporting delivery capacity.
What critics are saying
- Rubio v. Credence Management Solutions reached D.C. federal court in April 2026.
- Gerrard class action filed June 2025 alleges employment violations and damages.
- A failed Alliant 3 or MDA recompete would crush pipeline and force layoffs.
What makes Credence unique
- Credence won GSA Alliant 3 in February 2026, giving decade-long federal sales reach.
- Its September 2025 DLA AI/ML contract shows real delivery depth in defense modernization.
- Credence Streamline Solutions won MDA SHIELD IDIQ in March 2026 with Streamline Defense.
Help us improve and share your feedback! Did you find this helpful?
Benefits
- Health Insurance
- Dental Insurance
- Vision Insurance
- 401(k) Retirement Plan
- Paid Vacation
- Paid Sick Leave
- Paid Holidays
- Parental Leave
- Disability Insurance
- Training Programs