RQ10027 - Software Developer - ETL - Senior

Job Description

<p><b>Responsibilities:</b><br></p><li>Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.<br></li><li>Required to translate technical systems specifications into working, tested applications.<br></li><li>This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.<br></li><li>Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.<br></li><p><b>General Skills:</b><br></p><li>Experience in programming and analysis; specialized software package support at the specified experience level<br></li><li>Ability to collaborate with IT Professionals throughout the Software Development Life Cycle<br></li><li>Experience in structured methodologies for the development, design, implementation and maintenance of applications<br></li><li>Experience in design, code, test, debug and document applications<br></li><li>Experience in the use of object and/or third generation language development tools<br></li><li>Experience in one or more programming languages<br></li><li>Experience in application design, latest design patters, deployment and troubleshooting<br></li><li>Experience with relational and hierarchical database technologies<br></li><li>Experience in the use of information retrieval packages using query languages<br></li><li>Experience with one or more communications protocols<br></li><li>Experience in structured methodologies for the design, development, implementation and maintenance of applications<br></li><li>Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts<br></li><li>Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills<br></li><li>A team player with a track record for meeting deadlines.<br></li><p><b> </b><br></p><p><b>ETL Skills:</b><br></p><li>Knowledge and experience in gathering requirements and business process knowledge in order to transform the data in a way thats geared towards the needs of end users<br></li><li>Knowledge and experience maintaining and improving already existing processes.<br></li><li>Knowledge and experience ensuring that the data architecture is scalable and maintainable<br></li><li>Knowledge and experience working with the business in designing and delivering correct, high quality data<br></li><li>Experience investigating data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions<br></li><li>Experience preparing detailed documentation for further reference.<br></li><p><b>Desirable Skills:</b><br></p><li>Knowledge and experience with programming Internet-ready applications<br></li><li>Knowledge and experience in rapid application development (RAD) methodologies<br></li><li>Knowledge and understanding of Information Management principles, concepts, policies and practices<br></li><li>Experience with middleware and gateways<br></li><li>Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging<br></li><li>Ability to provide post-implementation support and resolve any post-implementation technical issues<br></li><li>Experience conducting design walkthrough sessions with project team<br></li><li>Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards<br></li><li>Ability to provide user and system documentation as required<br></li>
<br><br><h3>Requirements</h3><p><b>Experience and Skill Set Requirements:</b><br></p><p><b>Must have:</b><br></p><li>Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI<br></li><li>Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)<br></li><li>Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts<br></li><li>Experience with data integration, data cleansing, and data analytics<br></li><li>Experience with data modeling and design principles for data marts and data warehouses<br></li><li>Experience in database management and administration<br></li><li>Experience in constructing complex SQL queries and performance tuning<br></li><li>Experience creating technical documentation including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.<br></li>
<br>
<b>Skill Set Requirements:</b><br><p><b>Responsibilities/Assignment Deliverables – Senior ETL Developer:</b><br></p><li>Designs, develops, and maintains database back end and ETL applications for Data Warehouse and Business Intelligence solutions.<br></li><li>Uses knowledge of ETL languages and development techniques to build and expand application functionality by writing high-quality code using appropriate patterns.<br></li><li>Ensures applications remain scalable while complying to standards and following best practices.<br></li><li>Tests and debugs applications and ensures that software is properly documented.<br></li><li>Collaborates clearly and professionally as part of a development team and communicates with clients.<br></li><p><b>Mandatory Skills:</b><br></p><li>Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI<br></li><li>Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)<br></li><li>Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts<br></li><li>Experience with data integration, data cleansing, and data analytics<br></li><li>Experience with data modeling and design principles for data marts and data warehouses<br></li><li>Experience in database management and administration<br></li><li>Experience in constructing complex SQL queries and performance tuning<br></li><li>Experience with Git and knowledge of source control strategies<br></li><li>Experience creating technical documentation including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.<br></li><li>Experience in eliciting, documenting, and validating business requirements<br></li><li>Experience in software development lifecycle from Development, to Testing and Quality Assurance, to Delivery<br></li><li>Solid communications skills: the ability to understand, comprehend, and follow instructions and requirements to communicate clearly and effectively both verbally and in writing.<br></li><p><b>Nice to have skills:</b><br></p><li>Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards<br></li><li>Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned reports (scheduled and ad-hoc)<br></li><li>Experience with programming languages such as C#, developing application code such as APIs, Functions, etc.<br></li><li>Experience writing scripts with PowerShell and other scripting languages<br></li><li>Experience in implementation of SaaS solution<br></li><p><b>Core Technical Skills:</b><br></p><li>Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI<br></li><li>Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)<br></li><li>Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts<br></li><li>Experience with data integration, data cleansing, and data analytics<br></li><li>Experience with data modeling and design principles for data marts and data warehouses<br></li><li>Experience in database management and administration<br></li><li>Experience in constructing complex SQL queries and performance tuning<br></li><li>Experience creating technical documentation including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.<br> </li>
<b>Other Technical Skills:</b><br><li>Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned reports (scheduled and ad-hoc)<br></li><li>Experience with programming languages such as C#, developing application code such as APIs, Functions, etc.<br></li><li>Experience writing scripts with PowerShell and other scripting languages<br></li><li>Experience with Git and knowledge of source control strategies<br></li><li>Experience in software development lifecycle from Development, to Testing and Quality Assurance, to Delivery<br></li><p><b>Communications Skills:</b><br></p><li>Experience in eliciting, documenting, and validating business requirements<br></li><li>Solid communications skills: the ability to understand, comprehend, and follow instructions and requirements to communicate clearly and effectively both verbally and in writing.<br></li><p><b>Standards and Best Practices:</b><br></p><li>Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards<br></li>
<br>