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
C#
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:
C#
Food • Retail • Agriculture • Manufacturing
The Sr. Technical Lead is responsible for providing technical leadership for the data platform team, developing high-performing applications, mentoring developers, and ensuring code quality. They will collaborate with stakeholders to translate business requirements into technical solutions and manage project timelines and risks.
Top Skills:
Microsoft Sql Server
Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
As a Data Science Associate Consultant, you'll design and implement analytics solutions for structured and unstructured data, develop deep learning models, collaborate with teams on machine learning deployment, and contribute to AI research.
Top Skills:
JavaPythonR
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.