Find projects

Discover and match with projects from real companies

TechInsights
Ottawa, Ontario, Canada
Michael Spence
He / Him
VP, Software
(2)
4
Project
Academic experience or paid work
80 hours of work total
Learner
Anywhere
Intermediate level

Project scope

Categories
Cloud technologies Data analysis Data modelling Information technology Data science
Skills
data quality mulesoft anypoint extract transform load (etl) data governance data lineage datadog governance open source technology quality assessment amazon redshift
Details

Data governance in legacy systems can be tough to implement because those systems are often inflexible and unmaintainable. TechInsights needs to rationalize and document its existing data flows/ETLs.


In this project, learners will become familiar with AWS Data Zone and the Open Source Great Expectations too to document the complete Data Lineage of several ETL flows and implement reliable data quality rules so that TechInsights can establish and entrench better Data Governance, quality, and monitoring.


AWS Data Zone champions and implements the OpenLineage standard. This industry standard seeks to wrangle the complex ETL industry (100s of companies) towards data governance. TechInsights wants to adopt this standard and the AWS Data Zone tool


Great Expectations is an OpenSource tool that ETL authors and maintainers to specify automated quality checks on ETL sources and targets to ensure data is complete and compliant.

Deliverables

Learners will

  1. Learn and Setup AWS DataZone
  2. Learn and Setup Great Expectations
  3. Describe several ETL flows in DataZone including their full lineage and demonstrate to stakeholders
  4. Determine how to implement Data Lineage for ETLs written in Mulesoft AnyPoint and Composer
  5. Determine how best to implement data quality checks in Great Expectations
  6. Implement simple ETLs in AWS ZeroETL with full monitoring in DataDog
Mentorship
Domain expertise and knowledge

Providing specialized, in-depth knowledge and general industry insights for a comprehensive understanding.

Skills, knowledge and expertise

Sharing knowledge in specific technical skills, techniques, methodologies required for the project.

Tools and/or resources

Providing access to necessary tools, software, and resources required for project completion.

Regular meetings

Scheduled check-ins to discuss progress, address challenges, and provide feedback.

Supported causes

The global challenges this project addresses, aligning with the United Nations Sustainable Development Goals (SDGs). Learn more about all 17 SDGs here.

Responsible consumption and production

About the company

Company
Ottawa, Ontario, Canada
201 - 500 employees
Advanced manufacturing, It & computing, Science, Technology, Clean technology

TechInsights supports innovation and decision making in the semiconductor industry through its independent research and analysis. We exist to support our customers in advancing the world around us. TechInsights is the semiconductor industry’s authoritative platform.