DE&A - Core - Cloud Data Engineering - Informatica Cloud Professional
Zensar Technologies · Bengaluru · onsite · Posted 7d ago
Undisclosed5–10 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
Key Skills Experience - ETL / Informatica IDMC Developer:
Strong hands-on experience with Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC/IICS).
- Proven experience in at least one end-to-end migration project from Informatica PowerCenter to IDMC.
- Expertise in designing, developing, and supporting ETL/ELT solutions using:
- Cloud Data Integration (CDI)
- Mass Ingestion
- Cloud Application Integration (CAI)
- Data Quality (DQ)
- Hands-on experience integrating data from REST APIs using Informatica IDMC/IICS REST V2 Connector or Web Services Connector.
- Strong understanding of JSON/XML payloads, API authentication, pagination handling, and loading data into relational databases and cloud data warehouse platforms.
- Excellent SQL development skills with experience in:
- Oracle
- Snowflake
- Query optimization and performance tuning
- Strong experience in UNIX/Linux Shell Scripting for automation, orchestration, and support activities.
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.
- 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.
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Skills
AutomationCloud Environmentcloud data engineeringcloud platformscloud servicesapisautosysamazon web servicesComplex QueriesCloud Application IntegrationCloud DatacloudArchitectureMicrosoft AzureCommunication And Interpersonal Skills
About Zensar Technologies
Zensar Technologies
IT Services & Consulting
10.0k+
employees
2001
25 years old
Pune, Maharashtra
India
About
Zensar is a global organization that conceptualizes, builds, and manages digital products through experience design, data engineering, and advanced analytics for leading companies.
Industries
IT Services & Consulting
Employee ratings
2,994 reviews
3.7/ 5
Culture
3.5
Career growth
3.0
Work-life
3.8
Employees rate it well for
Work Life Balance442Work Culture366Senior Management300Salary295Job Security229
Find them on