Quality Assurance Analyst ,ETL (Ab Initio) :: Remote (Boston, MA; Charlotte, NC; Cheektowaga, NY)

Unclassified - Boston, MA

Full-time

Boston, MA

About the position

The Quality Assurance Analyst (ETL - Ab Initio) position is a remote role that focuses on ensuring the quality and reliability of data warehousing and reporting capabilities. Individuals in this role will be responsible for developing comprehensive test strategies, plans, and scripts, as well as executing tests and tracking defects throughout the testing lifecycle. The ideal candidate will possess exceptional communication skills, a keen attention to detail, and the ability to work independently to meet project deadlines and expectations. In this role, the analyst will define the approach to validating capabilities and will be involved in various types of testing, including functional, regression, negative, and deployment testing. They will also conduct ETL job execution testing using Control-M/Control Center and will be responsible for error handling testing. Collaboration with business stakeholders to understand requirements and with the operations team to coordinate build deployment and execution within the test environment is crucial. The analyst will track defects and report on testing progress and results, ensuring that all issues are documented and addressed in a timely manner. A strong proficiency in SQL, UNIX, Control-M, Control Center, and ETL processes using Ab Initio is essential. Additionally, the ability to understand the code base by reviewing Ab Initio Psets, graphs (.mp), and XFRs is required. The candidate should also have the necessary skills to mock-up and upload test data using the Ab Initio Test Data Management tool (TDM).

Responsibilities

• Define approach to validating capabilities.
• Develop testing strategies and test plans, including functional testing, regression testing, negative testing, deployment testing, ETL job execution testing, and error handling testing.
• Work with business to understand the requirements.
• Coordinate with the operations team for build deployment and execution within the test environment.
• Track defects and report on testing progress and results.
• Demonstrate advanced SQL, UNIX, Control-M, Control Center, and ETL (Ab Initio) skills.
• Understand the code base by reviewing Ab Initio Psets, graphs (.mp), and XFRs.
• Mock-up and upload test data using the Ab Initio Test Data Management tool (TDM).

Requirements

• Experience in building test strategies, test plans, test scripts, test execution, and defect tracking and reporting for data warehousing and reporting capabilities.
• Exceptional communication skills and attention to detail.
• Ability to work independently to meet target dates and expectations.
• Advanced SQL skills.
• Proficiency in UNIX.
• Experience with Control-M and Control Center.
• Experience with ETL processes, specifically Ab Initio.
• Ability to understand the code base by reviewing Ab Initio Psets, graphs (.mp), and XFRs.
• Skills to mock-up and upload test data using Ab Initio Test Data Management tool (TDM).