Talent.com
Sr ETL Specialist/ETL Engineer/ETL Developer
Sr ETL Specialist/ETL Engineer/ETL DeveloperIMAGINEEER LLC • Washington, DC, US
Sr ETL Specialist / ETL Engineer / ETL Developer

Sr ETL Specialist / ETL Engineer / ETL Developer

IMAGINEEER LLC • Washington, DC, US
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

Job Description

Job Description

Benefits :

  • 401(k) matching
  • Competitive salary
  • Health insurance
  • Paid time off

About this Role :

The Senior ETL Specialist / ETL Engineer will support enterprise data integration and modernization efforts for the U.S. Department of Health and Human Services (HHS). The role is responsible for designing, developing, and maintaining Extract, Transform, Load (ETL) processes that enable secure, accurate, and reliable data movement across federal systems and mission-critical programs. The ETL Specialist will work as part of a data engineering and analytics team to support data warehousing, business intelligence (BI), and enterprise reporting initiatives.

The ideal candidate will possess deep ETL development expertise, strong SQL and data modeling skills, and experience in enterprise data management solutions. This role requires the ability to build scalable data pipelines, optimize data flows, and ensure data integrity across multiple platforms. Experience in a federal environment and knowledge of HHS mission priorities are highly desirable.

Key Responsibilities :

ETL Development & Data Integration

  • Design, build, and maintain scalable ETL / ELT pipelines to support enterprise data warehouse (EDW) and analytics environments.
  • Develop data ingestion and transformation routines from multiple structured and unstructured data sources.
  • Implement ETL solutions using tools such as Informatica, Talend, SSIS, Azure Data Factory, AWS Glue, or ODI .
  • Create reusable components, frameworks, and data integration templates to accelerate delivery.
  • Ensure ETL workflows are optimized for performance, maintainability, and reliability.

    • Data Engineering & Architecture Support

  • Collaborate with data architects and analysts to define data models (conceptual, logical, physical).
  • Support integration across enterprise applications including financial, HR, grants, and program systems.
  • Implement data quality rules, validation logic, and exception handling procedures.
  • Support Master Data Management (MDM) and metadata initiatives.
  • Implement best practices for ETL / data integration architecture aligned with enterprise data strategy.

    • Testing, Optimization & Production Support

  • Conduct data profiling and validation to ensure ETL output accuracy.
  • Perform unit testing, integration testing, and UAT validation for ETL solutions.
  • Troubleshoot ETL failures, investigate root causes, and deploy corrective measures.
  • Optimize ETL workflows for high performance and reduced processing time.
  • Provide production support and participate in on-call rotation as necessary.

    • Documentation & Collaboration

  • Develop and maintain ETL documentation including design specifications, data flow diagrams, and data lineage documentation.
  • Collaborate with analysts, developers, database administrators, and federal stakeholders.
  • Participate in Agile ceremonies including sprint planning, reviews, and retrospectives.
  • Support data governance, data security, and compliance initiatives.

    • Qualifications and Skills :

  • U.S. Citizen with ability to obtain and maintain a Public Trust clearance .
  • Bachelors degree in Computer Science, Data Engineering, Information Systems, or related field.
  • 7+ years of experience in ETL development, data engineering, or enterprise data integration.
  • Hands-on experience with ETL tools such as Informatica PowerCenter / IDQ, Talend, SSIS, ADF, AWS Glue, or DataStage.
  • Strong proficiency in SQL and relational databases (Oracle, SQL Server, PostgreSQL, or Snowflake).
  • Experience with data warehousing concepts (star schema, slowly changing dimensions, data marts).
  • Proven experience creating high-performance, secure ETL processes.
  • Experience working in Agile or SDLC-driven environments.
  • Excellent communication and problem-solving skills.

    • Desired Skills and Competencies :

  • Prior experience supporting HHS or other federal agencies (CMS, NIH, HRSA, ACF, FDA).
  • Experience building ETL solutions in cloud environments (AWS, Azure, or GCP).
  • Familiarity with data governance, metadata management, and data catalog tools .
  • Experience with Python, Shell scripting, or PowerShell for automation.
  • Knowledge of API-based integrations, Kafka, or streaming data pipelines .
  • Experience with DevOps tools (Git, Jenkins, Azure DevOps).
  • Certifications such as Informatica Developer, Talend Data Integration, AWS Data Analytics, Azure Data

    • Flexible work from home options available.

    serp_jobs.job_alerts.create_a_job

    Etl Developer • Washington, DC, US

    Job_description.internal_linking.related_jobs
    ETL Developer

    ETL Developer

    Leidos Inc • Bethesda, MD, United States
    serp_jobs.job_card.full_time
    National Security Sector's (NSS) Cyber & Analytics Business Area (CABA).Our talented team is at the forefront in Security Engineering, Computer Network Operations (CNO), Mission Software, Analytica...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    Facilities - Contractor - L4

    Facilities - Contractor - L4

    Innova Solutions • Columbia, MD, United States
    serp_jobs.job_card.full_time
    A client of Innova Solutions is immediately hiring a.Position Type : Full time Contract, Possible Contract to Hire.Develop and implement space planning strategies that accommodate current and future...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Sr. Analyst, FP&A

    Sr. Analyst, FP&A

    hackerone • Baltimore, MD, United States
    serp_jobs.job_card.full_time
    HackerOne is a global leader in offensive security solutions.Our HackerOne Platform combines AI with the ingenuity of the largest community of security researchers to find and fix security, privacy...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    ENTERPRISE SALES NETWORKING SOLUTIONS ENGINEER - Maryland, Virginia or DC

    ENTERPRISE SALES NETWORKING SOLUTIONS ENGINEER - Maryland, Virginia or DC

    Cisco Systems, Inc. • Columbia, MD, United States
    serp_jobs.job_card.full_time
    You will be part of the Americas Networking Organization supporting Global Enterprise Segment team and improve our customers' lives, prospecting for new opportunities!. As a Solutions Engineer at Ci...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    Facilities - Contractor - L4 (Columbia)

    Facilities - Contractor - L4 (Columbia)

    Innova Solutions • Columbia, MD, US
    serp_jobs.job_card.full_time +1
    A client of Innova Solutionsis immediately hiring a.Position Type : Full time Contract, Possible Contract to Hire.Develop and implement space planning strategies that accommodate current and future ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    ETL Developer (SME)

    ETL Developer (SME)

    Leidos Inc • Bethesda, MD, United States
    serp_jobs.job_card.full_time
    National Security Sector's (NSS) Cyber & Analytics Business Area (CABA).Our talented team is at the forefront in Security Engineering, Computer Network Operations (CNO), Mission Software, Analytica...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    Senior Data Engineer

    Senior Data Engineer

    eSimplicity • Columbia, MD, US
    serp_jobs.job_card.full_time
    Simplicity is a modern digital services company that partners with government agencies to improve the lives and protect the well-being of all Americans, from veterans and service members to childre...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Software Development and Acquisitions Analyst

    Software Development and Acquisitions Analyst

    SimVentions, Inc - Glassdoor 4.6 • Barstow, MD, US
    serp_jobs.job_card.full_time
    SimVentions is a 100% employee-owned business and has consistently been voted one of Virginia's Best Places to Work.We are seeking a detail-oriented candidate with extensive knowledge of computer o...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Controls & Integration Engineer II

    Controls & Integration Engineer II

    CPG • Jessup, MD, United States
    serp_jobs.job_card.full_time
    Controls & Integration Engineer II .Jessup, MD .CONTROLS & INTEGRATION ENGINEER II.Contro...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    NAVAIR - Software Developer Analyst

    NAVAIR - Software Developer Analyst

    SimVentions, Inc - Glassdoor 4.6 • Barstow, MD, US
    serp_jobs.job_card.full_time +1
    SimVentions is a 100% employee-owned business and has consistently been voted one of Virginia's Best Places to Work.We are seeking a detail-oriented candidate with extensive knowledge of computer o...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_hour • serp_jobs.job_card.promoted • serp_jobs.job_card.new
    ETL / Data Engineer / Data Architect

    ETL / Data Engineer / Data Architect

    Node.Digital • Washington, DC, US
    serp_jobs.job_card.full_time
    ETL / Data Engineer / Data Architect.OR Permanent Resident Alien (Green card holder).Node is currently seeking a motivated, career and customer-oriented Senior Data Architect to begin an exciting and c...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Data Flow Engineer

    Data Flow Engineer

    Pointer Technologies • Annapolis Junction, MD, US
    serp_jobs.job_card.full_time
    Pointer Technologies is seeking a talented Data Flow and ETL Engineer to design, implement, and maintain robust data pipelines and ETL processes. You will play a critical role in transforming raw da...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Sr.Data Engineer

    Sr.Data Engineer

    nuanza • Bethesda, MD, US
    serp_jobs.job_card.full_time
    We have an immediate requirement with one of our Clients for Sr.Please share if you have any resumes to sushma@nuanza.POSITION : Senior Data Engineer. Python and SQL for querying databases and a...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Sr Manager, Release Train Engineer : : Bethesda, MD (Hybrid)

    Sr Manager, Release Train Engineer : : Bethesda, MD (Hybrid)

    Ark Solutions • Bethesda, MD, US
    serp_jobs.job_card.full_time
    Sr Manager, Release Train Engineer Bethesda, Md - Hybrid.Join us as a Senior Manager to lead the Agile Release Train for our web platforms. You'll be instrumental in managing Agile delivery, fosteri...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    ETL Developer

    ETL Developer

    Two95 International Inc. • Tysons, VA, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Design, implement, and support ETL processes from embedded sources to data warehouse.Design and support ETL processes for data cleansing, data auditing, and data profiling.Develop moderately comple...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days
    Principal ETL Developer

    Principal ETL Developer

    Leidos Inc • Bethesda, MD, United States
    serp_jobs.job_card.full_time
    National Security Sector's (NSS) Cyber & Analytics Business Area (CABA).Our talented team is at the forefront in Security Engineering, Computer Network Operations (CNO), Mission Software, Analytica...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    ETL Developer

    ETL Developer

    Zone IT Solutions • Washington, DC, US
    serp_jobs.job_card.full_time +1
    serp_jobs.filters_job_card.quick_apply
    This is a permanent role with a global IT service leader.Strong experience in ETL Development.Minimum of 3 years of experience in Informatica Cloud or Enterprise Informatica.Proficiency in Unix and...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days
    NAVAIR - Software Development and Acquisitions Analyst

    NAVAIR - Software Development and Acquisitions Analyst

    SimVentions, Inc • Barstow, MD, US
    serp_jobs.job_card.full_time
    SimVentions is a 100% employee-owned business and has consistently been voted one of Virginia's Best Places to Work.We are seeking a detail-oriented candidate with extensive knowledge of computer o...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_hour • serp_jobs.job_card.promoted • serp_jobs.job_card.new
    Data Engineer III

    Data Engineer III

    eSimplicity • Columbia, MD, US
    serp_jobs.job_card.full_time
    Simplicity is a modern digital services company that partners with government agencies to improve the lives and protect the well-being of all Americans, from veterans and service members to childre...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Project Coordinator - Energy Efficiency

    Project Coordinator - Energy Efficiency

    ICF • Columbia, MD, US
    serp_jobs.job_card.full_time
    Project Coordinator (Hybrid) Utility Programs And Services.Location : Columbia, MD (Hybrid Home Office With Local Travel). To support our growth, we are seeking candidates with an interest in utilit...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted