Business Intelligence Advisor

NTT DATA North America; Región Centro; Presencial; MXN 500.000 - 800.000; Jornada completa

Descripción de la vacante

NTT DATA seeks a Business Intelligence Advisor in Guadalajara, Jalisco to lead data integration efforts across cloud environments and on-prem systems. You will design BI solutions, support complex ETL/ELT pipelines, and collaborate with cross-functional teams.

The role requires strong UNIX/Linux skills, experience with IICS/CDI, and proficiency in SQL and multiple RDBMS. You will mentor staff and drive automation to improve platform resiliency and performance.

Formación

• 4+ years with Informatica Cloud (IICS), Power Center, UC4 and related support activities.
• 3+ years analyzing, doing RCA, and fixing production bugs/enhancements.
• Experience upgrading Informatica software across non-prod, pre-prod, and prod environments.
• Experience in setting up alerts and monitoring.
• Experience in managing outages during migration, patching, and deployments.
• Strong UNIX/Linux commands proficiency.
• Hands-on experience in cloud-native environment with high-volume data integrations.
• Experience in multiple Cloud environments (AWS, Azure, GCP, Oracle).
• Experience using connectors including HTTP, Salesforce, AWS, Azure, Oracle DB, and File/FTP.
• Ability to provide effort estimates for technical solutions.
• BI design of complex systems projects.
• 2+ years in Informatica Cloud Data Integration (IICS CDI).
• 5-6 years IT experience in Data Management / ETL / ELT / Data Warehousing.
• Experience integrating multiple sources into a centralized data platform or EDW.
• 3+ years work with RDBMS (SQL Server, Azure SQL DB, Oracle).
• Experience writing SQL stored procedures and shell scripts.

Responsabilidades

• Provide L1 (Monitoring), L1.5 (Basic Dev & incident management) and L2 (Complex Incident Management) support.
• Create and test simple/complex mapping tasks and task flows; debug issues and optimize performance.
• Continuously optimize platform to improve resiliency, uptime, and vulnerability remediation within SLA.
• Own the technical support team from triage to escalation for integrations and data pipelines.
• Investigate and troubleshoot data platform components from integrations to data warehousing.
• Innovate support capabilities by driving automation and best practices.
• Collaborate with cross-functional teams to troubleshoot issues.
• Monitor systems and incidents to ensure timely resolution and minimal downtime.
• Prepare operation support documentation and SOPs for support.
• Coordinate with network and database teams for production issue resolution.
• Mentor associates and mid-level developers; provide limited mentorship to seniors.

Conocimientos

Communication skills

Problem solving

Team collaboration

Herramientas

IICS

PowerCenter

UC4

UNIX/Linux

AWS

Azure

GCP

Oracle DB

SQL

REST APIs

Descripción del empleo

Req ID: 386067

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization,

We are currently seeking a Business Intelligence Advisor to join our team in Guadalajara, Jalisco (MX-JAL), Mexico (MX).

Qualifications

• 4+ years of experience with Informatica Cloud (IICS), Power Center, UC4 system and its related support activities.
• 3+ years of experience with analyzing, doing RCA, and fixing production bugs/enhancements.
• Experience helping with Informatica software upgrades across non-prod, pre-prod, and prod environments.
• Experience in setting up alerts and monitoring.
• Experience in managing outages during migration, patching, and deployments.
• Strong in UNIX/Linux commands.
• Hands-on experience working in a complex, cloud-native environment with high-volume, real-time/near-real-time data integrations.
• Experience working in multiple Cloud environments (AWS, Azure, GCP, Oracle, etc.).
• Experience using connectors including HTTP, Salesforce, AWS, Azure, Oracle DB, and File/FTP.
• The candidate must also have experience providing level of effort estimates for technical portion of solutions.
• Business intelligence design of complex systems projects.
• 2+ Experience developing integrations using Informatica Cloud Data Integration (IICS CDI Service).
• 5 - 6 years of prior IT experience in Data Management / ETL / ELT / Data Warehousing.
• Proven experience with Data Management & Integration.
• Experience establishing automation of UNIX/Linux operational tasks, repository backups, SSO integration, setting up SSL certificates, establishing and enforcing system security and role-based access.
• Experience in integrating multiple sources into a centralized data platform or Enterprise Data Warehouse.
• 3+ years of in-depth experience working with a wide variety of RDBMS (SQL Server, Azure SQL DB, Oracle etc.).
• Experience in writing stored procedures, secure coding with safeguards against SQL injection attacks [Optional].
• Experience working with structured and semi-structured data.
• Strong written and verbal communication skills.
• Knowledge of data modeling principles.
• Knowledge and experience in writing SQL stored procedures.
• Knowledge and experience in writing shell scripts.
• Passionate about complex data structures and problem solving.

Responsibilities

• Provide L1 (Monitoring), L1.5 (Basic Dev & incident management) support, L2 (Complex Incident Management).
• Create and test simple/complex mapping tasks and task flows, debug issues and implement performance optimization techniques.
• Continuous platform optimizations to improve resiliency, up-time, and resolution of vulnerabilities within SLA.
• Own the technical support team from triage, response, team coordination, and escalation in relation to application integrations, data hub/data warehousing, and ELT/ETL processes.
• Investigate and troubleshoot various levels of the data platform from integrations, storage, security, networking, to data warehousing and data pipelines (ETL/ELT).
• Innovate and modernize the support capabilities through identification of process and technology improvements with a focus on driving adoption of automation and best practices.
• Collaborate with cross-functional teams to troubleshoot and resolve issues.
• Monitor systems and incidents, ensuring timely resolution and minimal downtime.
• Prepare operation support documentation and SOPs for support.
• Work closely with network and database teams to ensure seamless integration and performance in case of production issues.
• Provides mentorship to associate and mid-level developers; provides limited mentorship to other senior developers in their technical area(s) of expertise.
• Stay updated on security vulnerabilities and implement necessary measures.
• Ready (willing) to learn different tools and platforms.

About NTT DATA

NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers and application services. our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50 countries. We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D.

Whenever possible, we hire locally to NTT DATA offices or client sites. This ensures we can provide timely and effective support tailored to each client’s needs. While many positions offer remote or hybrid work options, these arrangements are subject to change based on client requirements. For employees near an NTT DATA office or client site, in-office attendance may be required for meetings or events, depending on business needs. At NTT DATA, we are committed to staying flexible and meeting the evolving needs of both our clients and employees.

NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.