Data Engineer - Remote
Brazil | Nov. 17, 2026
Report as Closed
Company:
Capco
Country: Brazil
Type: Onsite
Employment: Full-time
Description: ABOUT CAPCO
Capco is a global technology and business consultancy, focused on the financial services and energy sector, we are passionate about helping our clients, we have 40 offices in the Americas, Europe and Asia-Pacific! If creativity and innovation are your passion, Capco is right for you. We will support you and help accelerate your career!
We are looking for a Senior Data Engineer with solid experience in Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC), to work on strategic data engineering initiatives, systems integration and modernization of data platforms.
The professional will be responsible for surveying, analyzing and documenting existing integration processes, as well as developing, implementing and optimizing ETL/ELT pipelines using Informatica technologies, with a focus on quality, integrity, traceability and efficiency in data processing.
Main responsibilities
- Carry out a survey and inventory of existing integration processes in Informatica PowerCenter, including mappings, sessions, workflows and dependencies.
- Perform reverse engineering activities to identify and document transformations, business rules, sources, destinations and data flows.
- Analyze and update existing technical documentation, identifying gaps, dependencies and opportunities for improvement.
- Support the design of data integration solutions using Informatica IDMC.
- Develop, migrate and optimize mappings, tasks and taskflows using Informatica IDMC, especially Cloud Data Integration (CDI).
- Build and maintain ETL/ELT pipelines for extracting, transforming and making data available from different systems.
- Develop SQL queries and Python scripts for data analysis, transformation, automation and validation.
- Perform source and destination mappings (source-to-target mapping), ensuring traceability and preservation of business rules.
- Perform unit and integrated tests, including validations, reconciliations and data quality analysis.
- Identify and address performance, integrity and consistency issues in integration processes.
- Support the planning and execution of technological migration, approval, cutover and stabilization activities.
- Develop and maintain technical documentation of mappings, pipelines, data flows and operational procedures.
- Collaborate with architects, technical experts, business analysts and other project members.
Mandatory requirements
- Solid experience in developing and maintaining ETL processes using Informatica PowerCenter.
- Practical experience with Informatica IDMC/IICS, especially Cloud Data Integration (CDI).
- Knowledge of mappings, sessions, workflows and transformations in PowerCenter.
- Experience in developing mappings, tasks and taskflows at IDMC.
- Experience in migrating or modernizing ETL processes, preferably from PowerCenter to IDMC.
- Advanced knowledge of SQL and relational databases.
- Knowledge of Python for automation, manipulation and data validation.
- Experience in reverse engineering, dependency analysis and documentation of integrations.
- Knowledge of ETL/ELT concepts and practices, data modeling and Data Warehouse.
- Experience in data mapping, analysis of transformation rules and reconciliation between systems.
- Knowledge of REST APIs and data formats such as JSON and XML.
- Familiarity with Git and versioning practices.
- Ability to work on technological migration projects, focusing on quality, traceability and operational continuity.
Differences
- Experience in implementation or integration projects with Customer Data Platforms (CDP).
- Knowledge of Adobe Experience Platform (AEP) and Real-Time CDP.
- Experience with Informatica Cloud Data Quality (CDQ).
- Knowledge of services and data architectures in Azure, AWS or GCP.
- Experience with Databricks, Snowflake or equivalent platforms.
- Knowledge of Data Lake and Lakehouse architectures.
- Experience with CI/CD and deployment automation of integration processes.
- Informatica PowerCenter or IDMC certifications.
- Intermediate or advanced English.
Expected experience
- Senior Profile, preferably with 5 years or more of experience in data engineering, ETL development or systems integration.
- Proven experience with Informatica PowerCenter and practical experience in Informatica IDMC/CDI.
- Experience in data platform modernization projects, migration of integrations or replacement of legacy technologies.
- Ability to act autonomously in technical survey activities, analysis of existing systems, documentation and implementation of data integration solutions.
WHY CAPCO:
At Capco we promote an inclusive culture. We value diversity in all its expressions.
We always think together about different inclusion and social responsibility actions through internal committees managed by our internal community, such as the Women, People with Disabilities, Black People, LGBTQIAPN+, Parenting, Generations groups, among others.
Our opportunities are created for everyone!!!
#LifeAtCapco
NEXT STEPS:
- If you are eager to progress your career with us, apply and wait to hear from one of our recruiters!
Apply here:
Web:
Apply here
Emails: