OBIEE + ETL Developer

Role: Senior developer working on BI project which involves OAC RPD design, Data warehousing, Data modelling, Reports/dashboard development and to work in global teams and support global cross-functional environment partnering with internal customers to help, support and enhance business systems

Qualifications & Certifications

1. Engineering Graduate or Master of Computer Applications (MCA)

2. Certified in one or more of the following is an advantage – OBIEE, OAC

Experience

1. 5-8 years of BI experience

2. 5+ years of experience on Informatica, OBI, OAC & SQL (minimum 2-year experience on each of the tool mentioned)

3. Must have worked on at least 2 complete life cycle implementations of BI projects

Required Skills (Must have) along with necessary industry experience

General

1. Experience in any service industry where Oracle BI is extensively used for their global customers with strong customer centric focus.

2. Total experience of 5-8 years, with excellent communication, coordination, and team leadership skills

3. Prior experience in handling E2E Product Operations Lifecycle (Ex: ETL/Report, Incident management/Bug-Fix) and E2E Product Engineering lifecycle (ex: Enhancements and Projects with release life cycle experience)

4. Ability to evaluate technology solution options for business requirements

5. Should be able to identify opportunities for automation and implement the same to bring in efficiencies

6. Ability to manage complex stakeholders in a dynamic, matrix organization

7. Self-motivated, positive attitude and ability to inject optimism

8. Ability to challenge status quo and lead discussions in the right direction

9. Ability to collaborate with various teams locally and globally

10. Ability to influence without authority

11. Ability to articulate thoughts and ideas clearly

12. Excellent interpersonal skills, ability to negotiate the best things for the organization

13. Crisis, conflict, issues management skills

14. Eye for detail as well as understanding of the big picture

15. Ability to work with ambiguous information

Requirements

Functional

1. Preferably HCM domain and process knowledge or prior experience of any data warehouse/ERP implementation.

2. Ability to gather requirements and convert business requirements to technical requirements

3. Providing effort estimations to complex BI projects

4. Engage with cross teams to analyze data sources required to integrate for a new analytical solution

5. Maintain and enhance operating rhythm

6. Experience in managing challenging stakeholders

7. Ability to validate change requests

Technical :

1. Should have worked extensively in OBIEE RPD development involving time series calculations, YTD measures and configuring security

2. Experience on creating projects using Oracle Analytics Cloud depicting visualizations to help understand the data trends and analytics for business users

3. Worked to build complex reports in OBIEE in a performant way and has good understanding of role security aspects.

4. Data modelling expertise using STAR and SNOWFLAKE schema design.

5. Should have worked extensively in OBIEE RPD development involving time series calculations, YTD measures and configuring security

6. Experience on creating projects using Oracle Analytics Cloud depicting visualizations to help understand the data trends and analytics for business users

7. Worked to build complex reports in OBIEE in a performant way and has good understanding of role security aspects.

8. Should have Strong knowledge of Oracle database & PL/SQL development

9. Must know how to write advance SQL, use Oracle's SQL aggregate and analytic function

10. Expert in debugging, optimizing, and Performance Tuning of OAC visualizations, Oracle BI Repository & Dashboards / Reports

11. Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.

12. Understand and design data models to setup robust Datawarehouse environment