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.