ETL Informatica Developer

ETL Informatica Developer Location: Across USA any Location (PST working hours) Duration: Contract Seeking 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. Yochana