Informaticab ETL Developer

Clindcast - Delray Beach, FL

Full-time - Mid Level

Delray Beach, FL

About the position

ClinDCast is looking for a skilled ETL Developer with expertise in Tableau and Informatica, specifically within the healthcare domain. The role focuses on designing, developing, and implementing ETL processes to ensure accurate and efficient data integration from various sources into data warehouses and reporting systems.

Responsibilities

• Design, develop, and implement ETL processes to extract data from diverse sources, transform it, and load it into data warehouses.
• Collaborate with data architects and business analysts to define data extraction requirements and transformation rules.
• Utilize Informatica to create ETL mappings, workflows, and transformations, ensuring data quality, accuracy, and timeliness.
• Develop and optimize complex SQL queries for data transformations and manipulation.
• Work closely with the data warehouse team to ensure seamless integration of transformed data into the data warehouse.
• Implement best practices for data modeling, data integrity, and performance optimization within the data warehouse.
• Integrate ETL processes with Tableau for effective data visualization and reporting.
• Collaborate with Tableau developers to provide well-structured data for dashboards and reports.
• Apply healthcare industry knowledge to understand data sources and domain-specific data transformation requirements.
• Ensure compliance with healthcare data regulations (HIPAA, HITECH, etc.) throughout the ETL process.
• Implement data validation routines to identify and resolve data quality issues during ETL processes.
• Monitor data quality continuously and proactively address discrepancies.
• Maintain comprehensive documentation for ETL processes, data mappings, and transformations.
• Create and update technical documentation for team members and stakeholders.
• Collaborate with cross-functional teams including data engineers, analysts, and business stakeholders to understand requirements and deliver solutions.

Requirements

• Proven experience in designing, developing, and implementing ETL processes using Informatica.
• Strong expertise in SQL for data transformations and manipulation.
• Deep understanding of data warehousing concepts and best practices.
• Experience with Tableau for data visualization and reporting integration.
• Knowledge of healthcare data structures and compliance regulations (HIPAA, HITECH).
• Ability to implement data validation routines and monitor data quality.

Nice-to-haves

• Experience with other ETL tools or data integration platforms.
• Familiarity with cloud-based data warehousing solutions.
• Knowledge of data governance and data management best practices.

Benefits

• Health insurance coverage
• Flexible working hours
• Professional development opportunities