Senior ETL QA Analyst

Intercontinental Exchange - Atlanta, GA

Full-time - Senior

Remote - Atlanta, GA

Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

The Senior QA Analyst (Clearing Data Analytics) plays a crucial role in ensuring the quality and functionality of software systems within the Clearing Houses business processes. This position involves collaboration with Business Analysts, SQL Developers, ETL and Data Warehouse Engineers to thoroughly review business and technical requirements. The analyst will be responsible for producing comprehensive test plans, strategies, scenarios, and cases, while also reporting any defects encountered during testing. A deep understanding of data models, complex data transformation logic, integration points, and reporting dashboards is essential for success in this role. In this position, the Senior QA Analyst will document, maintain, and execute detailed test cases to validate system functionality. This includes identifying and documenting software defects and tracking the execution status of test cases. The analyst will create test plans for software releases, detailing the overall strategy for testing complex systems, defining resources, test scope, and identifying dependencies and risks. Additionally, the role requires deploying software release builds, maintaining test environments, and troubleshooting any software or hardware configuration problems. The Senior QA Analyst will also work closely with the technology team to build cutting-edge Clearing Data Analytics and Reporting Systems, testing systems built in ETL, DWH, and reporting-based solutions. The role requires creating and maintaining QA artifacts in accordance with current standards and practices, gaining experience with iterative and agile software development methodologies, and performing all aspects of verification, including functional, integration, automated regression, and system testing.

Responsibilities

• Document, maintain and execute detailed test cases to validate system functionality, identify and document software defects, and track test case execution status.
• Create test plans for software releases to detail the overall strategy for testing complex systems, including defining resources and test scope for each test cycle, and identifying dependencies and risks.
• Deploy software release builds, maintain test environments, and perform troubleshooting software/hardware configuration problems.
• Work with technology team in building cutting edge Clearing Data Analytics and Reporting Systems.
• Test systems built in ETL, DWH and reporting based solutions.
• Create and maintain QA artifacts by following the current standards & practices.
• Gain experience with Iterative and Agile software development methodologies.
• Perform all aspects of verification, including functional, integration, automated regression, and system testing.

Requirements

• B.S or master's degree in computer science or related discipline; or equivalent work experience
• Minimum of 7 years of experience in enterprise application testing (test case development and execution)
• Strong SQL and/or python scripting experience
• Ability to set priorities and multi-task in a fast-paced environment
• Prefer 3+ years of working experience of Oracle environments with strong SQL skills
• Experience in working with ETL systems and Reporting solutions such as Tableau and/or Business objects
• 2+ years of experience with commodity markets, financial trading environment, or equity brokerage business and exposure to futures markets is preferred
• Extensive knowledge of testing process, testing methodology analysis and defect reporting tools
• Ability to work independently and productively under pressure
• Strong problem-solving, analytical, technical, and troubleshooting skills
• Strong verbal and written communication skills
• Strong organizational skills and decision-making ability
• Experience in working with Micro Focus ALM/Quality Center, and JIRA
• Experience and knowledge of all aspects of the SDLC methodology and related concepts
• Strong ability to manage multiple projects and prioritize deliverables based on business needs.

Benefits

• Work from home flexibility of one day per week