Ab Initio ETL Engineer: Data Pipelines & Warehousing

Lamwork; San Jose (CA); On-site; USD 158,346 - 193,534; Full time

Job summary

Lamwork is seeking an Ab Initio Developer responsible for creating and managing ETL pipelines essential for data analytics. Day-to-day, you will design ETL processes, automate tasks with UNIX shell scripting, and ensure data quality through code reviews.

The ideal candidate has expertise in Ab Initio, SQL, and data warehousing, and will contribute to the strategic data infrastructure in a dynamic environment.

Qualifications

• Strong skills in ETL development using Ab Initio.
• Experience with data warehousing and data pipelines.
• Proficiency in SQL and shell scripting.

Responsibilities

• Design end-to-end ETL pipelines from raw source extraction to warehouse load.
• Automate graph execution scripts and manage CI/CD workflows.
• Conduct peer code reviews and document requirements.

Skills

Ab Initio GDE And EME

SQL Query Development And Performance Tuning

Unix/Linux Shell Scripting

Data Warehouse Modeling

Hadoop Ecosystem

HDFS Concepts

Analytical Thinking

Stakeholder Communication

Problem Solving

Attention to Detail

Team Collaboration

Education

Ab Initio Certified Developer

AWS Certified Data Engineer – Associate

Databricks Certified Associate Developer for Apache Spark

Certified Data Management Professional

Job description

Lamwork is seeking an Ab Initio Developer responsible for creating and managing ETL pipelines essential for data analytics. Day-to-day, you will design ETL processes, automate tasks with UNIX shell scripting, and ensure data quality through code reviews.

The ideal candidate has expertise in Ab Initio, SQL, and data warehousing, and will contribute to the strategic data infrastructure in a dynamic environment.