Senior ETL Developer – Hybrid/Remote Data Warehousing

Compunnel, Inc.; Aliso Viejo, Northern (CA, KY); Hybrid; USD 100,000 - 150,000; Full time

Job summary

Compunnel, Inc. in California is hiring an experienced ETL Developer/Data Integration Professional to design, develop, and maintain robust data integration solutions that support healthcare operations.

You will leverage SQL, PL/SQL, and various ETL tools (Informatica, SSIS, Talend, DataStage, Matillion) to build scalable data pipelines, optimize queries, ensure data quality and security, and collaborate with analysts and engineers. Hybrid/remote options available.

Qualifications

• 5–10+ years of relevant professional experience.
• Strong experience in ETL/Data Integration development.
• Proficiency in SQL, PL/SQL, and database development.
• Experience with ETL tools such as Informatica, SSIS, Talend, DataStage, Matillion, or similar.
• Strong understanding of Data Warehousing concepts and dimensional modeling.
• Experience with Python scripting for data processing and automation.
• Knowledge of cloud platforms such as Azure, AWS, or GCP.
• Experience with large datasets and performance tuning.
• Familiarity with version control tools such as Git/Bitbucket.
• Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related field.

Responsibilities

• Design, develop, test, and maintain ETL/data integration workflows.
• Extract, transform, and load data from multiple source systems into data warehouses and data lakes.
• Develop and optimize SQL queries, stored procedures, and database objects.
• Build scalable and high-performance data pipelines.
• Perform data mapping, profiling, validation, and reconciliation activities.
• Monitor ETL jobs and troubleshoot data integration issues.
• Collaborate with business analysts, architects, and data engineers to understand requirements.
• Ensure data quality, integrity, security, and compliance standards.
• Support production deployments and ongoing maintenance.
• Participate in code reviews, performance tuning, and process improvements.

Skills

ETL/Data Integration

SQL/PLSQL

Dimensional modeling

Python scripting

Analytical thinking

Education

Bachelor's Degree in Computer Science, Information Technology, Engineering, or related field

Tools

Informatica

SSIS

Talend

DataStage

Matillion

Git/Bitbucket

Azure Data Factory

Databricks

Snowflake

Job description

Compunnel, Inc. in California is hiring an experienced ETL Developer/Data Integration Professional to design, develop, and maintain robust data integration solutions that support healthcare operations.

You will leverage SQL, PL/SQL, and various ETL tools (Informatica, SSIS, Talend, DataStage, Matillion) to build scalable data pipelines, optimize queries, ensure data quality and security, and collaborate with analysts and engineers. Hybrid/remote options available.