AbInitio Developer

Tata Consultancy Services; Mississauga; On-site; CAD 85,000 - 100,000; Full time

Job summary

A multinational IT services firm in Mississauga is seeking an ETL Developer to design and develop ETL solutions. This role includes building data pipelines, managing data quality, and optimizing processes. The ideal candidate will have experience with Ab Initio and be able to work on data warehousing projects. This is a full-time position with a mid-senior level seniority.

Qualifications

• Experience in designing and implementing data warehouses.
• Knowledge of ETL processes and tools, preferably Ab Initio.
• Ability to perform data quality checks and troubleshooting.

Responsibilities

• Create and maintain data pipelines for ETL processes.
• Design data warehouses and manage data quality.
• Perform unit testing and maintain documentation.

Skills

Data modeling

Building data pipelines

Ab Initio graphs

Data quality management

Performance tuning

Tools

Ab Initio GDE

Job description

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Tata Consultancy Services

Talent Acquisition Specialist | TCS Canada

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’s stories across our workforce and implemented through equitable workplace policies and processes.

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.

Job Description : Role Description :

Designing and Developing ETL Solutions :

• Building data pipelines : Creating and maintaining data pipelines that extract, transform, and load data from various sources.
• Data modeling : Defining the structure and format of data before and after transformation.
• Developing Ab Initio graphs : Coding and testing Ab Initio graphs to perform data transformations.
• Using ETL tools : Utilizing the Ab Initio GDE and other relevant tools to design and implement solutions.
• Integrating with other systems : Working with other data analysis and organizational tools.

Data Warehouse and Data Integration :

• Data warehousing : Designing and implementing data warehouses and data lakes.
• Data quality management : Ensuring data accuracy, consistency, and completeness.
• Metadata management : Managing metadata related to data sources, transformations, and data warehouse structures.
• Performance tuning : Optimizing Ab Initio processes for efficiency and speed.

Testing and Documentation :

• Unit testing : Performing unit tests to ensure the quality of Ab Initio graphs and components.
• Documentation : Creating and maintaining documentation for Ab Initio applications and processes.
• Troubleshooting and debugging : Identifying and resolving issues in Ab Initio jobs and processes.

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.

Seniority level: Mid-Senior level

Employment type: Full-time

Industry: IT Services and IT Consulting

Referrals increase your chances of interviewing at Tata Consultancy Services by 2x

Get notified about new ETL Developer jobs in Mississauga, Ontario, Canada.