About the role
Duties
Write complex SQL queries and ETL to integrate heterogeneous data sources to provide data insight.
Apply business logic to determine categorize the non-genuine base into opportunities.
Use DW best practices and capable of applying statistical methodologies and data mining skill sets on large volume of data
Analyze data and provide insights to senior executives
Skills
T- SQL Expertise. SSIS & SSAS ( DAX + Tabular) expertise.
Can write efficient queries and handle performance issues with ease.
Experience in designing DataMart with dimension and fact modelling.
Experience in extracting data from discrete sources viz. (MS Dynamics, Salesforce, Cloud platforms (Azure, AWS etc.)
Understanding of statistics concepts.
Ability to interpret data and exhibit excellent written and verbal communication skills
Knowledge of SnapLogic ETL tool.
Knowledge of Azure database and data lake.
Experience
4-6+ years
Skills
T- SQL Expertise. SSIS & SSAS ( DAX + Tabular) expertise.