
Data Engineer
Posted 3 days ago

Posted 3 days ago
This is a fully remote position, open to applicants in Brazil.
• 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.
• 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.
• An inclusive culture that appreciates diversity.
• Initiatives for inclusion and social responsibility through internal committees.
• Opportunities for career advancement.
Trax Technologies
Fiserv
Ontrac Solutions
General Dynamics Information Technology
Get handpicked remote jobs straight to your inbox weekly.