ETL Developer / Data Integration

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

Job Summary

We are seeking an experienced ETL Developer / Data Integration Professional to design, develop, and maintain robust data integration solutions supporting healthcare business operations. The ideal candidate should have strong expertise in ETL development, data warehousing, SQL, and cloud-based data integration technologies, with the ability to transform complex business requirements into scalable data solutions.

Key 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 provide ongoing maintenance.
• Participate in code reviews, performance tuning, and process improvements.

Required 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 working with large datasets and performance tuning.
• Familiarity with version control tools such as Git/Bitbucket.
• Strong analytical and problem-solving skills.
• Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related field.

Preferred Qualifications

• Experience in the healthcare domain and healthcare data processing.
• Exposure to Azure Data Factory, Databricks, Snowflake, or similar modern data platforms.
• Understanding of Agile/Scrum methodologies.
• Experience leveraging AI-assisted development tools such as GitHub Copilot or Microsoft Copilot.
• Knowledge of data governance, data quality, and compliance standards.
• Strong competencies in data integration and ETL development, SQL and database management, data warehousing, cloud data technologies, performance optimization, troubleshooting and root cause analysis, stakeholder collaboration, and Agile delivery.

Notes

Required Experience & Mandatory Skill

• 5+ Years ETL / Data Integration Development
• 5+ Years SQL, PL/SQL, and Database Development
• 3+ Years Experience with ETL Tools (Informatica, SSIS, Talend, DataStage, Matillion, or similar)
• 3+ Years Data Warehousing Concepts and Dimensional Modeling
• 2+ Years Python Scripting for Data Processing and Automation
• 2+ Years Cloud Platforms (Azure, AWS, or GCP)
• 2+ Years Large Dataset Processing and Performance Tuning
• 1+ Years Version Control Tools (Git/Bitbucket)RequiredStrong Analytical and Problem-Solving Skills
• Preferred Healthcare Domain Experience
• Domain Experience (If any ) – Good to have healthcare experience
• Must have Certifications – None
• Location -Meridian
• Onsite Requirement - Hybrid/Remote
• Number of days onsite -