Job Description
Arthur Grand Technologies is currently seeking a highly motivated and skilled Software Developer - ETL - Seniorfor one of our client
Position: Software Developer - ETL - Senior
Location: Toronto, Ontario (Hybrid)
Duration: Long Term Contract
Mandatory Skills:
- Experience with the Microsoft suite of technology including Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI
- 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)
- Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
- Experience with data integration, data cleansing, and data analytics
- Experience with data modeling and design principles for data marts and data warehouses
- Experience in database management and administration
- Experience in constructing complex SQL queries and performance tuning
- Experience with Git and knowledge of source control strategies
- Experience creating technical documentation including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.
- Experience in eliciting, documenting, and validating business requirements
- Experience in software development lifecycle from Development, to Testing and Quality Assurance, to Delivery
- Solid communications skills: the ability to understand, comprehend, and follow instructions and requirements to communicate clearly and effectively both verbally and in writing.
Software Developer - Senior - Evaluation Criteria
Core Technical Skills
- Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI
- 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)
- Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
- Experience with data integration, data cleansing, and data analytics
- Experience with data modeling and design principles for data marts and data warehouses
- Experience in database management and administration
- Experience in constructing complex SQL queries and performance tuning
- Experience creating technical documentation including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.
Other Technical Skills
- Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned reports (scheduled and ad-hoc)
- Experience with programming languages such as C#, developing application code such as APIs, Functions, etc.
- Experience writing scripts with PowerShell and other scripting languages
- Experience with Git and knowledge of source control strategies
- Experience in software development lifecycle from Development, to Testing and Quality Assurance, to Delivery
Communications Skills
- Experience in eliciting, documenting, and validating business requirements
- Solid communications skills: the ability to understand, comprehend, and follow instructions and requirements to communicate clearly and effectively both verbally and in writing.
Standards and Best Practices 5%
- Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
About Arthur Grand Technologies:
Arthur Grand Technologies is a leading provider of staffing and technology consulting services. Our company is managed by a team of professionals who have worked for big 5 consulting firms for 20+ years. We are a minority-owned staff augmentation and technology consulting company.
At Arthur Grand Technologies, we value our employees & contractors and strive to provide them with challenging, interesting work, market-relevant benefits, and opportunities for professional growth. If you have the necessary qualifications, and are excited to join a dynamic team, please send your resume to gayathri.dwaragan@arthurgrand.comfor immediate consideration.
Thank you for considering Arthur Grand Technologies. We look forward to hearing from you soon.
Best regards,
Gayathri Dwaragan
gayathri.dwaragan@arthurgrand.com
Arthur Grand Technologies Inc
www.arthurgrand.com
Arthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)
Job Type: Fixed term contract
Schedule:
Ability to commute/relocate:
- Toronto, ON: reliably commute or plan to relocate before starting work (required)
Education:
- Bachelor's Degree (preferred)
Language:
Apply
Go Back