- 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.
- 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