SAS Data Integration Analyst - ETL & SQL Expert

Accenture Malaysia; Selangor; On-site; MYR 89,000 - 156,000; Full time

Job summary

Accenture Malaysia seeks a SAS System Analyst with 3–5 years of experience in data integration and analytics. The role focuses on ETL development using Informatica PowerCenter, working with Hadoop/Hive, Oracle SQL/PL/SQL, and Unix/Linux environments to support credit risk and financial risk projects.

You will design and optimize data integration solutions, develop mappings, and participate in DevOps‑related activities. Strong troubleshooting and batch processing skills are essential.

Qualifications

• 3–5 years of relevant experience in data integration, ETL development, or system analysis.
• Strong hands‑on experience with Informatica PowerCenter 10.x or above.
• Experience working with AIX and/or Solaris environments.
• Strong knowledge of Oracle SQL and PL/SQL.
• Working knowledge of Hadoop, Hive, Impala, and Beeline.
• Good knowledge of Shell Scripting.
• Experience with Control‑M scheduling and batch processing.
• Experience working with AS400 and Oracle source/target systems.
• Experience with Informatica Metadata Manager 10+.
• Understanding of software/development lifecycle methodologies.
• Basic to good understanding of DevOps practices and deployment processes.

Responsibilities

• Design, develop, test, and maintain ETL workflows using Informatica PowerCenter 10.x.
• Develop and maintain mappings, sessions, workflows, transformations, and related ETL components.
• Work with Hadoop ecosystem technologies, including Hive, Impala, and Beeline, for data processing and integration.
• Develop and optimize Oracle SQL and PL/SQL scripts, procedures, and queries.
• Work with AS400 and Oracle as source and target systems.
• Perform data extraction, transformation, loading, validation, and reconciliation activities.
• Work with Informatica Metadata Manager 10+ for metadata management and analysis.
• Develop and maintain Shell scripts for automation and operational activities.
• Schedule and monitor batch processes using Control‑M.
• Support ETL jobs and troubleshoot production issues in Linux/Unix environments.
• Follow the development lifecycle methodology and ensure successful delivery of assigned Informatica development activities.
• Participate in DevOps‑related activities, including deployment and release processes.
• Contribute to projects involving Credit Risk, Customer Scoring, Basel, and IFRS 9 requirements.

Skills

ETL development

Informatica PowerCenter

AIX/Solaris

Oracle SQL/PLSQL

Hadoop/Hive

Shell scripting

Control-M

AS400/Oracle sources

Informatica Metadata Manager

DevOps basics

Tools

Beeline

Unix/Linux

Informatica PowerCenter

Job description

Accenture Malaysia seeks a SAS System Analyst with 3–5 years of experience in data integration and analytics. The role focuses on ETL development using Informatica PowerCenter, working with Hadoop/Hive, Oracle SQL/PL/SQL, and Unix/Linux environments to support credit risk and financial risk projects.

You will design and optimize data integration solutions, develop mappings, and participate in DevOps‑related activities. Strong troubleshooting and batch processing skills are essential.