Informaticab ETL Developer

Clindcast - Tampa, FL

Full-time - Senior

Tampa, FL

About the position

ClinDCast is seeking 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. The ideal candidate will leverage their technical skills and healthcare knowledge to enhance data quality and compliance with industry regulations.

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 manipulation and transformation.
• Experience with Tableau for data visualization and reporting.
• Deep understanding of data structures and data warehousing concepts.
• Knowledge of healthcare industry data sources and regulations (HIPAA, HITECH).
• Ability to implement data quality and validation routines.

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

• Competitive salary range of $109K - $138K per year.
• Opportunities for professional development and training.