Tech Lead

What it includes and what is required: - Continuous interaction with business stakeholders to understand specifications related to business analytics reporting - Good understanding of the data lineage of the source system and how that data can be utilized to prepare the IM publish layer data for reporting - Analytical skills with excellent hands-on experience in designing logic with SQL queries, views, stored-procs etc. - Proficient knowledge in ETL, data-pipelines and transformation logic design and development capability without any ETL tool - Knowledge and hands on experience in working with Data Warehousing Project (OLTP, OLAP) - Proficient knowledge in STAR schema, SNOWFLAKE Schema and Data Vault 2.0 modelling approaches - Proficient knowledge and hands on experience with SNOWFLAKE database. - Proficient knowledge on stages, snowflake architecture along with other features of snowflake like time-travel, snow pipe, streams, tasks etc - Experience in handling both structured and un-structured data in SNOWFLAKE - Excellent knowledge in Azure Data Factory, Azure-SQL, link services, API etc. Good to have skills: - Knowledge in Microsoft Fabric - Concepts of usage of Reporting tools like Power BI, Tableau - Knowledge of Agile Data Engine Tool - Knowledge in Python, Airflow