ETL ODI Developer

20 hours ago

India Weekday AI Full time ₹ 11,00,000 - ₹ 18,00,000 per year

This role is for one of Weekday's clients
Salary range: Rs Rs ie INR 11-15 LPA)
Min Experience: 8 years
Location: Remote (India), NCR, Pune, Mumbai, Kolkata
JobType: full-time

Requirements

We are looking for a highly skilled and experienced ETL Developer with strong expertise in Oracle Data Integrator (ODI) to join our team on a contractual basis. The ideal candidate will have over 5 years of hands-on experience in ODI, ELT/ETL processes, data modeling, and advanced SQL. Familiarity with Python scripting for API-based data ingestion is a key advantage.

This is a night shift role (India time), requiring strong analytical skills, a problem-solving mindset, and the ability to work independently in a fast-paced, data-driven environment.

Key Responsibilities:

  • Design, develop, and maintain ETL processes and stored procedures using Oracle Data Integrator (ODI).
  • Develop and document data warehouse schemas including fact and dimension tables based on business requirements.
  • Write and execute SQL scripts for table creation; collaborate with DBAs for schema deployment.
  • Analyze various data sources to identify relationships and align them with Business Requirement Documents (BRD).
  • Design and implement Extract, Load, Transform (ELT) processes to move data from source systems into staging and target environments.
  • Perform data validation and profiling using SQL and analytical tools to ensure data quality and completeness.
  • Apply data governance best practices, including query optimization, metadata management, and data quality monitoring.
  • Demonstrate strong data modeling skills to build scalable and efficient data architectures.
  • Use Python to automate API-based data ingestion, improving integration workflows and enabling near real-time data processing.
  • Investigate and resolve data quality issues through in-depth analysis and root cause identification.
  • Collaborate and communicate effectively with cross-functional stakeholders through strong written and verbal skills.
  • Show initiative and research capabilities to solve complex data problems quickly and efficiently.

Required Skills & Qualifications:

  • 8+ years of overall experience in ETL/Data Warehousing roles.
  • Minimum 5 years of hands-on experience with Oracle Data Integrator (ODI).
  • Strong proficiency in SQL, data modeling, and ETL/ELT design.
  • Experience with data warehouse architecture and schema design.
  • Practical knowledge of Python scripting for API integration and automation.
  • Solid understanding of data governance, data quality frameworks, and performance tuning.
  • Ability to analyze complex data sets and derive insights.
  • Excellent problem-solving, communication, and documentation skills.

Nice to Have:

  • Exposure to cloud platforms (Oracle Cloud, AWS, Azure, etc.)
  • Experience with version control systems (e.g., Git)
  • Familiarity with Agile methodologies

  • Senior ODI Developer

    1 day ago

    Anywhere in India/Multiple Locations MARKTINE TECHNOLOGY SOLUTIONS PRIVATE LIMITED Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Description : About the Role We are seeking an experienced Senior ODI Developer with expertise in Oracle Data Integrator (ODI) to design, develop, and maintain ETL processes that support enterprise data initiatives. The role involves working closely with data architects, business analysts, and ETL teams to deliver high-quality, scalable, and...

  • Etl Odi Developer

    3 weeks ago

    India Weekday AI Full time

    This role is for one of Weekday s clients Salary range Rs 1100000 - Rs 1500000 ie INR 11-15 LPA Min Experience 8 years Location Remote India NCR Pune Mumbai Kolkata JobType full-time Requirements We are looking for a highly skilled and experienced ETL Developer with strong expertise in Oracle Data Integrator ODI to join our team on a contractual basis The...

  • Senior Developer

    5 days ago

    India KPI Partners Full time

    Experience : 6 to 10 Years Mandatory Skill : ODI, OBIEE, DWH, Python Programming, SQL Key Responsibilities: - Design and develop ETL processes using Oracle Data Integrator to facilitate seamless data integration between various sources and targets. - Conduct requirements gathering sessions to understand client needs and translate them into technical...

  • Senior Developer

    6 days ago

    India KPI Partners Full time

    Experience : 6 to 10 YearsMandatory Skill : ODI, OBIEE, DWH, Python Programming, SQLKey Responsibilities:- Design and develop ETL processes using Oracle Data Integrator to facilitate seamless data integration between various sources and targets.- Conduct requirements gathering sessions to understand client needs and translate them into technical...

  • Senior Developer

    4 days ago

    India KPI Partners Full time

    Experience : 6 to 10 Years Mandatory Skill : ODI, OBIEE, DWH, Python Programming, SQL Key Responsibilities: - Design and develop ETL processes using Oracle Data Integrator to facilitate seamless data integration between various sources and targets. - Conduct requirements gathering sessions to understand client needs and translate them into technical...

  • Etl Developer

    3 weeks ago

    India Weekday AI Full time

    This role is for one of the Weekday s clients Salary range Rs 400000 - Rs 1500000 ie INR 4-15 LPA Min Experience 8 years Location Remote India JobType full-time We are seeking an experienced ETL Developer with deep expertise in Oracle Data Integrator ODI to join our team on a contractual basis The ideal candidate will have a strong background in ETL ELT...

  • Senior ODI Consultant

    1 week ago

    Pune, India Oracle Full time

    Job Description We are seeking a highly skilled Senior ODI Developer with strong hands-on experience in SQL, PL/SQL, and Oracle Data Integrator (ODI) projects, particularly on OCI (Oracle Cloud Infrastructure) PaaS or IaaS platforms. The ideal candidate will design, implement, and optimize ETL processes, leveraging cloud-based solutions to meet evolving...

  • ETL Developer

    2 days ago

    India Philodesign Technologies Inc Full time

    We’re Hiring: Enterprise Data Engineer Are you passionate about building large-scale, high-performance data solutions? We’re looking for an experienced Enterprise Data Engineer to join our team and play a key role in designing, developing, and optimizing robust data integration and warehouse systems.What You’ll DoDesign, build, and maintain data...

  • ETL Developer

    2 days ago

    India Philodesign Technologies Inc Full time

    We’re Hiring: Enterprise Data Engineer Are you passionate about building large-scale, high-performance data solutions? We’re looking for an experienced Enterprise Data Engineer to join our team and play a key role in designing, developing, and optimizing robust data integration and warehouse systems. What You’ll Do Design, build, and maintain data...

  • ETL Developer

    3 days ago

    India Philodesign Technologies Inc Full time

    We’re Hiring: Enterprise Data Engineer Are you passionate about building large-scale, high-performance data solutions? We’re looking for an experienced Enterprise Data Engineer to join our team and play a key role in designing, developing, and optimizing robust data integration and warehouse systems. What You’ll Do Design, build, and maintain data...