Position: Sr. ETL Data Warehouse Manual Tester with Python experience
Location: New York
Sr. ETL Data Warehouse Manual Tester with Python experience
Get AI-powered advice on this job and more exclusive features.
This range is provided by Eliassen Group. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.
Base pay range
$55.00/hr - $57.00/hr
Direct message the job poster from Eliassen Group
Hybrid Onsite | 3 days per week onsite in mid-town Manhattan
There will be an onsite interview in New York, must be able to get there at your own expense.
Status
W2 ONLY no C2C or supplier candidates.
Due to client requirement, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, Vision benefits, 401k with company matching, and life insurance.
Pay: $50 - $57/hr W2
Interviews: 1 round virtual, 1 round in-person will involve SQL scenarios and or coding.
Must have experience testing large volume data loads.
As a Senior Manual Data Warehouse/ETL QA Engineer, you will be involved throughout the development lifecycle with particular responsibility for the quality assurance of software development and deployment, with emphasis on manual test case creation and execution. Must have experience testing large scale batch data jobs from disparate sources. You will work closely with developers to ensure requirements are met with the correct quality standards and conduct manual tests to ensure the software created is fit for purpose.
You will also be responsible for creating, executing, and managing test cases for various kinds of testing such as functional, end-to-end, integration, and regression, along with proper reporting and tracking of bugs.
Responsibilities
• Work as part of cross-functional, passionate Agile project teams to ensure quality is driven into the heart of the development process from requirements definition through delivery.
• Translate functional requirements and specifications into documented test plans, cases, and steps.
• Peer review test cases and ensure test coverage.
• Conduct exploratory testing.
• Execute functional test plans manually.
• Create and maintain test data, tools, and scripts.
Experience Requirements
Mandatory Skills in
Summary:
• Highly Proficient in SQL skills
• Extensive ETL / Data Warehouse Testing
• Large Batch Data Job Testing
• Hands on experience using Python to automate data validation.
• UI / Reports Functional Testing
• Excellent communications skills
Knowledge,
Skills & Experience Required:
• 7+ years of overall testing experience as a lead QA engineer supporting enterprise web applications.
• 4+ years of DB/ETL processes/Data Warehouse Testing experience.
• Experience in Batch Testing.
• Experience in EDI Testing.
• Experience in File Ingestion Testing and Data Quality Testing.
• Experience using Python programming to automate data quality checks, data profiling, and anomaly detection.
• Proven experience in writing and executing manual test cases (functional, end-to-end, integration, etc.).
• Thorough understanding of SDLC and QA processes in an Agile delivery environment.
• Excellent working knowledge of testing fundamentals and test case design techniques.
• Ability to discover, integrate, and organize test data by implementing an effective Test Data Management Strategy.
• Proficient with bug tracking and test management tools (e.g., Zephyr for JIRA).
• Ability to write intermediate to complex SQL scripts to create and manipulate data, with experience in data migration testing.
• Functional knowledge of databases such as Oracle, SQL Server, Postgre
SQL.
• Experience with DDL, DML, and DQL SQL syntaxes, functions, joins, and operators.
• Experience with database validations and data quality testing.
• Ability to understand applications, batch flows, and associated services in relation to service levels and impacts.
• Proficient in utilizing an enterprise scheduling solution (e.g., IBM Workload Scheduler) to monitor and manage batch processing.
• Operational experience with file transfer protocols such as FTP and SFTP.
• Experience with AWS or other cloud platforms.
• Experience in Reports Testing using Business Objects, Crystal Reports, or similar.
• Strong collaboration skills with the ability to develop and maintain…
