Role: ETL TSQL DeveloperLocation: Weehawken NJ5 Days Onsite from Day 1Client: UBSRate: 600/Day
TSQL Programmer and Batch Developer (Using
Azure Data Factory and Python Scripting)
- BS in computer science or engineering degree or a related field or equivalent work experience required.
- Experience in Requirement Analysis, Strategic Analysis, Software Development Fundamentals, Design, Development, Maintenance, Testing and Implementation of efficient data flow and batch processes in applications.
- Experience in TSQL programming along with Azure Data Factory framework and Python scripting.
- Excellent understanding of relation transactional databases like MSSQL, Azure SQL and cloud-based framework like MS Azure.
- Strong knowledge of Extraction Transformation and Loading (ETL) processes using frameworks like Azure Data Factory or Synapse or Databricks.
- Establishing the cloud connectivity between different system like ADLS ,ADF, Synapse, Databricks , Axway etc.
- Hands on experience in Azure cloud services like Azure Data Factory or Azure Synapse , MSSQL Db, Azure SQL DB, Azure Data Lake Storage Gen2, Blob Storage etc.
- Worked on to create end to end pipeline to load data by reading from multiple source and load to landing layer or SQL tables.
- Experience in TSQL (MSSQL/SYBASE) code development, performance tuning, query optimization and extensive batch or ETL creation experience with better error handling.