Overview
Skills
Job Details
Role: Senior Oracle PL/SQL Developer/Architect (w/ ETL Informatica/DW Exp.)
Location: Jersey City, NJ 07302- Hybrid
Duration: 6+ Months Contract
Video Interview
*** Experience Level: Min. 10+ Years
Top skillets:
- Oracle PLSQL
- Informatica
- 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 PowerCenter, Data Warehousing, MuleSoft
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 PowerCenter.
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 PowerCenter.
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 MuleSoft Integration. Proficiency in MuleSoft tools desired.