Informatica Data Engineer

• Minimum of 6 years of professional experience in Data Engineering, Data Integration, ETL, or a related field.
• Strong hands-on experience with Informatica PowerCenter.
• Experience developing, maintaining, and optimizing ETL processes.
• Solid knowledge of:
• Informatica mappings, workflows, sessions, and transformations.
• Workflow configuration and parameterization.
• Error handling, recovery mechanisms, monitoring, and debugging.
• Data Masking using Informatica, including dynamic and persistent data masking approaches.
• SQL and relational databases.
• ETL/ELT concepts, data integration architectures, and data lifecycle principles.
• Proven experience troubleshooting complex ETL issues involving large datasets and high-volume workloads.
• Experience identifying performance bottlenecks and implementing technical optimizations.
• Knowledge of Data Quality practices, including validation rules, data controls, monitoring, and remediation processes.
• Experience working in structured development environments with version control, deployment processes, and technical documentation.
• Ability to work autonomously when troubleshooting and maintaining existing PowerCenter environments.
• Strong analytical, problem-solving, and communication skills.
• Good command of English.

Nice to Have

• Hands-on experience with Informatica Intelligent Data Management Cloud (IDMC), particularly Cloud Data Integration (CDI).
• Experience participating in PowerCenter-to-IDMC migration projects, including migration assessment, compatibility analysis, and remediation activities.
• Knowledge of Informatica Data Quality or IDMC Data Quality.
• Knowledge of Informatica services related to metadata management, data governance, or data cataloguing.
• Experience with CI/CD practices and automated deployment of data integration components.
• Experience working with cloud platforms and modern data architectures.
• Knowledge of scripting languages such as Python or Shell.
• Experience working in Agile environments.

Responsibilities

• Design, develop, maintain, and enhance data integration workflows using Informatica PowerCenter.
• Develop and maintain Data Masking workflows using Informatica PowerCenter or TDM to protect sensitive data across different environments.
• Support the implementation and evolution of Data Masking solutions, including dynamic and persistent data masking approaches.
• Analyze, troubleshoot, and resolve complex issues involving ETL workflows, mappings, sessions, and data integration processes.
• Identify performance bottlenecks and implement optimizations for ETL processes handling large volumes of data.
• Investigate production incidents, perform root-cause analysis, and implement corrective and preventive actions.
• Contribute to Data Quality initiatives by implementing validation rules, data controls, monitoring mechanisms, and data remediation processes.
• Ensure the reliability, scalability, performance, and maintainability of ETL and data integration solutions.
• Participate in deployment and industrialization activities across development, testing, and production environments.
• Promote development standards, reusable components, and technical best practices.
• Produce and maintain clear technical documentation covering workflows, mappings, interfaces, and operational procedures.
• Collaborate with Data Engineers, Data Architects, application teams, and business stakeholders.
• Contribute to the modernization of existing data integration solutions, including PowerCenter-to-IDMC migration initiatives where applicable.
• Share technical knowledge and contribute to the continuous improvement of Data Integration practices and the Informatica ecosystem.