Sr. ETL Tester - Randstad USA

job summary:

As an ETL Test Engineer, you will be responsible for both manual and automated testing to validate data sources, extract data, apply transformation logic, and load data into target tables. You'll work closely with data engineering teams to ensure a sustainable testing approach.

Required:

• Insurance domain knowledge - super important

• Main Frame Background (extracting files from MF and comparing in Db2)

• Python - super important

• DB2, Aurora SQL, MySQL, PostgreSQL, Databricks, Snowflake

• Power BI/SSRS/SSIS for report testing

• Messaging events (SNS/SQS/Kafka)

• Informatica tool for ETL

• AWS Cloud S3

Skills: API/Microservices RestAssured Testing, Azure Cloud data Testing, BI Reports / Data Visualization Testing, Cloud migration and Platform modernization Testing, Python Data Automation Testing, Selenium-Java -Testing, SQL & Database testing, Tosca Data Integrity (DI) Testing

 
location: Milwaukee, Wisconsin
job type: Permanent
salary: $130,000 - 140,000 per year
work hours: 8am to 4pm
education: No Degree Required
 
responsibilities:

• Testing data validation scenarios, data ingestion, pipelines, and transformation processes.

• Using automated testing tools and understanding information governance principles in a testing capacity.

• Automating tests across multiple platforms and technologies throughout the development lifecycle.

• Managing test cases and handling issue and defect management.

• Testing systems that capture, verify, and maintain field-generated metadata.

• Familiarity with various back-end and front-end languages, libraries, databases, web servers, web services, APIs, and UI/UX design.

• Knowledge of modern testing development practices and integrated testing products integration with tools such as GitLab.

• Experience with Agile Software Development & Testing methods for cloud deployments.

 
qualifications:

• Experience level: Experienced
• Minimum 12 years of experience
• Education: No Degree Required

 
skills:

ETL

Python

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).

This posting is open for thirty (30) days.