Data Business Analyst - Canada
nugget
Location – Toronto, ON (Onsite from Day 1)
Job Type - Contract
Description
- Essential skills include SQL dialects such as Databricks Spark SQL, Oracle SQL, T-SQL, PostgreSQL, and MongoDB.
- Good knowledge on Data Warehousing , Data Mart and Data Lake concepts
- Hands on experience writing basic SQLs
- Hands on experience on gathering requirements to add new source systems to existing Datawarehouse / Data Lake systems.
- Hands on experience creating STM (Source to Target Mapping ) / BRD (Business Requirements) documents.
- Awareness of Capital Market / Wealth Management business
- Good communication skills and can collaborate with different stake holders to gather requirements / resolve issues
- Incremental load / Full load
- Slowly changing dimensions
- Ingestion / Curation / Symantec layers
- Fact / Dim tables
