QA Tester-1

Develop, verify, and validate UAT test cases/plan for data platforms, interfaces and reporting systems
- Create custom test data, test scripts, and queries to be executed on the database
- Validate end to end functionality and enhancement requests
- Work closely with the Team Lead on implementing more effective software testing solutions

**Responsibilities**
- Contribute to an agile team by driving user story analysis and feature grooming, designing, and developing thorough test scripts.
- Write complex SQL queries against large datasets in AWS.
- Develop and maintain BDD test scenarios and regression plans.
- Participate in test development life cycle including requirements analysis and design.
- Business Intelligence testing involving the validation of DataMart, ODS, Data models and SSRS reports.
- Understand data flow and test strategy for ETL, Data warehouse and Business Intelligence testing.
- ETL testing of mapping, transformations and data pipeline.
- Write advanced SQL queries for ETL/data warehousing/Business Intelligence testing.
- Work with the team to continually improve test processes and practices based on inspection/adaption of previous iterations and to ensure adherence to process, tools and metrics standards within the project team.
- Document test results and defects and support defect triage and resolution.

**Required Qualifications**
- An understanding of software QA/ QE methodologies/ tools/ processes.
- Good experience with Manual Functional testing and Automation scripting.
- Must have hands on experience working on or designing test automation frameworks using tools like Selenium Java/C#/Python.
- Knowledge of DEVOPS, Continuous Integration, Continuous Development Environments.
- Create and maintain API specific test plans. API Automation using Soap UI/Rest assured / Postman.
- Experience in designing, developing, debugging and executing automation scripts.
- Strong oral and written communication skills, including presentation skills (MS Visio, MS PowerPoint).

**Preferred Qualifications**
- Experience in Functional Testing/Integration Testing/Regression Testing/System Testing/ E2E Testing and Acceptance Testing.
- Have experience working on agile and scrum methodology.
- Bachelor’s degree in Computer Science, Information Systems, or other related field from an accredited college/university.

**About Our Company**

Ameriprise India LLP has been providing client based financial solutions to help clients plan and achieve their financial objectives for 125 years. We are a U.S. based financial planning company headquartered in Minneapolis with a global presence. The firm’s focus areas include Asset Management and Advice, Retirement Planning and Insurance Protection. Be part of an inclusive, collaborative culture that rewards you for your contributions and work with other talented individuals who share your passion for doing great work. You’ll also have plenty of opportunities to make your mark at the office and a difference in your community. So if you're talented, driven and want to work for a strong ethical company that cares, take the next step and create a career at Ameriprise India LLP.

Ameriprise India LLP is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, genetic information, age, sexual orientation, gender identity, disability, veteran status, marital status, family status or any other basis prohibited by law.