Data Integration Engineer

ROLE SUMMARYData Integration Engineer specialized in designing, developing, and operating enterprise data pipelines using ETL tools, with Informatica IDMC (Intelligent Data Management Cloud / IICS) as the primary platform.Able to work across cloud-agnostic environments, including Azure, AWS, and GCP.REQUIRED TECHNICAL SKILLSInformatica IDMC – Integration CoreCloud Data Integration (CDI)Mapping DesignerSQL ELT with pushdown optimization (full/source/target)TaskflowsMapping partitioningDynamic MappingsParameterizationFile listenersIntelligent Structure Models (CLAIRE-powered)Performance tuningCloud Mass Ingestion (CMI)Experience with batch and near-real-time ingestion from heterogeneous sources across:Mass Ingestion Databases (CDC)FilesApplicationsStreamingCloud Application Integration (CAI)Process DesignerService connectorsGuidesBusiness processesAPI and microservices integrationPowerCenter to IDMCMigration and modernization of on-premises pipelinesStructured migration methodologyCDI-PCMigration acceleratorsPlatform OperationsAdministration of Secure AgentsRuntime environment managementSecure Agent GroupsMonitoringSLA managementAI-Assisted Development – CLAIRECLAIRE GPT / CLAIRE Copilot: Assisted generation of mappings, debugging of transformations, and automated pipeline documentation through natural language within IDMC.Awareness of new agentic capabilities (CLAIRE Agents, Fall 2025 release) for headless ingestion and transformation flows.Platform FinOpsUnderstanding of the IPU (Informatica Processing Units) consumption model.Per-service cost optimization.Cloud-Agnostic TechnologiesAWS — Core to the RoleAWS GlueAmazon S3AWS Step FunctionsAmazon AthenaAzureAzure Data Factory (ADF)Infrastructure as Code & CI/CDTerraformCloudFormationGitHub / BitbucketJenkinsDatabases & PlatformsAdvanced SQL: Oracle, SQL Server, PostgreSQL, Amazon Redshift, Databricks SQLNoSQL: MongoDB, DynamoDB (desirable)Data Warehouse architecture patternsData Lake architecture patternsLakehouse architecture patternsCERTIFICATIONSCoreInformatica Cloud Data Integration Developer, Professional Certification (ICP)RelevantInformatica IDMC Foundation / Data Engineering FoundationDesirableInformatica Cloud Application Integration Developer, Professional CertificationDatabricks Certified Data Engineer AssociateComplementaryMicrosoft Certified: Azure Data Engineer Associate (DP-203)AWS Certified Data Engineer / AWS Certified Data Analytics SpecialtyKEY RESPONSIBILITIESDesign and implement ingestion, transformation, and distribution pipelines using CDI and Cloud Mass Ingestion.Develop data pipelines using the following AWS cloud services:AWS GlueAmazon S3AWS Step FunctionsAmazon AthenaExtract and process data from heterogeneous sources using AWS services.Provide support for incidents related to data pipelines and data publishing, ensuring the quality and reliability of services provided to data users.Support infrastructure components, including:EC2 Linux and Windows machinesS3 bucketsSNSEventBridgeOperate and maintain integration infrastructure, including Secure Agents and runtime environments, across Azure and AWS while meeting SLA standards.Apply CLAIRE GPT / CLAIRE Copilot to optimize the mapping development lifecycle and improve development efficiency.