Job Description

Requirements
Minimum 2 years of experience working with Informatica IICS CDI and previous experience with Informatica PowerCenter.
Solid knowledge of relational databases (SQL, Oracle, SQL Server, etc.) and efficient management of large volumes of data.
Experience creating mappings, transformations, sessions and workflows in the Informatica environment.
Knowledge of ETL process optimization techniques and good data integration practices.
Experience in resolving incidents and supporting ETL processes in productive environments.
Ability to work in multidisciplinary teams, communicate effectively and collaborate with technical and business areas.
Desirable skills
Knowledge of data quality processes (Data Quality) and/or related tools.
Responsibilities
Design, develop and implement ETL processes using Informatica PowerCenter and Informatica IICS CDI for the integration and transformation of data between different systems.
Analyze business and data requirements to define efficient ETL solutions, ensuring quality, consistency and performance in loads.
Build and maintain mappings, transformations, sessions and workflows within the Informatica ecosystem.
Run unit tests and integrations to ensure accuracy in data loads and correct operation of processes.
Optimize ETL processes to handle large volumes of information, applying performance techniques and good practices.
Identify, manage and resolve incidents or errors in ETL flows, guaranteeing the stability of the processes.
Collaborate with database teams, data architects, and other developers to ensure proper integration with existing data architectures.
Document the developed ETL processes in a clear and up-to-date manner.
Ensure data quality by monitoring integrity, consistency and business rules applied during uploads.",