ETL Automation Lead — Ab Initio & Big Data QA

Robotic Technologies Automation

Tampa (FL)

On-site

USD 95,000 - 136,000

Full time

10 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Robotic Technologies Automation is seeking an experienced ETL Automation Lead / Engineer for a Tampa, FL engagement. The role focuses on Ab Initio ETL automation testing, Python/PySpark automation, and large-scale data validation, with responsibilities spanning design, development, testing, and mentoring of junior staff.

The candidate will build reusable automation frameworks, execute source-to-target validation, and collaborate with cross-functional teams to ensure data quality across Ab

Qualifications

  • Experience in Ab Initio ETL automation testing.
  • Python scripting for ETL testing.
  • PySpark scripting for large-volume data validation.
  • Strong SQL and Oracle knowledge with complex queries.
  • Unix/Unix Shell scripting experience.
  • Experience with Hive and Big Data validation.
  • Source-to-target data validation and transformation testing.
  • ETL regression testing and data-quality validation.

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.

Skills

Ab Initio ETL
Python scripting
PySpark scripting
SQL & Oracle
Unix Shell
Hive & Big Data
Data validation
Data reconciliation
ETL testing

Tools

Ab Initio Control Center
Selenium

Job description

Robotic Technologies Automation is seeking an experienced ETL Automation Lead / Engineer for a Tampa, FL engagement. The role focuses on Ab Initio ETL automation testing, Python/PySpark automation, and large-scale data validation, with responsibilities spanning design, development, testing, and mentoring of junior staff.

The candidate will build reusable automation frameworks, execute source-to-target validation, and collaborate with cross-functional teams to ensure data quality across Ab

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL Automation Lead — Ab Initio & PySpark Expert
ETL Automation Lead — Ab Initio & PySpark Expert

CloudBigD • Tampa (FL)

On-site
USD 98,000 - 134,000
ETL Automation Lead • Ab Initio & PySpark QA
ETL Automation Lead • Ab Initio & PySpark QA

Ethereum Technologies • Tampa (FL)

On-site
USD 95,000 - 136,000
Senior ETL Automation Lead — Ab Initio & Big Data
Senior ETL Automation Lead — Ab Initio & Big Data

Valiant Technologies LLC • Tampa (FL)

On-site
USD 95,000 - 136,000
ETL Automation Lead - Big Data Testing & Validation
ETL Automation Lead - Big Data Testing & Validation

Quantum Technologies. LLC • Tampa (FL)

On-site
USD 98,000 - 134,000
ETL Automation Lead / Engineer
ETL Automation Lead / Engineer

Valiant Technologies LLC • Tampa (FL)

On-site
USD 95,000 - 136,000
ETL Automation Lead / Engineer
ETL Automation Lead / Engineer

Ethereum Technologies • Tampa (FL)

On-site
USD 95,000 - 136,000
ETL Automation Lead / Engineer
ETL Automation Lead / Engineer

Robotic Technologies Automation • Tampa (FL)

On-site
USD 95,000 - 136,000
ETL Automation Lead / Engineer
ETL Automation Lead / Engineer

CloudBigD • Tampa (FL)

On-site
USD 98,000 - 134,000
ETL Automation Lead / Engineer
ETL Automation Lead / Engineer

Quantum Technologies. LLC • Tampa (FL)

On-site
USD 98,000 - 134,000
Senior ETL & Data Quality Engineer (Python/PySpark)
Senior ETL & Data Quality Engineer (Python/PySpark)

Robotic Process Automation LLC • Boston (MA)

On-site
USD 86,000 - 123,000