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.
Requirements
- 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
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
Other
- 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 problem-solving skills for addressing complex data integration challenges
- Excellent communication skills for collaborating with technical and business stakeholders
