Informaticab ETL Developer

Clindcast - Tampa, FL

Full-time - Mid Level

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.

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.
• 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.
• Collaborate with cross-functional teams including data engineers, analysts, and business stakeholders.

Requirements

• Proven experience as an ETL Developer with expertise in Informatica and Tableau.
• Strong background in the healthcare domain and understanding of healthcare data regulations.
• Experience in designing and implementing ETL processes and workflows.
• Proficiency in SQL for data manipulation and transformation.
• Ability to collaborate effectively with cross-functional teams.

Nice-to-haves

• Experience with other ETL tools and data visualization platforms.
• Knowledge of data warehousing concepts and best practices.
• Familiarity with data governance and data quality frameworks.