OBIEE/ETL Developer

Job Description :

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 :

- Engineering Graduate or Master of Computer Applications (MCA)

- Certified in one or more of the following is an advantage OBIEE, OAC

Experience :

- 5-8 years of BI experience

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

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

Required Skills (Must have) along with necessary industry experience :

General :

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

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

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

- Ability to evaluate technology solution options for business requirements

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

- Ability to manage complex stakeholders in a dynamic, matrix organization

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

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

- Ability to collaborate with various teams locally and globally

- Ability to influence without authority

- Ability to articulate thoughts and ideas clearly

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

- Crisis, conflict, issues management skills

- Eye for detail as well as understanding of the big picture

- Ability to work with ambiguous information

Requirements :

Functional :

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

- Ability to gather requirements and convert business requirements to technical requirements

- Providing effort estimations to complex BI projects

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

- Maintain and enhance operating rhythm

- Experience in managing challenging stakeholders

- Ability to validate change requests

Technical :

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

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

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

- Data modelling expertise using STAR and SNOWFLAKE schema design.

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

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

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

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

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

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

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

- Understand and design data models to setup robust Datawarehouse environment