Vacancy expired!
Job Description:Bank of America is one of the world's leading financial institutions, serving individual consumers, small and middle-market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk management products and services.The QA Specialist will work side by side with development and business partners to determine optimal ETL test coverage and ensure high quality software is delivered to our customers. They will be responsible for extracting data applications of transformation logic, and uploading data in target tables. They are responsible for designing, testing, and troubleshooting the company's data storage system before it goes live along with planning, executing, and managing the testing effort for a variety of projects across multiple lines of business and technology platforms. The QA Specialist is expected to learn the business and technical components of an application to appropriately communicate risk and status to senior project management and executives. Work with their peers across the organization to drive test efficiencies, improve frameworks, and enhance the enterprise testing process. Grow your career in our dynamic and fast paced environment of diverse development platforms and challenging projects that shape the future of the banking industry.Responsibilities:
- Write test data scripts, based on ETL mapping artifacts
- Execute data scripts and detailed analysis on the scripts
- Create strategies and test cases for applications that use ETL components
- Data mining and detailed data analysis on data warehousing systems
- Provide input and support big data testing initiative
- Define and track quality assurance metrics such as defects, defect counts, test results and test status
- Document all problems and assists in their resolution.
- Resource will be required to lead and perform hands on testing of business reports and data feeds that flow into and out of the general ledger system
- Responsible for providing inputs to Test Strategy document(s), Test Plan(s), Testing Tracker(s), Test Execution Status Reports, and Defect Reports
- Coordinate process team input into testing deliverables
- Responsible for creating and executing test scripts, reviewing test scripts written by offshore team, and KT to offshore team to avoid any knowledge gaps
- Manage day-to-day activity of onshore and offshore testers, including manual and automated testing
- Ensure testing is on schedule and escalate any issues/concerns
- Ensure defects are assigned and being worked on
- Understanding of end-to-end testing cycles using agile and waterfall methodologies
- Hands-on experience in driving the QA release cycle End to end, defect reporting.
- Hands-on work experience in preparing test plans, test scripts, and requirements traceability matrix
- Experience analyzing ETL mapping documents
- Create and execute strategies and test cases for applications that use ETL components
- Data warehouse testing experience
- Experience testing Waterfall/Agile Development Projects
- Experience testing mission critical Financial Applications
- Hands on experience in relational databases and database architecture
- Hands on experience interpreting and understanding data models and ER diagrams
- Very strong SQL query writing skills
- Experience in end-to-end ETL testing (data migration, conversion, data quality check)
- Experience in Automation (Preferred: Tosca, QTP)
- Familiarity with Unix commands
- Ability to write backend data driven test plans to support database data validations
- Banking domain experience specifically in General Ledger, Accounting, or Foreign Exchange concepts/systems
- Hands on experience in HP ALM/QC
- At least 5 years of experience in test planning and execution
- Understanding and use of various test design techniques
- Experience working with Development, Test Leads/Test Coordinators, Production Support, Change Management, and Business partners
- End-to-end process test coordination experience
- Excellent communication and presentation skills
- Demonstrated analytical, problem solving, and interpersonal skills
- Bachelor's degree or higher in a quantitative/technical field (e.g. Computer Science, Statistics, Engineering)
- Knowledge of data management fundamentals and data storage principles
- Strong experience with hands-on data analysis of large data sets.
- Advanced SQL skills
- Big Data Testing, ETL Testing experience