ETL / Informatica IICS Developer (Oracle PL/SQL)

Ariston Services

Kuala Lumpur

On-site

MYR 60,000 - 120,000

Full time

15 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ariston Services is seeking an experienced ETL/IICS Developer with hands-on data integration expertise, especially Informatica IICS and PL/SQL. The role focuses on designing, developing, testing and supporting ETL solutions and database-driven integrations.

You will design and maintain mappings, workflows, and data integration processes, optimize SQL/PLSQL queries, and ensure reliable data movement across systems. Strong analytical skills and SDLC experience are essential.

Qualifications

  • 3+ years of relevant ETL experience.
  • Hands-on Informatica IICS / Cloud Data Integration.
  • Strong SQL and PL/SQL development skills.
  • Experience with relational databases, preferably Oracle.
  • Experience in ETL performance tuning and troubleshooting.
  • Good understanding of data warehousing and data integration concepts.
  • Experience across the software development lifecycle.
  • Good analytical and problem-solving skills.

Responsibilities

  • Design, develop and maintain ETL/data integration solutions using Informatica IICS.
  • Develop and maintain mappings, workflows/taskflows and data integration processes.
  • Develop complex SQL and PL/SQL queries, procedures, functions and packages.
  • Integrate data across databases, applications, files and other source/target systems.
  • Perform data analysis, transformation, validation and reconciliation.
  • Troubleshoot ETL failures, data issues and database-related problems.
  • Perform performance tuning and optimisation of ETL jobs and database queries.
  • Conduct unit testing and support SIT/UAT and production deployments.
  • Monitor production data integrations and resolve incidents and defects.
  • Produce and maintain relevant technical documentation.

Skills

Informatica IICS
SQL
PL/SQL
Relational databases
ETL
Data warehousing concepts
SDLC
Analytical skills

Tools

Informatica PowerCenter

Job description

We are looking for an experienced ETL / IICS Developer with strong hands-on experience in data integration, Informatica IICS, PL/SQL and relational databases.

The role will be responsible for designing, developing, testing and supporting ETL/data integration solutions, with particular emphasis on Informatica IICS and database-driven integrations.

Key Responsibilities
  • Design, develop and maintain ETL/data integration solutions using Informatica IICS.
  • Develop and maintain mappings, workflows/taskflows and data integration processes.
  • Develop complex SQL and PL/SQL queries, procedures, functions and packages.
  • Integrate data across databases, applications, files and other source/target systems.
  • Perform data analysis, transformation, validation and reconciliation.
  • Troubleshoot ETL failures, data issues and database-related problems.
  • Perform performance tuning and optimisation of ETL jobs and database queries.
  • Conduct unit testing and support SIT/UAT and production deployments.
  • Monitor production data integrations and resolve incidents and defects.
  • Produce and maintain relevant technical documentation.
Required Experience
  • 3+ yrs of relevant experience
  • Strong hands-on Informatica IICS / Cloud Data Integration experience.
  • Strong SQL and PL/SQL development skills.
  • Strong experience working with relational databases, preferably Oracle.
  • Experience in ETL performance tuning and troubleshooting.
  • Good understanding of data warehousing and data integration concepts.
  • Experience working across the software development lifecycle.
  • Good analytical and problem-solving skills.
Preferred
  • Experience with Informatica PowerCenter in addition to IICS.
  • Experience with enterprise-scale data integration environments.
  • Experience with CI/CD and automated deployment of data integration components.
  • Experience working in Agile delivery environments.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL/IICS Developer | Data Integration & SQL Expert
ETL/IICS Developer | Data Integration & SQL Expert

Ariston Services • Kuala Lumpur

On-site
MYR 60,000 - 120,000
IICs Support Operator
IICs Support Operator

Seargin Ltd • Kuala Lumpur

On-site
MYR 90,000 - 130,000
MultiSport
Private Medical Care
Developer (Informatica ETL)
Developer (Informatica ETL)

GienTech • Kuala Lumpur

On-site
MYR 90,000 - 130,000
ETL Developer
ETL Developer

Two95 International Inc. • Kuala Lumpur

On-site
MYR 70,000 - 120,000
EDW Developer (Teradata / Informatica)
EDW Developer (Teradata / Informatica)

Unison Group • Kuala Lumpur

On-site
MYR 120,000 - 180,000
EDW Developer (Teradata / Informatica)
EDW Developer (Teradata / Informatica)

Hong Kong Unison Limited • Kuala Lumpur

On-site
MYR 90,000 - 150,000
IICS Integration Support & Migration Specialist
IICS Integration Support & Migration Specialist

Seargin Ltd • Kuala Lumpur

On-site
MYR 90,000 - 130,000
MultiSport
Private Medical Care
Informatica Developer
Informatica Developer

Luxoft • Kuala Lumpur

On-site
MYR 90,000 - 120,000
Informatica PowerCenter Developer (ETL development)
Informatica PowerCenter Developer (ETL development)

Luxoft • Kuala Lumpur

On-site
MYR 60,000 - 120,000
Informatica PowerCenter ETL Developer
Informatica PowerCenter ETL Developer

Luxoft • Kuala Lumpur

On-site
MYR 60,000 - 120,000