ETL Informatica Developer

Tittle : ETL Informatica Developer

Location: Across USA any Location (PST working hours)

The pay range for this role is $120k - $130k per annum

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.