**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** Every day, Guardian helps our 29 million customers realize their dreams through a range of insurance and financial products and services. Our Purpose, to inspire well-being, guides our dedication to the colleagues, consumers, and communities we serve. We know that people count, and we go above and beyond to prepare them for the life they want to live, focusing on their overall well-being — mind, body, and wallet. As one of the largest mutual insurance companies, we put our customers first. Behind every bright future is a GuardianTM. Learn more about Guardian at guardianlife.com .