Informatica Analyst, Lead & Architect

Modis Talent IT; Sunnyvale (CA); Hybrid; USD 90,000 - 130,000; Full time

Job summary

An IT Consulting Firm is looking for Informatica professionals (Analyst, Lead, Architect) to develop and maintain ETL solutions across various locations. Candidates must have a Bachelor’s degree and extensive experience in Informatica (4+ years for Analyst, 7+ for Lead, and 10+ for Architect). Strong skills in PL/SQL, troubleshooting, and ETL methodologies are essential. The roles emphasize collaboration within diverse teams. Join us for an exciting opportunity in a dynamic environment!

Qualifications

• At least 4 years of experience with Informatica required for Analyst role.
• At least 7 years of experience with Informatica required for Lead role.
• More than 10 years of experience with Informatica required for Architect role.

Responsibilities

• Develop and maintain ETL solutions using Informatica.
• Design and implement complex mappings and workflows.
• Conduct testing and support implementation efforts.

Skills

Informatica 8.x, 9.x

PL/SQL

ETL

SQL query optimization

Auditing and error handling

Testing and implementation support

Troubleshooting

Education

Bachelor’s degree or foreign equivalent

Job description

We have 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.

Qualifications

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.

Additional Information

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