Powercenter Developer

Cognizant; Navalcarnero; Híbrido; EUR 55.000 - 75.000; Jornada completa

Descripción de la vacante

Cognizant in Madrid is seeking a Sr. Developer / Data Support Analyst with 3–5 years of experience in Informatica PowerCenter, Oracle and MongoDB to join our Digital Engineering practice, supporting a private banking client in a hybrid role.

You will design, build and support data integration and transformation workflows, ensure data quality and performance across critical pipelines, and provide L2/L3 production support with clear mappings and runbooks.

Formación

• 3 to 5 years of experience in data integration/ETL development with Informatica PowerCenter.
• Practical experience with Informatica CLI for deployment, monitoring, and workflow administration.
• Proficiency with Oracle databases and PL/SQL.
• Exposure to MongoDB or other NoSQL databases.
• Strong analytical and troubleshooting skills in production support environments.
• Fluent English, both written and spoken.
• Availability for a hybrid work model, Day shift.

Responsabilidades

• Data Integration Development: Design and develop data integration solutions using Informatica PowerCenter.
• Workflow Administration: Manage, schedule, and monitor ETL workflows and batch jobs.
• Database Development: Develop PL/SQL procedures, queries, and data models in Oracle.
• NoSQL Integration: Support flows involving MongoDB for data exchange.
• Performance Optimization: Tune mappings, sessions, and workflows for efficiency.
• Data Quality & Governance: Apply data validation and reconciliation in regulated environments.
• Production Support: Provide L2/L3 support and ensure SLA compliance.
• Documentation: Maintain mappings, workflows, and runbooks.

Conocimientos

Fluent English

Analytical thinking

Troubleshooting

Herramientas

Informatica PowerCenter

Informatica CLI (pmcmd, infacmd)

Informatica Scheduler

Oracle PL/SQL

MongoDB

Descripción del empleo

About The Role

We are seeking a Sr. Developer / Data Support Analyst with 3 to 5 years of experience in Informatica PowerCenter, Oracle, and MongoDB to join our Digital Engineering practice, supporting a leading private banking client. In this hybrid role, you will design, build, and support data integration and transformation solutions, ensuring seamless workflows, high data quality, and optimized performance across critical banking data pipelines.

Key Responsibilities

• Data Integration Development: Design and develop data integration solutions using Informatica PowerCenter to meet business requirements and ensure data accuracy and consistency.
• Workflow Administration: Manage, schedule, and monitor ETL workflows, sessions, and batch jobs using Informatica CLI (pmcmd, infacmd) and Informatica Scheduler.
• Database Development: Develop and optimize PL/SQL procedures, queries, and data models in Oracle to support integration pipelines.
• NoSQL Integration: Support integration flows involving MongoDB, ensuring seamless data exchange between structured and unstructured data sources.
• Performance Optimization: Identify bottlenecks in ETL processes and implement performance tuning across mappings, sessions, and workflows.
• Data Quality & Governance: Apply data validation, error-handling, and reconciliation practices to ensure compliance with data quality standards relevant to a regulated banking environment.
• Production Support: Provide L2/L3 support for scheduled jobs, troubleshoot failures, and ensure SLA compliance for critical data pipelines.
• Documentation: Maintain clear technical documentation for mappings, workflows, and support runbooks to enable knowledge continuity.

Required Qualifications

• 3 to 5 years of experience in data integration/ETL development, with strong hands-on expertise in Informatica PowerCenter.
• Practical experience with Informatica CLI (pmcmd, infacmd) for deployment, monitoring, and workflow administration.
• Proficiency with Informatica Scheduler for batch job orchestration.
• Solid working knowledge of Oracle databases and PL/SQL.
• Exposure to MongoDB or other NoSQL databases.
• Strong analytical and troubleshooting skills in production support environments.
• Fluent English, both written and spoken.
• Availability for a hybrid work model, Day shift.

Preferred Qualifications

• Prior experience in banking, private banking, or other regulated financial services environments.