Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Employer? Claim Account for FREE

Ameriprise India

Compare

3.6

based on 110 Reviews

109 Ameriprise India Jobs

Bus Systems Analyst I

Ameriprise India Pvt. Ltd

3.6

based on 110 Reviews

1-6 years

Gurgaon / Gurugram

1 vacancy

Bus Systems Analyst I

Ameriprise India

posted 13d ago

Job Role Insights

Fixed timing

Key skills for the job

Python SAP Business Intelligence Selenium Testing Agile Coaching Functional Testing SSRS

+ 3 more

Job Description

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.
1+ years experience in the financial services industry
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.

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 youre 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.