Senior ETL Architect – Data Lakes & Warehouses (Hybrid)

JSM Consulting Inc.; New York (NY); Ibrido; USD 125.000 - 170.000; Tempo pieno

Descrizione del lavoro

JSM Consulting Inc. seeks an experienced ETL Developer for a hybrid role in Brooklyn, NY. You will design and implement complex data pipelines to feed the Data Lake/Warehouse per business requirements.

You will optimize SQL/PL/SQL, perform data modeling, and work with Informatica IICS on Oracle Exadata. This position requires 10+ years of experience, strong attention to detail, and the ability to pick up new data tools quickly.

Competenze

• At least 10 years of experience as ETL Developer.
• Proficient in SQL and ETL processes, ETL and DB performance tuning.
• Oracle database full life cycle development including data modeling and PL/SQL.
• Expertise in PL/SQL programming (data types, cursors, exceptions, packages, triggers) and performance tuning.
• Experience with ETL tools, preferably Informatica IICS.

Mansioni

• Develop complex data pipelines to bring data into the Data Lake/Warehouse per business requirements.
• Design, implement, and expand data pipelines using ETL processes.
• Design architecture for ETL data extraction, transformation, and load to enterprise data warehouse.
• Maintain and improve existing ETL processes and pipelines.
• Experience with Oracle Exadata and data modeling is a plus.

Conoscenze

ETL Development

SQL

PL/SQL

Data Warehousing

Data Lake

Performance Tuning

Data Modeling

Strumenti

Informatica IICS

Oracle DB

Descrizione del lavoro

JSM Consulting Inc. seeks an experienced ETL Developer for a hybrid role in Brooklyn, NY. You will design and implement complex data pipelines to feed the Data Lake/Warehouse per business requirements.

You will optimize SQL/PL/SQL, perform data modeling, and work with Informatica IICS on Oracle Exadata. This position requires 10+ years of experience, strong attention to detail, and the ability to pick up new data tools quickly.