Talent.com
Senior Informatica ETL Developer
Senior Informatica ETL DeveloperCredence • McLean, VA, US
Senior Informatica ETL Developer

Senior Informatica ETL Developer

Credence • McLean, VA, US
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

Job Description

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_alerts.create_a_job]

    Senior Informatica ETL Developer • McLean, VA, US

    [internal_linking.similar_jobs]
    Senior Software Developer HYBRID!

    Senior Software Developer HYBRID!

    Anavation • Lorton, VA, United States
    [job_card.full_time]
    Be Challenged and Make a Difference.In a world of technology, people make the difference.We believe if we invest in great people, then great things will happen. At AnaVation, we provide unmatched va...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Salesforce Developer

    Senior Salesforce Developer

    TLA-LLC • Sterling, VA, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Seeking a software developer to perform will provide full-lifecycle application development : designing, coding and debugging applications in various software languages software development.The idea...[show_more]
    [last_updated.last_updated_30]
    Common Business Services (CBS) - Senior Software Developer (100% Remote - REF1895I)

    Common Business Services (CBS) - Senior Software Developer (100% Remote - REF1895I)

    Citizant • Chantilly, VA, United States
    [filters.remote]
    [job_card.full_time]
    Citizant is a leading provider of professional IT services to the U.We seek to address some of our country's most pressing challenges in the areas of Agile application development, Enterprise Data ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Data Engineering - TS / SCI Required

    Senior Data Engineering - TS / SCI Required

    LMI Consulting, LLC • Reston, VA, United States
    [job_card.full_time]
    Senior Data Engineering - TS / SCI Required.Salaried High Fringe / Full-Time.LMI is a new breed of digital solutions provider dedicated to accelerating government impact with innovation and speed.Inves...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Clinical (eClinicalWorks) Informatics Analyst (Temporary Role)

    Clinical (eClinicalWorks) Informatics Analyst (Temporary Role)

    VSI • Reston, VA, US
    [job_card.full_time]
    Are you a clinical informatics professional whos passionate about optimizing EHR systems and supporting providers and staff? Were seeking afull-time, temporary Clinical. Electronic Health Record sys...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Appian Solution Architect — Cloud & Integration Lead

    Senior Appian Solution Architect — Cloud & Integration Lead

    Dovel Technologies, Inc • McLean, VA, United States
    [job_card.full_time]
    A technology consulting firm seeks an experienced Appian Solution Architect in McLean, Virginia to lead digital transformation initiatives. The ideal candidate will have a minimum of 8 years in IT c...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Application Engineer - Oracle ERP-PVM & Ivalua VenDoor

    Application Engineer - Oracle ERP-PVM & Ivalua VenDoor

    Navy Federal Credit Union • Vienna, VA, United States
    [job_card.full_time]
    Design, develop, and optimize software applications that bridge technical teams and end-users, addressing business needs through innovative solutions and enhancing member or internal user experienc...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Agile Development Director

    Agile Development Director

    PTR Global • McLean, VA, United States
    [job_card.temporary]
    McLean, Virginia (Fully 5 days onsite).Solid background in engineering and software development.Proven experience in leading development teams (5–6 developers). Project management from a technical / e...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Software Engineer, Core Experiences - Woodbridge, USA

    Senior Software Engineer, Core Experiences - Woodbridge, USA

    Speechify • Woodbridge, Virginia, United States
    [job_card.full_time]
    Speechify is the easiest way to listen to the world’s information.Articles on the web, documents in the cloud, books on your phone. We absorb it all and let you listen to it at your desk, on the go,...[show_more]
    [last_updated.last_updated_30] • [promoted]
    General Application

    General Application

    LEDE2 Consulting LLC • Frederick, MD, USA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    We are continuously searching for talented professionals in the areas of : .If you have experience and skills in the areas listed above but do not currently see a current opportunity available, pleas...[show_more]
    [last_updated.last_updated_30]
    Senior SW Developer

    Senior SW Developer

    Leidos Inc • Chantilly, VA, United States
    [job_card.full_time]
    Leidos is seeking a Software Developer for a technical development program supporting the Sponsor's Entitlement Programs as well as IdAM / ICAM, Authentication, Authorization, Attributes and Digital...[show_more]
    [last_updated.last_updated_30] • [promoted]
    InfoSec Program Lead : Agile, Cross-Functional Delivery

    InfoSec Program Lead : Agile, Cross-Functional Delivery

    Celerity IT, LLC. • McLean, VA, United States
    [job_card.full_time]
    A technology consulting firm located in McLean, Virginia is seeking a project manager to improve information security services. The ideal candidate will have experience with Agile methodologies, exc...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Manager, Data Engineering (Intelligent Foundations and Experiences)

    Senior Manager, Data Engineering (Intelligent Foundations and Experiences)

    Capital One • McLean, VA, United States
    [job_card.full_time] +1
    Senior Manager, Data Engineering (Intelligent Foundations and Experiences).Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-pace...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Workday Integration Architect — Lead & Remote Options

    Senior Workday Integration Architect — Lead & Remote Options

    Groundswell • McLean, VA, United States
    [filters.remote]
    [job_card.full_time]
    A leading technology integrator is seeking a Workday Integration Architect to develop and maintain HR technology solutions for federal agencies. The role involves leading a team, designing integrati...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Application Developer active FSP

    Application Developer active FSP

    Red Rock Government Services • Herndon, VA, USA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    With a proven track record of delivering innovative and mission-critical solutions, Red Rock specializes in developing secure, scalable, and cutting-edge technologies tailored to meet the complex n...[show_more]
    [last_updated.last_updated_30]
    Senior SQL Developer

    Senior SQL Developer

    Crystal Management | CMIT • Vienna, VA, United States
    [job_card.full_time]
    CMiT is seeking a motivated, career, and customer-oriented Senior SQL Developer to join our team in support of a Federal Customer. This high-visibility cybersecurity modernization initiative focuses...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Space Systems Engineering Lead

    Senior Space Systems Engineering Lead

    The Aerospace Corporation • Chantilly, VA, United States
    [job_card.full_time]
    The Aerospace Corporation is the trusted partner to the nation's space programs, solving the hardest problems and providing unmatched technical expertise. As the operator of a federally funded resea...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Clinical (eClinicalWorks) Informatics Analyst (Temporary Role)

    Clinical (eClinicalWorks) Informatics Analyst (Temporary Role)

    Virginia Spine Institute • Reston, VA, United States
    [job_card.full_time]
    Are you a clinical informatics professional who's passionate about optimizing EHR systems and supporting providers and staff? We're seeking a full-time, temporary Clinical Informatics Analyst to jo...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]