Data Engineer

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. Tata Consultancy Services (BSE: 532540, NSE: TCS) is the technology partner of choice for industry-leading organizations worldwide. Since its inception in 1968, TCS has upheld the highest standards of innovation, engineering excellence and customer service. It has set an aspiration to become the world's largest AI-led technology services company and is enabling its clients to transform themselves across the full AI stack, from infrastructure to intelligence. Rooted in the heritage of the Tata Group, TCS is focused on creating long term value for its clients, its investors, its employees, and the community at large. With a highly skilled workforce spread across 56 countries and 194 service delivery centers across the world, the company has been recognized as a top employer in six continents. With the ability to rapidly apply and scale new technologies, the company has built long term partnerships with its clients. Many of these relationships have endured into decades and navigated every technology cycle, from mainframes in the 1970s to artificial intelligence today. Key Responsibilities Design, develop, and maintain database objects, scripts, queries, and data processing logic using SQL and Python. Analyze business and technical requirements and translate them into scalable data solutions. Support data extraction, transformation, loading, validation, reconciliation, and reporting activities across multiple data platforms. Develop and optimize SQL queries, stored procedures, and scripts to support data analysis, reporting, and operational needs. Work with relational and cloud-based databases such as Oracle, IQ, BigQuery, and HANA, as applicable. Collaborate with business analysts, data analysts, architects, quality engineering teams, and business stakeholders to understand data requirements and resolve issues. Assist in data modeling activities, including understanding source-to-target mapping, relationships, business rules, and data lineage. Support dashboard/reporting development or validation using tools such as Tableau and Looker. Perform data quality checks, troubleshoot data issues, and support root cause analysis for defects or production incidents. Prepare and maintain technical documentation, data mapping documents, design notes, deployment steps, and support handover materials. Must have Skills Strong hands-on experience with SQL, including writing, debugging, and optimizing complex queries. Proficiency in Python for data processing, automation, scripting, and analysis. Solid understanding of database concepts, including tables, views, joins, indexes, keys, normalization, stored procedures, and data integrity. Ability to analyze data, troubleshoot issues, and validate results across source and target systems. Experience working with large datasets and applying data quality, reconciliation, and validation techniques. Strong communication skills with the ability to work with technical and business stakeholders. Good to have Skills Experience with database platforms such as Oracle, IQ, BigQuery, and SAP HANA. Understanding of ETL concepts, including extraction, transformation, loading, scheduling, monitoring, and error handling. Knowledge of data modeling concepts such as conceptual, logical, and physical models; star schema; snowflake schema; facts; dimensions; and source-to-target mapping. Experience with reporting and visualization platforms such as Tableau and Looker. Exposure to data warehousing, analytics platforms, cloud data services, and enterprise reporting environments. TCS does not use artificial intelligence tools for candidate screening or evaluation. This post is for a current vacancy. The hiring process includes an initial screening, followed by a technical evaluation and managerial discussion. 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.

Design, develop, and maintain database objects, scripts, and data processing logic using SQL and Python. Collaborate with stakeholders to translate business requirements into scalable data solutions and support data lifecycle activities.

Candidates must have strong hands-on experience with SQL and Python for data processing and automation. A solid understanding of database concepts, large dataset handling, and data validation techniques is required.

Identified from the job description. Confirm important requirements above.

• SQL
• Python
• Database Design
• Data Processing
• Data Modeling
• ETL
• Data Validation
• Data Warehousing
• Oracle
• BigQuery
• SAP HANA
• Tableau
• Looker
• Data Quality
• Data Lineage
• Stored Procedures

• Data & Analytics
• Technology
• Engineering
• Software
• Consulting

Minimum experience

5+ years

Apply by

Aug 22, 2026

Posting language

English

Working hours

40 hours per week

Seniority

Mid-Senior level

Application method

Direct apply is available