Senior Software Developer ETL

Randstad

  • Toronto, ON
  • Contract
  • Full-time
  • 5 hours ago
  • Apply easily
Do you have working knowledge of issue tracking system JIRA, Azure DevOps? Do you have advanced skills and hands-on experience with Azure SQL Server and Azure Data Factory? If so, this would be a great opportunity for you!Our client is looking for a Senior Software Developer ETL for a 7 month contract in Toronto.
This is a hybrid role.Advantages
  • Earn a competitive rate within the industry
  • Potential for extension
  • Hybrid - Candidate MUST work 3 days onsite and 2 days remote. Starting October 20, resources are expected to come into the office 4 days per week. Starting January 5, resources are expected to come into the office 5 days per week. This is subject to change based on manager discretion.
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.
Qualifications
MUST HAVES:
  • Design, build, automate and optimize complex data ETL/ELT processes using PL/SQL and equivalent
  • Cloud technologies (Azure, Google, AWS)
Advanced skills and hands-on experience with Azure SQL Server and Azure Data FactoryPL/SQL for data extraction, transformation, and loading, initial setup and other ETL experience management and support, such as troubleshooting, performance tuning, failover and recovery• Working knowledge of issue tracking system JIRA, Azure DevOpsGeneral Skills:Experience in programming and analysis; specialized software package support at the specified experience levelAbility to collaborate with IT Professionals throughout the Software Development Life CycleExperience in structured methodologies for the development, design, implementation and maintenance of applicationsExperience in design, code, test, debug and document applicationsExperience in the use of object and/or third generation language development toolsExperience in one or more programming languagesExperience in application design, latest design patters, deployment and troubleshootingExperience with relational and hierarchical database technologiesExperience in the use of information retrieval packages using query languagesExperience with one or more communications protocolsExperience in structured methodologies for the design, development, implementation and maintenance of applicationsExperience eliciting and documenting information from diverse business area stakeholders and subject matter expertsExcellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skillsA team player with a track record for meeting deadlinesETL Skills:Knowledge and experience in gathering requirements and business process knowledge in order to transform the data in a way that's geared towards the needs of end usersKnowledge and experience maintaining and improving already existing processes.Knowledge and experience ensuring that the data architecture is scalable and maintainableKnowledge and experience working with the business in designing and delivering correct, high quality dataExperience investigating data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutionsExperience preparing detailed documentation for further referenceDesirable Skills:Knowledge and experience with programming Internet-ready applicationsKnowledge and experience in rapid application development (RAD) and Agile methodologiesKnowledge and understanding of Information Management principles, concepts, policies and practicesExperience with middleware and gatewaysExperience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debuggingAbility to provide post-implementation support and resolve any post-implementation technical issuesExperience conducting design walkthrough sessions with project teamKnowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standardsAbility to provide user and system documentation as requiredSummary
If you are interested in the Senior Software Developer ETL role in Toronto, please apply online at www.randstad.ca. Qualified candidates will be contacted.Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.

Randstad