Mid ETL SpecialistEngineerDeveloper

Benefits : 401(k) matching

Competitive salary

Health insurance

Paid time off

About this Role :

Imagineeer is seeking an experienced ETL Developer to design, develop, and implement robust data integration solutions that enable efficient data movement and transformation across enterprise systems. This role is vital for ensuring data is accurately extracted from various sources, properly transformed, and loaded into target systems to support business intelligence, reporting, and analytics initiatives. The ideal candidate possesses strong technical expertise in ETL tools and methodologies, combined with excellent problem-solving skills and data management knowledge. This position may require the ability to obtain and maintain a Public Trust clearance.

Key Responsibilities :

Design, develop, and implement ETL processes using appropriate tools and technologies

Create data mappings and transformation logic to convert source data into required target formats

Develop data quality rules and validation processes to ensure data integrity throughout the ETL lifecycle

Optimize and automate ETL jobs for performance, efficiency, and scalability

Troubleshoot and resolve ETL process failures and data quality issues

Implement error handling, logging, and notification mechanisms in ETL workflows

Create and maintain technical documentation for ETL processes, including data mappings and transformations

Collaborate with data architects to understand data models and integration requirements

Work with business analysts to translate business requirements into technical ETL solutions

Work with stakeholder on understanding client’s existing ETL solution and propose a future modernization ETL solution

Develop and implement data reconciliation processes to validate ETL accuracy

Create and execute test cases to verify ETL functionality and data quality

Implement incremental load strategies and change data capture mechanisms

Monitor ETL job execution and ensure timely completion of scheduled processes

Support data migration activities and system integration projects

Implement metadata management practices for ETL processes

Qualifications and Skills :

U.S. Citizen with ability to obtain and maintain a Public Trust clearance.

Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or related field.

5+ years of experience in ETL development, data engineering, or enterprise data integration.

Strong experience with ETL tools and technologies (Informatica, SSIS, Talend, or similar)

Demonstrated experience designing and implementing complex data integration solutions

Experience with SQL and relational database systems

Expert knowledge of ETL methodologies, patterns, and best practices

Proficiency with at least one major ETL platform or framework

Strong SQL skills for data extraction, transformation, and querying

Experience with data profiling and data quality assessment techniques

Knowledge of data warehouse concepts and dimensional modeling

Experience implementing error handling and exception management in ETL processes

Understanding of performance optimization techniques for data processing

Experience with scheduling and orchestration of ETL workflows

Strong problem-solving skills for addressing complex data integration challenges

Knowledge of source-to-target mapping development and documentation

Experience with data type conversions and handling special data scenarios

Understanding of incremental loading strategies and techniques

Ability to work with large and complex datasets

Strong attention to detail and commitment to data accuracy

Excellent communication skills for collaborating with technical and business stakeholders

Desired Skills and Competencies :

Experience with cloud-based ETL solutions (AWS Glue, Azure Data Factory, etc.)

Knowledge of real-time data integration and streaming technologies

Experience with big data technologies (Hadoop, Spark, etc.)

Familiarity with data governance principles and practices

Experience with version control systems for ETL code management

Knowledge of API integration and web services

Experience with metadata management tools and practices

Understanding of master data management concepts

Experience with DevOps practices for ETL deployment

Knowledge of data privacy regulations and secure data handling practices

Experience supporting federal government data systems, HHS experience preferred

Familiarity with Agile and Hybrid development methodologies

Experience with data migration projects

Knowledge of NoSQL databases and unstructured data processing

Certifications relevant to data integration or specific ETL technologies

Understanding Unix Shell Scripting and PowerShell to automate ETL solutioning.

Flexible work from home options available.