ETL Engineer: Data Integration, Quality & Performance

Code Connect Inc; Virginia; On-site; USD 100,000 - 150,000; Full time

Job summary

Code Connect Inc. is seeking an ETL Developer to design, develop, and maintain ETL processes supporting data integration and reporting across the organization.

This role involves working with diverse data sources, transforming data into insights, and ensuring data quality and consistency. Responsibilities include building scalable ETL workflows, data migration, validation, governance, and performance tuning.

Qualifications

• 7-9 yrs of experience in designing ETL processes, pipelines, and SQL queries.
• ETL: Proficiency in ETL processes and tools, with the ability to oversee and execute complex data transformations.
• Data Migration: Experience in data migration projects and successful transitions.
• Data Analysis: Analyze data sources, understand relationships, and design data flows.
• Databases: Strong knowledge of MySQL, Oracle, SQL Server and SQL basics.
• Data Management: Understand data mapping, quality assurance, and governance.
• Data Modeling: Knowledge of data modeling for data warehouse design.
• Performance Tuning: Optimize ETL processes and queries for performance.

Responsibilities

• 7-9 yrs of experience in designing ETL processes, pipelines, and SQL queries, and ensure data flow
• ETL: Proficiency in ETL processes and tools, with the ability to oversee and execute complex data transformations
• Data Migration: Extensive experience in data migration projects, demonstrating a track record of successful data transitions.
• Data Analysis: Ability to analyze data sources, understand data relationships, and develop strategies to extract, transform, and load data effectively.
• Databases: A strong understanding of relational databases (such as MySQL, Oracle, and SQL Server) and knowledge of SQL is essential.
• Data Management: Deep understanding of data management principles, including data mapping, data quality assurance, and data governance.
• Data Modeling: Understanding data modeling principles and practices to design efficient data structures and optimize data warehouse performance.
• Performance Tuning: Skills in optimizing ETL processes and database queries to improve performance and reduce load times.

Skills

ETL

Python

Shell Scripting

Linux

FHIR

EDI

InterOp

Healthcare domain

Job description

Code Connect Inc. is seeking an ETL Developer to design, develop, and maintain ETL processes supporting data integration and reporting across the organization.

This role involves working with diverse data sources, transforming data into insights, and ensuring data quality and consistency. Responsibilities include building scalable ETL workflows, data migration, validation, governance, and performance tuning.