Jacobs ETL & Reporting Developer - BI in Navi Mumbai, India
ETL & Reporting Developer - BI
Job Title: ETL& reporting Developer - BI
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:
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.
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 18.104.22.168 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