Opens an external site
- Employment type
- Full-time
- Experience level
- Lead · 10+ years
- Apply by
- Nov 1, 2026
- Posting language
- English
- Working hours
- 40 hours per week
- Seniority
- Mid-Senior level
- Application method
- Direct apply is available
Job summary
Design, develop, and support scalable data pipelines and ETL/ELT workflows, including real-time processing, data ingestion, transformation, and validation. Lead on-premises-to-AWS migrations, optimize SQL and data workflows, monitor system reliability, and collaborate with development, architecture, and infrastructure teams.
Job details
Job Summary: The ideal candidate will have strong expertise in designing, developing, and supporting scalable data pipelines and distributed systems, along with hands-on experience in Big Data ecosystem tools, AWS services, and real-time data processing. This role involves working on data platform modernization, cloud migrations, Data Warehousing and ETL in a fast-paced enterprise environment. Required Technical Skills: • Cloud Technologies Strong experience in AWS Cloud services: EMR, EC2, S3, VPC, RDS, Redshift AWS Glue, IAM, CloudWatch, CloudFormation Airflow (or AWS Managed Workflows) Databases • Experience working with: Netezza is mandatory SQL-based systems: SQL Server and Postgres SQL Data warehouses: Teradata, Redshift, Netezza ETL Tools • Hands-on experience with:SSIS Programming & Scripting Strong proficiency in: SQL Shell scripting • Good to have: Python Operating Systems • Strong experience in Unix/Linux environments • Key Qualifications10+ years of experience in Data Engineering / Big Data / Platform Engineering Key Responsibilities: • Design, develop, maintain and support scalable data pipelines using Big Data and AWS technologies • Lead and support data platform migration initiatives (On-Prem to AWS Cloud), ideally with Netezza background. • Develop and manage ETL/ELT processes using tools like SSIS, Pentaho, or similar Implement and manage AWS services such as EMR, S3, EC2, Redshift, Glue, and Airflow Build and optimize data workflows and orchestration pipelines using Airflow Work with real-time streaming technologies such as Kafka and Spark Streaming • Perform data ingestion, transformation, and validation from multiple data sourcesOptimize SQL queries for performance and scalability • Monitor system performance, troubleshoot issues, and ensure system reliability • Collaborate with cross-functional teams including developers, architects, and infrastructure teams “Tekshapers is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.” *Disclaimer: This E-Mail may contain Confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, kindly notify us at itsupport@tekshapers.com and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution, and/or publication of this e-mail, its contents, or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful. Internet communication cannot be guaranteed to be secured or error-free as information could be delayed, intercepted, corrupted, lost, or contain viruses. Tekshapers. does not accept any liability for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this e-mail.
What you’ll do
Design, develop, and support scalable data pipelines and ETL/ELT workflows, including real-time processing, data ingestion, transformation, and validation. Lead on-premises-to-AWS migrations, optimize SQL and data workflows, monitor system reliability, and collaborate with development, architecture, and infrastructure teams.
Requirements
Requires 10+ years of experience in data engineering, Big Data, or platform engineering, with strong AWS, distributed systems, and Unix/Linux expertise. Netezza experience is mandatory; proficiency in SQL, shell scripting, and SSIS is required, while Python is an advantage.
Listed skills
- SQL · Preferred
- Amazon Web Services · Preferred
- Python · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- AWS
- Data Engineering
- Big Data
- Data Pipelines
- Netezza
- SQL
- Unix/Linux
- ETL/ELT
- SSIS
- Airflow
- Amazon Redshift
- AWS Glue
- Apache Kafka
- Spark Streaming
- Python
- Shell Scripting
Job areas
- Data & Analytics
- Technology
- Software
- Engineering
More jobs from Tekshapers
Mainframe QA LEAD
- On-site
- Toronto, ON
- Posted Oct 1, 2026
Platform Engineer
- On-site
- Toronto, ON
- Posted Oct 1, 2026
Python Developer
- On-site
- Toronto, ON
- Posted Sep 30, 2026
Senior Business Analyst
- On-site
- Toronto, ON
- Posted Sep 25, 2026
