ETL Developer

JSM Consulting Inc.; New York (NY); Hybrid; USD 125,000 - 170,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

ETL Development

SQL

PL/SQL

Data Warehousing

Data Lake

Performance Tuning

Data Modeling

Tools

Informatica IICS

Oracle DB

Job description

open rate

inperson interview

hybrid position

Client: NYC Government Client

Location: Brooklyn NY 11201

35hours per week

Interview Type: in-person interviews.

• Hybrid preferred. 3-days onsite.

At least 10 years of experience as ETL Developer.

Develop complex data pipelines to bring data into the Data Lake/Warehouse per business requirements.

Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.

Proficient in SQL and ETL processes, ETL and DB performance tuning.

Design the architecture to perform data management activities i.e., data extraction, transformation, and load (ETL) to enterprise data warehouse. Implement the data management solutions using SQL, SQL procedures, data management tools like Informatica IICS on Oracle exadata database.

Design the overall architecture to Extract, Transform and Load (ETL) data into data warehouse or data mart and data lake.

Oracle database full life cycle development including data modeling, database architecture, SQL and PL/SQL development, unit testing and support.

Expertise in PL/SQL Programming including Data Types, Cursors, Exception Handling Collections, Merge statements, Analytics Functions, Views, Materialized Views, Table Functions, Stored procedures, Functions and Packages, database triggers, mutating, Dynamic SQLs, External Tables, Performance Tuning, Object Programming, built in functions, joins, aggregate functions, Collections.

Working experience with ETL tool (Preferred - Informatica - IICS)

Develop data models and ER diagrams for existing and new databases.

Passionate about complex data structures and problem solving.

High attention to detail.

Ability to pick up new data tools and concepts quickly.

Maintain and improve already existing processes.

Any Experience in public safety systems is a plus.