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