Position Summary: Develop, maintain, and extract information from credit core databases and satellite systems, ensuring data integrity, availability, and quality, while actively participating in the migration to the new core. Key Highlights: 1. Key role in credit core migration (Sunnel to Prime/TSYS) 2. Focus on integrity and quality of credit data 3. Development and optimization of transactional databases **Further details during interview** **Department:** IT – Integrations / Credit Core Data **Location:** CDMX (Polanco) **Employment Type:** Full-time Position Objective Develop, maintain, and extract information from the **legacy credit core database (Sunnel)** and satellite systems, ensuring **integrity, availability, and quality** of data supporting portfolio operations (cards/credit). This role actively participates in the **migration to the new core (Prime/TSYS)**, generating queries, scripts, batch/ETL processes, and validations enabling daily operations and business decision-making. Main Responsibilities * Develop and execute **queries, scripts, and procedures** against the core database (extraction, cleansing, validation). * Support **batch processes** and data flows between systems (flat files, scheduled loads, reconciliations). * Participate in the **new core migration project**: mappings, validations, reconciliations, test support, and comparative analysis. * Prepare **reports and data analyses** for portfolio (balances, transactions, commissions, catalogs) supporting operations and business needs. * Document **data models**, procedures, information flows, and evidence (audit-ready traceability). * Cleanse and maintain **catalogs/parameters** (quality, consistency, change control). * Address production data incidents and coordinate corrections with IT Operations / Middleware / Business units. * Validate and reconcile information with internal/external systems, identifying discrepancies and root causes. * Optimize queries and procedures to improve performance (basic tuning). Essential Requirements * **2+ years** of database development and/or administration experience in transactional environments (financial/credit preferred). * **Advanced SQL** (complex queries, stored procedures, triggers, optimization). * Experience with **batch processes**, generation/consumption of **flat files** (CSV/XML/JSON), and **ETL/ELT** workflows. * Ability to read and interpret **relational data models**, including handling referential integrity. * Familiarity with typical credit core data structures (accounts, lines, products, catalogs) is desirable. * Collaborative work with **middleware, operations, and business teams** (tracking, evidence, resolution). Key Tools and Knowledge (Highly Important) * Database Engines: **SQL Server / Oracle / PostgreSQL** (at least one at an advanced level). * ETL/ELT: **SSIS / Informatica / Talend** (or equivalents). * Scripting/Analytics (desirable): **Python or R** for validations and analysis. * BI (desirable): **Power BI / Tableau** for consumption/validation. * Version Control: **Git**. * Basic understanding of **REST/SOAP APIs** (to comprehend integrations with platforms such as MuleSoft). * Data quality best practices and awareness of security/compliance standards (e.g., PCI-DSS as reference). Employment Type: Full-time Salary: $50,000.00 - $55,000.00 per month Work Location: On-site employment