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.
Portfolio
Experience
Availability
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
Innovapost
- 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.
Data Integration and Report Developer
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.
Senior Consultant – Bell Canada Teradata DBA
CGI
- 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.
Experience
Live Weather Data
Education
Bachelor's Degree in Computer Science
Ryerson University - Toronto, Canada
Certifications
Data Modeling Master Class
Steve Hoberman’s Best Practices Approach to Developing a Competency in Data Modeling
Skills
Tools
Microsoft Power BI, IBM Cognos, Erwin Data
Languages
SQL, Python
Storage
Teradata, SQL Server 2016, PostgreSQL, Datastage, Microsoft SQL Server, SQL Server Integration Services (SSIS), PL/SQL
Platforms
Linux, Oracle, Unix, Amazon Web Services (AWS), Azure Synapse
Other
ETL Development, Cognos 10, Azure Data Factory
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
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring