Data Engineer IBM Db2

Job Title: Data Engineer – IBM Db2

Number of Resources - 2

Experience: 4-6 years

Duration – 6 Months

Location- Seattle, WA

Type of working model- Hybrid

Start date- Mar 15, 2026

Job Summary

We are looking for a skilled Data Engineer with strong hands-on experience in IBM Db2 to design, build, and optimize data pipelines and analytical solutions. The ideal candidate will have deep expertise in Db2 SQL, table functions, stored procedures, and performance tuning, with experience supporting BI tools such as Metabase and enabling analytics and AI use cases.

Key Responsibilities

Design, build, and maintain data pipelines and transformations in IBM Db2

Develop and optimize SQL-based data models for analytics and BI consumption

Create, refactor, and optimize Db2 Table Functions (Inline and Compiled)

Migrate and modernize legacy logic by replacing stored procedures with table functions

Ensure data pipelines are Metabase-friendly, scalable, and performant

Implement robust error handling, testing, and monitoring for Db2 workloads

Collaborate with BI, Data Engineering, and AI teams to support reporting and advanced analytics needs

Perform performance tuning using explain plans, indexing strategies, and query optimization

Ensure best practices around deterministic logic, stability, and maintainability

Required Technical Skills

Strong experience with IBM Db2 (LUW / Server)

Solid understanding of Db2 SQL fundamentals

Advanced DB2 SQL tuning for complex analytical queries: MQTs, Joins on large fact tables, Window functions and analytical SQL, Stored procedures and UDFs

Data Transformation & Business Logic using: DB2 stored procedures, CTEs, Recursive queries and analytical functions

Experience integrating Db2 with Metabase or other BI tools

Optimized DB2 views and aggregates for BI tools

Experience working with cloud-based data warehouse environments using Db2

Strong understanding Stored Procedures & Table Functions

Hands-on experience with Db2 Table Functions, including Inline SQL Table Functions and Compiled SQL Table Functions

Refactoring & Modernization in DB2

Experience replacing stored procedures with table functions

Handling multi-value parameters in DB2

Implementing robust error handling using: SIGNAL SQLSTATE, Default return sets, NULL-safe logic

Ensuring deterministic, stable behavior and avoiding non-deterministic SQL

Performance tuning of Db2 SQL and table functions

Unit testing Db2 table functions for: Parameter edge cases, Empty result sets, NULL handling, Large input volumes

Nice to Have

Exposure to AI/ML data preparation pipelines

Refactoring DB2 logic into ELT or cloud-native pipelines

Experience working in large-scale analytics or enterprise data platforms

Knowledge of data governance, data quality, and best practices