ETL/Informatica Application Support Engineer

This is a full time role with pnc bank. 100% remote. usc / gc. Must have ETL/Informatica support exp.

1. must have specific Informatica/ETL application support experience from a Bank or Financial Services experience (Anti Money Laundering would be a home run - not required) 2. must have used monitoring tools: Dynatrace is highly preferred but any enterprise monitoring tool will work 3. must have Service Now 4. must be comfortable with SQL against Oracle and Linux Bash Scripting 5. on call 1 wk./month

6+ years of exp.

Screening question:

1. How many years do you have with Informatica and what is the most recent version you've worked on/currently are working on?

2. What is the experience that you have with production support in recent years?

3. Do you have experience with Control-M?

Candidate Technical and skills profile:

Describe the role and the key responsibilities in order of which they will be doing day 1 and frequently followed by those they will be doing as the project/work progresses:

Day 1 Responsibilities:

Understand all ETL concepts and Linux scripting/coding Understand scheduling logic and ServiceNow activities Understand Oracle scripts, procedure, DML (data manipulation language), DDL (Data Definition Language)

Describe the must have technical skills/experience (ask for alternative/tool/version) of the position in priority order:

Required Skills:

ETL/Informatica (9.6+ or newer)

Linux scripting coding

ServiceNow

Oracle scripts, procedure, DML, and DDL

Financial Services background

Preferred/Bonus Skills:

Hive

Sqoop

Big Data hub

Hadoop