Job Category: onsite
Location: Toronto, On
Job Type:Full Time
Job Posted: 2025-06-25
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.
Job Types: Full-time, Permanent
Pay: $95,000.00-$110,000.00 per year
Schedule:
Work Location: In person