Mid-Level Data Engineer

Capco

. Develop and maintain mappings, tasks, and taskflows using Informatica IDMC/CDI .

Posted 10/9/2026full-timeSão Paulo • BrazilMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Proficient in developing and maintaining ETL/ELT pipelines using Informatica IDMC/CDI, with strong skills in SQL and Python for data manipulation and automation. Demonstrates analytical thinking and effective communication within Agile/Scrum environments.

Highest-signal resume keywords

Informatica IDMC/CDIETL/ELT Pipeline DevelopmentSQL Query DevelopmentPython AutomationAgile/Scrum Methodologies

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ETL ConceptsELT ConceptsSQLData ModelingData Warehouse ConceptsREST APIsJSONXMLData ValidationUnit Testing

Soft Skills

Analytical ThinkingProblem-SolvingStrong CommunicationTeam Collaboration

Tools & Technologies

Informatica IDMCGitAzureAWSGCPDatabricksSnowflakePowerCenterCI/CD ToolsInformatica Cloud Data Quality

Certifications & Qualifications

Informatica IDMC CertificationCloud Platform Training

Industry Keywords

Data IntegrationData LakeLakehouse Architectures

Tech Stack

Tools & technologies

AWSAzureCloudETLGoogle Cloud PlatformInformaticaPythonSQL

About the role

Key responsibilities & impact

Develop and maintain mappings, tasks, and taskflows using Informatica IDMC/CDI
Support the development and maintenance of ETL/ELT pipelines
Extract, transform, and load data from various sources
Develop and execute SQL queries for data analysis, transformation, and validation
Use Python for automation, data manipulation, and integration support routines
Perform unit testing and support integration testing
Validate and reconcile data between source and target systems
Support the investigation and resolution of errors in pipelines and integration processes
Create and maintain technical documentation for mappings, pipelines, and data flows
Participate in team ceremonies and activities within Agile/Scrum methodologies
Use code version control tools such as Git

Requirements

What you’ll need

Knowledge of or hands-on experience with Informatica IDMC/IICS, preferably Cloud Data Integration (CDI)
Knowledge of ETL and ELT concepts
Knowledge of SQL and relational databases
Knowledge of Python for script development and automation
Knowledge of data modeling and basic Data Warehouse concepts
Knowledge of REST APIs and data formats such as JSON and XML
Familiarity with Git and version control concepts
Analytical thinking and an interest in problem-solving
Strong communication skills and the ability to work as part of a team
Nice to have: experience with or knowledge of Azure, AWS, or GCP
Nice to have: knowledge of Databricks, Snowflake, or similar platforms
Nice to have: knowledge of Data Lake and Lakehouse architectures
Nice to have: knowledge of PowerCenter
Nice to have: knowledge of CI/CD tools and processes
Nice to have: knowledge of Informatica Cloud Data Quality (CDQ)
Nice to have: certifications or training related to Informatica IDMC or cloud platforms
Nice to have: intermediate or advanced English proficiency

Benefits

Comp & perks

Inclusive culture and commitment to diversity in all its forms
Inclusion and social responsibility initiatives through internal committees
Support for career development
Opportunity to work for a global technology and business consultancy