Datastage Developer

4 weeks ago

Toronto, Canada Tata Consultancy Services Full time

About TCS


TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed to offer businesses a single window into industry-specific solutions. Our agile industry units have embedded capabilities to enable rapid responses that provide a competitive edge to our customers. This, coupled with a unique Global Network Delivery Model™ (GNDM™), is recognized as the current benchmark of excellence in technology deployment. We have made significant investments in digital technology, horizontal, and vertical platforms, allowing us to successfully serve our clients for over 50 years.



Required Skills:


• Hands on experience in using Data Stage 8.5 and higher versions of the tool.

• Extensive experience in working with databases such as Oracle, SQL, DB2 including PL/SQL scripting.

• Experience in data modeling techniques and processes with large volumes of data.

• Experience in Unix Shell Scripting and hands-on experience in Linux.

• Experience in data profiling and data quality analysis.

• Experience in Waterfall and Agile SDLC methodologies.

• Application domain knowledge in Finance/Banking.

• Experience in using Datastage 11.x

• Experience in solution architecture.


Roles and Responsibilities:


• Understand business requirements and create design documentation. Get Design documentation reviewed and signed off. Design, prototype, develop, test, and document ETL and related components.

• Contribute to the data modelling effort and ensure data model is optimized for performance.

• Deliver ETL and related components as specified in the design, functional and non-functional requirements, within established budget, time and quality standards.

• Perform unit testing of ETLs and related components and document test results.

• Correct testing defects and support all testing, including Unit Testing, Integration Testing, System Testing, User Acceptance Testing, and Performance Testing.

• Complete code reviews for ETLs and related components and guide the development team in delivering optimized code.

• Perform troubleshooting on ETLs, identify application bottlenecks and optimize performance.

• Provide innovative solutions to complicated ETL-related problems.

• Perform code version control activities.

• Coordinate with vendor for resolution of issues.


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 accommodations during the recruitment and selection process, please inform Human Resource


Thank you for your interest in TCS. Candidates that meet the qualification 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.

  • Datastage Developer

    4 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    About TCS TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed...

  • IBM Datastage/ETL Developer

    4 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    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 and is reflected in our people stories across our workforce implemented through...

  • IBM Datastage/ETL Developer

    3 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    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 and is reflected in our people stories across our workforce implemented through...

  • IBM Datastage/ETL Developer

    3 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    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 and is reflected in our people stories across our workforce implemented through...

  • ETL BI Developer

    2 weeks ago

    Toronto, Canada Maarut Inc Full time

    Resource ProfileThis requirement is for a ETL and BI Developer to work  with technology and business teams to provide technical leadership in planning, analysis, building, configure, testing, and post implementation support data solutions with experience with enterprise ETL and data integration and reporting tooling such as IBM Infosphere Information Server...

  • ETL BI Developer

    2 weeks ago

    Toronto, Canada Maarut Inc Full time

    Job DescriptionResource ProfileThis requirement is for a ETL and BI Developer to work  with technology and business teams to provide technical leadership in planning, analysis, building, configure, testing, and post implementation support data solutions with experience with enterprise ETL and data integration and reporting tooling such as IBM Infosphere...

  • TLM Developer

    1 day ago

    Toronto, Canada Royal Bank of Canada> Full time

    Job Summaryassignments.Job DescriptionWHAT IS THE OPPORTUNITY?TLM team is undertaking multiple complex enterprise-wide initiatives as part of RBC’s ongoing plan to improve technology management and architectural governance across the organization. In this role you will be responsible for development and implementation of TLM Suite.  The role will...

  • Business Data Analyst

    3 days ago

    Toronto, Canada Sodales Solutions Inc Full time

    Education: - Expérience: **Education**: - Bachelor's degree **Tasks**: - Confer with clients to identify requirements - Design, develop and implement information systems business solutions - Provide advice on information systems strategy, policy, management and service delivery - Assess physical and technical security risks to data, software and...

  • ETL Developer

    3 weeks ago

    Toronto, Canada Maarut Inc Full time

    Job...

  • Software Developer

    2 weeks ago

    Toronto, Ontario, Canada RBC - Royal Bank Full time

    Job SummaryJob DescriptionWhat is the opportunity?You will be directly involved in a team driven to transform technology in Wealth Management Technology & Solutions. The projects in this space will be leveraged to meet business needs, modernize our technical solutions, and align with enterprise level strategy (API-driven services, Data-driven insights,...

  • business data analyst

    2 weeks ago

    Toronto, Canada Sodales Solutions Inc Full time

    Education: Expérience: EducationBachelor's degreeTasksConfer with clients to identify requirementsConduct business and technical studiesDesign, develop and implement information systems business solutionsProvide advice on information systems strategy, policy, management and service deliveryAssess physical and technical security risks to data, software and...

  • business data analyst

    3 weeks ago

    Toronto, Canada Sodales Solutions Inc Full time

    Education: Bachelor's degreeExperience: 2 years to less than 3 yearsTasksConfer with clients to identify requirementsConduct business and technical studiesDesign, develop and implement information systems business solutionsProvide advice on information systems strategy, policy, management and service deliveryAssess physical and technical security risks to...

  • business data analyst

    3 days ago

    Toronto, Canada Sodales Solutions Inc Full time

    Education: Expérience: EducationBachelor's degreeTasksConfer with clients to identify requirementsDesign, develop and implement information systems business solutionsProvide advice on information systems strategy, policy, management and service deliveryAssess physical and technical security risks to data, software and hardwareDevelop policies, procedures...

  • Azure Data Engineer(Databricks, Azure Synapse)

    1 week ago

    Toronto, Canada Ampstek Full time

    Role – Azure Data Engineer(Databricks, Azure Synapse)Location – Toronto, Ontario (Onsite)Short-term Contract.Job Description:Key skillsets:• Azure Cloud: Azure Databricks, ADLS Gen2, Azure Data Factory, Azure Synapse• ETL Tools: Visual Studio 2015 (SSIS), Informatica PowerCenter 10.1.1/9.1, DataStage• Certification – Azure data...

  • Specialized I&IT Consultant

    3 weeks ago

    Toronto, Canada Global Pharma Tek Full time

    Title Specialized IT Consultant - Intermediate Location: Toronto, ON (Hybrid) Duration: Business Days + Possible extension Job Description: Design, develop, and maintain data pipelines using Azure Data Factory Services for data ingestion, transformation, and integration. Develop ETL processes using SQL Server Integration Services...

  • ETL Developer

    3 weeks ago

    Toronto, Canada Maarut Inc Full time

    Job DescriptionJob...

  • Azure Data Engineer(Databricks, Azure Synapse)

    6 days ago

    Toronto, Canada Ampstek Full time

    Role – Azure Data Engineer(Databricks, Azure Synapse)Location – Toronto, Ontario (Onsite)Short-term Contract.Job Description:Key skillsets:• Azure Cloud: Azure Databricks, ADLS Gen2, Azure Data Factory, Azure Synapse• ETL Tools: Visual Studio 2015 (SSIS), Informatica PowerCenter 10.1.1/9.1, DataStage• Certification – Azure data...

  • Azure Data Engineer(Databricks, Azure Synapse)

    1 week ago

    Toronto, Canada Ampstek Full time

    Role – Azure Data Engineer(Databricks, Azure Synapse)Location – Toronto, Ontario (Onsite)Short-term Contract.Job Description:Key skillsets:• Azure Cloud: Azure Databricks, ADLS Gen2, Azure Data Factory, Azure Synapse• ETL Tools: Visual Studio 2015 (SSIS), Informatica PowerCenter 10.1.1/9.1, DataStage• Certification – Azure data...

  • Azure Data Engineer(Databricks, Azure Synapse)

    6 days ago

    Toronto, Canada Ampstek Full time

    Role – Azure Data Engineer(Databricks, Azure Synapse)Location – Toronto, Ontario (Onsite)Short-term Contract.Job Description:Key skillsets:• Azure Cloud: Azure Databricks, ADLS Gen2, Azure Data Factory, Azure Synapse• ETL Tools: Visual Studio 2015 (SSIS), Informatica PowerCenter 10.1.1/9.1, DataStage• Certification – Azure data...

  • Azure Data Engineer(Databricks, Azure Synapse)

    1 week ago

    Toronto, Canada Ampstek Full time

    Role – Azure Data Engineer(Databricks, Azure Synapse) Location – Toronto, Ontario (Onsite) Short-term Contract. Job Description: Key skillsets: • Azure Cloud: Azure Databricks, ADLS Gen2, Azure Data Factory, Azure Synapse • ETL Tools: Visual Studio 2015 (SSIS), Informatica PowerCenter 10.1.1/9.1, DataStage • Certification – Azure data engineer...