Software Developer - ETL Full-time Job

Is this role right for you? In this role you will:

 

• Analyzes & acquires data from primary and secondary data sources – creating mapping specifications for use by development resources
• Participate in detailed discovery of data from the source, mapping the data to the data model after thorough analysis.
• Work with Business representatives and partner to understand requirements support the development of the ELT work.
• Evaluation of data identified from multiple sources, reconcile conflicts and classification of data in logical categories
• Build expertise in various data domains and take ownership of assigned data domains and be a single point of contact
• Documents, plans for collection, data cleansing, and normalization of data
• Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats

 

Do you have the skills that will enable you to succeed in this role? We’d love to work with you if you have:

 

• Ideally 5+ years’ experience in Informatica and DataStage
• 2+ years of Unix and Windows Shell Scripting 
• Highly analytical and good understanding of databases, technical architecture, and query tools
• Experience in working with SQL and NoSQL tools
• Advance knowledge of writing complex SQL queries
• Advanced skills using Excel spreadsheet
• Experience working in Agile/ Lean delivery teams
• Ability to adapt and quickly adjust to change
• Ability to work with cross functional teams
• Should be a team player and work collaboratively
• Excellent verbal, written and presentation skills
• Troubleshoot and resolve database and application defects in a timely manner with consultation with internal and external groups as needed.
• Train and assist users at all levels.
• Analyze root causes of operational malfunctions including but not limited to batch jobs and provide resolutions.
• Analyze highly complex business requirements; generate technical specifications to design or redesign complex software components and applications.
• Act as an expert technical resource in Data Warehouse/DBs and ETL 
• Leverage industry best practices to design, test, implement and support a solution.
• Assure quality, security and compliance requirements are met for supported area.
• Be flexible and thrive in an evolving environment.
• Adapt to change quickly and adjust work accordingly in a positive manner.
• On-call responsibilities to operate as the L2 point of contact for monitoring TIDAL/EDL jobs requests may be required for weekends rotation
• Independently support existing applications and resolve issues.  

• Experience with SAS or Talend applications

• Familiarity with JIRA/SharePoint

 

What's in it for you?

 

• Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
• Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
• Upskilling through online courses, cross-functional development opportunities, and tuition assistance. 
• Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
• Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more! 

 

 

Working location condition: Hybrid

 

#LI-Hybrid

Scotiabank is one of North America's leading financial institutions, and Canada's most international bank. We provide innovative financial products and services to individuals, small and medium-size businesses, corporations and governments across Canada and around the world.