Datawarehouse and ETL with Informatica Power Center
Career Guidant IncPhoenix, Arizona, United States
Posted February 16, 2017
Full Time
About the Company
Career Guidant is a multi-faced organization providing Information Technology Custom Learning Services, Lateral Staffing Solutions, and Infrastructure & Facility Management Services.
Job Description
Career Guidant is seeking a Datawarehouse and ETL specialist with expertise in Informatica Power Center. The ideal candidate will have 8+ years of experience in Informatica 8.x and 9.x, as well as knowledge of PL/SQL and SQL query optimization.
Requirements
- Informatica Power Center 8.x, 9.x
- At least 8+ years of hands-on development/maintenance experience in Informatica 8.x, 9.x
- Experience in Architect capacity to provide end to end ETL solution using Informatica and other ETL tools
- Knowledge / Experience on using Informatica Power center and ETL using different data sources
- PL/SQL
- SQL query optimization
- Informatica troubleshooting
- Auditing and error handling
- Test planning, testing and implementation support
- Creating mappings using complex transformations
- Providing solutions for complex scenarios, well versed with Informatica workflow manager
- Basic admin activities, migration, architecture
- Experience in other Informatica tools like Power Exchange, B2B, BDE (Big Data Edition)
Benefits
- Full-time employment
- On-site location in Phoenix, AZ