Apply for this opportunity

This job application is on an outside website. Be sure to review the job posting there to verify it's the same.

Apply Offsite

ETL/Data warehouse/Data Lake Developer

Job

iFusion Inc.

New York, NY (In Person)

Full-Time

Posted 3 days ago (Updated 15 hours ago) • Actively hiring

Expires 7/21/2026

See Job Scorecard

Review key factors to help you decide if the role fits your goals.

How is this calculated?

Pay Growth

out of 5

Not enough data

Not enough info to score pay or growth

Job Security

out of 5

Not enough data

Calculating job security score...

Total Score

out of 100

Average of individual scores

Were these scores useful?

Skill Insights

Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.

Job Description

ETL/Data warehouse/Data Lake Developer in Brooklyn,NY In person interview- 3 days Onsite At least 13 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.