Data Engineer

Posted 3 days ago

This is a fully remote position, open to applicants in Brazil.

📋 Description

• Conduct an assessment and inventory of current integration processes in Informatica PowerCenter, encompassing mappings, sessions, workflows, and dependencies.

• Execute reverse engineering to uncover and document transformations, business rules, sources, targets, and data flows.

• Analyze and revise technical documentation, pinpointing gaps, dependencies, and areas for enhancement.

• Assist in designing integration solutions utilizing Informatica IDMC.

• Create, migrate, and optimize mappings, tasks, and taskflows in Informatica IDMC, with a focus on Cloud Data Integration (CDI).

• Construct and sustain ETL/ELT pipelines for data extraction, transformation, and delivery.

• Develop SQL queries and Python scripts for data analysis, transformation, automation, and validation.

• Conduct source-to-target mapping to ensure traceability and the maintenance of business rules.

• Perform unit and integration testing, validations, reconciliations, and data quality assessments.

• Identify and resolve performance, integrity, and consistency challenges in integration processes.

• Support technology migration, user acceptance testing, cutover, and stabilization efforts.

• Generate and maintain technical documentation for mappings, pipelines, data flows, and operational procedures.

• Collaborate with architects, technical experts, business analysts, and other project team members.


⛳️ Requirements

• Extensive experience in developing and maintaining ETL processes using Informatica PowerCenter.

• Practical experience with Informatica IDMC/IICS, particularly with Cloud Data Integration (CDI).

• Proficiency in mappings, sessions, workflows, and transformations within PowerCenter.

• Experience in developing mappings, tasks, and taskflows in IDMC.

• Background in migrating or modernizing ETL processes, ideally from PowerCenter to IDMC.

• Advanced understanding of SQL and relational databases.

• Familiarity with Python for automation, data manipulation, and validation tasks.

• Experience with reverse engineering, dependency analysis, and integration documentation.

• Knowledge of ETL/ELT concepts and practices, as well as data modeling and Data Warehousing.

• Experience with data mapping, transformation rule analysis, and system reconciliation.

• Understanding of REST APIs and data formats such as JSON and XML.

• Familiarity with Git and version control methodologies.

• Capability to engage in technology migration projects, emphasizing quality, traceability, and operational continuity.

• Senior-level profile, ideally with 5 or more years of experience in data engineering, ETL development, or systems integration.

• Demonstrated experience with Informatica PowerCenter and practical knowledge of Informatica IDMC/CDI.

• Participation in data platform modernization, integration migration, or legacy technology replacement initiatives.

• Ability to work independently on technical assessments, analysis of existing systems, documentation, and execution of data integration solutions.


🏝️ Benefits

• An inclusive culture that appreciates diversity.

• Initiatives for inclusion and social responsibility through internal committees.

• Opportunities for career advancement.

People also viewed

Trax Technologies13 hours ago

Data Architect

US flagUnited States OnlyFull-timeData Engineer
ApplyView job
Fiserv13 hours ago

Senior Snowflake Data Platform and Artificial Intelligence Architect

US flagUnited States OnlyFull-timeData Engineer
ApplyView job
Ontrac Solutions13 hours ago

Staff Data Engineer

US flagUnited States OnlyFreelanceData Engineer
ApplyView job
General Dynamics Information Technology13 hours ago

ICAM Identity Data Management Engineer – Radiant Logic

US flagUnited States OnlyFull-timeData Engineer$170k – $230k/year
ApplyView job
General Dynamics Information Technology13 hours ago

Identity Data Management Engineer – Radiant Logic

US flagUnited States OnlyFull-timeData Engineer$170k – $230k/year
ApplyView job
General Dynamics Information Technology13 hours ago

Senior Data Engineer

US flagUnited States OnlyFull-timeData Engineer$102k – $138k/year
ApplyView job

Never miss a great job!

Get handpicked remote jobs straight to your inbox weekly.

Trusted by 7,400+ designers