We are looking for a Senior Data Engineer with strong expertise in IBM DB2 and legacy data integration to design, develop, and maintain reliable data pipelines connecting enterprise applications, payroll systems, and modern cloud platforms.
The ideal candidate combines deep database knowledge, strong programming skills, and experience modernizing legacy data environments.
Design, develop, and maintain batch and event-driven data pipelines.
Optimize IBM DB2 queries, stored procedures, indexes, and data extraction processes.
Build integrations between DB2, enterprise applications, ERP systems, and AWS cloud services.
Implement ETL/ELT processes, data validation, reconciliation, and quality controls.
Monitor production pipelines, troubleshoot incidents, and ensure data reliability.
Design scalable data architectures and support legacy-to-cloud modernization.
Collaborate with engineering, architecture, product, and operations teams.
RequisitosRequired Qualifications
5+ years of professional Data Engineering experience.
Strong hands-on expertise in IBM DB2 (LUW and/or DB2 for i) — mandatory.
Proven experience extracting and integrating data from legacy DB2 environments.
Strong programming skills in Python and/or Java.
Advanced SQL, stored procedures, query optimization, and database performance tuning.
Experience designing, developing, and supporting production ETL/ELT pipelines.
Knowledge of data architecture, data modeling, data quality, and integration patterns.
Experience with production monitoring, troubleshooting, and root-cause analysis.
Advanced English proficiency (C1) for technical collaboration and architecture discussions.
Skills Required
- 5+ years of professional data engineering experience
- Strong hands-on expertise in IBM DB2 LUW and/or DB2 for i
- Experience extracting and integrating data from legacy DB2 environments
- Strong programming skills in Python and/or Java
- Advanced SQL, stored procedures, query optimization, and database performance tuning
- Experience designing, developing, and supporting production ETL/ELT pipelines
- Knowledge of data architecture, data modeling, data quality, and integration patterns
- Experience with production monitoring, troubleshooting, and root-cause analysis
- Advanced English proficiency at C1 level
What We Do
Softgic helps organizations pursue digital and cognitive transformation through innovative, customized technology solutions. Its services include software development, automation, cloud computing, cybersecurity, UX design, and related IT consulting. The company’s mission is to make life easier with technology and help clients transform digitally and cognitively, optimizing processes, reducing costs, and accelerating results for businesses across Latin America and the United States.
