ROLE: POWERCENTER 9.X/10.X, PL/SQL, SQL
EXPERIENCE: 3+ YEAR
Key Skills
TABLEAU DESKTOP, SERVER, SQL SERVER
ROLE BACKGROUND
This role is an opportunity to be part of enterprise data warehouse
implementations which helps you explore and grow on your data analytics
capabilities by transforming raw data from heterogenous applications into
more well-structured information for consumption by business
Key Responsibilities
- Designing dashboards with the use of visualization tools like Tableau
Using SQL for managing large volume of data - Communicating with customers to analyse historical data and identify KPIs
- Improving data processing speed by building SQL automations
Tweaking SQL Queries for best performance - Making sure the team delivers reports as per the requirements
- Analysing the data to identify trends and share insights
- Implementing Tableau mobile dashboards with the help of Tableau mobile application
- Creating Thematic Heat maps with the help of MapInfo
- Recognizing areas for automation
Restricting data for users with the help of User filters - Producing support documentation and keep existing documentation up-to-date
- Carrying out investigation of root cause analysis
Required Skills
- 5+ years of practical work experience with a sustainable performance record in significantly sized data warehouse for a reporting environment following industry standards
- Excellent analytical and problem-solving skills for data warehouse requirement analysis, gap and design specifications, support and documentation.
- Excellent working knowledge, recent experience and developer skills on Informatica Power Centre 9.x/10.x including complex transformations, mapplets, mappings, connectors and performance improvement measures. Informatica PowerCenter certification is an advantage