Source Code
RQ10840 - Software Developer - ETL - Senior
Senior ETL Software Developer on a 6-month contract designing, building, and optimizing data pipelines using PL/SQL, Azure Data Factory, and Oracle in a hybrid Toronto setting.
- Compensation
- CA$71–CA$85 / hr
- Location
- Not listed
- Work setup
- Hybrid
- Seniority
- Senior
- Employment
- Not specified
- Experience
- Not specified
- Category
- Software engineering
- Posted
Skills
Must have
- Data warehousing design and development with ETL into star/snowflake schemas
- Design, build, automate and optimize complex ETL/ELT processes using PL/SQL
- Complex procedures/packages/views/scripts for data de-normalization, extraction, transformation, loading
- Create denormalized data assets from Oracle DB and load to other DBMS (SQL Server, PostgreSQL, etc.)
- Relational databases (Oracle, MySQL, SQL Server), data modelling, advanced SQL, query optimization
- Advanced SQL skills (PL/SQL, TSQL)
- Scripting languages (Python, Unix shell)
- Cloud technologies (Azure, Google, AWS)
- Advanced hands-on experience with Azure SQL Server and Azure Data Factory
- Create Data Factory pipelines for copy activity and custom Azure development
- PL/SQL for ETL including troubleshooting, performance tuning, failover and recovery
- Elasticsearch for search/reporting and performance tuning
- JIRA and Azure DevOps for issue tracking
- GitHub for version control and data model changes
- Oracle Enterprise Manager, Oracle RAC, Oracle Exadata, Oracle Warehouse Builder experience
- Data migration and integration across platforms (Windows to UNIX, etc.)
- RMAN recovery and refresh of production/Dev/UAT/Test environments to SAN storage
Nice to have
- RAD and Agile methodologies experience
- Information Management principles, concepts, policies and practices
- Middleware and gateways experience
- Post-implementation support and resolving technical issues
- Knowledge of AODA and related regulations/standards
Full description
RQ10840 - Software Developer - ETL - Senior
Duration: 6+ Months (133 Business Days) Location: Hybrid - 3 days in office at 40 St Clair Ave WMust Have:**
- 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
Responsibilities:
- Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
- Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
- Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.