PL/SQL Developer

Role: Senior Oracle PL/SQL Developer/Architect (w/ ETL Informatica/DW Exp.) Location: Jersey City, NJ 07302- Hybrid Duration: 6+ Months Contract Video Interview Rate:$65-70/hr on W2 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