ODI ETL developer Job at Infinity Quest UK, Remote

K0NuYmd5UzJ0WUorWk5tUkZrNG00SXNESFE9PQ==
  • 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

Aethir

Advertising & Media Marketing Sales Specialist Job at Aethir

 ...We are seeking for a Sales Representative for our social media marketing platform, you will be responsible for identifying potential clients, building relationships, and closing deals. You will play a key role in driving revenue growth by demonstrating the value of our... 

SC Wild

Wellness Coach Job at SC Wild

 ...Role You will be responsible for : Providing support for executing clinical trials. Coordinating with the business and as well as onsite staff, clinical research coordinators, principal investigators, and vendors to ensure clinical studies meet or exceed... 

The UPS Store #5048

The UPS Store Customer Service Sales Associate Job at The UPS Store #5048

 ...outstanding customer service to walk-in customers and telephone inquiry * Continuously practices good listening skills with customers, UPS Store team members, and leadership* Takes ownership of the customer's shipping needs and offers viable solutions* Takes action to... 

Solomon Page

Art Director Job at Solomon Page

Were looking for a visionary Digital Art Director to help lead the transformation of a dynamic, fast-evolving retail brand in Columbus, OH! This is a rare opportunity for a creative leader who thrives at the intersection of concept, craft, and technology someone who... 

Steampunk

UX/UI Designer Job at Steampunk

**Overview**As a **UI/UX Designer** ,you willbe responsible forguiding government clients through our Design Intelligenceframework, incorporating human-centered methods to solve complex user experience challenges. You will plan and execute UX initiatives from discovery...