Test data / ETL

Categoría: Testing / Garantía de calidad
Ubicación principal: Canada, Ontario, Toronto
ID de Posición: J0921-1711
Tipo de empleo: Jornada Completa

Conoce a nuestros profesionales

CGI Insights you can act on

Descripción de la publicación:

CGI provides business process services, hosting, operations, maintenance and support for one of our large banking client on a number of critical line of business. As part of the services we are providing for the customer and expanding out business, the candidate will work closely with the client and the delivery leads, and will be accountable for a deliveries of the task that will be assigned which includes business requirement capturing and document creation, solution requirement document creation and also lead the JAD/POD sessions.

Delivery will be located in the Toronto area and the candidate is also expected to work at the same location along with the client team. Travel is not anticipated though may be periodically required.

Sus futuros deberes y responsabilidades:

The candidate will support the program lead, delivery leads, and project managers with completing the test design and automation for all the test cases that has been created for the program. The candidate is also expected to create the mapping diagram with all user stories and articulate the automation requirements as part of the test design to better enable the automation execution in all lower environments

The candidate will also be responsible for reviewing the work and also ensure that all the work is being delivered as per the timelines defined and agreed with the client.

• Effectively understand requirements from business and work with the internal team to create the business requirements document.
• Efficiently create the use cases for each project as per the request from client/project
• Create the flows for systems, process or any other areas needed which is demanded by the project requirement/business
• Strong experience in communicating with both business and technology team to ensure that the requirements are effectively being communicated to the technology team to meet the delivery
• Experience in both agile and waterfall methodology
• Help the testing team to ensure the requirements are properly captured
• Liaise and confer with internal and external teams when designing and implementing and integrating new technologies.
• Validate existing test cases and consolidate them from the QA standpoint.
• Assist project team in the troubleshooting of testing issues.
• Anticipates the impact of a change or project across multiple systems
• Raise defects/issues and follow up and resolve outstanding defects/issues.
• Report on test progress.
• Work with various departments in the company to ensure all product integration requirements are satisfied.
• understand data provisioning processes including collection of source data, data transfer mechanism and data upload mechanism
• Identify and test for bugs and bottlenecks in the ETL solution
• Support with developing Source-to-Staging-to-Target mappings and actively work with Development, Test and Implementation efforts
• Design data migration processes including collection of source data, data transfer mechanism and data upload mechanism
• See the big picture, and take the initiative to find and fill gaps in our processes
• Maintain appropriate levels of data security and privacy relating to user/customer data
• Proactively identifying and communicating project risks
• Plan, execute and monitor data migration tasks and activities

Calificaciones requeridas para tener éxito en este rol:

• Maintain a solid understanding of software testing best practices, methodologies, and terminologies
• Ability to write basic SQL queries
• Working experience in salesforce system or any cloud systems.
• Ability to go through the User stories and understand the technical aspects required for aspects of ETL/Data process.
• Good knowledge on SSMS & Azure Data Factory [ETL]
• Autosys along with UNIX shell script understanding
• Strong testing experience for data based programs and validating data consistency
• Good knowledge in data loader to insert/update or import/export bulk data
• Strong experience with retail banking/ECRM domain
• Good to have Salesforce system admin certification

• Team oriented
• Quick learner / adaptable
• Detail orientated
• Persistent
• Strong communicator
• Analytical
• Organized
• Time management
• Self-starter


  • Azure Data Factory
  • ETL

¿Qué esperas de nosotros?:

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.