Description
Job description:
- Co-ordinate with Business Analysts and Data Modellers to provide technical analysis of databases, including:
- Identifying table(s)/attribute(s) required
- Identifying table joins and limitations to consider
- Identifying data quality issues
- Basic Volumes
- Defining how to create reports for Microstrategy
- Providing Business Process understanding
- Testing Data Warehouse's data against source
- Providing analysis and solutions to Data Warehouse's data issues
- Identifying Data Model limitations
Required Skills:
- Experience of 4-5 years with RDBMS like Oracle, SQL Server
- Experience of ETL, Data Warehousing and Dimensional models
- Experience on any Datawarehouse Appliances like Netezza, Teradata, Redshift, etc.
- Good understanding of relational data models
- SQL query writing skills
- Problem-solving skills
- Written and verbal communication skills
- BI Reporting general skills (Tableau, MicroStrategy, PowerBI, etc)