Logo
Futran Tech Solutions Pvt. Ltd.

Futran Tech Solutions Pvt. Ltd. is hiring: Lead TSQL Developer with Azure Data F

Futran Tech Solutions Pvt. Ltd., Weehawken, NJ, United States


Role: Lead TSQL Developer with Azure Data Factory framework and Python scripting
Location: Weehawken, New Jersey (Hybrid Mode, 3 days WFO)


Responsibilities:
- Leading the team, planning, collaborating with stakeholders
- Design and develop large-scale applications
- Collaborate to refine user requirements through test-driven development (TDD)
- Analyze root causes of incidents and provide the solution
- TSQL Programming and Batch Developing using Azure, Python, Perl and Shell scripting
- Development Fundamentals, Design, Development, Maintenance, Testing and Implementation of efficient data flow and batch processes in applications.
- Working on creating end-to-end pipeline to load data by reading from multiple sources and load to landing layer or SQL tables.

Mandatory Skills Description:
- Team Lead experience
- 8-10 years of experience in TSQL programming along with Azure Data Factory framework and Python scripting
- Strong of Perl/Shell scripting
- Experience in TSQL (MSSQL/SYBASE) code development, performance tuning, query optimization and extensive batch or ETL creation experience with better error handling.
- 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.

Nice-to-Have Skills:
- BS in computer science or engineering degree or a related field or equivalent work experience required.
- Experience in Requirement Analysis, Strategic Analysis, Software
- Experience in TSQL programming along with Azure Data Factory framework and Python scripting.
- 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.