Richard Baker, Developer in Mississauga, ON, Canada
Richard is available for hire
Hire Richard

Richard Baker

Verified Expert  in Engineering

ETL Development Developer

Mississauga, ON, Canada
Toptal Member Since
May 17, 2019

Richard is a developer and has spent over 14 years building and maintaining data warehouses and working on data integrations and reports. He possesses expertise in SQL and is more than competent in Python. Richard believes that the key to successful remote work is communicating clearly defined milestones and the expected availability.


Amazon Web Services (AWS), Python, Teradata, Datastage
University Health Network
PL/SQL, SQL Server Integration Services (SSIS), Microsoft Power BI, IBM Cognos...
Erwin, Unix, Teradata




Preferred Environment

Cognos 10, Microsoft Power BI, Python, Datastage, Azure Data Factory, Azure Synapse

The most amazing...

...thing I've coded was a single line of sed that contained a page of logic.

Work Experience

Data Integration Developer

2008 - PRESENT
  • Wrote Python and PySpark scripts to scrape and download XML files from a website that provides live weather in an XML format, transformed it to JSON, and made the data available to use on Athena.
  • Developed Datastage jobs and sequences for projects, change requests, and minor enhancements based on business and system requirements.
  • Performed Teradata query tuning and optimization and provided suggestions on database performance improvements.
  • Enhanced existing Datastage jobs to enable better flexibility and optimization, utilizing different job layouts and Unix commands.
Technologies: Amazon Web Services (AWS), Python, Teradata, Datastage

Data Integration and Report Developer

2008 - 2018
University Health Network
  • Built a reusable PL/SQL ETL framework that was utilized for new projects which allowed the team to have a standardized way of organizing its PL/SQL code.
  • Developed dashboards and reports using Power BI and Cognos to meet a given project’s requirements.
  • Worked extensively with the staff throughout the hospital to understand their reporting needs, profiled new source systems and then, if required, integrated them existing data warehouse sources.
  • Developed ETL processes using SSIS or a combination of PL/SQL and Unix scripting to load and integrate the EDW data.
Technologies: PL/SQL, SQL Server Integration Services (SSIS), Microsoft Power BI, IBM Cognos, Microsoft SQL Server, Oracle

Senior Consultant – Bell Canada Teradata DBA

2004 - 2008
  • Designed logical and physical data models using ERWIN for data warehouse projects and conducted walkthroughs with business users to ensure business rules were properly captured.
  • Constructed Visual Basic program to monitor Teradata performance and send automatic alerts when set thresholds were reached.
  • Designed and implemented backup and recovery procedures for MVS and NetVault.
Technologies: Erwin, Unix, Teradata

Live Weather Data

I built this scraping site that involves live weather data; it downloads XML files and transforms the data to JSON.
1998 - 2003

Bachelor's Degree in Computer Science

Ryerson University - Toronto, Canada


Data Modeling Master Class

Steve Hoberman’s Best Practices Approach to Developing a Competency in Data Modeling


Microsoft Power BI, IBM Cognos, Erwin


Teradata, SQL Server 2016, PostgreSQL, Datastage, Microsoft SQL Server, SQL Server Integration Services (SSIS), PL/SQL


SQL, Python


Linux, Oracle, Unix, Amazon Web Services (AWS), Azure Synapse


ETL Development, Cognos 10, Azure Data Factory

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.


Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring