SAS Data Integration & ETL Analyst

7802 Accent.Tech.Solut.Sdn Bhd Company; Petaling Jaya; On-site; MYR 90,000 - 150,000; Full time

Job summary

Accenture PLC is seeking a SAS System Analyst with 3–5 years of data integration and analytics experience. The ideal candidate will work with Informatica PowerCenter 10.x, Hadoop/Hive, Oracle SQL/PLSQL, and Unix/Linux environments to develop, maintain, and support data integration solutions for credit risk and financial risk projects.

The role involves designing ETL workflows, optimizing SQL scripts, and collaborating across DevOps and BI teams.

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 with Hadoop, Hive, Impala, Beeline, and related ecosystems.
• Solid knowledge of Oracle SQL and PL/SQL.
• Experience with UNIX/Linux environments and basic shell scripting.

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 for data processing and integration.
• Develop and optimize Oracle SQL and PL/SQL scripts, procedures, and queries.
• Work with AS400 and Oracle sources/targets.
• Perform data extraction, transformation, loading, validation, and reconciliation.
• Develop and maintain Shell scripts for automation and operations.
• Schedule and monitor batch processes using Control‑M.
• Support ETL jobs and troubleshoot production issues in Linux/Unix environments.
• Follow the development lifecycle and contribute to Informatica development tasks.
• Participate in DevOps activities including deployment and release processes.
• Contribute to projects involving Credit Risk, Customer Scoring, Basel, and IFRS 9 requirements.

Skills

Informatica PowerCenter 10.x

Hadoop/Hive/Beeline

Oracle SQL/PLSQL

Shell scripting

Control‑M

AS400/Oracle sources

Informatica Metadata Manager 10+

Tools

Informatica PowerCenter 10.x

Hadoop/Hive/Beeline

Oracle SQL/PLSQL

Shell scripting

Control‑M

Job description

Accenture PLC is seeking a SAS System Analyst with 3–5 years of data integration and analytics experience. The ideal candidate will work with Informatica PowerCenter 10.x, Hadoop/Hive, Oracle SQL/PLSQL, and Unix/Linux environments to develop, maintain, and support data integration solutions for credit risk and financial risk projects.

The role involves designing ETL workflows, optimizing SQL scripts, and collaborating across DevOps and BI teams.