Informatica Power Center Developer - Senior

About the role

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 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 pri

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Mirai? Share your experience