5+ years of experience with:
- Data warehousing design and development with focus on extracting, transforming data coming from various data sources and loading into star/snowflake schemas
- Design, build, automate and optimize complex data ETL/ELT processes using PL/SQL and equivalent
- Writing complex procedures/pkg/views/scripts to do data de-normalization, data extraction, data transformation(cleansing), and data loading.
- Creating data assets (denormalized) from highly normalized Oracle database, and load the data asset to another type of DBMS (Microsoft SQL DBs, Postgress, etc.)
- Relational databases (Oracle, MySQL, SQL Server), data modelling (relational & dimensional), advanced SQL, query optimization, data replication, administration
- Advanced SQL skills (PL/SQL, TSQL)
- Scripting languages (Python, Unix shell)
- Cloud technologies (Azure, Google, AWS)
- Advanced skills and hands-on experience with Azure SQL Server and Azure Data Factory
- Proficient in creating Data Factory pipelines for copy activity and custom Azure development
- PL/SQL for data extraction, transformation, and loading, initial setup and other ETL experience management and support, such as troubleshooting, performance tuning, failover and recovery
- Elasticsearch for search/reporting, tuning for performance optimization
- Working knowledge of issue tracking system JIRA, Azure DevOps
- Using Git hub for version control and data model changes
- Oracle Enterprise Manager (OEM Cloud 12c, OEM 11g Grid), Oracle Names Server, Oracle Net Service, Oracle Connection Manager, and Oracle Advanced Security, Oracle RAC, Oracle Network, Names Server, Data Guard, Oracle Exadata, Oracle Warehouse Builder (OWB)
- PL/SQL Programming for database change tracking and data warehousing
- Data migration and data integration across different platforms (Windows to UNIX, Windows to Windows, UNIX to UNIX)
- /Recovery (Restore) and refresh production and Dev/UAT/Test using RMAN to SAN storage
Job Type: Fixed term contract
Contract length: 6 months
Salary: Up to $80.00 per hour
Flexible Language Requirement:
Schedule:
Ability to commute/relocate:
- Toronto, ON M4V 1M2: reliably commute or plan to relocate before starting work (required)
Experience:
- Data warehousing design and developmen: 5 years (required)
- ETL/ELT processes using PL/SQL: 5 years (required)
- elational databases (Oracle, MySQL, SQL Server): 5 years (required)
- Scripting languages: 5 years (preferred)
Work Location: Hybrid remote in Toronto, ON M4V 1M2
Application deadline: 2023-09-29
Expected start date: 2023-10-02
