
Purple Drive Technologies LLC
Pleasanton, California • Today
Easy Apply
Full-time, Part-time, Contract, Third Party
33 results (6 new)

Purple Drive Technologies LLC
Pleasanton, California • Today
Easy Apply
Full-time, Part-time, Contract, Third Party







Maven Companies
Hybrid in Fremont, California • Today
Easy Apply
Third Party, Contract
Depends on Experience













TechClub Inc.
Remote or San Diego, California • 13d ago
Easy Apply
Contract, Third Party
Depends on Experience

Experience: 10+ Years
Role: Informatica IDMC / IICS Tech Lead
Essential Skills: Informatica IDMC (IICS), PowerCenter, CDI-PC, Oracle SQL, Unix
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
To see how well you match this job, please log in or create an account.
Once logged in, be sure to complete your profile to get the most accurate match score.
Atlanta, Georgia
•
Today
Job Description: Security Engineer - Blockchain & Cloud Security Essential Skills: Security Engineering, Vulnerability Remediation, Security Controls, Blockchain Fundamentals, API Security Job Summary We are seeking a skilled and motivated Security Engineer to identify and remediate security vulnerabilities, strengthen security controls, and support secure solution architecture across enterprise applications, infrastructure, and cloud environments. The candidate will collaborate with engineering
Easy Apply
Full-time, Part-time, Third Party, Contract
Remote or Atlanta, Georgia
•
Today
Job Description: Senior Oracle XStore POS Developer - Java Full Stack & AI Job Title: Senior Oracle XStore POS Developer Location: Remote / Hybrid / Onsite Essential Skills: Oracle XStore POS, Advanced Java, Retail POS Systems Job Summary We are seeking an experienced Senior Oracle XStore POS Developer with strong expertise in Oracle Retail XStore, advanced Java development, and point-of-sale (POS) systems. The candidate will be responsible for developing, customizing, integrating, and maintai
Easy Apply
Full-time, Part-time, Third Party, Contract
New York, New York
•
Today
Hi All, Location:NYC,NY ROLE_DESCRIPTION - We are looking for a highly skilled Senior Data Engineer with strong hands-on experience in SQL Server, Snowflake, Python, and SSIS to design, develop, and support enterprise data integration and analytics solutions. The candidate will work closely with business stakeholders, data analysts, data scientists, and technical teams to build scalable and reliable data pipelines, ensure data quality, support testing activities, and optimize enterprise data w
Easy Apply
Full-time, Part-time, Contract, Third Party