ETL/Data warehouse/Data Lake Developer (Onsite)

DMS Vision • New York City, NY

15h • Onsite

About The Position

The ETL/Data warehouse/Data Lake Developer designs, implements, and expands data pipelines that move data into data lakes and data warehouses according to business requirements. The role performs extraction, transformation, and loading activities; designs data management architecture for enterprise data warehouses, data marts, and data lakes; and implements solutions using SQL, SQL procedures, data management tools such as Informatica IICS, and Oracle Exadata.

The position also involves full lifecycle Oracle database development, including data modeling, database architecture, SQL and PL/SQL development, unit testing, and support. The developer maintains and improves existing processes, develops data models and ER diagrams for existing and new databases, and addresses complex data structures and problems.

Requirements

• At least 5 years of experience as an ETL Developer.
• Proficiency in SQL, ETL processes, and ETL and database performance tuning.
• Expertise in PL/SQL programming, including data types, cursors, exception handling, collections, merge statements, analytic functions, views, materialized views, table functions, stored procedures, functions and packages, database triggers, mutating triggers, dynamic SQL, external tables, performance tuning, object programming, built-in functions, joins, and aggregate functions.
• High attention to detail.
• Ability to quickly learn new data tools and concepts.

Nice To Haves

• Working experience with an ETL tool; Informatica IICS is preferred.
• Experience with public safety systems.

Responsibilities

• Develop complex data pipelines to bring data into data lakes and data warehouses according to business requirements.
• Design, implement, and continuously expand pipelines by performing extraction, transformation, and loading activities.
• Design architecture for data management activities and ETL processes for enterprise data warehouses, data marts, and data lakes.
• Implement data management solutions using SQL, SQL procedures, data management tools such as Informatica IICS, and Oracle Exadata.
• Perform Oracle database full lifecycle development, including data modeling, database architecture, SQL and PL/SQL development, unit testing, and support.
• Develop data models and ER diagrams for existing and new databases.
• Maintain and improve existing processes.

What This Job Offers

• Career Level: Mid Level
• Education Level: No Education Listed