Data Engineer

Position Overview
Do you love Healthtech and Singapore? Synapxe is a multiple award-winning Healthcare IT Leader that digitises, connects, and analyses Singapore's health ecosystem. Its ultimate aim is to improve the Singapore population's health and health administrations by integrating intelligent, highly resilient, and cost-effective technologies with process and people.
An ETL Lead will oversee the migration specializing in Informatica PowerCenter to IDMC. This role involves leading the migration efforts, ensuring seamless transition, and leveraging the advanced features of IDMC. The ideal person will have extensive experience in data integration, migration projects and hands-on expertise with both CDI-PC and IDMC.
Role & Responsibilities
Manage the end-to-end migration process from informatica PowerCenter (CDI PC) to Informatica IDMC, ensuring minimal disruption to business operations
Hands on experience in Informatica IDMC for creating mappings, workflows, setting up Secure Agents etc
Integrate data from various sources, both internal and external, into AWS and Databricks environments, ensuring data consistency and quality, while leveraging Informatica IDMC for data integration, transformation, and governance
Develop ETL processes to cleanse, transform, and enrich data for analytical purposes using Databricks Spark and Informatica IDMC
Monitor and optimize data processing and query performance in AWS and Databricks, adjusting to meet performance and scalability requirements, utilizing IDMC for workflow optimization
Implement security best practices and data encryption to protect sensitive data in AWS and Databricks, ensuring compliance with data privacy regulations and using IDMC for data governance
Maintain documentation of data infrastructure, pipelines, and configurations in AWS and Databricks, with metadata management facilitated by IDMC
Collaborate with cross-functional teams to understand data requirements and deliver solutions across AWS, Databricks, and Informatica IDMC
Requirements
Degree in Computer Science, Information Technology, Computer Engineering or equivalent
Minimum 7 years of experience in data engineering, with expertise in AWS or Azure services, Databricks, and/or Informatica IDMC
Understanding and hands-on experience in all phases of project lifecycle and involvement in at least 2 project cycles
Experience in AWS Services focusing on ETL and data processing using ETL software: Informatica PowerCenter, IDMC, CDI-PC, DEI
Strong understanding of data integration concepts, ETL, and data quality management
Experience designing and implementing ETL data mappings, transformations, and workflows
Ability to evaluate technical solutions and resolve data issues, especially for performance of complex transformations
Strong BI data model design skills and proficiency in BI tools such as Oracle Analytics Server and Tableau
Strong knowledge of Oracle SQL, NoSQL databases, and SQL skills in Oracle, Teradata, and MS-SQL Server
Working knowledge of BI languages such as Python, Java, VBA
Excellent problem-solving and analytical skills; strong written and verbal communication and collaboration
Team player with ability to meet delivery targets
AWS Associate/Professional/Specialty certification is preferred
Databricks, IDMC, Tableau certifications are a plus
Experience in healthcare industry with understanding of healthcare business processes is a plus
Apply Now
Note: It only takes a few minutes to apply for a meaningful career in HealthTech - GO FOR IT
Details
Seniority level: Mid-Senior level
Employment type: Full-time
Job function: Information Technology
Industries: IT Services and IT Consulting
#J-18808-Ljbffr