DEandA - Core - Cloud Data Engineering - Informatica Cloud

Zensar Technologies; Bengaluru Urban; On-site; INR 2,800,000 - 4,000,000; Full time

Job summary

Zensar Technologies is seeking an experienced Informatica Developer to join our Cloud Data Engineering team in Bengaluru. You will design and develop data integration solutions using Informatica PowerCenter and CDI, and contribute to migrating to IDMC/CDI while aligning with ETL best practices.

You will work with Oracle, SQL Server, and Snowflake, leveraging REST APIs in IDMC CDI, and collaborate with cross-functional teams to translate data requirements into robust solutions.

Qualifications

• 5+ years of hands-on experience with Informatica PowerCenter.
• 3+ years of experience with Informatica Cloud Data Integration (CDI).
• Experience with IDMC migration projects is a strong plus.
• Strong understanding of ETL architecture, data modeling concepts, and data warehousing best practices.
• Proficiency in SQL and Shell scripting.
• Ability to work independently with minimal supervision in a fast-paced environment.
• Excellent problem-solving skills and a proactive attitude toward learning and development.

Responsibilities

• Develop, enhance, and maintain ETL processes using Informatica PowerCenter and Informatica Cloud Data Integration (CDI).
• Lead or contribute to migration efforts from PowerCenter to IDMC/CDI.
• Integrate data across various platforms including Oracle, SQL Server, and Snowflake.
• Leverage REST APIs within IDMC CDI to connect with internal and external applications and systems.
• Collaborate with business and technical teams to understand data requirements and translate them into effective integration solutions.
• Work independently to analyze complex source-to-target mappings and resolve data integration challenges.
• Troubleshoot and optimize data workflows for issue resolution, performance, and scalability in a cloud environment.
• Develop and maintain SQL queries and Unix Shell scripts as part of data workflows and automation.
• Document ETL processes, data flows, and system integrations effectively.

Skills

ETL architecture

Data warehousing

Problem solving

Independent worker

Tools

Informatica PowerCenter

Informatica Cloud Data Integration (CDI)

IDMC migration

SQL

Shell scripting

Job description

Job Description:

As an Informatica Developer, you will play a crucial role in our Cloud Data Engineering team, focusing on Informatica Cloud. Your primary responsibility will be to design and develop robust data integration solutions, ensuring efficient data flow and transformation. You will collaborate closely with our team to implement Informatica PowerCenter and CDI best practices, contributing to our data-driven culture.

Responsibilities

• Develop, enhance, and maintain ETL processes using Informatica PowerCenter and Informatica Cloud Data Integration (CDI).
• Lead or contribute to migration efforts from PowerCenter to IDMC/CDI.
• Integrate data across various platforms including Oracle, SQL Server, and Snowflake.
• Leverage REST APIs within IDMC CDI to connect with internal and external applications and systems.
• Collaborate with business and technical teams to understand data requirements and translate them into effective integration solutions.
• Work independently to analyze complex source-to-target mappings and resolve data integration challenges.
• Troubleshoot and optimize data workflows for issue resolution, performance, and scalability in a cloud environment.
• Develop and maintain SQL queries and Unix Shell scripts as part of data workflows and automation.
• Document ETL processes, data flows, and system integrations effectively.

Qualifications

Required Qualifications:

• 5+ years of hands-on experience with Informatica PowerCenter.
• 3+ years of experience with Informatica Cloud Data Integration (CDI).
• Experience with IDMC migration projects is a strong plus.
• Strong understanding of ETL architecture, data modeling concepts, and data warehousing best practices.
• Proficiency in SQL (complex queries, optimization) and Shell scripting.
• Ability to work independently with minimal supervision in a fast-paced environment.
• Excellent problem-solving skills and a proactive attitude toward learning and development.

Preferred Qualifications:

• Experience with Informatica Data Management Cloud Services (IDMC), Data Quality (IDQ), or other IDMC components.
• Exposure to cloud platforms such as AWS, Azure, or GCP.
• Familiarity with job scheduling tools (e.g., Control-M, Autosys).
• Good communication and interpersonal skills to interact with cross-functional teams.

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 Zensarand join us to Grow. Own. Achieve. Learn.tobe 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.