Informatica Analyst, Lead & Architect

Modis Talent IT

Apply to this job
Sunnyvale, CA, us on site Until 8/22/2026 First posted March 27, 2025 Last posted March 27, 2025
Job description

We have a Full-time openings as Informatica Analyst, Lead & Architect at Torrance CA, Sunnyvale CA, Phoenix AZ, Plano TX, Austin TX, Moline IL. Kindly forward me your resume immediately if interested ASAP.

Job Title : Informatica (3 Roles: Technology Analyst, Technology lead & Technology Architect)
Location : Torrance CA, Sunnyvale CA, Phoenix AZ, Plano TX, Austin TX, Moline IL
Duration : Full-time


Position 1: Informatica Analyst
Qualifications Basic
• Bachelor’s degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education
• At least 4 years of experience with Informatica

Mandatory Technical Skills
• Skills: Informatica 8.x, 9.x
• Should have at least 4+ years of hands-on development/maintenance experience in Informatica 8.x, 9.x
• Knowledge / Experience on using Informatica Power center and ETL using different data sources
• Experience in creating complex mappings/sessions/workflows.
• Should have good knowledge on scheduling.
• Good in troubleshooting
• Good in performance tuning.
• Good knowledge on export/import.
• Should be good in handling change request.
• Should be good on PL/SQL (especially query writing and tuning)
• Experience on implementing auditing and error handling
• Experience in test planning, testing and implementation support

Preferred:
• At least 4+ years of experience in DW/BI related technologies and tools
• At least 4+ years of experience in software development life cycle.
• At least 4+ years of experience in Project life cycle activities on development and maintenance projects.
• Ability to work in team in diverse/ multiple stakeholder environment
• Experience to Financial domain
• Experience and desire to work in a Global delivery environment

Position 2: Informatica lead
Qualifications Basic
• Bachelor’s degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education
• At least 7 years of experience with Informatica

Mandatory Technical Skills
• Skills: Informatica 8.x, 9.x
• Should have at least 5+ years of hands-on development/maintenance experience in Informatica 8.x, 9.x
• At least 2 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
• Experience on implementing auditing and error handling
• Experience in test planning, testing and implementation support
• Experience in creating mappings using complex transformations

Preferred
• At least 7+ years of experience in DW/BI related technologies and tools
• At least 7+ years of experience in software development life cycle.
• At least 7+ years of experience in Project life cycle activities on development and maintenance projects.
• At least 4 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

Position 3: Informatica Architect
Qualifications Basic
• 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.

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.

All your information will be kept confidential according to EEO guidelines.

About this role

Summary

Design, develop, and implement ETL solutions using Informatica in diverse environments.

Job title

Informatica Analyst, Lead & Architect

Experience level

4+ years (Analyst), 7+ years (Lead), 12+ years (Architect)

Industry

software

Location requirements

Multiple US locations, remote work not specified

Salary

Not specified

Management role

No

Skills & keywords

Required skills

Informatica 8.xInformatica 9.xPL/SQLETLperformance tuning

Preferred skills

DW/BIsoftware development life cyclefinancial domainglobal delivery

Specializations

ETLInformaticaPowerCenterPL/SQLbig data
Locations

Structured locations inferred from the posting.

Sunnyvale, CA, USA

On-site City