Kumar Pankaj
Lead ETL Consultant | 13+ yrs in IBM DataStage | Data Integration | Cloud ETL Exposure | Ex-TCS, Accenture | BFSI & Retail
- Role
- Lead Consultant at HCLTech
- Location
- Jamshedpur, JH, IN
- LinkedIn followers
- 500 followers
About Kumar Pankaj
ETL Lead | Data Integration Specialist | 13+ Years in DataStage | BFSI & Retail…
Experience
Lead Consultant
Feb 2022 — Present · Kolkata, IN
13+ years of experience in IBM DataStage development, support, and ETL architecture for large-scale data warehouse projects across BFSI, Healthcare, and Retail domains. Hands-on expertise in parallel jobs, server jobs, job sequencing, and handling complex transformations and performance tuning. Led a team of 5–10 ETL developers, assigning tasks, reviewing code, and ensuring timely delivery with high-quality standards. Designed ETL pipelines for data extraction, transformation, and loading from multiple sources: SQL Server, Oracle, Flat Files, APIs. Strong experience in job monitoring, debugging, and resolving failures in production environments (Level 2/3 support). Involved in requirement gathering, design documentation, unit testing, and deployment using SDLC/Agile methodologies. Experience in data warehouse modeling (star/snowflake schema) and collaborating with data architects and business users. Exposure to cloud migration initiatives, especially to platforms like Snowflake, Azure Data Factory, and DevOps pipelines. Tools used: IBM DataStage 11.x, Unix/Linux scripting, Control-M, Git, JIRA, Tivoli, and ServiceNow.
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.