PL/SQL Developer with Informatica

Pyramid Consulting, Inc

Jersey City (NJ)

Hybrid

USD 96,432 - 100,564

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Health insurance

401(k) plan

Paid sick leave

Job summary

A leading consulting firm is seeking a talented PL/SQL Developer with Informatica expertise for a 12+ month contract opportunity. Located in Jersey City, NJ, this role involves developing complex ETL workflows, Unix scripting, and collaboration with a distributed team. Ideal candidates will have strong skills in PL/SQL, ETL, Informatica, and good communication abilities. Competitive hourly rate offered.

Qualifications

Expert in PL/SQL programming and database design with strong data analysis skills.
Technically strong in performance tuning of targets, sources, mappings, and SQL queries.
Self-managed and proactive communicator with experience in Unix scripting.

Responsibilities

Developing Unix scripting and performing unit testing.
Interacting and coordinating with a distributed team.
Creating complex ETL workflows using Informatica Powercenter.

Skills

PL/SQL

ETL

Informatica

Unix Commands

Python

Tableau

Job description

Base pay range

$70.00/hr - $73.00/hr

Immediate need for a talented PL/SQL Developer with Informatica. This is a 12+ Months Contract opportunity with long-term potential and is located in Jersey City, NJ and Plano, TX (Hybrid). Please review the job description below and contact me ASAP if you are interested.

Job ID: 25-81112

Pay Range: $70 - $73/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Responsibilities:

Responsible for developing Unix scripting. Must be able to work independently with minimum supervision.
Responsible to develop test cases and perform unit testing.
Must be able to interact and co-ordinate with distributed team. Must have good communication skills.
PL/SQL/ETL Informatica. Individual should be able to demonstrate technical and analytical skill in developing complex ETL workflows using Informatica Powercenter. Create data mapping to ingest data from disparate data sources ranging from flat files to RDMS, Hive or REST APIs.

Key Requirements and Technology Experience:

Skills-PL/SQL, ETL, Informatica
Expert in PL/SQL programming and Database design, with strong data analysis skills.
Responsible to provide regular task status update to the management. Technically strong in Informatica Power center.
Technically strong in 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.
Self-managed and proactive communicator, Unix scripts, Autosys
Previous experience of working in a data warehouse project is a plus
Python programming
Tableau/reporting experience

Our client is a leading Banking and Financial Industry and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here.

Seniority level