Senior Oracle PL​/SQL Developer​/Architect; w​/ETL Informatica​/DW Exp

Position: Senior Oracle PL/SQL Developer/Architect (w/ ETL Informatica/DW Exp.)
Role:
Senior Oracle PL/SQL Developer/Architect (w/ ETL Informatica/DW Exp.)

Location:
Jersey City, NJ 07302
- Hybrid

Duration: 6+ Months Contract

Visa: USC/GC Only

Video Interview


*** Experience Level: Min. 10+ Years

Top skillets:

1. Oracle PLSQL

2. Informatica

3. Unix/Shell

Must have Technical

Skills:

• Oracle SQL / PLSQL
• Informatica
• UNIX Shell Scripting

MUST HAVE TECHNICAL

SKILLS:

Oracle Pl/SQL, Complex SQL, DB Performance Tuning, Unix Shell Scripting, ETL Informatica Power Center, Data Warehousing, Mule Soft

Job Description:

Position Summary:

• What are the daily responsibilities and/or priorities?

Responsible for translating the requirements created by functional analysts into the architecture for that solution and describing it through the set of architecture and design documents. Those documents are then used by the rest of the development team to implement the solution. The process of defining architecture by the Solutions Architect often involves selection of the most appropriate technology for the problem being solved, impact assessment as well as technical and operational feasibility.

Individual should be able to demonstrate technical and analytical skill in developing complex ETL workflows using Informatica Power Center.

Responsible to develop test cases and perform unit testing. Create data mapping to ingest data from disparate data sources ranging from flat files to RDMS, Hive or REST APIs. Responsible for developing Unix scripting.

Technically strong in Informatica Power Center.

Technically strong in Oracle DB performance tuning of targets, sources, mappings, and SQL queries. Conceptually good in PL/SQL, Functions, and writing complex SQLs, and creating and exposing views/materialized views.

Strong in UNIX commands and Scripting.

Good in Mule Soft Integration. Proficiency in Mule Soft tools desired.