Lead Data Engineer (IICS & SQL) - R01554184

Lead Data Engineer (IICS & SQL) - R01554184

Lead Data Engineer

Primary Skills

• Microsoft Dynamics CRM, Synapse, IICS

Job Requirements

• Job Description – Lead Data Engineer (Individual Contributor)
• Position Summary Looking for a highly skilled Senior Data Engineer with expert-level experience in Informatica Cloud (Data Integration & Application Integration), Azure (Synapse SQL, API Management), Python, and CRM integration (Microsoft Dynamics 365 or Salesforce).
• This role is a hands-on individual contributor position, responsible for building, optimizing, and supporting complex data and application integration solutions in a cloud-first environment.
• Key Responsibilities Informatica Cloud (IICS): Develop and maintain Informatica Cloud Data Integration (ICDI) mappings, tasks, and workflows.
• Build Application Integration solutions using APIs, event-driven integrations, and real-time flows.
• Apply best practices for performance optimization, error handling, and deployment automation.
• Azure Services: Design and implement data pipelines and transformations using Azure Synapse SQL.
• Develop and manage APIs using Azure API Management, ensuring secure and scalable integrations.
• Integrate Azure data services seamlessly with Informatica Cloud and enterprise applications.
• Python Development: Write advanced Python scripts for ETL automation, data quality checks, and API interactions.
• Build reusable modules and utilities to support integration frameworks.
• Troubleshoot and optimize scripts for performance and reliability.
• CRM Integration (Dynamics 365 / Salesforce): Develop and support real-time and batch integrations between CRM platforms and enterprise systems.
• Ensure data consistency, error handling, and synchronization across CRM and downstream systems.
• Work closely with CRM teams to address integration needs for Sales, Service, and Customer Data.
• Required Skills & Experience Informatica Cloud (Expert): 7–9 years hands-on with Data Integration & Application Integration.
• Expertise in handling large-volume data synchronization and delta processing.
• Other Skills: Strong analytical and problem-solving skills.
• Ability to work independently and deliver high-quality integration solutions.
• Good communication skills for working with business and technical stakeholders.