ETL Tester with Datastage and Python

Role: ETL Tester with Datastage and Python

Location: Columbus,Ohio (Hybrid) Locals or relocation OK

Duration: 1 Years with Possible extensions

JOB DESCRIPTION :

• Responsible for the planning, integration, test casing, scripting and execution of all testing to ensure proper coverage

• Schedules and leads test deliverables review sessions as necessary

• Work on multiple projects/systems as a project team member and are considered to be a subject matter expert for a single project/system.

• These projects are of moderate to high complexity within one or more development environments

• Collaborate with the BSA and Development teams in the analysis and review of business objectives and requirements to ensure requirements are testable

• Actively participate in the review of architectural and technical design specifications

• Develop, document and maintain the test data, data validation, end to end testing flows.

• Conducts testing using HNB manual and/or automated test processes and reports results

• May run database queries in order to supply data validation within test scripts

• Updates test cases based upon approved change requests; Works with BSAs and Development teams on defect analysis and triage

• Assigns defect severity, and manages defects throughout the project

• Works with colleagues and project managers to meet established target dates and completion of activities/deliverables under changing conditions

• Creates test status reports per project guidelines

• Creates test results and test summary deliverables to ensure production implementation readiness

• Creates and facilitates review of the Test Strategy with the project team

• Identifies any potential quality issues per defined processes and escalates potential quality issues immediately to management

• Collects testing sign-off from all testing participants, including cross-impacted application teams

• Ensures all aspects of testing, such as manual execution, regression, automation and performance testing, is completed

• Collaborates with Project Test Lead on estimating the test efforts

• Collaborates with the project team to support UAT efforts as needed

• Maintains the regression test bed to meet changing requirements

• Participates in off-hour production releases as needed

• Supports the project is warranty period as needed

• Works under moderate supervision with some latitude for independent judgement and problem solving

• Provides mentorship to junior team members as needed; Understands and follows the project lifecycle methodology consistently.

Specific Requirements for these positions:

• Need to be able to create and have created test plans/test scripts.

• Be able to identify expected results (had conversations with developers/business/etc wherever requirements came from), which may not be clear from the requirements.

• Moderate to Advanced SQL skills

• Focus in on testing of data, not front or UI testing

• Maintain test data generator Preferable to know python

• Experience in scripting or programming (Python is the preferred, excel macros)

• Development Experience, preferably in python

• Worked with financial data

• Experience with large data migrations

• Experience with API Testing

• Problem Solver, Curious Mindset to find problems, need a higher-level thinker.

• Able to manage your own work. Ability to work with light supervision. Create your own test schedule. Plan and prioritize your own work.

• Self-Starter ability to come in and dig in with little/no documentation; ability to quickly grasp and understand concepts/systems/applications

• Highly collaborative and comfortable working a team-oriented environment

• Attention to detail

• Collections background, Commercial loan or CC background (preferred, but not a deal breaker)

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.