AS400 Developer, Snowflake, ETL - Senior

Runtalent

Desenvolvedor AS400 desenvolvendo aplicações em ambiente AS400. Projetar e implementar processos ETL/ELT para migração de dados do ambiente AS400/BPCS para Snowflake.

Posted 7/17/2026full-timeRemote • 🇧🇷 BrazilSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in developing and maintaining applications in an AS400 (IBM i) environment, with a strong focus on data migration, ETL processes, and data modeling for analytics and reporting. Proficient in ensuring data quality and performance while supporting business analytics teams.

Highest-signal resume keywords

AS400 (IBM i) ExperienceRPGLE ProgrammingDB2/400 Query DevelopmentETL Process ImplementationData Migration Projects

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

AS400 (IBM i)RPGLEDB2/400ETLSQLData ModelingChange Data Capture (CDC)Data Warehouse StructuresData Quality AssuranceAnalytics Architecture

Tools & Technologies

BPCS/Infor LXSnowflake

Industry Keywords

ManufacturingSupply ChainERPData MigrationCloud Platforms

Tech Stack

Tools & technologies

ERPETLSQL

About the role

Key responsibilities & impact

Develop, maintain and enhance applications in an AS400 (IBM i) environment
Develop queries and routines using DB2/400
Maintain programs written in RPGLE and CL
Support the maintenance and evolution of the BPCS/Infor LX ERP
Design and implement ETL/ELT processes to migrate data from the AS400/BPCS environment to Snowflake
Develop extraction, transformation and loading (ETL) processes
Implement Change Data Capture (CDC) processes
Build, optimize and monitor data pipelines
Develop data models focused on analytics and reporting
Ensure data quality, integrity, performance and scalability
Develop high-performance SQL queries
Create and optimize Data Warehouse structures
Support business and Analytics teams in making data available for reports and analyses
Participate in data modeling and the evolution of the analytics architecture

Requirements

What you’ll need

Solid experience with AS400 (IBM i)
Plus: Experience with BPCS / Infor LX
Experience in environments such as Manufacturing, Supply Chain, ERP
Experience in data migration projects between legacy systems and cloud platforms
Knowledge of modern data architecture and analytical solutions

Benefits

Comp & perks

Remote work
Development using RPGLE
Development in CL (Control Language)
Experience with ETL/ELT processes
Knowledge of Change Data Capture (CDC)
Experience with Snowflake, including Streams, Tasks, Snowpipe, Stored Procedures
Advanced SQL skills
Data Modeling
Data Warehouse concepts and practices