Developer - Generic

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.