SQL Lead

Ahmedabad, IND
01 Position
FullTime

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

Apply for this job online