Shape data warehouse solutions with Tata Consultancy Services using IBM DataStage, dimensional modeling, and broad source-system integration expertise.

This DataStage Developer contributes across the complete systems development life cycle, from analysis and design through implementation and production support. You will analyze business-process data, define granularity, map source-to-target elements, and create index and aggregate tables for warehouse development. The assignment also includes database programming, reverse engineering, metadata dependency analysis, and ETL strategy development. Tata Consultancy Services describes itself as an AI-led technology services company with operations across 56 countries and 194 service delivery centers.

Key Responsibilities:

- Analyze data generated by business processes




- Create index and aggregate tables for data warehouses
- Develop database schemas and dimensional models
- Study repository metadata and data dependencies
- Prepare batches for scheduling multiple sessions

Requirements:

- Experience with data modeling and reverse engineering
- Proficiency in database programming for data warehouses
- Experience integrating diverse relational and XML sources
- Knowledge of IBM DataStage parallel and server stages
- Experience troubleshooting performance and production issues

Use data modeling, warehouse design, metadata analysis, and IBM DataStage skills to deliver integrated enterprise data solutions.

📌 Data Warehouse DataStage Engineer (Toronto)
🏢 TATA Consultancy Services
📍 Toronto