Jacobs ETL & Reporting Developer - BI in Navi Mumbai, India

ETL & Reporting Developer - BI

Description

Job Title: ETL& reporting Developer - BI

Location: Airoli

About Jacobs Engineering:

Jacobs Engineering Group (http://www.jacobs.com) headquartered in Dallas, Texas, is a Fortune 500 company with presence in more than 30 countries and 250 offices spread across, with employee strength of more than 70,000 world-wide. In India, we have offices in Mumbai – Andheri, Airoli, Vadodara, Gurgaon, Kolkata and Bangalore. Jacobs is listed in the S&P 500 stock market index, and traded on the New York Stock Exchange under the symbol JEC.

With more than 65 years in the industry, we have attracted and retained clients by providing superior value — in fact; over 90 percent of our work is repeat business from loyal clients. That commitment to client value and partnership produces consistent cost advantages, profits and growth, allowing us to attract and retain the industry's top talent. Jacobs Information Technology supports the enterprise by supplying and supporting highly leveraged technology solutions for the entire spectrum of services and management functions within the company with a global strength of 1000 talented professionals. If you share our commitment to doing what's best for our customers, enjoy working in teams and hold yourself to the highest ethical standards, you'll fit right in.

Follow us on:

LinkedIn (https://www.linkedin.com/company/jacobs)

YouTube: (https://www.youtube.com/user/jacobsworldwide)

Job Description:

Duties and responsibilities:

Developing Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data Model and Web Catalog Objects as per the reporting requirements using OBIEE Admin and Web tool.

Fragmentation, Aggregate Navigation & Level based dimensions in the BI repository.

Working on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.

Configuring Dimensional Hierarchies in the Business Model and Mapping Layer.

Extensively used Oracle Analysis in building various reports.

Creating templates for presenting results and Analytics and modified the OBIEE Dashboard using cascading style sheets configured various dashboards and embedded various requests in to the dashboards with the help of pages, columns, sections and dashboard objects according to the business categorization.

Implementing security object level to restrict users from accessing unauthorized object.

Knowledge on DAC.

Understanding Business requirements and customizing the Repository to meet the requirements.

Creating Calculation Measures Using Logical Columns, Physical Columns and the Calculation Wizard.

Developing business reports using OBIEE Analysis and to display the reports in Dashboards.

Created prompts and filters as per requirements and adding them to the necessary reports.

Qualifications:

Bachelor’s degree in engineering, or a related scientific or technical discipline with at least 2-4 years of relevant experience

Experience extracting and summarizing data from a variety of data source types using Oracle SQL

Experience in using Oracle PLSQL or SQL Plus

Dimensional modeling experience

Experience interfacing with business users and understanding their requirements

Experience with Informatica 9.0.1 or higher, OBIEE, DAC ,Oracle 11.2.0.2 of higher

Ability to learn and implement new and different techniques

Strong Project Management skills

Must have Understanding of business intelligence development in the IT industry

Outstanding written and verbal communication skills

ETL routines, Database skills

Good to have:

Tableau, Power BI

At Jacobs, we help prepare people for new opportunities and challenges. With positions at every level, openings in multiple disciplines, expertise in a range of markets and offices around the globe, we create an environment where you can learn, grow, and thrive. From our competitive benefits program to our Health and Safety initiative of Beyond Zero workplace injuries, we believe that you'll find a flourishing career here at Jacobs

Primary Location India-India Countrywide-Navi Mumbai

Travel Yes, 10 % of the Time

Req ID: GLO000024