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 📝💼

