ODI ETL developer Job at Infinity Quest UK, Remote

SFMySXo1ZGZ5bDE5cnQ4SDFRbDZoU3AvcXc9PQ==
  • Infinity Quest UK
  • Remote

Job Description

We are seeking a talented ODI Developer with IDMC knowledge to design, build, and optimize enterprise data integration solutions. The role involves migrating ODI-based ETL pipelines to Informatica IDMC for modern cloud-native data integration, governance, and quality initiatives.

Key Responsibilities:

  • Analyse business requirements and translate them into technical solutions.
  • Re-engineer legacy ETL processes for cloud-native execution.
  • Analyse current ODI mappings, packages, and procedures for ETL workflows.
  • Build and optimize data integration pipelines using Informatica IDMC (Cloud Data Integration, Data Quality, Governance).
  • Migrate and modernize ODI-based ETL processes into IDMC cloud solutions.
  • Collaborate with data architects, analysts, and business stakeholders to gather requirements and deliver scalable solutions.
  • Implement data quality, lineage, and governance frameworks across ODI and IDMC environments.
  • Troubleshoot, monitor, and enhance performance of ETL jobs and workflows.
  • Document technical designs, maintain version control, and support production deployments.
  • Integrate IDMC with cloud platforms like Azure, and Snowflake and other data warehouses.
  • Automate data flows, task scheduling, and workflows within the platform.
  • Implement data cataloguing and metadata management for improved data discovery
  • Monitor and optimize data pipelines for scalability, efficiency, and cost-effectiveness.
  • Troubleshoot performance bottlenecks and implement tuning strategies.
  • Ensure compliance with organizational data governance and security policies.
  • Conduct data reconciliation between Teradata and Snowflake post-migration.
  • Implement validation frameworks to ensure consistency and accuracy.
  • Ensure compliance with data governance and security policies.
  • Document migration processes, best practices, and technical solutions.

Technical Skills:

  • Strong expertise in Oracle Data Integrator (ODI) - mappings, packages, procedures, and performance tuning.
  • Knowledge of Informatica IDMC (Cloud Data Integration, Data Quality, Governance).
  • Proficiency in SQL, PL/SQL, and RDBMS (Oracle, SQL Server, Teradata, Snowflake, etc.).
  • Knowledge of data warehousing concepts, ETL design patterns, and BI integration.
  • Familiarity with cloud platforms (AWS, Azure, GCP) and hybrid architectures.
  • Strong experience in ETL/ELT concepts, data modelling, and design and building data pipelines and transformation logic.
  • Experience with metadata ingestion, data lineage, and classification.
  • Knowledge of DevOps and CI/CD practices for data workflows and version control (Git, Jenkins).
  • Basic scripting in Python, Shell, or PowerShell for automation tasks.
  • Experience in different batch processing and data loading/transformation strategies.
  • Understanding of data profiling, cleansing, and metadata management.
  • Strong problem-solving and communication skills.
  • Experience in banking and financial services will be preferred.

Job Tags

Similar Jobs

Georgetown University

Associate Vice President for Compliance and Ethics and Chief Compliance Officer Job at Georgetown University

 ...a difference in the world. Requirements Job Overview The Associate Vice President for Compliance and Ethics and Chief Compliance Officer of Georgetown University coordinates, monitors, and provides general oversight of the Universitys compliance... 

ORAU

Global Carbon Cycle studies using observations, reanalysis and climate model simulations Job at ORAU

 ...carbon cycle research seeks to study the integrated carbon cycle in the atmosphere, oceans, land, in observational datasets and in models and describe the implications for Earths climate, productivity, and natural resources. The research goal is to understand and quantify... 

Princess Cruises

Security Officer Job at Princess Cruises

 ...unlimited opportunities for growth, and ports of call that will leave you breathless.Be the Consummate Host by leading a team of security personnel in monitoring passenger and crew activities, investigating security matters that arise, and promptly reporting and correcting... 

QSAC, Inc.

Curriculum Coordinator (BCBA) - Bronx School - QSAC Education Job at QSAC, Inc.

 ...years old. Job Summary The QSAC Education program is hiring for a dedicated and...  ...participation in workshops and conferences Administrative Support & Training Participate...  ...training for staff on curriculum: Special education requirements Alternate... 

Go Logistix Inc

Sprinter/Cargo Van Owner Operator Job at Go Logistix Inc

 ...HIRING DRIVERS ACROSS THE NATION. Revolutionize Your Logistics Career with Go Logistix Inc. Empower Your Drive Become a Go...  ...nationwide. E-commerce, B2B, and time-sensitive shipments. Airport, port, and secure freight available for qualified drivers. Driver...