Relevant Experience: 12+ years
Mandatory Skills: SSIS & SSRS and SQL Server, Azure Synapse, Python, Pyspark & ADF.
Job Description:
- Strong work experience in Azure Synapse, Python, Pyspark and ADF.
- Proficient in SSIS and SSRS and SQL Server.
- Hands-on in writing SQL query, stored procedure and functions with hands-on in Power BI.
- Experience in creating SQL Server Database tables, Indexes, Views and ETL scripts for data replication from non-relational database to SQL Database.
- Should have rich experience with design, build and deployment of SSIS packages.
- Work Experience in performance optimization techniques using MSBI tool set SQL Server, SSIS and SSRS.
- Hands-on on azure Devops (ADO) , familiar with concepts like cherry picking, checking/merging code etc.
- Knowledge in debugging skills with SQL Agent Job, SSIS packages and complex T-SQL queries