Lead Data Engineer

Pride Global; Campinas; On-site; BRL 180,000 - 270,000; Full time

Job summary

Pride Global is seeking an experienced Data Engineer to design, develop, and maintain large-scale Data Warehouse environments with hands-on work on ETL pipelines, stored procedures, triggers, and MQTs. The role emphasizes robust data processing, optimization, and collaboration in a fast-paced setting.

The candidate should bring 5+ years with Informatica PowerCenter and IBM DB2, strong SQL/PL-SQL, data modeling, and warehousing expertise, paired with excellent English communication and teamwork

Qualifications

• 5+ years of experience with Informatica PowerCenter, developing complex ETL processes
• 5+ years of experience with IBM DB2
• 5+ years of advanced SQL / PL-SQL
• Hands-on experience developing DB2 stored procedures, triggers, MQTs, and views
• Experience with DB2 performance tuning and query optimization
• Strong experience with Data Warehousing and Data Modeling
• Experience working with large data volumes and complex data environments
• Bachelor's degree in Computer Science, IT, or a related field
• Strong English communication and collaboration skills

Skills

SQL/PL-SQL

ETL development

Data warehousing

Data modeling

English communication

Team collaboration

Education

Bachelor's degree in Computer Science, IT, or related field

Tools

Informatica PowerCenter

IBM DB2

DB2 stored procedures/triggers/MQTs/views

SQL optimization

Job description

Pride Global is looking for an experienced Data Engineer with strong expertise in IBM DB2 and Informatica PowerCenter.

This is a hands-on role focused on developing and maintaining complex ETL processes, stored procedures, triggers, MQTs, and views within large-scale Data Warehouse environments.

Must-Have Requirements

• 5+ years of experience with Informatica PowerCenter, developing complex ETL processes
• 5+ years of experience with IBM DB2
• 5+ years of advanced SQL / PL-SQL
• Hands-on experience developing DB2 stored procedures, triggers, MQTs, and views
• Experience with DB2 performance tuning and query optimization
• Strong experience with Data Warehousing and Data Modeling
• Experience working with large data volumes and complex data environments
• Bachelor's degree in Computer Science, IT, or a related field
• Strong English communication and collaboration skills

Nice to Have

• Python or Perl
• Data Lake / Dataverse
• Power BI
• Data Governance / Data Quality

Important: This role requires hands-on experience with both Informatica PowerCenter and IBM DB2. Candidates without professional experience in these technologies will not be considered.