ETL Developer

United States Digital Space LLC; Toronto; On-site; CAD 65,000 - 115,000; Full time

Job summary

United States Digital Space LLC in Toronto is seeking an ETL Developer to design, develop, and optimize enterprise data pipelines using DataStage, Python, and SQL/HQL. You will ensure data quality and reliability while supporting AML initiatives and production deployments in a hybrid work model with minimum three days on-site in downtown Toronto.

The role offers collaboration with business partners, documentation, and knowledge transfer to keep data initiatives aligned with critical business

Qualifications

• 6+ years of ETL development experience.
• Strong DataStage, Python, SQL/HQL, and UNIX skills.
• Experience with data analysis, transformation design, and ETL development.
• Experience implementing source-to-target mappings and data transformation logic.
• Experience working on AML initiatives.
• Strong troubleshooting, testing, and defect resolution skills.

Responsibilities

• Design, develop, enhance, and maintain enterprise ETL data pipelines.
• Perform data analysis and design mappings and transformation logic.
• Support onboarding of new data sources and enhance data feeds.
• Develop and maintain batch processing frameworks and workflows.
• Implement data cleansing, validation, and standardization logic.
• Perform unit testing, defect resolution, and code optimization.
• Support production deployments, implementation activities, and software updates.
• Create technical documentation and support knowledge transfer.

Skills

ETL development

AML initiatives

Analytical and problem-solving

Communication skills

Tools

DataStage

Python

SQL/HQL

UNIX

Job description

the company is seeking an ETL Developer to join our team and support the development and maintenance of enterprise data integration solutions. In this role, you will design, develop, and optimize ETL pipelines while ensuring data quality, performance, and reliability in support of critical business initiatives.

This role is hybrid and requires you to be at our downtown Toronto office and/or the client office a minimum of three days per week, subject to change at any time.

Your future duties and responsibilities

• Design, develop, enhance, and maintain enterprise ETL data pipelines using DataStage, Python, SQL/HQL, and UNIX.
• Perform data analysis and design source-to-target mappings and transformation logic.
• Support the onboarding of new data sources and enhance existing data feeds.
• Develop and maintain batch processing frameworks and workflows.
• Implement data cleansing, validation, and standardization logic.
• Perform unit testing, defect resolution, and code optimization.
• Support production deployments, implementation activities, and software currency updates.
• Create technical documentation and support knowledge transfer activities.

Required qualifications to be successful in this role

• 6+ years of ETL development experience.
• Strong experience with DataStage, Python, SQL/HQL, and UNIX.
• Experience with data analysis, transformation design, and ETL development.
• Experience implementing source-to-target mappings and data transformation logic.
• Experience working on Anti-Money Laundering (AML) initiatives.
• Strong troubleshooting, testing, and defect resolution skills.
• Experience supporting production deployments and maintaining enterprise data pipelines.
• Excellent analytical, problem-solving, and communication skills.

the company is providing a reasonable estimate of the pay range for this role. The determination of this range includes factors such as skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is $65,000-$115,000. This role is an existing vacancy.

At the company, we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all the company partners to thrive.

As an equal-opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter.

That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.

To learn more about accessibility at the company, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Come join our team — one of the largest IT and business consulting services firms in the world.