Senior Informatica PowerCenter Data Integration Specialist
Empower data integration at enterprise scale — drive innovation and streamline global business processes!
Location & Work Model Lisbon, Porto – Hybrid work model (up to 3 days remote per week)
As a Senior Informatica PowerCenter Data Integration Specialist, you will be working for our client, a leading financial services organization. You will help design, develop, and optimize complex ETL solutions that support critical leasing and banking processes. Join a dynamic team committed to leveraging cutting-edge data management technologies to enable strategic decision-making and operational excellence.
Your main responsibilities:
- Analyze complex functional and technical requirements provided by business teams and Business Analysts to design scalable data architectures.
- Create detailed technical specifications and data flow diagrams for end-to-end ETL processes.
- Develop, test, and deploy high-performance ETL workflows using Informatica PowerCenter, ensuring optimal processing and data quality.
- Integrate heterogeneous data sources—including relational databases, flat files, APIs, XML/JSON, and cloud environments—into consolidated data warehouses.
- Perform performance tuning on ETL pipelines, optimize SQL queries, and troubleshoot complex production incidents to ensure system resilience.
- Implement data governance practices, maintain operational documentation, and automate scheduling processes with workload automation tools.
- Serve as the technical reference and mentor for the Porto engineering team, conducting code reviews and championing best practices.
- Ensure compliance with data security, masking, and access control policies across all data processes.
You’re ideal for this role if you have:
- At least 7+ years of proven experience as a Data Engineer / ETL Developer.
- Deep expertise with Informatica PowerCenter (Design, Workflow Manager, Repository Manager).
- Strong SQL and database experience with Oracle, Teradata, SQL Server, or PostgreSQL.
- Proficiency in Shell scripting for automation and orchestration.
- Solid understanding of Data Warehousing methodologies, including star and snowflake schemas.
- Experience integrating multiple heterogeneous sources and optimizing ETL workflows.
It is a strong plus if you have:
- Experience with Informatica Cloud (IICS), Data Quality (IDQ), or MDM.
- Hands-on knowledge of modern programming languages such as Python, Scala, Java, or Spark.
- Cloud platform exposure such as AWS, Azure, GCP, or Snowflake.
- Familiarity with CI/CD practices and DevOps tools like Jenkins or AutoSys.
- Agile methodologies experience, especially Scrum or Kanban.
Language Required for the role: Fluent English
Eligibility to work in: Only candidates with an existing legal right to work in the European Union will be considered for this role.
#MAKEYourCareerBETTER Interested? Apply now and include your CV (preferably in English), along with a statement confirming your consent to the processing and storage of your personal data.