Sr. Data Stage Developer

Category: Software Development/ Engineering
Main location: Canada, Ontario, Toronto
Position ID: J0722-0269
Employment Type: Full Time

Position Description:

The Retail Credit and Payment Systems team is looking for an experienced Datastage Developer to join the fast paced and exciting world of credit data platform development. The position “IBM Datastage SME” will be accountable for desigining, developing and supporting data stage solutions to accommodate near real time data processing requirements.
What will you do?
• Convert the functional requirement into ETL solution and technical design
• Preparation of ETL mapping documents and technical design document
• Perform PoC before adopting a solution
• Works with solution architecture team to finalize the solution approach
• Develop the ETL code & necessary SQL Scripts according to the specifications
• Preparation of unit test cases
• Develop DS Wrapper Unix scripts to invoke the Datastage job
• UAT batch executions and gather stats/test results
• Participate in the UAT meetings and resolve any issues that arises and drive the project to closure
• Prod readiness and cut over activities and GO LIVE
• Warranty support after production deployment
• Plan and transfer knowledge to production support
• Guide and coach junior team members
What do you need to succeed?
• Extensive coding experience with Datastage ETL tools and schedule datastage jobs in micro batches
• Strong experience with RDBMS, SQL specifically with MSSQL Server
• Good experience in UNIX command line and shell scripting
• Coding experience with event platform (Kafka) , API and mainframe and familiarity with cloud concepts
• Experience with DevOps tools and technologies
• A solid track record of accomplishments in systems design, deployment, troubleshooting, and tuning
• A minimum of 8 years of application instrumentation systems design, deployment and support experience is required
• Understanding of CDC technologies like SQData and Qlik Replicate
• Experience in working an agile environment
• Work experience with financial organization
What’s in it for you?
• We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual
• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
• Leaders who support your development through coaching and managing opportunities
• Ability to make a difference and lasting impact
• Work in a dynamic, collaborative, progressive, and high-performing team
• A world-class training program in financial service


  • DevOps
  • ETL
  • SQL
  • RDBMS Concepts

What you can expect from us:

Insights you can act on

While technology is at the heart of our clients’ digital transformation, we understand that people are at the heart of business success.

When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes. We call our employees "members" because they are CGI shareholders and owners and owners who enjoy working and growing together to build a company we are proud of. This has been our Dream since 1976, and it has brought us to where we are today — one of the world’s largest independent providers of IT and business consulting services.

At CGI, we recognize the richness that diversity brings. We strive to create a work culture where all belong and collaborate with clients in building more inclusive communities. As an equal-opportunity employer, we want to empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist.

Ready to become part of our success story? Join CGI — where your ideas and actions make a difference.