The Senior Lead Engineer IT oversees project development methodologies, implements procedures for database solutions, focuses on data extraction, transformation, and loading, and provides technical guidance to teams. Experience with Microsoft SQL Server and SSIS is essential, along with skills in C# and various web technologies. Familiarity with broker/dealer operations is a plus.
Job Description:Qualifications:
Specific Technical Expertise
- Understanding of various project development methodologies including Agile and waterfall and overall SDLC Process.
- Knowledge of Microsoft software development framework and related development environments
- Databases – Experienced with Microsoft SQL Server 2016 and higher. Familiar with CTE and New features available in SQL Server 2016 and above.
- Proficient in developing and implementing procedures and functions. Ability to performance tune the queries.
- Experience in understanding complex data models and designing quality database solutions.
- Experience in data analysis and research.
- Experience in reviewing, interpreting, and implementing according to the business requirements
- Experience in Data Extraction, Transformation and Loading ETL between systems, file formats, using various SQL tools like SSIS.
- Experience in SSIS package Deployment methodology.
- Ability to analyze and troubleshoot SSIS packages.
- Familiar with Object-Oriented concepts and Design Patterns.
- Hands on experience of OO Development methodology in n-tiered Client/Server and Web based environments
- Programming languages – C# (.net core and Entity Framework).
- Other - Knowledge of XML, XSLT, ADO.NET, Tibco Topic/Queue
- Experience working with Third Party Vendor Systems.
- Should have 8-12 years of relevant experience in leading the teams and providing technical expertise and guidance, wherever required.
Nice to have Technical Expertise
- Working Knowledge with REST API’s).
- Knowledge of AWS technologies,. CI/CD pipeline, bitbucket, SNS/SQS Queue
- Knowledge of React, redux, other Javascript frameworks like Angular, ASP.NET MVC, JQuery
Domain Knowledge (Not required but a big plus.)
- Familiar with broker/dealer and securities processing.
- Familiar with industry standard feeds such as DTCC/DAZL/DST.
- Familiar with clearing firms and data aggregators such as Pershing/Albridge.
Location:
This position can be based in any of the following locations:
Gurgaon
Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday
Top Skills
.Net Core
Ado.Net
Angular
Asp.Net Mvc
AWS
Bitbucket
C#
Ci/Cd
Entity Framework
ETL
JavaScript
Jquery
Microsoft Sql Server 2016
React
Redux
Rest Apis
Ssis
Tibco
XML
Xslt
Similar Jobs
Insurance • Financial Services
The Senior Lead Engineer will oversee project requirements, design detailed technical specifications, manage project planning and tracking, build and review code, conduct testing and debugging, and ensure adherence to best practices and SDLC methodologies. The role includes mentoring team members and maintaining technical documentation.
Top Skills:
Asp.Net MvcC#CSSEntity FrameworkHTMLJavaScriptMs Sql ServerMsbiT-SqlTeam Foundation Server
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
As an Engineer III at CrowdStrike, you'll develop and maintain services focused on reliability and scalability while enhancing monitoring services. You’ll collaborate with teams to innovate, improve architecture, and ensure high-quality software delivery. A deep understanding of distributed systems and experience in backend scalability is essential.
Top Skills:
AWSC++CassandraGCPGoJavaK8SKafkaKotlinNode.jsOpensearchPythonScala
Enterprise Web • Fintech • Financial Services
The Senior Software Engineer will analyze current applications, develop new products/features, design and implement systems, and provide innovative solutions to enhance performance and scalability. Responsibilities include owning project modules from requirements scoping to launch, integrating business and technical needs, and improving systems design while ensuring compliance with user-centered design principles.
What you need to know about the Kolkata Tech Scene
When considering the industries shaping India's tech scene, gaming might not immediately come to mind. However, in the last decade, increased internet usage and greater access to mobile devices have catapulted the industry to new heights, with Kolkata-based companies like Virtualinfocom, Red Apple Technologies and Digitoonz, at the forefront, driving the design and animation of new gaming titles for players.
