Search jobs > Toronto, ON > Etl developer

Senior Developer with Data stage ETL

Scotiabank
Toronto, ON, CA
$100K a year (estimated)
Full-time

Is this role right for you?

  • Support of design and development of new regulatory and risk requirements from our business partners
  • Updating existing DataStage routines to support downstream consumers of business banking data
  • Deploying updated programs to various environments
  • Design and develop Data Stage routines
  • Identify complex process and systems solutions to address major system needs
  • Design and develop Unix Shell scripting and writing complex SQL queries
  • Debug, troubleshoot and performance tune the Data Stage jobs
  • Write unit tests, mocks, participate in code reviews
  • Perform change management activities such as source code management, creating activity records for production implementation, creating implementation plans

Do you have the skills that will enable you to succeed in this role?

  • At least 8+ years of strong Data stage ETL experience.
  • Candidate should be able to work independently by understanding the design document and handle application development, testing and QA support.
  • Prior XML knowledge (reading from XML files and writing to XML files) would be added advantage.
  • Should be able to design, develop and test the Data Stage Jobs (Server, Parallel, Sequence)
  • Strong SQL knowledge and skilled and experienced in working with relational database structures
  • Should be able to design and implement Data warehousing applications
  • Should be able to design and create Unix shell scripts for the given requirements
  • Should be able to design and create SQL query for the given requirements
  • Strong Database modelling experience.
  • Banking / Financial Risk experience.
  • Experience working in Agile environment

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!

Work arrangements : Hybrid

LI-Hybrid

30+ days ago
Related jobs
S.i. Systems
Toronto, Ontario

Senior Java (Spring Boot) Developer with GCP, data structures, Redis and reactive programming experience to develop new features and backend capabilities to their eCommerce website. Enhance GCP cloud capabilities with experience in logging, tracing, and observability. Java Development with Spring Bo...

Mediabistro
Toronto, Ontario

Work with marketing, integration, and data technologies to design and implement new customer experience strategies and solutions for clients,. Customer Data Platform technologies : Salesforce Data Cloud, Adobe Experience Platform. We combine our strength in technology and leadership in cloud, data a...

Arctic Wolf
Remote, Canada
Remote

Senior Developer - Data Ingestion & Pipeline. Have experience with databases, and database schema design (specifically PostgreSQL or another enterprise quality DB). We are growing rapidly, with our data volume increasing exponentially. We are looking for experienced developers to join our pack and w...

Project X
Toronto, Ontario

Qualifications: 5+ years of experience in a Data Architect role or similar position with a focus on data management, data governance, and architecture design. Collaborate with stakeholders to understand their data needs and provide solutions that enhance business intelligence, reporting, and data go...

S.i. Systems
Toronto, Ontario

Our Concord based Client requires the services of a Senior developer/tech Lead with expertise in SQL, Angular, C#,. Assist with requirement gathering. Follow agile methodology, report progress and communicate effectively with project manager, users and other team members. Coordinate and organize the...

KPMG-Canada
Toronto, Ontario

Ability to collaborate closely with functional consultants, business analysts, developers, and project managers to understand requirements and deliver data conversion solutions aligned with project objectives. Are you a talented leader with a proven track record for motivating teams and delivering e...

S.i. Systems
Toronto, Ontario

Strong experience with AG Grid, enhancing data presentation and user interaction in data-intensive applications. Net Core) Developer (10+ years) with strong backend experience to upgrade a complex application in a Cloud environment. Strong experience with at least two of the following: JavaScript, T...

NTT DATA Services
Toronto, Ontario
Remote

Senior Developer - Point of contact between IT and key business users / senior leadership in defining IT solution based on business needs. NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. Senior Mulesoft Developer (w/SalesForce) - REMOTE. Must hav...

E-Solutions
Markham, Ontario

Role: ETL Data Testing with Finance background. With 3-9 years of Hands-on experience in QA (ETL Testing) / test case development, Creating Test Scripts, Test Execution, Defects & status reporting. Candidate should be able to perform the back end testing along with the ETL and validate the source an...

Lorven Technologies
Toronto, Ontario

Senior Python Developer with AWS. Manage timelines/deliverables within the team towards the successful delivery of projects. Design software solutions by interacting with portfolio managers, traders, operations staff and peers to understand requirements. Develop solutions that are in line with clien...