AS400 (IBM i) Developer with Data Warehouse Experience- Open for C2C- 100% Remote

Summary: The role is for an AS400 (IBM i) Developer with extensive experience in application development and data warehousing. The position is fully remote and requires strong programming skills in RPG and SQL, along with expertise in ETL processes and data migration. Candidates should have a solid understanding of data warehouse architecture and the ability to develop scalable solutions based on business requirements.

Key Responsibilities:

• Develop and maintain AS400 (IBM i) applications.
• Implement and optimize ETL processes for data extraction, transformation, and loading.
• Collaborate on data warehouse architecture and dimensional modeling.
• Analyze business requirements to create scalable solutions.
• Perform troubleshooting and debugging of applications.
• Enhance database performance through SQL optimization and stored procedures.

Key Skills:

• 8+ years of experience in AS400 (IBM i) application development.
• Strong programming experience with RPG III, RPG IV, RPGLE, Free Format RPG, CL/CLLE.
• Hands-on experience with DB2/400 and advanced SQL development.
• Strong understanding of Data Warehouse architecture, dimensional modeling, and ETL processes.
• Experience with ETL tools such as Informatica, IBM DataStage, SSIS, Talend, or Azure Data Factory (ADF).
• Experience with data extraction, transformation, and loading (ETL) from AS400 to enterprise data warehouses.
• Knowledge of data migration, data integration, and performance tuning.
• Experience developing stored procedures, SQL optimization, and database performance improvements.
• Ability to analyze business requirements and develop scalable solutions.
• Strong troubleshooting and debugging skills.

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT