Datastage developer

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.

Required skill set

"Skills and Responsibilities

• Participate in all aspects of a systems development life cycle within the development team (Analysis, Design, Development, Test, QAT, Implementation, and Production Support).
• Designing, developing, and maintaining ETL jobs using IBM DataStage, optimizing performance, troubleshooting issues, and collaborating with business analysts to understand requirements.
• Proficient in developing strategies for Extraction, Transformation, and Loading (ETL) mechanisms.
• Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.
• Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner, and Link Collector.
• Experienced in the integration of various data sources (DB2-UDB, SQL Server, PL/SQL, Oracle, Teradata, XML, and MS-Access) into the data staging area.
• Expert in working with Data Stage Manager, Designer, Administrator, and Director.
• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Index and Aggregate tables for the data warehouse design and development.
• Excellent knowledge of studying the data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate the scheduling of multiple sessions.
• Proven track record in troubleshooting Data Stage jobs and addressing production issues like performance tuning and enhancement.
• Experienced in Database programming for Data Warehouses (Schemas), proficient in dimensional modeling · Expertise in UNIX shell scripts using K-shell for the automation of processes and scheduling the Data Stage jobs using wrappers.
• Experience in using software configuration management tools like bitbucket for version control. · Experienced in Data Modeling as well as reverse engineering

Salary Range - CA$ 100,000 - CA$ 120,000 Per Year

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.