AS/400 Data Engineer: Cloud ETL & Data Modernization

TESTQ Technologies LTD.; Amsterdam; Hybrid; EUR 70,000 - 95,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

TESTQ Technologies LTD. in Amsterdam seeks a data engineering specialist with IBM i expertise to extract, transform, and load data. You will design ETL/ELT pipelines and integrate AS/400 data with cloud platforms, data warehouses, and BI tools.

You will optimize SQL and batch jobs, work with RPG/CL/COBOL as needed, ensure data quality and governance, and support migration initiatives across cloud environments.

Qualifications

• Experience designing and maintaining ETL/ELT pipelines.
• Proficient in integrating IBM i data with cloud platforms and warehouses.
• Ability to optimize SQL queries and batch jobs for performance.
• Knowledge of IBM i technologies such as RPG, CL, COBOL.
• Experience with data quality, security, and governance.
• Proficient in Python or Java programming.

Responsibilities

• Extract data from IBM i (AS/400) databases such as Db2 for i.
• Design and maintain ETL/ELT pipelines.
• Integrate AS/400 data with cloud platforms, data warehouses, and BI tools.
• Optimize SQL queries and batch jobs for performance.
• Work with RPG, CL, COBOL, or other IBM i technologies when needed.
• Ensure data quality, security, and governance.
• Support data migration and modernization initiatives.
• IBM i (AS/400) administration and architecture
• Db2 for i and SQL
• ETL tools such as Informatica PowerCenter or Talend
• Programming with Python or Java
• Knowledge of RPG, CL, or COBOL
• Cloud platforms such as Amazon Web Services , Microsoft Azure , or Google Cloud
• Data warehousing and API integration

Skills

Data integration

ETL/ELT pipelines

Cloud data platforms

SQL optimization

Python or Java

RPG/COBOL knowledge

Data governance

Data quality

IBM i administration

APIs and data warehousing

Tools

Informatica PowerCenter

Talend

Job description

TESTQ Technologies LTD. in Amsterdam seeks a data engineering specialist with IBM i expertise to extract, transform, and load data. You will design ETL/ELT pipelines and integrate AS/400 data with cloud platforms, data warehouses, and BI tools.

You will optimize SQL and batch jobs, work with RPG/CL/COBOL as needed, ensure data quality and governance, and support migration initiatives across cloud environments.