Your future duties and responsibilities
- At least 5 years of experience in ETL development within a Data Warehouse.
- Experience in ETL development within a Data Warehouse.Python/PySpark, DataStage ETL and SQL, AWS and Azure, preferably Snowflake. AWS Certified Solutions Architect Associate, AWS Certified DevOps Engineer Professional and/or AWS Certified Solutions Architect Professional.
- Deep understanding of enterprise data warehousing best practices and standards.
- Strong experience in software engineering comprising of designing, developing and operating robust and highly-scalable cloud infrastructure services.
- Strong experience with Python/PySpark, DataStage ETL and SQL development.
- Proven experience in cloud infrastructure projects with hands on migration expertise on public clouds such as AWS and Azure, preferably Snowflake.
- Knowledge of Cybersecurity organization practices, operations, risk management processes, principles, architectural requirements, engineering and threats and vulnerabilities, including incident response methodologies.
- Understand Authentication & Authorization Services, Identity & Access Management.
- AWS Certified Solutions Architect Associate, AWS Certified DevOps Engineer Professional and/or AWS Certified Solutions Architect Professional
- Experience defining future state roadmaps for data warehouse applications.
- Experience leading teams of developers within a project.
- Experience in financial services (banking) industry.
- Translate requirements and data mapping documents to a technical design.
- Develop, enhance and maintain code following best practices and standards.
- Create and execute unit test plans. Support regression and system testing efforts.
- Debug and problem solve issues found during testing and/or production.
- Communicate status, issues and blockers with project team.
- Support continuous improvement by identifying and solving opportunities.
Required qualifications to be successful in this role
- CA7 scheduling tool knowledge is good to have.
- Good knowledge of Unix and SQLs is required.
- CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodation for people with disabilities in accordance with provincial legislation. Please let us know if you require reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.
