Data Integration Developer

Job title:

Data Integration Developer

Company

ProViso Consulting

Job description

Summary of day-to-day responsibilities:

• Follow all development and/or maintenance related processes, methodologies and standards
• Analyze application potential problems and recommend corrective action.
• Gain knowledge in own area, stay abreast of technology trends and developments, develop expertise in bank services, applications, infrastructure, analytical tools and techniques, business domains and their products and services.
• Produces estimates for development work and raise any areas of risk or concerns.
• Ensure all aspects of the development life cycle specific to building/ integrating applications are followed while maintaining consistent with overall design.
• Work closely with stakeholders to determine solutions, assess impact to existing work processes and systems, and pinpoint how to manage integration.
• Work collaboratively with other areas / team members to meet deliverables while following to guidelines / procedures on medium to large scale projects.
• Build and maintain effective working relationships with peers and management, and stakeholders.
• Take part in creating a positive work environment that promotes innovation, creativity, teamwork and high quality results.

Skill needed:

• Database Scripting & Development
• Advance SQL Scripting
• Transactions
• Normal Forms
• Hierarchical Queries
• Database Development
• Main and Foreign keys
• Triggers
• Indices
• Stored procedures
• ETL Programing Language and Batch Process
• Advance SSIS Development
• Control Flow Elements
• Data Flow Elements
• Event Handlers
• Connection Managers
• Variables and Expressions
• Precedence Constraints
• Parameters
• Powershell
• Advance Python Development
• Cloud Data Process
• Azure Data Factory
• Pipelines
• Activities
• Datasets
• Linked Services
• Data Flows
• Integration Runtimes
• Databricks
• Excel Data Processing
• Advance Data Development:

o VLOOKUP, CHOOSE, MID, SUMPRODUCT, INDIRECT, INDEX MATCH, OFFSET
o Charts creation
o Building formulas to manipulate text and dates
o Using the Formula ta and Functions Library
o Know how to create and use PivotTable
o Know how to use AutoFilter
o Creating and Modifying Macros

• Agile Development:

o Familiar with working in an Agile Scrum delivery process
o Understand the responsibility of role a developer plays in a Agile Scrum team

• Critical & Strategic thinking:

o Strong Problem Solving skills
o Ability to think outside the box
o Know when to Search and when to Ask

• Communication:

o Strong Interpersonal and communication on getting information through
o Excellent organization skills and the understand of the importance of transparency of priorities
o Attitude
o Always maintain outstanding professionalism
o Comfortable juggling with multiple deliverables with the “Get IT Done” philosophy
o Strong sense of Ownership and Pride in all things delivered
o Able to ensue high levels of engagement, motivation and innovation
o Demonstrates initiative, self-confidence and with the ability to work independentlyMust have:

• Advance SQL Scripting
• Advance SSIS Development
• Powershell
• Advance Python Development
• Azure Data Factory
• Databricks
• Advanced Excel
• Agile experience

Nice to have:

• Relevant Certification in Big Data or Azure Cloud
• Banking Background

Job Details12607Contract1 yearToronto

Expected salary

Location

Toronto, ON

Job date

Fri, 08 Nov 2024 23:28:31 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnearcanada.com) you saw this job posting.