Participate in Scrum meetings to properly plan, report, and execute work.
Assists in creation of database management procedures.
Develop documentation around existing database architecture.
Act as mentor to colleagues through code reviews and technical discussions
Collaborate with other developers to produce high quality software products that delivers business value and follows established design patterns.
Develop, code, test, and debug application programs of varying degree of complexity.
Works closely with the project manager and assigned project team to review and ensure the on-time delivery of complex IT solutions.
Required Skills & Experience
5+ years of hands-on experience in MS SQL Server writing complex T-SQL queries, stored procedures, functions etc.
5+ years of ETL development using Azure Data Factory (experience with SSIS a plus)
5+ years of experience with building data pipelines and analytics solution to stream and process datasets at low latencies.
5+ years of experience with complex data modelling, ELT/ETL design, and using large databases in a business environment. Experience ingesting data from various source formats viz. Parquet, csv, SQL databases, SharePoint, APIs etc. to Azure SQL databases.
3+ years of experience with SSAS (SQL Analysis Services) Tabular and Multi-Dimensional cubes/models. Experience writing DAX expressions a plus.
Expertise in ELT/ETL optimization, designing, coding, and tuning big data processes using Azure Data Factory.
Advanced experience in SQL Server relational database management systems
Bachelors Degree in related field
Extensive understanding and knowledge in data analytics and reporting (TSQL, SSRS, Power BI, etc.)
o Strong Knowledge of data warehousing frameworks and methodologies.