Job Title: DB2 – Data Engineer / Python
Location: Houston, TX – Hybrid (3 Days Onsite)
Interview: In-Person (F2F)
TOP MUST-HAVE SKILLS:
- Expert-level DB2 / IBM iSeries SQL Stored Procedures – MUST HAVE
- Strong hands-on Python Services experience
- Oracle Database & Data Pipelines
- RPG to SQL Stored Procedure Conversion / Modernization
- Advanced SQL Development & Performance Tuning
- IBM iSeries / AS400 Development
Required Skills:
- Hands-on expertise in IBM DB2 development on IBM iSeries/DB2 for i, including DB2 SQL, stored procedures, database design, and performance tuning
- Expert-level SQL Stored Procedures development on DB2 IBM iSeries – (MUST HAVE)
- Candidates with only embedded SQL and RPG experience will not be considered.
- Experience with Dynamic SQL, SQL Stored Procedures, performance tuning, logging, and exception handling.
- Strong experience with RPG IV, RPGLE, RPG Free, and embedded SQL.
- Hands-on experience with RPG-to-SQL Stored Procedure conversion/modernization.
- Strong Python services development experience.
- Experience with Oracle Database and data pipelines.
- Experience working with SQL cursors.
- Experience developing applications using REST APIs and JSON.
- Exposure to Python, microservices, and VS Code.
- Experience with Git/source control and integration.
- Familiarity with IBM i tools such as Aldon, RDi, and ACS.
Key Responsibilities:
- Develop, maintain, and modernize DB2 applications on the IBM iSeries platform.
- Convert legacy RPG programs into SQL Stored Procedures.
- Develop and optimize complex SQL procedures and database solutions.
- Build and support Python services and data pipelines.
- Integrate backend applications with REST APIs and front-end systems.
- Troubleshoot performance, logging, and exception-handling issues.
