ETL Developer :
Role Summary
We are seeking a highly skilled and results-driven ETL Developer with extensive hands-on experience in IBM DataStage and IBM Cloud Pak for Data (CP4D). The ideal candidate will be responsible for designing, developing, optimizing, and supporting enterprise-scale ETL solutions, data integration pipelines, and modernization initiatives involving migration from legacy DataStage environments to cloud-native data platforms.
The candidate should possess strong expertise in data warehousing, data transformation, performance optimization, and production support while collaborating with cross-functional teams in an Agile delivery environment.
Key Responsibilities
- Design, develop, test, and deploy ETL/Data Integration solutions using IBM DataStage (latest versions).
- Develop scalable and high-performance data pipelines for batch and near real-time processing.
- Lead migration and modernization initiatives from traditional DataStage environments to IBM Cloud Pak for Data (CP4D).
- Design and implement reusable ETL frameworks, shared containers, parameter sets, and automation components.
- Perform complex data mapping, transformation, cleansing, enrichment, and validation activities.
- Conduct performance tuning and optimization of ETL jobs, databases, and data flows.
- Analyze production issues, perform root-cause analysis, and implement permanent fixes.
- Collaborate with Data Architects, Business Analysts, Product Owners, and QA teams during solution design and delivery.
- Participate in Agile ceremonies including Sprint Planning, Daily Standups, Reviews, and Retrospectives.
- Create and maintain technical design documents, source-to-target mappings, and operational runbooks.
- Ensure compliance with enterprise security, governance, and data quality standards.
Mandatory Technical Skills
Primary Skills
- IBM DataStage (11.x and above) – Expert Level
- IBM Cloud Pak for Data (CP4D)
- Data Warehousing Concepts
- Data Migration & Modernization
- Performance Tuning and Optimization
- Unix/Linux Shell Scripting
Preferred Skills
- Experience migrating ETL workloads from IBM DataStage to Cloud Pak for Data.
- Exposure to cloud-native architecture and enterprise modernization programs.
- Experience with Autosys, Control-M, or enterprise scheduling tools.
- Understanding of data governance, metadata management, and data lineage.
- Knowledge of DevOps and automated deployment pipelines for ETL applications.
- Exposure to Banking and Financial Services domain is highly preferred.
- Experience working in large-scale enterprise data platforms handling high-volume data processing.
TCS Employee Benefits Summary:
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Salary Range- $100,000-$110,000 a year
