ETL Developer and Support Engineer

ETL Developer and Support Engineer (Ingeniero de Desarrollo y Soporte ETL)Location: Mexico (Monterrey, Mexico City, Guadalajara) – Hybrid as per Infosys Mexico policy (EST time)

ETL Developer and Support Engineer (Ingeniero de Desarrollo y Soporte ETL)ETL Developer and Support Engineer (Ingeniero de Desarrollo y Soporte ETL)ETL Developer and Support Engineer (Ingeniero de Desarrollo y Soporte ETL)ETL Developer and Support Engineer (Ingeniero de Desarrollo y Soporte ETL)Location: Mexico (Monterrey, Mexico City, Guadalajara) – Hybrid as per Infosys Mexico policy (EST time)Location: Mexico (Monterrey, Mexico City, Guadalajara) – Hybrid as per Infosys Mexico policy (EST time)Location:Location:Mexico (Monterrey, Mexico City, Guadalajara) – Hybrid as per Infosys Mexico policy (EST time)Role OverviewRole OverviewRole OverviewRole OverviewAs an ETL Developer and Support Engineer, you will design and develop ETL solutions using Informatica and SQL, ensuring data accuracy and performance. Manage deployments and provide production support, including monitoring, incident resolution, and root cause analysis, while meeting SLAs and collaborating with stakeholders.As an ETL Developer and Support Engineer, you will design and develop ETL solutions using Informatica and SQL, ensuring data accuracy and performance. Manage deployments and provide production support, including monitoring, incident resolution, and root cause analysis, while meeting SLAs and collaborating with stakeholders.As an ETL Developer and Support Engineer, you will design and develop ETL solutions using Informatica and SQL, ensuring data accuracy and performance. Manage deployments and provide production support, including monitoring, incident resolution, and root cause analysis, while meeting SLAs and collaborating with stakeholders.ETL Developer and Support EngineerKey ResponsibilitiesKey ResponsibilitiesKey ResponsibilitiesKey Responsibilities

• Design, build, and optimize ETL pipelines in Informatica (including CDC/SCD) with robust SQL and performance tuning.

Design, build, and optimize ETL pipelines in Informatica (including CDC/SCD) with robust SQL and performance tuning.Design, build, and optimize ETL pipelines in Informatica (including CDC/SCD) with robust SQL and performance tuning.Design, build, and optimize ETL pipelines in Informatica (including CDC/SCD) with robust SQL and performance tuning.Design, build, and optimize ETL pipelines in Informatica (including CDC/SCD) with robust SQL and performance tuning.

• Ensure data quality and reliability through thorough requirements, profiling, validation, and controlled deployments across environments.

Ensure data quality and reliability through thorough requirements, profiling, validation, and controlled deployments across environments.Ensure data quality and reliability through thorough requirements, profiling, validation, and controlled deployments across environments.Ensure data quality and reliability through thorough requirements, profiling, validation, and controlled deployments across environments.Ensure data quality and reliability through thorough requirements, profiling, validation, and controlled deployments across environments.

• Lead production support monitoring jobs, resolve incidents within SLAs, perform RCA, and communicate status with stakeholders/vendors.

Lead production support monitoring jobs, resolve incidents within SLAs, perform RCA, and communicate status with stakeholders/vendors.Lead production support monitoring jobs, resolve incidents within SLAs, perform RCA, and communicate status with stakeholders/vendors.Lead production support monitoring jobs, resolve incidents within SLAs, perform RCA, and communicate status with stakeholders/vendors.Lead production support monitoring jobs, resolve incidents within SLAs, perform RCA, and communicate status with stakeholders/vendors.Basic QualificationsBasic QualificationsBasic QualificationsBasic Qualifications

• Bachelor’s degree or foreign equivalent in Computer Science or related field.

Bachelor’s degree or foreign equivalent in Computer Science or related field.Bachelor’s degree or foreign equivalent in Computer Science or related field.Bachelor’s degree or foreign equivalent in Computer Science or related field.Bachelor’s degree or foreign equivalent in Computer Science or related field.

• 6+ years of IT experience.

6+ years of IT experience.6+ years of IT experience.6+ years of IT experience.6+ years of IT experience6+ years of IT experience.

• Bilingual (Spanish & English) – strong verbal and written communication.

Bilingual (Spanish & English) – strong verbal and written communication.Bilingual (Spanish & English) – strong verbal and written communication.Bilingual (Spanish & English) – strong verbal and written communication.Bilingual (Spanish & English)Bilingual (Spanish & English)– strong verbal and written communication.Mandatory SkillsMandatory SkillsMandatory SkillsMandatory Skills

• Development:At least 6 years of IT experience in business analysis, requirement elicitation and documentation while working on Informatica PowerCenter 9.x, 10.x.Understanding the change data capture (CDC), slowly changing dimensions (SCD), Data Profiling and Data validation concepts.Experience in estimating ETL requirements, designing and architecting integration solutions.Tracking issues and requirements using Jira or a similar tool. Good knowledge in designing and developing ETL mappings using Informatica PowerCenter.Efficient in coding and understanding the deliverables.Knowledge in performance tuning and optimization.Build advanced stored procedures or queries using PL/SQL and Transact SQL.Understanding configuration, migration and deployment of ETL mappings.

Development:Development:Development:DevelopmentDevelopment:

• At least 6 years of IT experience in business analysis, requirement elicitation and documentation while working on Informatica PowerCenter 9.x, 10.x.

At least 6 years of IT experience in business analysis, requirement elicitation and documentation while working on Informatica PowerCenter 9.x, 10.x.At least 6 years of IT experience in business analysis, requirement elicitation and documentation while working on Informatica PowerCenter 9.x, 10.x.At least 6 years of IT experience in business analysis, requirement elicitation and documentation while working on Informatica PowerCenter 9.x, 10.x.At least 6 years of IT experience in business analysis, requirement elicitation and documentation while working on Informatica PowerCenter 9.x, 10.x.

• Understanding the change data capture (CDC), slowly changing dimensions (SCD), Data Profiling and Data validation concepts.

Understanding the change data capture (CDC), slowly changing dimensions (SCD), Data Profiling and Data validation concepts.Understanding the change data capture (CDC), slowly changing dimensions (SCD), Data Profiling and Data validation concepts.Understanding the change data capture (CDC), slowly changing dimensions (SCD), Data Profiling and Data validation concepts.Understanding the change data capture (CDC), slowly changing dimensions (SCD), Data Profiling and Data validation concepts.

• Experience in estimating ETL requirements, designing and architecting integration solutions.

Experience in estimating ETL requirements, designing and architecting integration solutions.Experience in estimating ETL requirements, designing and architecting integration solutions.Experience in estimating ETL requirements, designing and architecting integration solutions.Experience in estimating ETL requirements, designing and architecting integration solutions.

• Tracking issues and requirements using Jira or a similar tool.

Tracking issues and requirements using Jira or a similar tool.Tracking issues and requirements using Jira or a similar tool.Tracking issues and requirements using Jira or a similar tool.Tracking issues and requirements using Jira or a similar tool.

• Good knowledge in designing and developing ETL mappings using Informatica PowerCenter.

Good knowledge in designing and developing ETL mappings using Informatica PowerCenter.Good knowledge in designing and developing ETL mappings using Informatica PowerCenter.Good knowledge in designing and developing ETL mappings using Informatica PowerCenter.Good knowledge in designing and developing ETL mappings using Informatica PowerCenter.

• Efficient in coding and understanding the deliverables.

Efficient in coding and understanding the deliverables.Efficient in coding and understanding the deliverables.Efficient in coding and understanding the deliverables.Efficient in coding and understanding the deliverables.

• Knowledge in performance tuning and optimization.

Knowledge in performance tuning and optimization.Knowledge in performance tuning and optimization.Knowledge in performance tuning and optimization.Knowledge in performance tuning and optimization.

• Build advanced stored procedures or queries using PL/SQL and Transact SQL.

Build advanced stored procedures or queries using PL/SQL and Transact SQL.Build advanced stored procedures or queries using PL/SQL and Transact SQL.Build advanced stored procedures or queries using PL/SQL and Transact SQL.Build advanced stored procedures or queries using PL/SQL and Transact SQL.

• Understanding configuration, migration and deployment of ETL mappings.

Understanding configuration, migration and deployment of ETL mappings.Understanding configuration, migration and deployment of ETL mappings.Understanding configuration, migration and deployment of ETL mappings.Understanding configuration, migration and deployment of ETL mappings.

• Production Support:At least 2 years of production support experience.Production Support Lead for a BI project using Informatica / PL-SQL / AUTOSYS.Maintain and own bug management and incident resolution process.Resolve bugs within defined service levels.Debug, troubleshoot, root cause analysis and resolve issues within SLA.Monitoring processes using any Job Orchestration Tool like (CA Workload Automation, HCL Workload Automation or Control-M).Communicate with stakeholders in case of delays or SLA breaches.Use of IT Service Management tools for incident management, change management or request fulfillment tracking like HP Service Management, BMC Helix, ServiceNow.Resolve complex bugs with long term fixes following BI best practices and collaborate with BI team for solution review of complex bugs and incident resolution.Follow up with third party vendors for issue resolution and prevention.

Production Support:Production Support:Production Support:Production Support:

• At least 2 years of production support experience.

At least 2 years of production support experience.At least 2 years of production support experience.At least 2 years of production support experience.At least 2 years of production support experience.

• Production Support Lead for a BI project using Informatica / PL-SQL / AUTOSYS.

Production Support Lead for a BI project using Informatica / PL-SQL / AUTOSYS.Production Support Lead for a BI project using Informatica / PL-SQL / AUTOSYS.Production Support Lead for a BI project using Informatica / PL-SQL / AUTOSYS.Production Support Lead for a BI project using Informatica / PL-SQL / AUTOSYS.

• Maintain and own bug management and incident resolution process.

Maintain and own bug management and incident resolution process.Maintain and own bug management and incident resolution process.Maintain and own bug management and incident resolution process.Maintain and own bug management and incident resolution process.

• Resolve bugs within defined service levels.

Resolve bugs within defined service levels.Resolve bugs within defined service levels.Resolve bugs within defined service levels.Resolve bugs within defined service levels.

• Debug, troubleshoot, root cause analysis and resolve issues within SLA.

Debug, troubleshoot, root cause analysis and resolve issues within SLA.Debug, troubleshoot, root cause analysis and resolve issues within SLA.Debug, troubleshoot, root cause analysis and resolve issues within SLA.Debug, troubleshoot, root cause analysis and resolve issues within SLA.

• Monitoring processes using any Job Orchestration Tool like (CA Workload Automation, HCL Workload Automation or Control-M).

Monitoring processes using any Job Orchestration Tool like (CA Workload Automation, HCL Workload Automation or Control-M).Monitoring processes using any Job Orchestration Tool like (CA Workload Automation, HCL Workload Automation or Control-M).Monitoring processes using any Job Orchestration Tool like (CA Workload Automation, HCL Workload Automation or Control-M).Monitoring processes using any Job Orchestration Tool like (CA Workload Automation, HCL Workload Automation or Control-M).

• Communicate with stakeholders in case of delays or SLA breaches.

Communicate with stakeholders in case of delays or SLA breaches.Communicate with stakeholders in case of delays or SLA breaches.Communicate with stakeholders in case of delays or SLA breaches.Communicate with stakeholders in case of delays or SLA breaches.

• Use of IT Service Management tools for incident management, change management or request fulfillment tracking like HP Service Management, BMC Helix, ServiceNow.

Use of IT Service Management tools for incident management, change management or request fulfillment tracking like HP Service Management, BMC Helix, ServiceNow.Use of IT Service Management tools for incident management, change management or request fulfillment tracking like HP Service Management, BMC Helix, ServiceNow.Use of IT Service Management tools for incident management, change management or request fulfillment tracking like HP Service Management, BMC Helix, ServiceNow.Use of IT Service Management tools for incident management, change management or request fulfillment tracking like HP Service Management, BMC Helix, ServiceNow.

• Resolve complex bugs with long term fixes following BI best practices and collaborate with BI team for solution review of complex bugs and incident resolution.

Resolve complex bugs with long term fixes following BI best practices and collaborate with BI team for solution review of complex bugs and incident resolution.Resolve complex bugs with long term fixes following BI best practices and collaborate with BI team for solution review of complex bugs and incident resolution.Resolve complex bugs with long term fixes following BI best practices and collaborate with BI team for solution review of complex bugs and incident resolution.Resolve complex bugs with long term fixes following BI best practices and collaborate with BI team for solution review of complex bugs and incident resolution.

• Follow up with third party vendors for issue resolution and prevention.

Follow up with third party vendors for issue resolution and prevention.Follow up with third party vendors for issue resolution and prevention.Follow up with third party vendors for issue resolution and prevention.Follow up with third party vendors for issue resolution and prevention.Preferred SkillsPreferred SkillsPreferred SkillsPreferred Skills

• Strong problem-solving, leadership, and stakeholder management skills.

Strong problem-solving, leadership, and stakeholder management skills.Strong problem-solving, leadership, and stakeholder management skills.Strong problem-solving, leadership, and stakeholder management skills.Strong problem-solving, leadership, and stakeholder management skills.Other RequirementsOther RequirementsOther RequirementsOther Requirements

• Ability to work under tight timelines and manage complex requirements.

Ability to work under tight timelines and manage complex requirements.Ability to work under tight timelines and manage complex requirements.Ability to work under tight timelines and manage complex requirements.Ability to work under tight timelines and manage complex requirements.

• Flexible to work extended hours if needed.

Flexible to work extended hours if needed.Flexible to work extended hours if needed.Flexible to work extended hours if needed.Flexible to work extended hours if needed.

• Self-motivated, proactive, and a strong team player.

Self-motivated, proactive, and a strong team player.Self-motivated, proactive, and a strong team player.Self-motivated, proactive, and a strong team player.Self-motivated, proactive, and a strong team player.

About UsInfosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.EEO Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability. Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.

About UsEEO Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability. Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.