Senior Informatica PowerCenter / ETL Engineer

TECHTIERA SDN. BHD.; Kuala Lumpur; On-site; MYR 120,000 - 180,000; Full time

Job summary

TechTiera Sdn. Bhd.

in Malaysia is seeking a Senior Informatica PowerCenter / ETL Engineer to design, develop and maintain high-volume ETL workflows in a production environment, ensuring data quality and reliability. Responsibilities include L3 production support, troubleshooting failures and performance issues, ETL tuning, working with Oracle databases (12c/19c), PL/SQL development, and coordinating with application, database and infrastructure teams to ensure smooth production deployments and

Qualifications

• Strong ETL experience with PowerCenter.
• Experience with high-load ETL processing.
• Experience in Linux/RHEL environments.
• Expertise in Oracle Database 12c/19c and PL/SQL.
• Ability to develop stored procedures and views.

Responsibilities

• Design, develop and maintain ETL workflows using Informatica PowerCenter
• Provide L3 production support for ETL applications
• Troubleshoot ETL failures and performance issues
• Perform ETL performance tuning and optimization
• Support high-volume/high-load ETL processing
• Analyse data processing issues and perform root-cause analysis
• Work with Oracle databases and troubleshoot database-related issues
• Develop and optimize PL/SQL procedures, views and related database objects
• Collaborate with application, database and infrastructure teams
• Support production deployments and incident resolution

Skills

ETL

Informatica PowerCenter

Production support

Performance tuning

Tools

Oracle Database

PL/SQL

RHEL/Linux

Job description

We are looking for a Senior Informatica PowerCenter / ETL Engineer to support and develop high-volume ETL solutions in a production environment.

Key responsibilities

Design, develop and maintain ETL workflows using Informatica PowerCenter

Provide L3 production support for ETL applications

Troubleshoot ETL failures and performance issues

Perform ETL performance tuning and optimization

Support high-volume/high-load ETL processing

Analyse data processing issues and perform root-cause analysis

Work with Oracle databases and troubleshoot database-related issues

Develop and optimize PL/SQL procedures, views and related database objects

Collaborate with application, database and infrastructure teams

Support production deployments and incident resolution

About you

Strong ETL experience

Experience with ETL performance tuning

Experience handling high-load/high-volume ETL

RHEL/Linux or equivalent

Oracle Database 12c/19c

Strong PL/SQL

Stored procedures

Views

TechTiera is a young and innovative information technology services company, with global presence. TechTiera is rightsized for providing maximum value to its customers for information technology services.

TechTiera works with an attitude of providing service with excellence. We are experts in providing IT solutions & professional staffing services. We work with an agile and innovative offshore development approach. Our far reaching contributions has helped us to establish ourselves as an ISO 9001:2015, ISO/IEC 27001:2013 certified company and SEI CMMI Level-3(V1.3-2015) company. Our vision is to excel and serve our clients with exceptional services and quality standards. The blend of industry-leading products, domain knowledge, project management skills and extensive experience has helped TechTiera deliver complete solutions that can help organizations improve quality of service while building customer loyalty and to keep them ahead of their competition.

TechTiera is currently calling the best brains in Content Management, OCR, NLP, Text Mining, Text Analytics, AI, ML, BigData, IoT and digital technologies at all levels. TechTiera provides the best environment for career growth.

TechTiera is a young and innovative information technology services company, with global presence. TechTiera is rightsized for providing maximum value to its customers for information technology services.

TechTiera works with an attitude of providing service with excellence. We are experts in providing IT solutions & professional staffing services. We work with an agile and innovative offshore development approach. Our far reaching contributions has helped us to establish ourselves as an ISO 9001:2015, ISO/IEC 27001:2013 certified company and SEI CMMI Level-3(V1.3-2015) company. Our vision is to excel and serve our clients with exceptional services and quality standards. The blend of industry-leading products, domain knowledge, project management skills and extensive experience has helped TechTiera deliver complete solutions that can help organizations improve quality of service while building customer loyalty and to keep them ahead of their competition.

TechTiera is currently calling the best brains in Content Management, OCR, NLP, Text Mining, Text Analytics, AI, ML, BigData, IoT and digital technologies at all levels. TechTiera provides the best environment for career growth.