Location: Remote
Public Trust Required
Technical Skills
Skill
Years/Level of Experience
Structured Query Language (SQL)
P2 – Intermediate
Extract Transform Load (ETL)
P2 – Intermediate
Informatica PowerCenter
P2 – Intermediate
P1 – Beginner (0-2 yrs experience)
P2 – Intermediate (3-5 yrs experience)
P3 – Advanced (7-10 yrs experience
P4 – Expert (10+ yrs experience)
Role Description
Solid ETL experience with Informatica PowerCenter development and related components technologies (ETL Designer, etc.)
Experience in creating, maintaining, and optimizing stored procedures, functions, inllne SQL, and ETL processes
Familiarity with Informatica performance tuning of sources, mappings, targets, and sessions
Familiarity with Software Development Life Cycle, specifically Agile, and able to independently participate in each phase
Experience working with Greenplum (PostgreSQL) and/or Oracle SQL/PLSQL
Previous experience in monitoring, supporting, and resolving issues for applications with technologies such as Informatica, Greenplum, etc.
Willing to work during Production maintenance hours & on call support
Work Authorization
US Citizens
Dual Citizens
US Persons (Green Card)
Clearance Required
Public Trust - Interim