ETL Developer

JSM Consulting Inc.

New York (NY)

Hybrid

USD 125,000 - 170,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL Developer
ETL Developer

Princeton IT Services, Inc • New York (NY)

On-site
USD 83,000 - 138,000
ETL Developer
ETL Developer

Ethereum Technologies LLC • Denver (CO)

On-site
USD 90,000 - 150,000
ETL Developer
ETL Developer

Quantum Technologies LLC • Denver (CO)

On-site
USD 90,000 - 130,000
ETL Developer
ETL Developer

Robotics Technologies LLC • Denver (CO)

On-site
USD 110,000 - 140,000
ETL Developer
ETL Developer

Valiant Technologies LLC • Denver (CO)

On-site
USD 90,000 - 130,000
ETL Developer
ETL Developer

Robotic Process Automation LLC • Denver (CO)

On-site
USD 110,000 - 140,000
ETL Developer
ETL Developer

Quantum Technologies LLC • Charlotte (NC)

On-site
USD 90,000 - 120,000
ETL Developer - 1 year contract - 60/hr Remote
ETL Developer - 1 year contract - 60/hr Remote

ContractStaffingRecruiters.com • Branford (CT)

Remote
USD 90,000 - 120,000
ETL Developer
ETL Developer

Insight Global (United States) • Dallas (TX)

On-site
USD 90,000 - 130,000
ETL Engineer
ETL Engineer

Valiant Technologies LLC • Columbia (SC)

On-site
USD 110,000 - 150,000