Inclusion without Exception:
Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our people stories across our workforce and implemented through equitable workplace policies and processes.
About TCS:
TCS is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive-powered portfolio of business, technology, and engineering services and solutions is delivered through its unique Location Independent Agile™ delivery model, recognized as a benchmark of excellence in software development. A part of the Tata group, India's largest multinational business group, TCS operates in 55 countries and employs over 607,000 highly skilled individuals, including more than 10,000 in Canada. The company generated consolidated revenues of US $ 30 billion in the fiscal year ended March 31, 2025, and is listed on the BSE and the NSE in India. TCS' proactive stance on climate change and award-winning work with communities across the world have earned it a place in leading sustainability indices such as the MSCI Global Sustainability Index and the FTSE4Good Emerging Index.
Required Skill Set:
Role Description:
• For each Use Case, analyze the Mapping document of target table to determines operational objectives by studying business functions, gathering information, and evaluating output requirements.
• Track the target field mapping back to origin data element in the source system.
• Having strong knowledge in SQL to perform data analysis and data profiling on different Legacy system.
• Document the existing source to target data flow for each table, which includes.
• Business transformation rule applied.
• Key-Cutting implemented to identify surrogate key that is defined as a unique identifier in a table.
• Reference data used to enhance the context and validity of target data elements.
• For tables where mapping document is not available, TSBI and ETL leads jointly must go over the code to extract the business rules applied and capture them into the requirement document.L2L3 Model
• Business team would be responsible for the creation of L2 Model supported by Project Business Analyst, Solution Architect and TSBI
• Collaborate with data scientists, business analysts, and IT teams to integrate advanced L2L3 models into the data pipeline.
• Mapping Design of New L2L3Prepares technical Design and mapping (Data Movement Model) for the new L2 Model by working with Project Business Analysts and Solution Architect.
• Review the Key Cutting process to be implement on the L2 model and get approval from L2 Schema Owners.
• Only BORT System data would be populated into L2 schema, other reference and tactical data would directly be consumed by L3 processes.
• L2 to L3 mapping would contain the Business transformation rules for each target table.
• Custom Surrogate Key process would be implemented on L3 tables, which would contain different keys than L2 tables.
• Any system having one-off tables holding business data would be loaded into L3 schema for target table processing.
• Spearheaded the implementation of robust data governance policies and procedures, ensuring compliance with industry regulations and standards, resulting in a 20 reduction in data security incidents.
• Collaborate with cross-functional teams to design and implement data quality frameworks, improving data accuracy and integrity, and reducing errors.
• Determines operational objectives by studying business functions gathering information evaluating output requirements and formats.
• Designs, analyzing requirements and designing modifications.
• Defines project requirements by identifying project milestones, phases, and elements, forming project team.
• Monitors project progress by tracking activity resolving problems publishing progress reports recommending actions.
• Provides references for users by writing and maintaining mapping documentation.
• Maintains user confidence and protects operations by keeping information confidential.
• Prepares technical Design and mapping by collecting, analyzing and data profiling.
• Maintains professional and technical knowledge by attending workshops.
Required Skill Sets:
• TSBI - Analyze of Legacy System
• For each Use Case, analyze the Mapping document of target table to determines operational objectives by studying business functions, gathering information, and evaluating output requirements.
• Track the target field mapping back to origin data element in the source system.
• Having strong knowledge in SQL to perform data analysis and data profiling on different Legacy system.
Tata Consultancy Services Canada Inc. is committed to meeting the accessibility needs of all individuals in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code (OHRC). Should you require accommodation during the recruitment and selection process, please inform Human Resources.
Thank you for your interest in TCS. Candidates that meet the qualifications for this position will be contacted within a 2-week period. We invite you to continue to apply for other opportunities that match your profile.
