Informatica Powercenter Developer

Quess IT Solutions; Bengaluru; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

Quess IT Solutions seeks an experienced ETL Developer to design, develop, test, and maintain Informatica PowerCenter workflows in Bengaluru.

You will work with APIs, XML, Oracle PL/SQL, UNIX shell scripts, and SAP integrations to deliver robust data integration solutions across systems.

Qualifications

• Experience designing, developing, testing, and maintaining ETL workflows in Informatica PowerCenter.
• Experience with APIs and XML as data sources/targets.
• Proficient in Oracle PL/SQL procedures, functions, packages, and queries.
• Proficient with UNIX shell scripting to support ETL processes.

Responsibilities

• Design, develop, test, and maintain ETL workflows and mappings using Informatica PowerCenter (PWC).
• Understand the system landscape, including upstream and downstream systems, data flows, and dependencies.
• Analyze ETL specifications and translate requirements into efficient ETL solutions.
• Develop and optimize Informatica mappings, workflows, sessions, and related ETL components.
• Leverage Informatica features to deliver robust and efficient solutions.
• Work with APIs and XML, including XML as source/target.
• Develop and maintain Oracle PL/SQL procedures, functions, packages, and queries as required.
• Develop and execute UNIX shell scripts to support ETL processes.
• Work on SAP connectivity and integration with Informatica.
• Support data integration and SAP migration projects.
• Troubleshoot ETL failures, data issues, and performance-related problems.
• Collaborate with technical teams to understand data requirements and ensure successful integration across systems.

Skills

ETL design

Data integration

Systems analysis

Collaboration

Tools

Informatica PowerCenter (PWC)

UNIX shell scripting

XML

SAP connectivity

Oracle PL/SQL

Job description

Role & responsibilities:

• Design, develop, test, and maintain ETL workflows and mappings using Informatica PowerCenter (PWC).
• Understand the overall system landscape, including upstream and downstream systems, data flows, and dependencies.
• Analyze ETL technical specifications and translate business/technical requirements into efficient ETL solutions.
• Develop and optimize Informatica mappings, workflows, sessions, and related ETL components.
• Leverage Informatica features, transformations, and functions to deliver robust and efficient solutions.
• Work with APIs and XML, including using XML as both source and target.
• Develop and maintain Oracle PL/SQL procedures, functions, packages, and queries as required.
• Develop and execute UNIX shell scripts to support ETL processes and batch operations.
• Work on SAP connectivity and integration with Informatica.
• Support data integration and SAP migration projects.
• Troubleshoot ETL failures, data issues, and performance-related problems.
• Collaborate with technical teams to understand data requirements and ensure successful integration across systems.

Preferred candidate profile

• Design, develop, test, and maintain ETL workflows and mappings using Informatica PowerCenter (PWC).
• Understand the overall system landscape, including upstream and downstream systems, data flows, and dependencies.
• Analyze ETL technical specifications and translate business/technical requirements into efficient ETL solutions.
• Develop and optimize Informatica mappings, workflows, sessions, and related ETL components.
• Leverage Informatica features, transformations, and functions to deliver robust and efficient solutions.
• Work with APIs and XML, including using XML as both source and target.
• Develop and maintain Oracle PL/SQL procedures, functions, packages, and queries as required.
• Develop and execute UNIX shell scripts to support ETL processes and batch operations.
• Work on SAP connectivity and integration with Informatica.
• Support data integration and SAP migration projects.
• Troubleshoot ETL failures, data issues, and performance-related problems.
• Collaborate with technical teams to understand data requirements and ensure successful integration across systems.