Creating and maintaining data pipelines in Azure Data Factory to pull data from heterogeneous sources and performing ETL / ELT
Working on database designing, complex SQL queries, stored procedures, functions, query optimization in SQL Server
Assembling large and complex data sets that meet functional/non-functional business requirements using Azure SQL
Writing and maintaining PowerShell workloads for bulk updates
Designing, optimizing, and fine-tuning of ETL solutions in ADF and SQL queries for a large volume of organizational business data considering aspects like performance, efficiency and maintenance
Requires extensive coordination with different teams and groups including application , QA , CSS and infrastructure
PowerBI & SnowFlake data warehouse knowledge can be a huge plus point as client is planning to use it in near future
Must to have skills :
Good understanding of Azure cloud platform including services like Azure Data Factory, Azure Blob storage, Azure SQL, and concepts like access management and basic networking
SQL skills including advanced skills like performance-tuning, clustering, Indexing, modeling, database optimizing, etc.
Hands-on experience in building and maintaining ETL and ELT pipelines in Azure Data Factory and with Azure blob storage
Ability to handle huge datasets and performing quick data analysis to extract insights from raw data for sharing with clients with story telling
Must posses basic skills to write or maintain workloads code in C#
Good client interaction and communication skills
Must know PowerShell scripting
Ability to work under high pressure and customer demanding environment with tight deadlines
Good to have skills:
Programming skills
Familiarity with Entity framework
Familiarity with application development phases/process
India
USA
All
