Informatica Power Center Developer - Senior

About Mirai RiskTech

Mirai RiskTech is the global technology leader in Balance Sheet Management, Financial Risk and Regulation. With pioneering SaaS Solutions and consulting services, we empower banks to shorten the path to success in risk management and regulatory compliance.

Mirai RiskTech operates with fully remote operations and main employee hubs in Madrid, Mexico City, and Boston. Our team comprises 150 professionals from over 20 countries, fostering a collaborative international culture at the intersection of technology, data, consulting, and finance.

About the Role

Mirai RiskTech is looking for an Informatica PowerCenter Developer with strong technical expertise and a solution-oriented mindset to join our team. This role will be responsible for optimizing business processes using the Informatica PowerCenter ecosystem and ETL processes.

The person in this position will work closely with business stakeholders and technical teams to translate functional requirements into scalable, efficient, and secure solutions. The role requires strong expertise in Informatica PowerCenter, ETL processes, Data Warehousing, and Business Intelligence projects, along with solid development best practices and a continuous improvement mindset.

Key Responsibilities

• Design and develop ETL processes using Informatica PowerCenter, ensuring quality, performance, and reliability.
• Map and model data for Data Warehouses and Data Marts, including physical data modeling and transformation rules.
• Optimize ETL performance in complex scenarios and estimate database and file system resource needs.
• Manage code migrations across environments and coordinate both initial and incremental data loads.
• Review and monitor testing (unit, integration, UAT) to ensure accurate and validated results.
• Coordinate ETL activities in pre-production and production environments, ensuring stable operations.
• Ensure compliance with data governance standards, including metadata management, data quality controls, and documentation best practices.
• Collaborate with cross-functional teams (DBAs, architects, QA, business analysts) to refine requirements, resolve dependencies, and guarantee end-to-end data flow integrity.
• Participate in the design of ETL/ELT architectures and contribute to architectural decision-making.
• Perform formal code reviews (peer review) to ensure compliance with development standards.
• Identify areas of improvement within existing data pipelines and propose optimization strategies (continuous improvement).
• Lead incident resolution for critical ETL issues and perform Root Cause Analysis (RCA).
• Participate in project effort estimations and planning.
• Define development standards, coding guidelines, and best practices for the ETL team.
• Mentor Junior and Mid-Level developers, supporting their technical growth and development.

We are looking for a proactive and self-motivated individual with strong analytical and problem-solving skills, and a solid background in data integration technologies. The ideal candidate is someone who:

• Brings over five years of experience in ETL development and data integration.
• Applies strong software development and data engineering principles, with hands-on expertise in developing, maintaining, and optimizing ETL processes using Informatica PowerCenter.
• Has proven experience working with Oracle databases, including SQL development, data modeling, and performance tuning to support reliable data processing and business reporting.

Qualifications

• Bachelor’s degree in information technology or a related field. Proof of academic credentials and professional license number required.
• English proficiency at B2 or higher (required).
• 3+ years of programming experience with strong knowledge of Informatica Power Center.
• 3+ years of experience in ETL development, implementation, and performance optimization.
• 3+ years of experience in Business Intelligence projects, participating in full development lifecycle activities.
• Strong ability to understand functional requirements and conduct technical requirement gathering with clients.
• Proven experience in designing and implementing data models for Data Warehouses and Data Marts.
• Solid knowledge of relational databases and advanced proficiency in SQL.
• Advanced knowledge of UNIX, including shell scripting, log analysis, and job automation.
• Intermediate experience with Control-M for scheduling, monitoring, and managing ETL jobs.
• Strong organizational skills with the ability to prioritize tasks, work proactively, and collaborate effectively within a team environment.
• Experience designing ETL/ELT architectures and data integration frameworks.
• Advanced proficiency with Git and version control workflows (branching strategy, code versioning).
• Experience leading or coordinating small technical teams.
• Ability to interact directly with clients and stakeholders to gather requirements and present solutions.
• Strong negotiation and conflict-resolution skills in technical contexts.

Location

This position is based in Mexico City and primarily follows a remote work model, with occasional on-site meetings as needed for business purposes.

At Mirai Risk Tech, our people are our greatest asset. We offer flexibility, work-life balance, and a comprehensive benefits package designed to support your professional and personal growth.

• Work From Anywhere: Remote work on demand of each position.
• Events: on-site and on-line events to foster team bonding.
• Flexible Hours: Enjoy shorter workdays on Fridays.
• Career Growth: We offer multiple fast-paced career paths with annual performance reviews.
• Attractive benefit package.

Mirai offers equal opportunities and accepts application from all the sectors of the society, the company does not discriminate for race, religion, ethical origin, incapacity, age, nationality, marital status, sexual orientation, gender identity or any other motive protected by the current law.

Personal data will be processed by Mirai as responsible to evaluate the authenticity of the application for this position or other ones. You can see the policy in this link.