Developer - Generic
City: | 40 King Street West Toronto, M5H 1H1 ON, Canada |
Title: | Developer - Generic |
Category: | |
EmploymentType: | Contract |
Description: |
Location Address: Hybrid (twice a week; usually Tuesday and Thursday)
Contract Duration: 3 months Scheduled Hours: Monday to Friday, 9am-5pm Extension Opportunity: Yes, depending on performance FTE Opportunity: Yes, depending on performance pay rate $ 55-59.25/hr. Typical Day in Role: • Conduct source data analysis and profiling to complete source to target mapping • Perform data wrangling to merge disjointed data sources and implement complex data transformation • Develop ETL process using MS SQL Server, SSIS package and MS Azure Data Factory to ingest, transform, cleanse and load data into on-prem SQL Server and/or Azure SQL DB • Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions • Logical and physical data modeling to develop highly optimized data infrastructure for fast querying of large volume of data. Assure data quality, security, and compliance requirements are met • Prepare documentation for further reference • Work with Business stakeholders for requirement gathering and collaborate with QA for test cycles • Conduct performance testing and tuning code for optimization • Responsible for code deployment to all environments including production • Provide Production Support for the current environment as required Candidate Requirements/Must-Have skills: 1. 10+ years of experience in working for large projects and have advanced experience with SQL Scripting, ETL architecture, data analysis and profiling, data mapping, data modeling, data lakes, and analytics 2. 5+ years of extensive development experience with SQL Server SSIS, Integration Services Catalog and project deployment 3. 3+ years of experience working with BitBucket or TFS, and creating DevOps pipeline 4. You have experience working with an agile scrum team Nice-To-Have Skills: • Experience with Azure ADF and Azure MI • Experience with static code scans such as Fortify, Blackduck, etc. • Previous exposure to Banking/Financial Industry backgrounds Soft Skills: • You are excellent in written and spoken English to clearly communicate complex issues and interface with all levels of the organization with ease • You are highly organized, disciplined, and responsive in a fast paced and demanding environment • You constantly and strongly demonstrate the core values that continuously advance the productivity of high-performing and self-organizing teams: respect, commitment, courage, openness, and focus • You are self-disciplined, proactive, take accountability Best vs. Average Candidate: • You are curious and highly motivated to discover new relations in business data, understand and interpret data and how to deliver business value by transforming it • Capability to provide leadership type of roles and coach others • Architecture skills and experience Education: • University degree in a technical field such as computer science, computer engineering or related IT field is an asset We thank everyone who applies. However, only those selected for an interview will be contacted. |
Company: |