Logo
Lorven Technologies

Lead TSQL Developer

Lorven Technologies, Weehawken, New Jersey, United States,


Job Description:Bachelor's degree or equivalent working experience with minimum of 8+ years of IT experience.Responsibilities

Leading the team, planning, collaborating with stakeholdersDesign and develop large-scale applicationsCollaborate to refine user requirements through test-driven development (TDD)Analyze root causes of incidents and provide the solutionTSQL Programming and Batch Developing using Azure, Python, Perl and Shell scriptingDevelopment 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.Skills Must have:

Team Lead experience5+ years of experience in TSQL programming along with Azure Data Factory framework and Python scriptingStrong of Perl/Shell scriptingExperience 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

BS in computer science or engineering degree or a related field or equivalent work experience required.Experience in Requirement Analysis, Strategic Analysis, SoftwareExperience 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.