ETL Ab Initio

Robotics Prcocess Automation, LLC; Irving (TX); On-site; USD 120,000 - 150,000; Full time

Job summary

A leading automation solutions provider in Texas is seeking a Data Architect/Senior ETL Developer with over 10 years of experience in building enterprise-scale ETL solutions. You will design and optimize ETL workflows using Ab Initio while leveraging your strong skills in Unix/Linux, Oracle SQL, and AWS cloud services. The ideal candidate should excel in problem-solving and analytical skills, contributing to cross-functional teams and mentoring junior developers. This role is a great opportunity to impact the development of innovative data processes.

Qualifications

• 10+ years of experience in ETL development.
• Strong expertise in Ab Initio, Unix/Linux, and Oracle SQL.
• Solid understanding of data warehousing concepts and ETL best practices.

Responsibilities

• Design, develop, and optimize ETL workflows using Ab Initio.
• Troubleshoot and resolve production and performance issues.
• Collaborate with cross-functional teams and mentor junior developers.

Skills

Ab Initio

Unix/Linux scripting

Oracle SQL/PL-SQL

Python/PySpark

AWS cloud services

problem-solving

analytical skills

communication skills

Education

Bachelor's Degree in Computer Science/Information Technology

Tools

Autosys

Netcool

ITM

Splunk

Dynatrace

AppDynamics

SiteScope

Job description

• Bachelor's Degree in Computer Science/Information Technology and/or field experience.
• They are looking for a Data Architect /Senior ETL Developer with 10+ years of experience in building and maintaining enterprise-scale ETL solutions. The ideal candidate must have strong expertise in Ab Initio, Unix/Linux scripting, and Oracle SQL/PL-SQL, with a solid understanding of data warehousing concepts and ETL best practices.
• Design, develop, and optimize ETL workflows using Ab Initio.
• Work with Unix shell scripting and Autosys as job scheduling tool.
• Write and tune complex Oracle SQL queries and stored procedures.
• Troubleshoot and resolve production and performance issues.
• Collaborate with cross-functional and cross-vendor teams and mentor junior developers .
• 10+ years of ETL development experience (Ab Initio, Unix, Oracle).
• Strong SQL/PL-SQL and database optimization skills.
• Excellent problem-solving and analytical skills.
• Good Knowledge of Python/PySpark for big data solutions.
• Must have a Strong Experience with AWS cloud services (S3, Glue, Athena, EMR, Redshift ).
• Experience with infrastructure, application performance, and customer experience tools using Netcool, ITM, Splunk, Dynatrace, AppDynamics, and SiteScope
• Good and confident communication skills and Positive learning attitude

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