Ab Initio ETL developer

Robotics Prcocess Automation, LLC; Atlanta (GA); Hybrid; USD 100,000 - 130,000; Part time

Job summary

A leading automation company in Atlanta is seeking an experienced Ab Initio ETL Developer with strong MHUB experience. The developer will design and implement ETL solutions and must possess 8+ years of development experience along with banking domain familiarity. The role requires solid skills in data warehousing, UNIX/Linux scripting, SQL, and problem-solving. This is a contract position offering onsite or hybrid work options.

Qualifications

• 8+ years of hands-on experience in Ab Initio ETL development.
• Proven expertise with Ab Initio MHUB (Metadata Hub).
• Strong understanding of data warehousing concepts and ETL performance tuning.

Responsibilities

• Design, develop, and implement Ab Initio ETL solutions.
• Gather requirements and translate them into scalable ETL solutions.
• Optimize ETL workflows for performance and maintainability.

Skills

Ab Initio ETL development

Data warehousing concepts

UNIX/Linux scripting

SQL

Problem-solving

Analytical skills

Tools

Ab Initio Express>IT

Control Center

Conduct>IT

Query>IT

AWS

Google Cloud Platform

Azure

Job description

Job Title: Ab Initio ETL Developer with strong MHUB Experience

Location: Atlanta, GA (Onsite/Hybrid)

Client: Banking Domain)

Employment Type: Contract

Position Overview

We are seeking a highly skilled Ab Initio ETL Developer with strong MHUB (Metadata Hub) experience. The ideal candidate will have extensive hands‑on experience designing, developing, and optimizing complex ETL workflows in Ab Initio, along with expertise in metadata management, data lineage, and data integration processes within large enterprise environments.

Key Responsibilities

• Design, develop, and implement Ab Initio ETL solutions to support enterprise data integration and processing needs.

• Work extensively with Ab Initio MHUB for metadata management, data lineage, and governance support.

• Collaborate with data architects, business analysts, and application teams to gather requirements and translate them into scalable ETL solutions.

• Optimize ETL workflows for performance, reusability, and maintainability.

• Perform data analysis, validation, and profiling to ensure accuracy and consistency across systems.

• Troubleshoot production issues, perform root cause analysis, and implement corrective measures.

• Participate in code reviews, testing, and deployment activities following enterprise SDLC and DevOps standards.

• Document ETL processes, data flows, and transformation logic for operational transparency.

Required Skills & Qualifications

• 8+ years of hands‑on experience in Ab Initio ETL development.

• Proven expertise with Ab Initio MHUB (Metadata Hub) design, configuration, and integration.

• Strong understanding of data warehousing concepts, data modeling, and ETL performance tuning.

• Experience in UNIX/Linux scripting, SQL, and working with large relational databases.

• Exposure to data governance, data lineage, and metadata‑driven architectures.

• Excellent problem‑solving, analytical, and communication skills.

• Banking or financial domain experience preferred.

Preferred Skills

• Experience with Ab Initio Express>IT, Control Center, Conduct>IT, and Query>IT.

• Familiarity with Agile/Scrum methodologies.

• Exposure to cloud‑based data platforms (AWS, Google Cloud Platform, or Azure).

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.