Brief description :
Experience : 4-6 Years
Job Location: Technopark (Trivandrum) and Infopark (Kochi)
Technical Skills:
- MS SQL Server, ETL and data analysis technique
Mandatory Skills:
- 4-6 years of experience in MS SQL and ETL. Knowledge of handling large datasets. Well versed in RDBMS databases and extensive experience in SQL
- Advance level knowledge on SQL Query optimization, writing complex SQL queries, functions, procedures, triggers, and RDBMS data modelling
- Knowledge of Data warehouse concepts (Implementation of ETL/ELT pipelines, data integration components (SSIS).
- knowledge of data analysis tools. Interpret Business requirements /information and translate to technical solutions – from data warehouse to analysis services, tabular models
- Hands-on experience in Data Model design, Schema representation, DB structures, and other table/object-related properties.
- Build and maintain stateful data pipelines, and fault tolerant complex ETL/ELT jobs. Using Data Factory and SSIS.
Preferred skills
- Knowledge in DBT (Data build tool)
- Experience with scrum / agile development methodology.
- Good written and oral communication skills.