ETL ODI Developer at Weekday AI

, , India -

Full Time

Start Date

Immediate

Expiry Date

13 Jan, 26

Salary

1500000.0

Posted On

15 Oct, 25

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

ETL, Oracle Data Integrator, SQL, Data Modeling, Python, Data Governance, Data Quality, Problem Solving, Analytical Skills, Data Warehousing, ELT, Data Validation, API Integration, Metadata Management, Performance Tuning, Communication Skills

Industry

technology;Information and Internet

Description

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 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

Responsibilities

Design, develop, and maintain ETL processes and stored procedures using Oracle Data Integrator (ODI). Collaborate with cross-functional stakeholders to ensure data quality and alignment with business requirements.