Business Systems Analyst I Job in Gurgaon at Ameriprise Financial

Ameriprise Financial is hiring for the role of Business Systems Analyst I!

Responsibilities of the Candidate:

• 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 the 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/adaptation 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.

Requirements:

• Demonstrated excellent hands-on personal computer and organisational skills, Familiar with advanced features in MS Word, MS PPT, and Familiar with formulas and complex spreadsheets. The ability to write embedded formulas is 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, and 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 relationships 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.