Informatica ETL Developer
Position Location: Pittsburgh, PA, 15222 / Strongsville, OH, 44136
100% Onsite.
Days of the week: Monday - Friday with possibility of production support as well.
Working Hours: Flexible, 8-8:30 am Start.
OT: No - however, possibility of production support as well.
Length of Assignment: 12 Months Contract to Hire role
Pay Rate: $60 to 80/hr. on W2 ONLY
Function of the Group: Critical finance applications.
Industry background: Banking or financial background preferred.
Roles and Responsibilities:
Working on development, small work efforts, and BAU items.
Assisting and working on production support.
Must Have Technical Skills (7 - 10 years of experience):
1. Oracle PL/SQL,
2. Informatica,
3. Unix,
4. Mainframe,
5. MS SQL
Flex Skills/Nice to Have:
1. OSFA,
2. Essbase
Education/Certifications: Bachelor Degree
Pre-Screening Questions:
1. What are the methods of exception handling in PL/SQL?
2. What are active vs. passive transformations in informatica?
Interview Process: 2 virtual rounds (potential for second interview in person if availability and location matches) - first initial screening with Hiring Manager; second panel interview with hiring manager and team.
Hiring Manager Stack Ranking of Importance (Most Important to Least Important): 1. Skills 2. Location 3. Rate 4. Prior Client Experience