ETL Informatica DeveloperLocation: Across USA any Location (PST working hours)Duration: ContractSeeking an experienced ETL Informatica Developer to join our Data Engineering team. This role focuses on designing, developing, and implementing data integration solutions within a hybrid cloud and on-premises environment. The ideal candidate will have expertise in Informatica, Java, and Boomi, with a strategic focus on migrating integration workflows to MuleSoft.
A strong understanding of complex SQL and healthcare data standards is essential.Key Responsibilities:Data Integration Development: Design, develop, and maintain ETL workflows using Informatica PowerCenter/IICS, Boomi, and Java to integrate data across various systems and platforms.API Development: Develop and maintain Java-based APIs for data integration and transformation, adhering to best practices in API design and security.Data Quality Assurance: Implement data validation and reconciliation routines to ensure data accuracy and integrity across systems.MuleSoft Migration: Lead the migration of existing integrations from Boomi and Informatica to MuleSoft, ensuring scalability, security, and compliance with healthcare standards.Collaboration: Work closely with cross-functional teams, including data architects, analysts, and business stakeholders, to understand requirements and deliver effective data solutions.Agile Practices: Participate in Agile ceremonies, including sprint planning, daily stand-ups, and retrospectives, contributing to continuous improvement efforts.Documentation: Maintain comprehensive documentation of data integration processes, API specifications, and migration plans.Required Skills:ETL Tools: Hands-on experience with Informatica PowerCenter/IICS and Dell Boomi for data integration tasks.SQL Expertise: Proficiency in writing complex SQL queries for data extraction, transformation, and loading (ETL) processes.Healthcare Data Standards: Understanding of healthcare data standards and regulations, including HIPAA compliance.Java Development: Strong experience in Java programming, particularly in developing enterprise-level applications and APIs.API Integration: Experience in developing and consuming APIs, with a focus on data integration and interoperability.CI/CD Practices: Familiarity with Continuous Integration and Continuous Deployment (CI/CD) pipelines and DevOps practices.Collaboration Tools: Experience with tools like JIRA, Confluence, and ServiceNow for project management and issue tracking.Preferred Qualifications:Data Governance: Knowledge of data governance practices and tools.Cloud Platforms: Experience with cloud platforms such as AWS or Azure.MuleSoft Experience: Exposure to MuleSoft or willingness to transition to it as the primary integration platform.Healthcare Systems: Familiarity with healthcare systems and data formats, including HL7 and FHIR.Exposure to CRM and Learning Management Systems will be a plus.