SQL Developer

Key Responsibilities:

• SDLC development of product features, enhancements, UAT/production issues.
• Work with development team members for development of product features.
• Client-side and server-side development.
• Develop and manage well-functioning databases and application.
• Write/ design product APIs and write unit test cases.
• Follow standard agile scrum practices for software development.
• Peer review, pull requests, code refactoring and managing source code per standards and ensure quality. 

Required Experience & Skills:

• 5+ years of software development experience using Microsoft .Net technology stack.
• Strong experience in .Net, .Net Core, C#, Entity Framework, SQL server, JavaScript, jQuery, etc.
• Experience in using unit test framework e.g., xUnit, Moq.
• Experience in Web API development.
• Experience in Agile / SCRUM development process.
• Good to have experience in Domain driven design development and Microservice architecture.
• Excellent communication and teamwork skills
• Good to have knowledge and experience in ABP.IO framework, Angular 8+, PostgreSQL and AWS cloud service and CI/CD process.

Job Profile

Purpose of Role: To support and maintain the existing and future applications managed by ABD (Agile Business Development) Team.

Main Responsibilities:

• To work on existing and future applications as required
• Work with ABD India Application Support and Business Support team to address production issues and/or to do development work
• Work with US ABD team to coordinate the on-going support and monthly release of C-Hub (Customer-Hub) application and other ABD Applications
• Report status to management on project progress
• Identify and escalate related issues and risks
• Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies 
• Assess current modules and offer performance improvements techniques  
• Make sure Database Design Standards/coding standards established by ABD are followed
• Constant communication with ABD leadership team in US.
• Problem Solving ability with “Can-do” attitude
• IT experience in Banking industry is preferred

Candidate Profile:

• Minimum 10 years of experience at least 3-5 years of experience in Corporate & Investment Banking area and Bachelor's degree in Engineering, Accounting, Finance, or equivalent
• Expertise with MS SQL Server development including SSIS and SSRS, Proficient in development of Stored procedure, Views, Functions etc in MS SQL Server
• Experienced with DBA kind tasks such as replication, linked server, query analyzer, DBCC commands, data transfer from one DB server to other DB Server etc
• Experienced in MS Excel VBA and macro scripting
• Knowledge of data Encryption in database

• Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
• Understand platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases
• Review and analyse the data provided by customers along with its technical/functional intent and interdependencies
• Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data
• Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery
• Create and execute test plans,document issues and track progress at resolving issues.

• You have 2-5 years of experience using two or more development languages (ASP.NET, JavaScript, Scala, C#, etc.) with experience in Object-Oriented programming and full-stack web application development
• You can write clean, high-quality code in a variety of languages and are also able to spot and improve bad code
• You have experience with Agile and/or Continuous Delivery approaches such as Continuous Integration, TDD, Infrastructure as Code, etc.
• Experience with developing web applications based on ReactJS
• Hands on experience in setting up automated build pipelines based on Jenkins, Gradle, MSBuild, Maven etc.
• Bonus points if you have knowledge of cloud technologies such as AWS/Azure/GCP, Docker and Kubernetes
• Experience with atleast one RDBMS sql-server or postgress having good sql skills
• You will champion best practices like writing clean and reusable code using practices like Test Driven Development, SOLID principles, OO design, and pair programming
• You will partner with developers from other cross-functional teams advocating devops culture
• Experience with building REST APIs and asynchronous messaging systems
• You will work in collaborative, product-focused teams to build innovative customer experiences
• Take ownership and accountability beyond individual deliverables, always pushing the envelope in order to deliver awesome results for our clients

Position : Database Programmer:

Job Description / Required Skills

• Strong experience in Database design for complex web and mobile application, including writing complex store procedures, function, triggers and ad-hoc queries.
• Hands-on development experience with T-SQL.
• Strong experience on Database designing, normalization, optimization and performance tuning.
• Experience in advanced SQL programming, problem-solving and analytical skills.
• Experience in security, troubleshooting and optimizing the performance of databases and stored procedures.
• Experience in Refactoring/troubleshooting existing databases as needed.
• Deep understanding of referential integrity and indexing.
• Assisting with production database issues and helping to troubleshoot and isolate the root cause of issues and provide issue resolution by interacting with Developers.
• Ability to estimate development tasks accurately and meet agreed upon deadlines.
• Understanding of code promotion, version control and QA procedures.
• Good Communication skills.

Technical Skills:

• MySql, MS-SQL, SQL Server Management Studio and SQL Server Profiler.
• PostgreSQL
• DCL, DDL, DML Scripts.
• T-SQL, SSRS and SSIS
• OS Environments: Windows XP/Windows 7, Windows Server 2003/2008

Experience         :               3 to 4 years

Qualification       :               B. Tech/BE/MCA/MSC Computers

Location               :               Mumbai

• Participate in requirement analysis
• Write clean, scalable code using .NET
• Test and Deploy applications and systems

• Must have good command on c#
• Should have knowledge on the official ASP.NET, ANGULAR JS and MVC