Senior Informatica ETL Developer Job at Credence, McLean, VA

dXRld213N0xxWU1oWWo1aEgxc1lYRG9MWXc9PQ==
  • Credence
  • McLean, VA

Job Description

Join a team where innovation meets mission. Our AI, cloud, cyber, and modernization solutions save agencies thousands of hours, safeguard national security, and strengthen health and humanitarian missions worldwide. With 1,700+ team members, 1,500+ AI/data experts, and 100+ prime contracts, we deliver at scale and with purpose.

We’ve been recognized as a Top Workplace by the Washington Post for six straight years and named to the Inc. 5000 Fastest Growing Private Companies 13 of the past 14 years. Credence is a welcoming home for those looking to grow and contribute to positive change. We encourage all employees to expand beyond their boundaries, dive into important world-changing Federal challenges.

Position Summary

Credence has an immediate need for a Senior Informatica ETL Developer to support large-scale digital modernization efforts for mission-critical Department of Defense (DoD) systems with massive national impact. This role serves as a Sustainment Lead/SME, providing expert-level knowledge of sustainment lifecycle management and leading complex data engineering initiatives. The developer will design, build, and optimize ETL pipelines, develop database solutions for large-scale DBMS environments, and ensure high availability, performance, and compliance with DoD standards. Candidates should have extensive experience in ETL development, database architecture, and sustainment of enterprise applications, as well as the ability to provide technical direction to teams. This position is based in Credence’s corporate offices located in Tyson’s Corner in McLean, VA or Dayton OH. This role is on-boarding now.

Requirements

  • 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

Education, Requirements and Qualifications

  • 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.

Additional Qualifications Preferred:

  • Locals Preferred
  • Active Public Trust /Secret Clearance preferred.

Primary Location: McLean VA and Dayton OH

Hours on-site: Monday – Friday

Please join us, as together we build a better world one mission at a time powered by Technology and its People!

#LI-Hybrid

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

Job Tags

Full time, Local area, Immediate start, Worldwide, Monday to Friday,

Similar Jobs

CDM Smith, Inc.

Environmental Engineer 2 Job at CDM Smith, Inc.

 ...CDM Smith is looking for an entry-level Environmental, Water Resources, or Civil Engineer to join our Water Services Group. This position presents an excellent opportunity for early career candidates to apply their engineering skills to innovative and sustainable water... 

Stellent IT LLC

Solutions Architect Job at Stellent IT LLC

 ...Solutions Architect (Generative AI (GenAI), Machine Learning (ML)) Boston, Massachusetts (4 day hybrid / Weeks) long term contract...  ...seeking an experienced Solutions Architect with expertise in AWS Solution Design, Generative AI (GenAI), Machine Learning (ML)... 

SITE STAFFING INC

Employment Recruiter Job at SITE STAFFING INC

 ...JOB REQUIREMENTS: Skilled Trades Recruiter West Allis, WI Office Monday - Friday 1st shift, 8am to 5pm Your career is in SITE! We are...  ...This position is listed by a private employment agency. The agency is the legal employer. No fee will be charged of the job applicant.

Pixelle Specialty Solutions

Human Resources Manager Job at Pixelle Specialty Solutions

 ...comprehensive portfolio of specialty papers to help you meet todays challenging demands. Job Description The Human Resources Manager leads, organizes, and directs the Spring Grove Human Resources department to deliver human resources programs, services, and... 

G.Z.Q.S.O.

Mold/Die Setter Job at G.Z.Q.S.O.

 ...Injection Molding Facility Presses up to 3,100 Tons Mold Setter 1st Shift (7:00 a.m. Start) Location: Clinton Township, MI Pay Range: $22 $25 per hour Job Summary We are seeking a skilled and motivated Mold Setter to join our 1st shift team...