Job Description :
Description:
Seeking an experienced Informatica PowerCenter Administrator with expertise in Business Intelligence ETL and strong SQL skills in an Oracle/SAP/Informatica environment
The successful candidate will support the development team''s design and code for ETL logic to enable initial load and incremental processing, error and exception handling, restart ability and recovery, data cleansing, validation and monitoring
The successful candidate will support data collection from multiple varied data sources and administers daily requests with responsibility for a 3-tiered environment
Daily tasks include: creating user accounts, ETL integrations/implementations/migrations, scheduling and monitoring jobs, performing root cause analysis for job failures and missed data loads, and providing server and database administrators with support for performance tuning, upgrades and patches
The successful candidate does not require a DoD clearance at this time but may in the future
This role will be expected provide off hours and weekend support on a rotating schedule.

Key Skills:
Strong Business Intelligence ETL development and administrations skills using Informatica PowerCenter 10.x
Strong Tidal Enterprise Scheduler skills
Firm understanding of standard data warehousing methodologies
Good PL/SQL development skills, especially in an Oracle 12 environment
Demonstrated skill in data profiling, cleansing, and integration
Experience with adapters for Informatica, SAP, Oracle and Hadoop
Review of ETL design documents, best practices, peer reviews to ensure standards are followed
Clear and effective communication skills
Ability to work cross functions with architects, server and database admins, development teams and Corporate IT.

Desired Skills:
Informatica BDM, IDL, EDC, IIS for Hadoop
MS SQL Server Integration Services (SSIS)

Experience:
4 years Business Intelligence Informatica PowerCenter ETL design, development, deployment and administration
2 years PL/SQL design and development
Experience sourcing data from SAP ERP and Business Warehouse a strong plus
Experience working in an SAP Business Objects environment a strong plus