Department Overview :
Consumer Lending Banking Technology supports various applications for the Wholesale line of businesses. The teams are spread across various locations including EGS.
Team member will be working from any of the EGS India work locations. The technology team has various applications based on Java Stack, Microsoft, DWH, Etc.,.
About the Role :
An opportunity has arisen in Recon team for a Developer with about 10+ Years of hands-on experience in T-SQL, SSRS and SSIS based enterprise applications.
Role involves technical solution designing, coding, unit testing, builds and deployment of SQL scripts and reports with critical focus on data & workflows, Analytical skills and performance tuning.
Candidate should have strong written and oral communication skills. Candidate will be interacting with the internal business partners, reviewing the requirements with them and take care of deliverables.
The primary responsibility of this role is to own, design, develop, unit test & deliver source codes.
Analyze requirements and come up with high level / low level technical design.
Ensure that the deliverables are on time, within estimates and of high quality and follows the best development practices
Should be well acquainted with on secure coding and best coding practices
Should be able to debug, analysis and fix the defects raised during development phase and in QA testing.
Optimizing the queries and tuning the stored procedures.
Point of contact for any escalations from support teams for L2 / L3 production support defects and troubleshooting and provides fixes and resolutions.
Work with team members from other global locations and in multiple projects / tasks simultaneously.
Evaluate the architecture and identify opportunities for improvement.
Mentor and lead the team.
Technical Skills) :
10+ years of strong & proven experience in T-SQL, SSRS and SSIS (MSBI)
Strong hands-on experience in T-SQL, SQL, SSIS and SSRS.
Experience with power shell scripting or any other scripting language.
Strong hands-on experience in SQL queries, stored procedures, functions and performance tuning techniques.
Experience with Data ware house concepts and Relational data modelling.
Good at analyzing business requirements pertaining to ETL tools (MSBI).
Good understanding and experience in using build and deployment tools like TFS, GIT, UDeploy etc.
Working experience on Reconciliation platforms.
Exposure in Reconciliation application - Intellimatch.
Good to Have Qualifications (Technical Skills) :
Knowledge on ASP.NET or React