ETL ODI developer

1 day ago

Bengaluru, Karnataka, India Addnectar Solutions Full time ₹ 15,00,000 - ₹ 25,00,000 per year

END client of Addnectar

Shift: 9PM IST to 6 AM IST

Requirements

We are seeking a skilled and experienced Data Integration Specialist with over 5 years of experience in designing and developing data solutions using Oracle Data Integrator (ODI). The ideal candidate will have strong expertise in data modeling, ETL/ELT processes, and SQL, along with exposure to Python scripting for API-based data ingestion.

Key Responsibilities:

Design, develop, and maintain functions and stored procedures using Oracle Data Integrator (ODI).

Create and document data warehouse schemas, including fact and dimension tables, based on business requirements.

Develop and execute SQL scripts for table creation and collaborate with Database Administrators (DBAs) for deployment.

Analyze various data sources to identify relationships and align them with Business Requirements Documentation (BRD).

Design and implement Extract, Load, Transform (ELT) processes to load data from source systems into staging and target environments.

Validate and profile data using Structured Query Language (SQL) and other analytical tools to ensure data accuracy and completeness.

Apply best practices in data governance, including query optimization, metadata management, and data quality monitoring.

Demonstrate strong data modeling skills to support scalable and efficient data architecture.

Utilize Python to automate data collection from APIs, enhancing integration workflows and enabling real-time data ingestion.

Investigate and resolve data quality issues through detailed analysis and root cause identification.

Communicate effectively with stakeholders through strong written, verbal, and analytical skills.

Exhibit excellent problem-solving and research capabilities in a fast-paced, data-driven environment

  • ODI Developer/ Lead

    5 days ago

    Bengaluru, Karnataka, India Oracle Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Job Description:Responsibilities:Minimum 4-5 years hands-on, end to end DWH Implementation experience using ODI. Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. Should be able to implement reusability, parameterization, workflow design, etc. Expertise in the Oracle ODI tool set and Oracle...

  • ODI Developer

    3 days ago

    Bengaluru, Karnataka, India Vinncraft Software Pvt Ltd Full time ₹ 1,80,000 - ₹ 8,32,00,000 per year

    . Job description5+ Yrs. in-depth hands-on experience in developing ETL/ELT interfaces in Oracle Data Integrator (ODI) 11g.Develop medium to complex ODI interfaces and using various transformation packages and knowledge modules.Ability to diagnose and debug data reconciliation issues and identify fix.Migrate and deploy Code to multiple environments.Create...

  • ODI Developer

    1 week ago

    Bengaluru, Karnataka, India Systechcorp Inc Full time ₹ 10,40,000 - ₹ 26,00,000 per year

    Role: ODI DeveloperExperience: 7+yrsNotice period: Only 15-30daysLocation: BangalorePackage: 13LPA maxWe are seeking an experienced ODI Developer with strong data modeling and analytics skills to design, develop, and maintain data integration and reporting solutions. The ideal candidate will have expertise in Oracle Data Integrator (ODI), Oracle Analytics...

  • ODI Developer

    4 weeks ago

    Bengaluru, Karnataka, India iNetFrame Technologies Private Limited Full time

    Job Title : ODI DeveloperExperience : 5+ YearsLocation : Bengaluru.Required Skills : - Strong hands-on experience with Oracle Data Integrator (ODI).- Proficient in data modeling and relational database design.- Demonstrated expertise in Oracle Analytics Cloud (OAC).- Advanced PL/SQL programming and performance tuning skills.- Solid understanding of data...

  • ODI Developer

    5 days ago

    Bengaluru, Karnataka, India SysTechCorp Inc Full time ₹ 10,00,000 - ₹ 13,00,000 per year

    Role : ODI Developer.Experience : 7+yrs.Notice period : Only 15-30days.Location : Bangalore.Package : 13LPA max. We are seeking an experienced ODI Developer with strong data modeling and analytics skills to design, develop, and maintain data integration and reporting solutions. The ideal candidate will have expertise in Oracle Data Integrator...

  • ODI Developer with PLSQl

    1 week ago

    Bengaluru, Karnataka, India Systechcorp Inc Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Role & responsibilitiesODI Developer with PLSQLPreferred candidate profileJob Description: Job Summary:We are seeking an experienced ODI Developer with strong data modeling and analytics skills to design, develop, and maintain data integration and reporting solutions. The ideal candidate will have expertise in Oracle Data Integrator (ODI), Oracle Analytics...

  • ODI Consultant

    3 weeks ago

    Bengaluru, Karnataka, India LTIMindtree Full time

    Job Skill: ODI ConsultantYears of experience :3+ YearsLocation: Pan India (LTIMindtree office)Technical RequirementTools and Technology ODI 12c and ORACLE database 12c Additional Skills Snowflake and DBTJob description1. Design interfaces packages and load plans in ODI 12c2. Ensure correctness and completeness of Data loading Full load Incremental load3....

  • ODI Consultant

    3 weeks ago

    Bengaluru, Karnataka, India LTIMindtree Full time

    Job Skill: ODI Consultant Years of experience :3+ Years Location: Pan India (LTIMindtree office) Technical Requirement Tools and Technology ODI 12c and ORACLE database 12c Additional Skills Snowflake and DBT Job description Design interfaces packages and load plans in ODI 12c Ensure correctness and completeness of Data loading Full load Incremental...

  • ETL Developer

    1 week ago

    Bengaluru, Karnataka, India Unison Group Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    ETL Development:Collaborate with data architects, business analysts, and stakeholders to gather data requirements and translate them into efficient ETL processes using ODI. Leverage your deep understanding of the OFSAA FSDF data model to design ETL workflows that ensure accurate data extraction, transformation, and loading. Data Integration:Design, develop,...

  • ETL Developer

    1 day ago

    Bengaluru, Karnataka, India UNISON Group Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    ETL Development:Collaborate with data architects, business analysts, and stakeholders to gather data requirements and translate them into efficient ETL processes using ODI.Leverage your deep understanding of the OFSAA FSDF data model to design ETL workflows that ensure accurate data extraction, transformation, and loading.Data Integration:Design, develop,...