SQL Server Developer with 10 years experiences
Job Title: SQL Developer with ETL experience
Location: Coimbatore
Position Overview: We are looking for an experienced ETL Developer to join our team. The
ideal candidate will have a minimum of 6 years of hands-on experience in SQL development
with exposure to ETL process for 3 years (latest) and ETL tools for migrating the data from
one system to another. Developer will be responsible for designing, implementing ETL
pipelines and designing, developing, and maintaining complex SQL queries and procedures
to support critical business applications. Additionally, the candidate shall have experience in
database architecture and be capable of providing technical leadership in optimizing SQL
code for maximum performance.
Key Responsibilities:
Data Management and Storage:
o Design and implement data storage solutions using Azure services like Azure
SQL Database, Azure Data Lake Storage, and some experience of Azure
Cosmos DB.
o Ensure data storage systems are scalable, performant, and cost-effective.
o Perform database performance tuning and optimization, including query
optimization, index tuning, and database configuration would be an
advantage
o Write Unit Tests for database objects like stored procedures.
Data Integration and ETL:
o Develop and manage ETL (Extract, Transform, Load) processes using Azure
Data Factory to integrate data from various sources.
o Ensure data is efficiently cleaned, transformed, and loaded into data
warehouses or data lakes.
o Gather and process raw data at scale (including writing scripts, web scraping,
calling APIs, write SQL queries, writing applications and positive knowledge of
Entity Framework)
o Primarily use the skills above to perform multiple data migrations from
existing operational systems, or data extracts, into our live multi-tenanted
system, to tight deadlines with minimal operational downtime.
o Investigating data to anticipate any pipeline issues.
Big Data an