Senior TSQL Programmer and Batch Developer
This is with a global IT services firm for a leading global investment management firm.
Work environment - on-site 5 days / week - in-office required
Location is Weehawken, NY (New York City area)
6 months contract, Likely extension.
Market rate
Project Description :
You'll be working in the Client Discovery, Planning and Wealth Way team. We provide engineering services to WMA business divisions of the Global Investment Bank.
Together as team, we provide solutions to unique business / market requirements in line with the established Corporate IT Standards.
As a SQL Developer, you'll play an important role in developing fa and client-facing applications.
Responsibilities :
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 :
5+ 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.
Experience with Investment / Portfolio Management systems .