DNAFS_MFS - ETL Developer and Support - TL Mexico

hace 4 días

Monterrey, Nuevo León, México Infosys A tiempo completo
ETL Developer and Support Engineer (Ingeniero de Desarrollo y Soporte ETL)
Location: Mexico (Monterrey) – Hybrid as per Infosys Mexico policy (EST time)
Role Overview
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.

Key Responsibilities
  • 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.
  • Lead production support monitoring jobs, resolve incidents within SLAs, perform RCA, and communicate status with stakeholders/vendors.

Basic Qualifications
  • Bachelor's degree or foreign equivalent in Computer Science or related field.
  • 7+ years of IT experience.
  • Bilingual (Spanish & English) – strong verbal and written communication.

Mandatory 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.
  • 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.

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

Other Requirements
  • Ability to work under tight timelines and manage complex requirements.
  • Flexible to work extended hours if needed.
  • Self-motivated, proactive, and a strong team player.
About Us
Infosys 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.

  • Junior Web Developer

    hace 2 semanas

    Monterrey, Nuevo León, México The Wow Agency A tiempo completo

    Company DescriptionWe're a world-class marketing agency lookingRole DescriptionThis is a hybrid role for a Junior Web Developer. The Junior Web Developer will assist in building and maintaining websites, developing and testing both front-end and back-end systems, debugging and troubleshooting issues, optimizing web performance, and ensuring website...

  • Technical Support Engineer(Mexico)

    hace 2 días

    Monterrey, Nuevo León, México Mech-Mind Robotics A tiempo completo

    Job Description:1.Support the sales strategies and customer interaction of the outside sales team.2.Develop and implement processes between sales and solutions engineering.3.Coordinate and participate in technical demonstrations, presentations and proposals for customers and prospects .4.Provide technical expertise and support to the sales team and customers...

  • Salesforce Developer

    hace 1 semana

    Monterrey, Nuevo León, México GM Financial A tiempo completo

    Job DescriptionGM Financial International Operations conducts business in Latin America and China. International Operations offers a wide range of wholesale and retail automotive financing products to dealers and their customers. The strength of the international business lies in its ability to tailor its products to meet unique dealer needs, consumer...

  • Technical Support Engineer, Tier 2 and Partner Support

    hace 2 días

    Monterrey, Nuevo León, México JumpCloud A tiempo completo

    All roles at JumpCloud are Remote unless otherwise specified in the Job Description.About JumpCloudJumpCloud delivers a unified open directory platform that makes it easy to securely manage identities, devices, and access across your organization. With JumpCloud, IT teams and MSPs enable users to work securely from anywhere and manage their Windows, Apple,...

  • Senior ServiceNow Developer

    hace 2 días

    Monterrey, Nuevo León, México Hexagon Manufacturing Intelligence A tiempo completo

    Senior ServiceNow DeveloperJob DescriptionHexagon Manufacturing Intelligence (HMI)is seeking a seasonedSenior ServiceNow Developer, ideally certified as aServiceNow Implementation Specialist. The candidate should have substantial experience in deploying and managing ServiceNow modules in large organizations. The role entails developing and architecting...

  • Salesforce Developer

    hace 2 días

    Monterrey, Nuevo León, México Slalom A tiempo completo

    Who You'll Work WithIn our Salesforce business, we help our clients bring the most impactful customer experiences to life and we do that in a way that makes our clients the hero of their transformation story. We are passionate about and dedicated to building a diverse and inclusive team, recognizing that diverse team members who are celebrated for bringing...

  • Sr. ServiceNow Developer

    hace 2 días

    Monterrey, Nuevo León, México Peterson Technology Partners A tiempo completo

    Job DescriptionJob Description:We are seeking an experienced Sr ServiceNow Developer to support enterprise-level ServiceNow initiatives, with a focus on ITSM, HRSD, and platform integrations. The ideal candidate will have hands-on expertise in design, development, and implementation of ServiceNow modules, along with strong integration, automation, and...

  • Medical Scientific Liaison Oncology

    hace 2 días

    Monterrey, Nuevo León, México Bayer A tiempo completo

    Tasks And ResponsibilitiesResponsible for being catalyst of medical strategy by translating and sharing deep scientific and clinical insights from external stakeholders into strategic actions that shape and support the product squad outcomes in oncology, mainly in prostate cancer.MSL should be a key player in the customer squad close to the customer and...

  • Relationship Manager/Product Support Analyst

    hace 4 días

    Monterrey, Nuevo León, México Wimmer Solutions A tiempo completo

    We are looking for someone with strong analytical and BA skills, excellent communication and collaboration abilities, as well as documentation skills. Experience in support or operational project work is preferred. Must be willing to work 7am - 6pm Mexico Time Zone, 4 days a week.WHAT YOU GET TO DO:As an RM1, you will be a key technical contributor,...

  • Medical Scientific Liaison Oncology

    hace 2 días

    Monterrey, Nuevo León, México Bayer A tiempo completo

     Medical Scientific Liaison Oncology      TASKS AND RESPONSIBILITIESResponsible for being catalyst of medical strategy by translating and sharing deep scientific and clinical insights from external stakeholders into strategic actions that shape and support the product squad outcomes in oncology, mainly in prostate cancer.MSL should be a key player in...