TAD PGS, Inc. Database Administrator in Tucson, Arizona
TAD PGS, INC. is currently seeking a Database Administrator for one of our clients in Tucson, AZ . Job 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 Required 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.
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.
Informatica BDM, IDL, EDC, IIS for Hadoop.
MS SQL Server Integration Services (SSIS).
TAD PGS, INC. specializes in delivering secure, reliable and rapidly implemented workforce solutions to the U.S. Federal marketplace, including U.S. Government agencies and their prime contractors. With more than 50 years of experience, TAD PGS, INC. has earned a reputation for accountability, a value that government agencies and prime contractors both demand and deserve. TAD PGS, INC. sources professionals for the full spectrum of federal positions, from administrative to management, and those contracts requiring extremely niche-oriented technical skills and the highest levels of security clearance. VEVRAA Federal Contractor / Request Priority Protected Veteran Referrals / EOE Protected Veterans/Disability
Location: Tucson , AZ
Minimum Experience (yrs): 4
Required Education: H.S. diploma or equivalent