ETL Developer

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 processes , data modeling , and advanced SQL , with added advantage for experience in Python scripting for API-based data ingestion . This is a night shift role (India time) suited for someone who thrives in a fast-paced, data-driven environment and can work independently with strong analytical and problem-solving abilities.

Requirements

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 needs.
• Write and execute SQL scripts for table creation and coordinate with DBAs for schema deployment.
• Analyze diverse data sources to identify data relationships and map them to Business Requirement Documents (BRD) .
• Design and implement Extract, Load, Transform (ELT) workflows to move data efficiently from source to target systems.
• Perform data validation and profiling to ensure accuracy, consistency, and completeness.
• Apply data governance best practices , including query optimization, metadata management, and data quality checks.
• Demonstrate strong data modeling skills to develop scalable and efficient data architectures.
• Use Python scripting to automate API-based data ingestion and enhance integration processes.
• Investigate and resolve data quality issues through root cause analysis.
• Communicate effectively with cross-functional teams, presenting insights and recommendations clearly.
• Exhibit strong research and problem-solving capabilities to address complex data challenges.

Required Skills & Qualifications :

Nice to Have :

Skills :

ETL | ODI | SQL | Data Modeling | BRD | FRD | UAT | Python | ELT | Data Governance