SQL Lead

Job Description:

• Strong knowledge of T-SQL
• Extensive experience in designing transactional as well as warehouse database.
• Extensive working experience in designing and development of SSIS packages.
• Expert in writing complex queries, procedures and functions with complex joins.
• Expert in handling SQL Server jobs and monitoring.
• Must have experience in database and table partitions.
• Extensive database programming experience in writing T-SQL Stored procedures, Functions, Triggers, Constraints and Indexes using various DDL and DML commands. 
• Involved in Performance tuning at different levels (Package, Source, and Target)
• Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
• Must be strong in verbal & written communication.

Minimum requirement:

• 10+ years of working experience in database as well as ETL environment.
• Strong experience in SQL+ETL experience, preferably in SQL Server Environment, being able to optimize and write complete SQL queries as well as scripts with performance tune.
• Must have experience of large scale databases.
• Experience on warehouse schema i.e. star schema.
• Must have experience on Azure ETL tools (Azure Data Factory, Synapse, Databricks)

Good to have:

• Experience of working with Power BI, Tableau.
• Python knowledge
• Azure/AWS Certification on ETL/data engineering