Purple Drive Technologies LLC
Purple Drive Technologies LLC

Senior Informatica IDMC Tech Lead

Pleasanton, CA, US • Posted 6 hours ago • Updated 52 minutes ago
Full Time
Part Time
On-site
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Durable Skills
  • Data Management
  • Software Estimation
  • Authentication
  • Routers
  • Aggregator
  • Java
  • XML
  • Design Patterns
  • Performance Analysis
  • Unit Testing
  • Integration Testing
  • Regression Testing
  • Data Quality
  • Data Processing
  • Workflow
  • Scheduling
  • Orchestration
  • Continuous Integration
  • Continuous Delivery
  • Access Control
  • IT Management
  • Delivery Management
  • Technical Analysis
  • Software Design
  • Development Testing
  • Testing
  • Management
  • Mentorship
  • Technical Drafting
  • Data-flow Diagrams
  • Collaboration
  • Quality Assurance
  • Knowledge Transfer
  • Continuous Improvement
  • Data Engineering
  • Informatica PowerCenter
  • PL/SQL
  • Unix
  • Linux
  • Shell Scripting
  • Log Analysis
  • Extract
  • Transform
  • Load
  • ELT
  • Data Integration
  • Mapping
  • Estimating
  • Analytical Skill
  • Conflict Resolution
  • Problem Solving
  • Communication
  • Documentation
  • Migration
  • Databricks
  • Microsoft Azure
  • Analytics
  • PySpark
  • Python
  • Scripting
  • Meta-data Management
  • Extraction
  • Reporting
  • Cloud Computing
  • Data Migration
  • Business-to-business
  • Health Care
  • Electronic Data Interchange
  • Informatica
  • Data Validation
  • DVO
  • Agile
  • Sprint

Summary

Job Description: Senior Informatica IDMC Tech Lead

Experience: 10+ Years

Role: Informatica IDMC / IICS Tech Lead

Essential Skills: Informatica IDMC (IICS), PowerCenter, CDI-PC, Oracle SQL, Unix

Job Overview

We are looking for an experienced Senior Informatica IDMC Tech Lead to lead the modernization and migration of existing Informatica PowerCenter/CDI-PC assets to Informatica Intelligent Data Management Cloud (IDMC/IICS). The role involves technical analysis, solution design, development, conversion, validation, and testing of ETL/ELT workflows, along with technical leadership, effort estimation, task allocation, and delivery governance.

The ideal candidate should have strong hands-on experience with Informatica PowerCenter, CDI-PC, IDMC/IICS, Oracle SQL, and Unix, along with expertise in cloud data integration and migration. Experience with Databricks, Azure Data Factory, Python, and large-scale data ingestion is highly desirable.

Key Responsibilities

1. Informatica Development and Migration

  • Analyze existing Informatica PowerCenter/CDI-PC mappings, sessions, workflows, mapplets, worklets, parameter files, and dependencies.

  • Design, develop, and maintain data integration workflows using Informatica IDMC/IICS.

  • Convert legacy ETL assets into IDMC-compatible mappings, mapping tasks, taskflows, connections, and schedules.

  • Identify conversion challenges, assess asset complexity, and recommend appropriate redesign or remediation approaches.

  • Ensure migrated workflows preserve existing business logic, transformation behavior, and source-to-target mappings.


2. ETL/ELT Pipeline Development

  • Build, optimize, and maintain ETL/ELT pipelines for enterprise data integration and cloud data platforms.

  • Integrate Informatica IDMC with Databricks Lakehouse, Azure Data Factory, Azure Synapse Analytics, and other data platforms as required.

  • Develop scalable data ingestion and transformation solutions supporting diverse data formats and large data volumes, including petabyte-scale workloads.

  • Configure secure connections, authentication mechanisms, and data movement strategies between source and target systems.


3. Complex Transformation and Technical Design

  • Analyze and implement complex Informatica transformations, including expression, router, lookup, aggregator, Java, and XML transformations.

  • Evaluate transformation compatibility between PowerCenter/CDI-PC and IDMC/IICS.

  • Develop reusable design patterns and remediation approaches for unsupported or behaviorally different transformations.

  • Establish development standards, naming conventions, reusable components, and environment deployment practices.


4. Data Validation and Quality

  • Develop and execute Oracle SQL queries for source-to-target validation, data reconciliation, performance analysis, and defect investigation.

  • Validate converted workflows through unit testing, integration testing, regression testing, and production-readiness checks.

  • Troubleshoot pipeline failures, data discrepancies, runtime issues, and performance bottlenecks.

  • Use Informatica Data Validation Option (DVO) or similar automated validation tools where applicable.

  • Implement data quality, metadata management, governance, and monitoring best practices.


5. Cloud Data Engineering and Automation

  • Develop and optimize cloud-based data integration solutions using Informatica IDMC/IICS.

  • Use Python and Unix/Linux shell scripting to automate data processing, validation, metadata extraction, and operational activities.

  • Implement workflow scheduling, task orchestration, and event-driven processing using Informatica capabilities.

  • Support CI/CD practices, deployment automation, monitoring, and operational reliability.

  • Apply secure data handling and access control practices across cloud data environments.


6. Technical Leadership and Delivery Management

  • Lead technical analysis, solution design, development, testing, and migration activities.

  • Estimate effort based on asset complexity, dependencies, transformation logic, source/target systems, and testing requirements.

  • Break down deliverables into actionable tasks and allocate work based on team capabilities and priorities.

  • Review technical designs, code, mappings, test evidence, and conversion deliverables.

  • Track progress, resolve technical blockers, manage risks, and communicate delivery status to stakeholders.

  • Mentor developers and guide the team on Informatica best practices, troubleshooting, and migration patterns.


7. Documentation and Collaboration

  • Prepare technical design documents, data flow diagrams, conversion playbooks, validation reports, and operational runbooks.

  • Collaborate with data architects, business analysts, QA teams, infrastructure teams, and business stakeholders.

  • Conduct technical walkthroughs, knowledge-transfer sessions, and peer reviews.

  • Identify opportunities for reusable accelerators, automation, and continuous improvement.


Required Qualifications

  • 10+ years of experience in Informatica ETL development, data integration, or data engineering.

  • Strong hands-on experience with Informatica PowerCenter and/or CDI-PC.

  • Practical experience developing, configuring, validating, and troubleshooting Informatica IDMC/IICS assets.

  • Strong Oracle SQL skills, including complex joins, data validation, reconciliation, and performance troubleshooting.

  • Working knowledge of Unix/Linux commands, shell scripting, file handling, and log analysis.

  • Experience with ETL/ELT pipeline design, data integration, migration, and source-to-target mapping.

  • Experience leading technical teams, estimating effort, allocating tasks, reviewing deliverables, and resolving complex technical issues.

  • Strong analytical, problem-solving, communication, and documentation skills.


Preferred Qualifications

  • Experience with Informatica CDI-PC to IDMC/IICS migration or modernization initiatives.

  • Experience integrating Informatica IDMC with Databricks Lakehouse.

  • Knowledge of Azure Data Factory, Azure Synapse Analytics, and PySpark.

  • Python scripting experience for automation, validation, metadata extraction, and comparison reporting.

  • Familiarity with petabyte-scale data ingestion, cloud data migration, and diverse data formats.

  • Exposure to Informatica B2B services and healthcare EDI formats, particularly 835 and 837.

  • Familiarity with Informatica Data Validation Option (DVO) or equivalent reconciliation tools.

  • Experience with Agile delivery methodologies and sprint planning.


Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91018020
  • Position Id: PDT - 12158-13293-1793021268
  • Posted 6 hours ago

Company Info

About Purple Drive Technologies LLC

Founded in 2007, Purple Drive started as a tech solutions firm and has grown into a full-service consulting and talent partner. We help businesses navigate complex technology challenges while connecting top professionals with career-defining opportunities.

We believe in transforming businesses through smart IT solutions and empowering technologists to grow their expertise through challenging projects and meaningful partnerships. Built on over 20 years of trusted relationships, we create success stories for both our clients and the talented professionals who drive innovation forward.

Go to company profile
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.
More jobs at Purple Drive Technologies LLC in Pleasanton, CA