Title – Data Test Engineer

Location - Lomas de Sotelo, Naucalpan, Estado de México, C.P. 53390

DESCRIPTION:

In this role, you will work with project team members to analyze automation needs and design, document, test and develop automation scripts / solutions as required to deliver quality test solutions which meet business requirements in the data warehouse environment. The candidate will analyze business/technical requirements in order to determine the automation test strategy needed for maintaining and running existing automation test scripts/regression suites.

Role & Responsibilities:

• Apply Performance/Test Automation/ETL/Data/Database testing techniques

• Developing and running new automation test scripts

• Preparation of test automation scenarios/cases/execution and test results

• Reporting any defects / observations on day to day basis, following the Defect Management strategy

• Involving in giving daily and weekly status reports to project stakeholders as needed

• Onshore and Offshore resource coordination

• Perform requirements analysis, author functional test cases, and execute test cases while understanding the testable software requirements (manual / functional testing)

• Developing, maintaining, and excecuting SQL queries to test movement of data across source and target systems

• Validation of data across source and target systems using ETL tools and framework

Required Experience:

• Three + years of experience with software development tools (e.g., Postman, Jenkins, GitHub, Swagger)

• Three + years of experience in Extract, Transformation, and Load (ETL) testing, including data validation across source and target systems

• Three + years of experience with database testing / data warehouse testing, including data comparison and validation using SQL queries

• Two + years of experience with Programming languages (e.g., Java, Python) and object-oriented programming – class structure, code re-use, abstract thinking / page object model / wrapper classes/ XML object repository

• Two + years of experience with agile project delivery methodology (i.e., scrum)

• Two + years of experience in Functional testing within database environments (creating test plans/test cases/test data strategy)

• Experience in the financial services industry (e.g., insurance, banking, investing, credit card processing, etc.)

Preferred Experience:

• Experience in the P&C insurance industry

• Experience with project and test management tools (e.g., Jira, Application Management Lifecycle (ALM), Azure DevOps, PICT, etc.)

• Experience with test automation frameworks (e.g., ADAPT, Robot, SpecFlow)

• Experience with ETL / data automation tools, including scripting (e.g., Python, Java)

Required Skills:

• Native-level proficiency with the English language

• Effective communications

• Problem solving

• Quality management

• Coaching

• Application testing

• Application programming

• Application development tools

• SQL queries (authoring, executing)

• ETL platforms (e.g., Informatica)

• Data governance

Preferred Skills:

• Business acumen

• Analytical thinking

• CI/CD and DevOps