Tester Specialist

Test Specialist

Technical Must Haves: SQL, Unix, AWS - Snowflake, Exposure to Python, PySpark. XML and JSON.

• Take ownership of testing, tasks, and assignments to ensure completion. Perform testing to test functional and non-functional requirements for SF Risk data sources and data movement controls.
• Partner with appropriate groups within SF Risk, IT and Modern Delivery to define Test Strategy and Test Scenarios to ensure data quality.
• Understand the business contexts and ensure test cases and test data are developed to meet all data and system execution scenarios.
• Develop good testing artifacts, positive and negative test scenarios and ensure that the testing team completes the testing as expected. The test lead will take ownership of the testing results.
• Responsible to deliver RTM and document test execution, ensuring appropriate coverage to functional, non-functional and compliance requirements.
• Perform hands-on testing per plan and complete follow-ups to ensure that they are completed timely and aligned with the corporate self-testing standards.
• Prepare test reports that identify and communicate issues and recommendations where necessary.
• Lead and facilitate data loads required for testing.
• Logical thinker performing data analysis. Troubleshoot complex technical and data issues to resolve them.
• Assist with the development and maintenance of detailed procedures that document self-test plans and scripts.
• Automate testing and validations to run regression test cases.
• Develop data profiling, deduping logic, matching logic for analysis.
• Providing senior management and IDEA-VMO with timely status updates and communication of issues. Assist with management reporting.
• Analyze and test large datasets (Structured and Unstructured data - XMLs, JSONs, PDFs) using big data platform.
• Would be required to engage using AWS Cloud, Python, PySpark, PIG, HIVE scripts to filter/map/aggregate data.
• Test R&D and exploratory analysis developments.
• Demonstrated ability to understand different business domains and become an expert in the business domain. Plays a key role in influencing the stakeholders regarding various strategies, solving problems and decision-making.
• Possess strong understanding of data quality and data movement control best practices and standards. Shall be responsible to gather business and system requirements for data movement and controls, develop and document mappings and rules. Handle requirements document.
• Ability to work with the business stakeholders to understand the business contexts of the project under consideration, understand the requirements, understand the data, critical data elements and establish Testing Strategy and Test Plans.
• Establish good partnership with architecture & design, business requirement and development team to ensure that the testing strategy and test plans are in line with the project needs.
• Ability to think critically and logically to perform analysis and presentation of the findings across the team.
• Experience with test and defect tracking tools.
• Has excellent communication (verbal and written) and interpersonal skills.

• Bachelors degree in Business Administration, Computer Science, Data Analytics, Information Systems, Finance or a related discipline or equivalent work experience.
• 5 or more years of Backend data operations testing experience within the financial services industry.
• Ability to analyze and assess the adequacy of test scenarios and identify opportunities for test script improvements.
• 5+ years of data analysis experience, with a combination of business and technical skills

• Demonstrated 5 + Years in writing and executing SQL. This will include writing or reviewing complex SQL code for the purpose of analysis or testing.
• Experience with test automation tools.
• Working experience with data movement/ETL technologies like Informatica. This will include home grown data movement processes in Python and PySpark, SAS data sets and SAS Reporting. Must be able to walk thru the test results with the developers and point out issues.
• Must have worked with defect and issues tracking tools like JIRA.
• Command over using Excel and similar tools to help in the testing process.
• Excellent working knowledge of working with different database technologies which include, Snowflake, MongoDB, Hive, Sybase, UDB. Ability to connect to some of the above databases using LINUX and perform the necessary analysis.
• Demonstrated work with XML, JSON, Delimited Files, Spread Sheets as sources from where the data is sourced or where the data is loaded as a target.
• Ability to guide the team members in the above technologies and train them as needed.
• Microsoft Visio and Microsoft Office (Excel, PowerPoint, Word).

• Designed and developed in Python, Big Data Technologies, PySpark, PIG, HIVE, MongoDB SAS, Tableau, IICS, Informatica or other programming languages.
• Foundational knowledge on AWS Data Platforms,…