• 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 testing solutions
  
  

Key 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

Demonstrated excellent hands-on personal computer and organizational skills, Familiar with advanced features in MS Word, MS PPT Familiar with formulas and complex spreadsheets. Ability to write embedded formulas are essential. Exposure to VBA macro development within MS Excel

An understanding of software QA/ QE methodologies/ tools/ processes. Good experience with Manual Functional testing and Automation scripting.

Experience with defect management applications like, Jira, xRay

Knowledge of DEVOPS, Continuous Integration, Continuous Development Environments

Experience in designing, developing, debugging and executing automation scripts

Must have hands on experience working on or designing test automation frameworks using tools like Alteryx/Selenium/Java/Python

Understanding of SQL and data sets Ability to write SQL queries and understand data retrieval, formatting, and integration. Ability to understand Database architecture concepts.

Familiarity with Back and Middle Office technology.

Solid analytical, quantitative and problem-solving skills, with the ability to interpret data, reach conclusions and take action.

Ability to understand technology as it relates to business and may require product or system certifications.

Ability to communicate technology related information clearly to different audiences and clearly detail implementation processes.

Strong relationship within the department and across business functions.

Bachelor’s degree or equivalent work experience.

4+ years’ experience in the financial services industry as a Tester

Strong leadership competencies and execution skills by way of cross-collaboration and workflow facilitation with multiple internal business partners.

Must be highly responsive and proactive in a fast-paced changing environment.

Preferred Qualifications

Experience in Functional Testing/Integration Testing/Regression Testing/System Testing/ E2E Testing and Acceptance Testing

Experience On Alteryx Is Preferred.

Strong oral and written communication skills, including presentation skills (MS Visio, MS PowerPoint).

Have experience working on agile and scrum methodology.

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.

Full-Time/Part-Time

Full time

Timings

(2:00p-10:30p)

India Business Unit

AWMPO AWMP&S President's Office

Job Family Group

Business Support & Operations