Description

You will design, implement, and maintain complex data pipelines for enterprise data warehouses and data lakes, primarily using Oracle Exadata, SQL/PL/SQL, and Informatica IICS.

Responsibilities

• Develop and expand data pipelines to extract, transform, and load data per business requirements.
• Design ETL architecture and data management solutions on Oracle Exadata.
• Create data models and ER diagrams for existing and new databases.
• Perform unit testing, support, and continuous improvement of existing processes.
• Tune SQL and ETL processes for optimal performance.

Required Skills

• 5+ years of experience as an ETL Developer.
• 2+ years of Oracle database full lifecycle development, including data modeling and database architecture.
• Expert-level PL/SQL programming: cursors, exception handling, collections, merge statements, analytics functions, views, materialized views, table functions, stored procedures, functions, packages, triggers, dynamic SQLs, external tables, and performance tuning.
• 2+ years of experience in SQL and ETL processes with proven ability in DB performance tuning.
• Working knowledge of ETL tools, specifically Informatica IICS.
• Strong attention to detail and ability to solve complex data structure problems.
• Ability to quickly learn new data tools and concepts.

Preferred Skills

• Associates degree or higher in a related field.
• Experience in public safety systems.

Key Skills

Education

Any Graduate