ETL Ab Initio

Cloud Hybrid Technologies, LLC; Irving (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

A technology solutions company seeks a Data Architect/Senior ETL Developer in Irving, Texas, with over 10 years of experience in ETL solutions. Candidates should be proficient in Ab Initio, Unix/Linux scripting, and Oracle SQL/PL-SQL, and possess strong AWS cloud skills. The ideal candidate will design and optimize ETL workflows, collaborate with teams, and resolve performance issues. This position offers a dynamic work environment with opportunities for professional growth.

Qualifications

• 10+ years of experience in building and maintaining ETL solutions.
• Strong expertise in ETL development.
• Excellent problem-solving and analytical skills.

Responsibilities

• Design, develop, and optimize ETL workflows using Ab Initio.
• Write and tune complex Oracle SQL queries and stored procedures.
• Troubleshoot and resolve production and performance issues.

Skills

Ab Initio

Unix/Linux scripting

Oracle SQL/PL-SQL

ETL best practices

AWS cloud services (S3, Glue, Athena, EMR, Redshift)

Python/PySpark

Database optimization

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

Cloud Hybrid 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. Cloud Hybrid 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 Cloud Hybrid 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