Responsibilities
- Design, develop, and maintain complex workflows, mappings, transformations, and sessions using Informatica PowerCenter.
- Analyze business requirements and translate them into robust and scalable technical solutions.
- Ensure the maintenance, support, and optimization of existing data pipelines.
- Develop and optimize complex PL/SQL stored procedures, functions, and queries to support business data needs.
- Implement data quality, governance, and security management strategies.
- Perform unit and integration testing to ensure the quality and performance of data flows.
- Debug and resolve issues related to data integration processes.
- Optimize the performance of existing and new ETL processes.
- Participate in the architectural design of data integration solutions.
- Collaborate closely with business analysts, data architects, and other stakeholders to understand and meet business needs.
- Provide accurate technical documentation for developed solutions.
- Mentor junior developers and share best practices.
- Stay up-to-date with new technologies and Informatica evolutions.
Requirements
- Senior experience in Informatica PowerCenter
- Ability to design, develop, and maintain complex workflows, mappings, transformations, and sessions using Informatica PowerCenter
- Ability to analyze business requirements and translate them into technical solutions
- Experience maintaining, supporting, and optimizing data pipelines
- Proficiency in developing and optimizing complex PL/SQL stored procedures, functions, and queries
- Experience implementing data quality, governance, and security management strategies
- Ability to perform unit and integration testing
- Debugging and resolving data integration issues
- Performance optimization of ETL processes
- Participation in architectural design of data integration solutions
- Collaboration with business analysts, data architects, and stakeholders
- Creation of technical documentation
- Mentoring junior developers
- Staying current with Informatica and related technologies
Work Arrangement
Hybrid — Porto
Additional Information
- French language proficiency required
- Hybrid work model in Porto office