Apply on Employer Site

Credence · 2 months ago

Senior Informatica ETL Developer

Dayton, OH

Full-time

Onsite

Senior Level, Lead/Staff

10+ years exp

Credence is a company focused on innovation in AI, cloud, cyber, and modernization solutions. They are seeking a Senior Informatica ETL Developer to support large-scale digital modernization efforts for Department of Defense systems, focusing on designing and optimizing ETL pipelines and database solutions.

GovTechInformation TechnologySoftware

Growth Opportunities

No H1B

Security Clearance Required

U.S. Citizen Only

Responsibilities

Design, build, and maintain complex ETL pipelines to extract, transform, and load data from multiple sources (databases, APIs, legacy systems, flat files) into enterprise data repositories. Support both batch and real-time data flows

Develop, enhance, and sustain applications on large-scale DBMS platforms (e.g., Oracle, SQL Server, PostgreSQL). Optimize SQL queries, stored procedures, indexing, and partitioning for performance and scalability

Serve as Sustainment Lead/SME, providing expert knowledge of sustainment lifecycle management. Oversee issue resolution, patching, performance improvements, and long-term maintainability

Analyze functional business applications (finance, logistics, personnel, contracts, etc.) and design scalable data models, block diagrams, and flowcharts that support modernization objectives

Translate detailed designs into software solutions, including coding, testing, debugging, and refining database-driven applications

Develop and support APIs to integrate with modern platforms, including low-code/no-code applications within hybrid architectures

Prepare and maintain program-level and user-level documentation, ensuring compliance with IA, QA, and CM procedures. Provide regular reports on sustainment status and modernization progress

Provide technical direction to programmers and junior developers, ensuring deadlines are met and quality standards are maintained

Enhance software and database processes to reduce operating time, improve efficiency, and support mission readiness

Qualification

Informatica ETLDatabase developmentData engineeringSQL optimizationAPI developmentSustainment lifecycle managementAgile developmentData modelingTechnical directionProblem-solvingDocumentation

Required

Bachelor's degree in an IT-related field with 10+ years of relevant experience in ETL, database development, or data engineering

Proven experience designing, developing, and optimizing ETL pipelines using scripting, SQL, and enterprise ETL tools (Informatica, Talend, SSIS, Pentaho, or similar)

Expert-level proficiency with large-scale DBMS (Oracle, SQL Server, PostgreSQL, etc.), including schema design, query optimization, and performance tuning

Demonstrated experience in sustainment lifecycle management activities for large-scale programs and applications

Hands-on experience developing data APIs and supporting integration with low-code/no-code platforms

Experience in Agile and hybrid development environments, supporting iterative delivery and sustainment

Must possess an IT-II Non-Critical Sensitive clearance, a Secret clearance preferred

Relevant certifications in ETL, database, or data engineering (e.g., Oracle Certified Professional, Microsoft SQL Server, Informatica Certified Developer, AWS Data Analytics Specialty, Security+)

Strong problem-solving ability, knowledge of computer equipment capacity and limitations, and ability to develop complex software to meet design objectives

Preferred

Locals Preferred

Active Public Trust /Secret Clearance preferred

Company

Credence

Credence provides innovative technology, health, engineering, and management solutions to support mission-critical programs for Federal government customers.

Founded in 2005

Vienna, Virginia, USA

1001-5000 employees