Job Description
Please find below details:
- Mode of interview – R1 Zoom, R2 in person
- Rounds of interview – 2 Rounds
- Acceptable notice period – Immediate, 15 - 30 days
- 3 days’ work from office is a must and rest 2 days work from home, later basis business needs it can move to all 5 days WFO.
- Hacker Rank test link will be directly shared with the candidate, passing score – 60%.
Mandatory Skills:
- Strong SQL experience and database programming skills; including stored procedures, macros, functions
- 4 - 7 years of manual testing experience in database, data reporting and data visualization projects
- Experience with shell script testing
- Be able to convert business reports and dashboards to SQL
Note:
- HR test should to be completed within a week. Failing to do so, profile will be considered as Screen Reject.
- We will not consider any profiles exceeding the submission limit (3 profiles each supplier per req). New submission can be made only once the feedback is shared on the current submittals.
Job Description: Database QA Engineer
Department Profile
Global Banking Technology (GBT) is a dynamic and fast-paced area within the Firm’s WM Technology Division. We are responsible for creating innovative technology solutions for the Private Banking Group (PBG), one of the strategic growth areas of the Firm, providing cash management and lending products and services to our WM clients. This includes state-of-the-art technology for a nationwide network of Private Bankers and product specialists who work with Financial Advisors to provide access to products and services such as online banking, cards, deposit products, residential mortgages, and securities based loans and tailored lending. If you are an exceptional individual who is interested in solving complex problems and building sophisticated solutions in a dynamic team environment, GBT is the place for you.
Position Description
• The candidate should be adaptive to a continuous changing and fast paced environment, be able to successfully multi-task, and thrive in a dynamic, fully engaged QA role. The role will involve interacting with clients in the Business, developers, external vendors and other QA teams
• Candidate will be working on existing and new initiatives within global QA team. The team incorporates agile methodologies including Scrum, Test Driven Development, Continuous Integration and Continuous Delivery in its development processes.
• The Candidate needs to be able to work with geographically dispersed Dev & QA team in a very dynamic, rapidly evolving and high pressure, high visibility project setting. The candidate is expected to contribute in a hands-on fashion on the project as well as take ownership of various QA deliverables. The following will be the candidates key focus areas
• Passionate around automating end to end testing for database applications
• Comfortable with frequent, incremental code testing and deployment
• Ability to use a wide variety of open source and in house technologies and tools
• Take a hands-on approach to implementing QA processes right from requirements analysis, test design, automation and analysis
• Own the quality and timeliness of delivery
• Collaborate with Developers, Business and multiple global stakeholders to drive QA agenda & standards by engaging with them throughout the SDLC
• Communicate key issues and progress updates in a regular, accurate, timely fashion
Responsibilities & Required Skills
• 4 - 7 years of manual testing experience in database, data reporting and data visualization projects
• Strong SQL experience and database programming skills; including stored procedures, macros, functions
• Understanding of data warehouse concepts
• Be able to analyze complex database programs
• Be able to convert business reports and dashboards to SQL
• Be able to perform benchmark on database programs, business reports and dashboards
• Performing, detailing and documenting unit, regression test cases
• Experience with End to End testing in data warehouse project
• Good understanding of the data types and data conversion functions
• Good understanding of Tableau features
• Experience with shell script testing
• Experience with relational database concepts, data analysis, and database design
• Knowledge of the Waterfall and Agile SDLC
• Excellent problem solving skills
• Development within agile framework
• Good communication skills
• Self-driven, motivated and innovative
• Interest to learn new tools, technologies
Desired skills
• Automation testing experience
• Experience in Informatica or similar ETL tool
• Scripting in UNIX/Linux environment (shell scripting)
• Teradata along with performance tuning experience on this platform
• Experience with Big Data (Hadoop, Apache Spark)
• Experience with Reporting and Analytical tools such as Business Objects, Qlik-View
• Prior experience working in the Financial Services Industry
• Experience with Continuous Integration, Continuous Delivery, Test Driven Development/Behaviour Driven development