Job Description

R_350923 Applications Developer (Informatica PowerCenter Developer)

Role: Informatica PowerCenter Developer with expertise in production support, data analysis, and coordinating with other teams to resolve issues. Skilled in designing, developing, and testing Informatica mappings and workflows, as well as SQL and PL/SQL analysis, performance tuning, and documenting development and enhancement requirements.

Responsibilities:

• Monitor Informatica jobs and analyze and resolve job failures.

• Coordinate with downstream teams to resolve data issues.

• Work on development and enhancement projects.

• Prepare the technical design document for new projects.

• Maintain strong knowledge of Azure DevOps (ADO) to create work items and support code migrations.

• Identify long-running SQL queries and tune them to improve performance.

• Fix problematic SQL procedures and document test results.

• Coordinate with the DBA team to resolve database-related issues.

• Conduct unit and integration testing new developments and enhancements.

• Coordinate with the EBS team to analyze the impact on the data warehouse and downstream systems.

• Design and develop mappings, workflows, and sessions using Informatica PowerCenter.

Qualifications:

Bachelor’s degree in computer science or related field.

Required Skills:

• 5 to 6 years of experience with Informatica Power Center10.x, Oracle, and Python.

• Proficiency in SQL and PL/SQL, including query tuning.

• Should be able to develop mappings, workflows, and sessions using Informatica PowerCenter.

• Expertise in data analysis and data interpretation.

• Well-versed in Informatica power center transformations.

• Solid knowledge of data warehousing concepts.

• Well-versed in code migration procedures.

• Ability to understand requirements and identify risks.

• Ability to work independently and meet project timelines

Mandatory Skills

• Experience in Supporting data warehouse projects

• Good oral & written communication skills

• Strong analytical skills.

R_350923 Applications Developer (Informatica PowerCenter Developer)

Role: Informatica PowerCenter Developer with expertise in production support, data analysis, and coordinating with other teams to resolve issues. Skilled in designing, developing, and testing Informatica mappings and workflows, as well as SQL and PL/SQL analysis, performance tuning, and documenting development and enhancement requirements.

Responsibilities:

• Monitor Informatica jobs and analyze and resolve job failures.

• Coordinate with downstream teams to resolve data issues.

• Work on development and enhancement projects.

• Prepare the technical design document for new projects.

• Maintain strong knowledge of Azure DevOps (ADO) to create work items and support code migrations.

• Identify long-running SQL queries and tune them to improve performance.

• Fix problematic SQL procedures and document test results.

• Coordinate with the DBA team to resolve database-related issues.

• Conduct unit and integration testing new developments and enhancements.

• Coordinate with the EBS team to analyze the impact on the data warehouse and downstream systems.

• Design and develop mappings, workflows, and sessions using Informatica PowerCenter.

Qualifications:

Bachelor’s degree in computer science or related field.

Required Skills:

• 5 to 6 years of experience with Informatica Power Center10.x, Oracle, and Python.

• Proficiency in SQL and PL/SQL, including query tuning.

• Should be able to develop mappings, workflows, and sessions using Informatica PowerCenter.

• Expertise in data analysis and data interpretation.

• Well-versed in Informatica power center transformations.

• Solid knowledge of data warehousing concepts.

• Well-versed in code migration procedures.

• Ability to understand requirements and identify risks.

• Ability to work independently and meet project timelines

Mandatory Skills

• Experience in Supporting data warehouse projects

• Good oral & written communication skills

• Strong analytical skills.

Qualifications:

Bachelor’s degree in computer science or related field.

At Zensar, we’re “experience-led everything” We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.