-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 AWSDevelop and maintain BDD test scenarios and regression plansParticipate in test development life cycle including requirements analysis and designBusiness 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 testingETL testing of mapping, transformations and data pipelineWrite advanced SQL queries for ETL/data warehousing/Business Intelligence testingWork 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 teamDocument 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 ExcelAn understanding of software QA/ QE methodologies/ tools/ processes. Good experience with Manual Functional testing and Automation scripting.Experience with defect management applications like, Jira, xRayKnowledge of DEVOPS, Continuous Integration, Continuous Development EnvironmentsExperience in designing, developing, debugging and executing automation scriptsMust have hands on experience working on or designing test automation frameworks using tools like Alteryx/Selenium/Java/PythonUnderstanding 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.1+ years’ experience in the financial services industryStrong 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 TestingExperience 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