Search for Jobs

Applied Filters (1)
2 Results
CirrusLabs
Toronto, ON, Canada (on-site)
30+ days ago
CirrusLabs
Toronto, ON, Canada (on-site)
30+ days ago
CirrusLabs
Toronto, Ontario, Canada (on-site)
30+ days ago

Description

Must Haves:

  • 7+ years in ETL tools such as Microsoft SSIS, and data warehousing, and
  • Azure Databricks,Python, Azure Data Lake
  • Azure Synapse, ADF pipelines
  • SQL Server
  • Oracle
  • Ability to present technical requirements to the business
  • Nice to have - Oracle Golden Gate

Experience:

  • Experience of 7+ years of working with SQL Server SSIS, ADF and T-SQL Development
  • Experience building data ingestion and change data capture using Oracle Golden Gate
  • Experience working with building Databases, Data Warehouse and Data Mart and working with delta and full loads
  • Experience with ETL tools such as SQL Server SSIS, ADF,
  • Experience with Azure cloud services such as Azure DataBricks, Azure Datalake and Azure Synapse.
  • Experience working with MSSQL Sever on premise and within Azure Environment
  • Experience on Data modeling, and tools – e.g. SAP Power Designer,
  • Experience with snowflake and star schema model. Experience in designing data warehouse solutions using slowly changing dimensions.
  • Experience working with SQL Server SSIS and other ETL tools, solid knowledge and experience with SQL, other RDBMS (SQL Server, SSIS), Golden Gate (nice to have)
  • Understanding data warehouse architecture with a data vault, dimensional data and fact model.
  • Analyze, design, develop, test and document ETL programs from detailed and high-level specifications, and assist in troubleshooting.
  • Utilize SQL to perform tasks other than data transformation (DDL, complex queries)
  • Good knowledge of database performance optimization techniques
  • Ability to assist in the requirements analysis and subsequent developments
  • Ability to conduct unit tests and assist in test preparations to ensure data integrity
  • Work closely with Designers, Business Analysts and other Developers
  • Liaise with Project Managers, Quality Assurance Analysts and Business Intelligence Consultants
  • Design and implement technical enhancements of Data Warehouse as required.

Skills:

  • 7+ years in ETL tools such as Microsoft SSIS, and data warehousing, and
  • Azure Databricks,Python, Azure Data Lake
  • Azure Synapse, ADF pipelines
  • SQL Server
  • Oracle
  • Ability to present technical requirements to the business
  • Nice to have - Oracle Golden Gate

Assets:

  • Knowledge and experience building data ingestion, history, change data capture using Oracle Golden Gate is major asset but is not required.

Evaluation Criteria

Data Design and Development (25 points)

  • Demonstrated experience in Microsoft specific software development and a number of years of practical experience (minimum 7+ years)
  • Proven experience in developing in Azure DevOps
  • Experience in application mapping to populate data vault and dimensional data mart schemas

ETL experience (25 points)

  • Demonstrated experience in Extract, Transform & Load and Extract, Load and Transforms software development and a number of years of practical experience (minimum 7+ years)
  • Experience in providing ongoing support on Azure pipeline/configuration and SSIS development
  • Experience building data ingesting and change data capture using Golden Gate
  • Assist in the development of the pre-defined and adhoc reports and meet the coding and accessibility requirements.

Design Documentation and Analysis Skills (20 points)

  • Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD).
  • Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises and reviews.
  • Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.
  • Work with the Client & Developer(s) assigned to refine/confirm Business Requirements
  • Participate in defect fixing, testing support and development activities for ETL tool. Assist with defect fixing and testing support for Power BI reports.
  • Analyze and document solution complexity and interdependencies by function including providing support for data validation.

Database Related (20 points)

  • Demonstrated experience with Oracle and Microsoft interfaces
  • Proficient in SQL and Azure DevOps
  • Implementing logical and physical data models


Job Information

  • Job ID: 66079437
  • Workplace Type: On-Site
  • Location:
    Toronto, Ontario, Canada
  • Company Name For Job: CirrusLabs
  • Position Title: Business Intelligence Specialist
  • Industry: Information Services
  • Job Function: Information Technology
  • Job Type: Contract
  • Job Duration: 3-6 Months
Jobs You May Like
Filters
Workplace Type
Job Function
Industry
State