ETL/ODI Developer - Python/SQL

Job Title : ETL ODI Developer Night Shift

Client : Raynstech

Location : Remote

Shift Timing : 9 PM IST to 6 AM IST

Experience Required : 7+ Years

Joining : Immediate preferred

Job Description :

- Develop and maintain ETL/ELT solutions using Oracle Data Integrator (ODI).

- Design and document data warehouse schemas, including fact and dimension tables.

- Write and deploy stored procedures and functions; collaborate with DBAs for implementation.

- Analyze structured and unstructured data sources to map them to Business Requirements Documentation (BRD).

- Create and manage SQL scripts for data transformation and loading.

- Implement and monitor data quality and governance best practices.

- Develop and execute Python scripts to automate data ingestion from APIs.

- Perform data profiling and validation to ensure data accuracy and completeness.

- Investigate and resolve data quality and integration issues.

- Communicate effectively with business and technical stakeholders.

Required Skills :

- 7+ years of hands-on experience with Oracle Data Integrator (ODI)

- Strong expertise in SQL, ETL/ELT, and data warehouse design

- Proven experience with data modeling (fact/dimension schemas)

- Proficient in Python scripting for API integration and automation

- Strong analytical and troubleshooting skills

- Excellent communication skills, both verbal and written

- Ability to work independently and adapt to a fast-paced, night shift schedule

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