ETL Developer and Support Engineer

Infosys

2.7

(23)

Monterrey, Mexico

Why you should apply for a job to Infosys:

4.2/5 in supportive management

57% say women are treated fairly and equally to men

Ratings are based on anonymous reviews by Fairygodboss members.

Our STEM education and maker movement programs enable you to support a more equitable digital society

At Infosys, our D&I charter draws inspiration from our values and is contained in the first tenet of our Code of Conduct and Ethics.

At Infosys, we nurture that spirit with technology that can inspire you to not just ask ‘what next’, but actually help you to build it.

#144076BR

Position summary

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.