Ab Initio Architect & Subject Matter Expert (SME)
Credence Management Solutions, LLC2 months ago
McLean, VA, USA or Dayton, OH, USAStaff+
Base Salary
$130k - $140k/yr
Responsibilities
- Design and document conceptual data processes and scalable ETL solutions for migrating legacy systems to Ab Initio.
- Lead end-to-end ETL workflow design and implementation, including data extraction, transformation, loading, integration, and performance optimization.
- Gather requirements from business analysts, technical teams, stakeholders, and clients, and produce system and functional requirements documentation.
- Analyze legacy data workflows, resolve performance bottlenecks, and improve scalability, efficiency, and processing times.
- Use Ab Initio, Oracle SQL, and related technologies to support data conversion and integration.
- Create maintainable and auditable ETL design specifications and perform functional and unit testing before code handoff.
- Participate in technical peer reviews and ensure compliance with coding, design, software development lifecycle, and ETL standards.
- Design automated job schedules and improve ETL process automation.
- Ensure solutions meet DoD security and compliance requirements, including FISMA and NIST standards.
- Provide rotational on-call support and proactively monitor and maintain ETL and data integration jobs.
Requirements
- Bachelor’s degree 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.
- Experience leading modernization efforts for federal government systems or large-scale enterprise data platforms.
- Strong knowledge of system architecture, data modeling, ETL processes, integration strategies, data workflows, pipelines, and transformation logic.
- Expertise developing complex ETL solutions with Ab Initio, Unix Shell Scripting, Oracle SQL, and Control-M.
- Experience troubleshooting, optimizing, and maintaining Ab Initio-based solutions.
- Experience with cloud-based Ab Initio platforms and integration with AWS, Azure, or similar environments.
- Extensive experience with the Ab Initio GDE, Co>Operating System, and EME components.
- Familiarity with Conduct> and Agile development environments.
- Knowledge of federal regulations and data-system security and compliance standards.
- Ab Initio certifications are highly desirable.
- Must be eligible for a security clearance; an active Secret clearance is preferred.
- Strong strategic problem-solving, communication, stakeholder-management, and client-interaction skills.
Benefits
- Hybrid work arrangement in McLean, Virginia or Dayton, Ohio.
- Full-time role with onboarding planned for September 2026.
- Medical, dental, and vision health-care plans.
- 401(k) and IRA retirement plans.
- Basic, voluntary, and accidental death and dismemberment life insurance.
- Paid vacation, sick leave, and public holidays.
- Maternity and paternity family leave.
- Short-term and long-term disability coverage.
- Training and development opportunities.
- Wellness resources.
About Credence Management Solutions, LLC
Credence Management Solutions, LLC provides IT consulting, engineering, and mission support to U.S. federal agencies, with emphasis on defense, intelligence, health, and humanitarian programs. It builds and operates secure AI, cloud, cyber, and DevSecOps solutions and delivers program management and systems engineering under government contracts. The privately held firm is headquartered in McLean, Virginia, and supports customers such as the U.S. Air Force at Wright-Patterson Air Force Base.