Role Purpose
- 3+ years of strong experience with Data Transformation, Datawarehouse/Database creation & ETL on large data sets.
- 3+ years of Data Modelling experience (i.e. Relational, Dimensional, Columnar)
- 3+ years of complex SQL or NoSQL experience.
- Experience in advanced Data Warehouse concepts.
- Experience with Business Requirements definition and management, structured analysis, process design, use case documentation.
- Experience in professional software development capacity using SDLC, waterfall and Agile mode of development.
- Demonstrate exceptional organizational skills and ability to multi-task simultaneously with different parallel projects.
- Strong verbal & written communication skills to interface with business teams & lead towards successful business outcome.
- Must be self-managed, proactive and customer focused.
- Degree in Computer Science, Information Systems, Data Science or related field.
Good to have - Experience & knowledge with DBA activities in SQL Server 2008 R2, 2012, 2016, and 2017 as well as 2019 features along with any other cloud-based databases like Snowflake and Multidimensional databases
Stakeholder Interaction
| Stakeholder Type | Stakeholder Identification | Purpose of Interaction |
| Internal | Team Leaders | Performance review |
| HR | Hiring and employee engagement and retention | |
| Training Team | Capability development | |
| Technical Lead | Training, issue escalation/ resolution | |
| External | Client | Query Resolution |
Display
Lists the competencies required to perform this role effectively:
- Functional Competencies/ Skill
- Process Knowledge - Knowledge of assigned process, tools and systems - Foundation to Competent
| Competency Levels | |
| Foundation | Knowledgeable about the competency requirements. Demonstrates (in parts) frequently with minimal support and guidance. |
| Competent | Consistently demonstrates the full range of the competency without guidance. Extends the competency to difficult and unknown situations as well. |
| Expert | Applies the competency in all situations and is serves as a guide to others as well. |
| Master | Coaches others and builds organizational capability in the competency area. Serves as a key resource for that competency and is recognized within the entire organization. |
- Behavioral Competencies
- Collaborative working
- Problem solving and decision making
- Attention to Detail
- Execution Excellence
- Client (Internal) Centricity
- Effective Communication
Deliver
| No. | Performance Parameter | Measure |
| 1. | Process | No. of cases resolved per day, compliance to process and quality standards, meeting process level SLAs, Pulse score, Customer feedback |
| 2. | Self- Management | Productivity, efficiency, absenteeism, Training Hours, No of technical training completed |
Data Analyst, Data Visualization (Tableau, Power BI), Data Modelling, Data Warehousing, SQL and Advance SQL