Job Description
Job DescriptionBenefits:
- 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 clients 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.
- Bachelors 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.