- ODI

- DW and ETL Concept

- Performance Tuning

- SQL

- BRD

- DBA

Role/Job Description :

Requirements :

7 + years experience with 3+ years in ODI development.

- Strong expertise in ODI 11g/12c, Oracle 11g/12c, SQL, and PL/SQL.

- Proficient in ODI components like interfaces, packages, procedures, variables, knowledge modules.

- Experience working with data warehouse design, OLAP models, and performance tuning.

- Knowledge of data integration from multiple sources like Oracle, flat files, XML.

- Hands-on experience in error handling, static and flow controls, and job scheduling (Standalone/J2EE agents).

- Familiarity with reporting tools like OBIEE, and dashboard configuration is a plus.

- Good exposure to production support activities and release management.

- Strong problem-solving skills, attention to detail, and ability to handle data quality issues.

Nice to Have :

- Experience with Salesforce, Oracle EBS, or other enterprise source systems.

- Exposure to data modeling concepts (fact/dimensions) and SCDs.

- Experience working in Agile environments and using tools like VSTS or Jira.

- Basic familiarity with Ad hoc reporting, user training, and client interfacing.