Jacobs | Hiring | Senior ETL& reporting Developer – BI | Bangalore | BigDataKB.com | 2022-09-28

0

Job Location: Bangalore

Your Impact:

  • Supporting data warehousing, data modeling, data integration, business intelligence and ETL processes
  • Use Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse
  • As the senior most ETL developer, take leadership of ETL tasks and supervise other ETL developers and solve difficult problems
  • Develops ETL’s using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
  • Responsible for installing, configuring, developing, support and maintenance of the BI APPS.
  • Determine data storage needs – evaluate the exact storage needs to have clear picture of the current data situation and analyze different options to determine the best fit.
  • Design and create a data warehouse – designs a data warehousing system that meets needs and work with a development team to build the warehouse – conceptual, logical and physical data models to include data conversion, data conversion and data mining.
  • Extract, Transformation and Load data – extract necessary data and transfer it to new system.
  • Test and troubleshoot – test designs of new system to ensure smooth operations and fix any issues that arise.
  • Design schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables
  • Identify and capture lessons learned, best practices, and information gained during performance of tasks.

Here’s What You’ll Need:

  • Bachelor’s degree in engineering, or a related scientific or technical discipline with at least 4-6 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

At Jacobs, we’re challenging today to reinvent tomorrow by solving the world’s most critical problems for thriving cities, resilient environments, mission-critical outcomes, operational advancement, scientific discovery and cutting-edge manufacturing, turning abstract ideas into realities that transform the world for good. With $13 billion in revenue and a talent force of more than 55,000, Jacobs provides a full spectrum of professional services including consulting, technical, scientific and project delivery for the government and private sector.

Apply Here

Submit CV To All Data Science Job Consultants Across Bharat For Free

🔍 Explore All Related ITSM Jobs Below! 🚀 ✅ Select your preferred "Job Category" in the Job Category Filter 🎯 🔎 Hit "Search" to find matching jobs 🔥 ➕ Click the "+" icon that appears just before the company name to see the Job Detail & Apply Link 📝💼

LEAVE A REPLY

Please enter your comment!
Please enter your name here