ETL Developer Informatica IICS

Brooklyn, NY - USA

Monthly Salary: Not Disclosed

Posted on: 7 hours ago

Vacancies: 1 Vacancy

Job Summary

Req Title: ETL Developer

Locations: Brooklyn NY 11201

HYBRID (3 DAYS ONSITE and 2 DAYS REMOTE)

INPERSON INTERVIEW

Job Requirements / Responsibilities

Minimum 5 years of experience as an ETL Developer.
Design develop and maintain complex data pipelines to bring data into Data Lake/Warehouse based on business requirements.
Perform full ETL lifecycle: Extraction Transformation and Loading of data into enterprise data warehouses or data lakes.
Proficient in SQL and ETL processes including ETL and database performance tuning.
Design and implement data management solutions using SQL PL/SQL and ETL tools (preferably Informatica IICS) on Oracle Exadata databases.
Develop data models and ER diagrams for existing and new databases.
Expertise in Oracle database development.
Data modeling database architecture SQL and PL/SQL development unit testing and support
PL/SQL Programming: Data types cursors exception handling collections merge statements analytics functions views materialized views table functions stored procedures functions packages database triggers dynamic SQL external tables performance tuning object programming built-in functions joins aggregate functions collections
Design architecture for ETL pipelines to populate data warehouses data marts and data lakes.
Passionate about complex data structures and problem-solving.
High attention to detail and ability to maintain and improve existing processes.
Quick learner with the ability to pick up new data tools and concepts.
Experience in public safety systems is a plus.

Req Title: ETL Developer Locations: Brooklyn NY 11201 HYBRID (3 DAYS ONSITE and 2 DAYS REMOTE) INPERSON INTERVIEW Job Requirements / Responsibilities Minimum 5 years of experience as an ETL Developer. Design develop and maintain complex data pipelines to bring data into Data Lake/Warehouse bas...