Data Analyst

Sopra Steria USA; Dadri; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

Sopra Steria USA is looking for an experienced ODI Developer in Dadri, Uttar Pradesh. The candidate will be responsible for designing and implementing ETL processes using Oracle Data Integrator and integrating data from Oracle Fusion Applications.

With 6-8 years of relevant experience, strong SQL and PL/SQL skills are essential. The role includes performance optimization and data quality management. A B.Tech, M.Tech, or MCA degree is required. The position is open to candidates willing to work in UK shifts.

Qualifications

• 6-8 years of professional relevant experience in ODI development.
• Proven track record of 2–3 ODI projects (end-to-end implementation).
• Strong experience with SQL, PL/SQL, and Oracle database concepts.

Responsibilities

• Design, develop, and implement ETL processes using Oracle Data Integrator.
• Extract and transform data from Oracle Fusion applications into downstream systems.
• Tune ODI mappings, packages, and procedures for efficiency.
• Implement validation rules and reconciliation processes to ensure accuracy.
• Lead or contribute to 2–3 ODI implementation projects, ensuring timely and successful outcomes.
• Work closely with business analysts, functional consultants, and DBAs to deliver integrated solutions.
• Prepare technical design documents, deployment guides, and support manuals.

Skills

ODI development

Oracle Fusion Applications

SQL

PL/SQL

Data warehousing principles

ETL best practices

Troubleshooting integration issues

Education

B.Tech / M.Tech / MCA

Job description

Job Description

Skills

1. 6-8 years of professional relevant experience in ODI development.
2. Strong experience with Oracle Fusion Applications as a data source.
3. Proven track record of 2–3 ODI projects (end-to-end implementation).
4. Proficiency in SQL, PL/SQL, and Oracle database concepts.
5. Knowledge of ETL best practices and data warehousing principles.
6. Ability to troubleshoot and resolve complex integration issues.

Key Responsibilities

• ODI Development: Design, develop, and implement ETL processes using Oracle Data Integrator.
• Oracle Fusion Integration: Extract and transform data from Oracle Fusion applications into downstream systems.
• Performance Optimization: Tune ODI mappings, packages, and procedures for efficiency.
• Data Quality: Implement validation rules and reconciliation processes to ensure accuracy.
• Project Delivery: Lead or contribute to 2–3 ODI implementation projects, ensuring timely and successful outcomes.
• Collaboration: Work closely with business analysts, functional consultants, and DBAs to deliver integrated solutions.
• Documentation: Prepare technical design documents, deployment guides, and support manuals.

Qualifications

B.Tech / M.Tech / MCA

Additional Information

Open to work in UK Shift

At our organization, we are committed to fighting against all forms of discrimination. We foster a work environment that is inclusive and respectful of all differences.

All of our positions are open to people with disabilities.