Senior TSQL Programmer and Batch Developer

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 a team, we provide solutions to unique business/market requirements in line with the established Corporate IT Standards. As a Full Stack Developer, you'll play an important role in developing client-facing applications.

Responsibilities

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

SKILLS

Must have

1. Team Lead experience.
2. 5+ years of experience in TSQL programming along with Azure Data Factory framework and Python scripting.
3. Strong knowledge of Perl/Shell scripting.
4. Experience in TSQL (MSSQL/SYBASE) code development, performance tuning, query optimization, and extensive batch or ETL creation experience with better error handling.
5. Excellent understanding of relational transactional databases like MSSQL, Azure SQL, and cloud-based frameworks like MS Azure.
6. Strong knowledge of Extraction Transformation and Loading (ETL) processes using frameworks like Azure Data Factory or Synapse or Databricks.

Nice to have

1. BS in computer science or engineering degree or a related field or equivalent work experience required.
2. Experience in Requirement Analysis and Strategic Analysis.
3. Establishing cloud connectivity between different systems like ADLS, ADF, Synapse, Databricks, Axway, etc.
4. Hands-on experience in Azure cloud services like Azure Data Factory, Azure Synapse, MSSQL Db, Azure SQL DB, Azure Data Lake Storage Gen2, Blob Storage, etc.