This website uses cookies to ensure you get the best experience on our website. By continuing to use this site, you agree to our cookie  & privacy policy.Accept

checked This is a sample alert

Consultant — Senior BI Developer

  • Full Time
  •  Hybrid - Mumbai Metropolitan Region
  • 6 months
  • Project posted on: 8/12/2025
add_new View Project Details

Consultant — Senior BI Developer

  • Technology
  • Full Stack Development
  • Software architect
  • Technical Product Management

Hybrid - Mumbai Metropolitan Region, Delhi / NCR, Kolkata, Chennai, Bengaluru, Bengaluru, Pune, Hyderabad

Full Time

6 months

 8/12/2025

Assignment Details

Our client, a global leader in Energy Management and Automation, is seeking an Independent Senior BI Developer who will work on global Business Intelligence initiatives involving OAC RPD design, data warehousing, data modelling, and dashboard/report development. The role requires close collaboration with global cross-functional teams and internal business partners to enhance, support, and optimise business systems.


Essential Day-to-Day Responsibilities:
 

1. Delivery of enhancement requests and other operational activities of the project
2. Up to date communication to stakeholders using JIRA as medium.
3. Participate in Replenishment calls with stakeholders to clarify blockers and agree on deliveries
4. Train and mentor team members and management to understand technologies and assist with
development of OAC/OAC
5. Tracking and following up the action items
6. Ensure all requests are addressed in a timely manner with optimal solution
7. Simplify – use every opportunity to simplify to the maximum extent possible and go the extra
mile in doing so
8. Collaborate with internal teams to address business needs
9. Assume personal responsibility for achieving defined outcomes
10. Effectively plan & organize work to deliver consistent results

Skills Required

Qualifications & Certifications

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

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


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 7-10 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 organisation
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 OAC 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 OAC 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 OAC RPD development involving time series calculations, YTD measures and configuring security

6. Strong experience in design, development and testing of Informatica based applications
(PowerCenter 10.2)

7. Transformations like Lookup, sorter, Expression, router , update strategy , filter.

8. Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor).

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

1
0. Expert in using mapping Parameters, Mapping Variables, testing and fixing the issues in
Mapping.

1
1. Understand complex transformations such as mapplet, worklet, normalizer and custom
transformations.

1
2. Experience in Extract/Load/Transform (ETL)workflows (Informatica PowerCenter)
Knowledge on Informatica Cloud services is an advantage. Should have Strong knowledge of Oracle database, PL/SQL development, UNIX scripting.

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

1
4. Worked to build complex reports in OAC in a performant way and has good understanding of role security aspects.

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

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

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

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

1
9. Understand and design data models to setup robust Datawarehouse environment

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

2
1. Monitor and tune the performance of the OAC environment

Industry

IT Services & Consulting

Experience Required:

8+ years

Additional Skills:

  • Oracle Analytics Cloud
  • Product Engineering Lifecycle
  • Dashboard Development
  • Advanced SQL
  • Oracle BI
  • Data Warehousing
  • JIRA
  • Informatica PowerCenter
  • Data Modelling

No of open positions:

1

Similar Freelance Projects you can apply to

View More Projects btn btn

How it works

  • 1

    Build your
    skill profile

  • 2

    Strengthen it
    with feedback

  • 3

    Determine your
    optimal fee level

  • 4

    Apply for matching
    projects

  • 5

    Get finalized

  • 6

    Stay Engaged

Build your skill prodile

Project
step1
shape_step

Request feedback from prior projects and/or work stints

shape_step

Determine your optimal fee level

  • starFeeBee helps consultants understand how to price their services.
  • starEnter your skill & location to get ranges for what similar professionals have charged on projects.
  • starUnlock more details e.g., best paying sub-skills, ranges by projects durations, by simply adding a benchmark from a orior projects.
graph_step2
shape_step

Apply for matching projects

shape_step

Get finalized!

Project
step5
shape_step

Stay Engaged!

Project
step6
shape_step

More than 3000 clients rely on Flexing It today

Frequently asked questions.

We host both full-time & part-time projects from top clients for 100+ skill categories. We also help connect experts like you with clients for short consultation calls called Flexperts

You just need to create a ‘boutique firm’ account during the registration process. The rest of the application process remains the same.

Our freelancers fee benchmarking tool, FeeBee helps our freelancers and consultants find out what their peers charged for similar projects. Built on 600K+ verified benchmarks, registered users get unlimited access to it.

As a freelancing platform, we do not provide permanent positions or full-time job to our consultant network.

Flexing It will be involved end to end right from contracts to invoicing. Once you are finalized, your payment details are transparently laid out in your contract terms with your client and our team actively liaises with the client finance team to ensure timely payments.

We do not charge any fee or commission from you. Your fee quote will be paid out to you in full as per your project contract.