Datastage Developer

About TCSTCS 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 ResourceThank 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. IT Services and IT Consulting