Azure Database Engineer AssignX Global Solutions

About AssignX Global Solutions

Job Description

Position: Azure Database Engineer Experience: 5 to 7 Years Must Have Skills: Azure Data Factory, SSIS, T-SQL, Azure Synapse (or Azure SQL), Data Lake Gen2, SQL tuning Shift/Working Hours: IST(WFO ) Budget/Rate: up to 15 LPA Location: Pune/Ahmedabad/Goa/Chennai/Bangalore/Hyderabad/Mumbai/Noida Excellent English communication is a must (no exceptions). Candidate must have hands-on experience in the primary skills listed. No employment gaps will be accepted. Please do not share Hyderabad natives or JNTU profiles. Ensure relevant experience is mentioned in years and matches the skillset. Notice period should be 15 days or less (currently serving, jobless, project ending/ended). Job Description Azure - Database Engineer (DBMS, ADF, SSIS, T-SQL) High-Level Responsibilities: Design and develop scalable data pipelines using Azure Data Factory, incorporating SSIS packages where applicable. Write and optimize T-SQL queries for data transformation, validation, and loading. Collaborate with the customers data architects to understand and modernize legacy data integration patterns. Perform relational database design and schema optimization for Azure SQL or Synapse targets. Support migration of on-premise or legacy ETL jobs into cloud-native Azure Integration Services. Conducted unit testing and troubleshot data pipeline issues during sprint cycles. Provide support during UK overlap hours (up to 8 PM IST) to align with the customer teams collaboration windows. Mapped Skills: Azure Data Factory development (SSIS helpful) T-SQL development Relational database design SQL Server Management Studio Azure Data Studio Azure Portal Visual Studio 2022 Experience migrating existing integrations to AIS Recommended Skills: Azure Synapse Analytics (often paired with ADF in modern pipelines) Data flow transformations in ADF Data lake concepts and Azure Data Lake Gen2 Monitoring & debugging ADF pipelines Integration Runtime setup and optimization Azure Key Vault integration in ADF Performance tuning in SQL Server and Azure SQL DB Knowledge of Delta Lake format if modern analytics is a goal,