# Datawarehouse and ETL with Informatica Power Center — Career Guidant Inc

- Location: Phoenix, AZ
- Posted: Feb 16, 2017
- Status: open (checked Nov 22, 2026)
- Apply (employer's site): https://jobs.smartrecruiters.com/careerguidant/108457030
- Employer record: https://visajobs.io/company/career-guidant.md

## Sponsorship history
- Tier: Employer history only
- With this exact title: 0
- Staffing / consulting firm: 75% of its H-1B applications place workers at client sites (FY2024–FY2026)

## Description
Job Description
Mandatory Technical Skills
• Skills: Informatica Power Center 8.x, 9.x
• Should have at least 8+ years of hands-on development/maintenance experience in Informatica 8.x, 9.x
• At least 5 years of 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
• Should be very proficient in PL/SQL
• Very good in SQL query optimization
• Should have excellent knowledge and experience on Informatica troubleshooting
• Experience on implementing auditing and error handling
• Experience in test planning, testing and implementation support
• Experience in creating mappings using complex transformations
• Should be able to provide solutions for complex scenarios, well versed with Informatica workflow manager.
• Experience in basic admin activities, migration, architecture is required.
• Exposure to other Informatica tools like Power Exchange, B2B, BDE (Big Data Edition) is required.
Preferred
• At least 12+ years of experience in DW/BI related technologies and tools
• At least 12+ years of experience in software development life cycle.
• At least 12+ years of experience in Project life cycle activities on development and maintenance projects.
• At least 8 years of experience in Design and architecture review.
• Ability to work in team in diverse/ multiple stakeholder environment
• Experience to Financial domain
• Analytical skills
• Experience and desire to work in a Global delivery environment
Qualifications
• Bachelor’s degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education
• More than 12 years of overall experience.
• More than 10 years of experience with Informatica
• Should have played Architect role
Additional Information
Note : NO OPT, H1 for this position
Client : Infosys

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
