Skip to main content

Bus Systems Analyst II

Description

Apply Now
Share
-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

Requisition Number

R25_0000001341