Job ID: J55756 Job Title: ETL Automation Lead / Engineer Location: Tampa, FL Duration: 10 Months + Extension Domain Exposure: Media/ Entertainment Client: To Be Discussed Later Employment Type: W-2, 1099, C2C Work Authorization: US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other Job Title: ETL Automation Lead / Engineer Location: Tampa, FL Duration: 10 Months + Extension Bill Rate: $84/hour Job Type: W-2, 1099, C2C Client: To Be Discussed Later Work Authorization: US-Citizen, H-1B, OPT-EAD, GC-EAD
Job Description We are seeking an experienced ETL Automation Test Engineer with strong expertise in Ab Initio ETL testing, Python, PySpark, SQL, and Big Data validation. The candidate will be responsible for developing automated testing solutions, validating large-volume datasets, performing data reconciliation, and ensuring the accuracy and quality of ETL workflows.
Key Responsibilities:
- Design, develop, and maintain automated test solutions for Ab Initio ETL applications.
- Build reusable automation scripts and frameworks using Python and PySpark.
- Perform source-to-target, data transformation, reconciliation, and data-quality validation.
- Validate large datasets across Ab Initio, Hive, Oracle, and Big Data environments.
- Develop complex SQL queries for backend and ETL data validation.
- Create Unix Shell scripts to support test automation and batch validation.
- Perform end-to-end, functional, regression, and integration testing.
- Analyze Ab Initio job failures, investigate data discrepancies, and perform root-cause analysis.
- Improve automation coverage and reduce manual testing efforts.
- Collaborate with developers, data engineers, business analysts, and QA teams.
- For Lead-level candidates, provide technical guidance, review automation scripts, establish testing standards, and mentor team members.
Mandatory Technical Skills:
- Strong hands-on experience in Ab Initio ETL Automation Testing.
- Python scripting for ETL test automation.
- PySpark scripting for large-volume data validation.
- Strong SQL and Oracle knowledge, including complex queries and data reconciliation.
- Unix and Unix Shell Scripting.
- Hive and Big Data validation.
- Source-to-target data validation and transformation testing.
- ETL regression testing, data reconciliation, and data-quality validation.
Preferred Skills:
- Java and Selenium Automation.
- Working knowledge of Ab Initio Control Center.
Equal Opportunity Employer We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.