Senior BI Developer - Data Analytics (5-8 yrs)

Senior BI Developer OAC.

Bangalore, Karnataka, India.

Job Type : Full Time.

Immediate Joiners only.

Face to Face is mandatory.

About the Role :

Qualifications & Certifications :

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

- Certified in one or more of the following is an advantage - OAC, 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.

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

- Hands on experience in tuning mappings, identifying, and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.

- Monitor and tune the performance of the OAC environment.

Essential Day-to-Day Responsibilities :

- Delivery of enhancement requests and other operational activities of the project.

- Up to date communication to stakeholders using JIRA as medium.

- Participate in Replenishment calls with stakeholders to clarify blockers and agree on deliveries.

- Train and mentor team members and management to understand technologies and assist with development of OAC/OAC.

- Tracking and following up the action items.

- Ensure all requests are addressed in a timely manner with optimal solution.

- Simplify - use every opportunity to simplify to the maximum extent possible and go the extra mile in doing so.

- Collaborate with internal teams to address business needs.

- Assume personal responsibility for achieving defined outcomes.

- Effectively plan & organize work to deliver consistent results.

Requirements :

Qualifications & Certifications :

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

- Certified in one or more of the following is an advantage - OAC, 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.

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

- Hands on experience in tuning mappings, identifying, and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.

- Monitor and tune the performance of the OAC environment.

Essential Day-to-Day Responsibilities :

- Delivery of enhancement requests and other operational activities of the project.

- Up to date communication to stakeholders using JIRA as medium.

- Participate in Replenishment calls with stakeholders to clarify blockers and agree on deliveries.

- Train and mentor team members and management to understand technologies and assist with development of OAC/OAC.

- Tracking and following up the action items.

- Ensure all requests are addressed in a timely manner with optimal solution.

- Simplify - use every opportunity to simplify to the maximum extent possible and go the extra mile in doing so.

- Collaborate with internal teams to address business needs.

- Assume personal responsibility for achieving defined outcomes.

- Effectively plan & organize work to deliver consistent results.