ETL Developer

Job description

Position Description:

This role is hybrid and requires you to be in our Markham office 2-3 times per week - subject to change at any time.

Your future duties and responsibilities:

• Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our finance systems.
• Develop and optimize complex SQL queries and stored procedures in PostgreSQL.
• Monitor daily/monthly jobs and resolve failures (if any)
• Collaborate with finance and insurance teams to understand data requirements and ensure data integrity and accuracy.
• Build Qlik reports.
• Perform data analysis and troubleshooting to resolve data-related issues.
• Implement data quality checks and validation processes.
• Provide solutions by building complexed Finance calculations using Postgres store procedure or ETL.
• Monitor and improve the performance of ETL processes and database systems.
• Document technical specifications and maintain comprehensive documentation of ETL processes and database schemas.
• Stay up to date with the latest industry trends and best practices in ETL and database management.

Required qualifications to be successful in this role:

• Bachelor’s degree in computer science, Information Technology, or a related field.
• Experience in the insurance industry & able to understand underwriting data terminology.
• Experience in supporting finance systems.
• Knowledge in Oracle Fusion applications including sub-modules such as accounts payable, Cash management & fixed assets.
• Proven experience as an ETL Developer (Informatica PowerCenter and Informatica BDM)
• Proven experience as a PostgreSQL Developer.
• Experience in Guidewire Policy, Billing & Claims Centers.
• Experience on automation tools like Control-M, ASG ZENA Experience in writing Unix scripts.
• Experience in Qlik & Python reporting.
• Experience with Snowflake.
• Solid understanding of accounting principles (Balance sheet/P&L concepts).
• Expertise in ETL tools (especially Informatica) and PostgreSQL.
• Strong expertise in Postgres and database design.
• Knowledge of data warehousing concepts and best practices.
• Excellent problem-solving skills and attention to detail.
• Experience in Agile methodology & JIRA.
• Above average communication and collaboration skills.
• Ability to work both independently and as part of a team.

Guidewire Components Relevant to the Role:
1. BillingCenter: This module handles billing and receivables management. As a Finance Systems Data Engineer, you will work with data from BillingCenter to ensure accurate financial reporting and analysis. Data from BillingCenter helps in accurately recognizing revenue by tracking premium payments, installment plans, and receivables. This ensures that the financial statements reflect the correct revenue figures. BillingCenter data provides insights into outstanding receivables, helping in the management of cash flow and the identification of overdue accounts, which is essential for accurate financial reporting.
2. PolicyCenter: Manages policy administration, including underwriting and policy lifecycle. Understanding data from PolicyCenter can help in creating comprehensive financial reports and ensuring data integrity. Data from PolicyCenter helps in analyzing underwriting performance, including loss ratios and expense ratios, which are key metrics in financial reporting.
3. ClaimsCenter: Manages the claims process. Data from ClaimsCenter is crucial for financial analysis and reporting, especially in understanding claims reserves and payouts. ClaimsCenter data is vital for setting up and adjusting claims reserves. Accurate reserve calculations are essential for financial reporting as they impact the company’s liabilities and profitability. Tracking claims payouts and outstanding claims helps in understanding the company’s cash flow and financial health. This data is used to report on claims expenses and liabilities.
Relevance to the Role:
Data Integration: You will need to understand and integrate data from Guidewire systems into our finance systems. This involves designing ETL processes to extract, transform, and load data from Guidewire applications.
Data Analysis: Understanding the data structures and terminology used in Guidewire applications will be essential for performing accurate data analysis and troubleshooting.
Financial Reporting: Data from Guidewire systems will be used to build financial reports and perform complex financial calculations in our Corporate Reporting Engine (CRE) and Accounting Engine (AE), ensuring that the finance team has accurate and timely information.
Collaboration: You will collaborate with teams that use Guidewire applications, ensuring that data requirements are met, and that data integrity is maintained across systems.

• Informatica Certified Professional (ICP) and/or Informatica Foundation Level Certifications (IDMC, CDCG, MDM etc.)
• Experience with database systems (e.g., Oracle, Postgres, MySQL). SQL Associate Certification an asset.
• Guidewire professional certifications an asset.
• Familiarity with cloud-based data solutions (e.g., AWS, Snowflake).
• Knowledge of data visualization tools (e.g., Qlik, Python, Power BI).

!

Skills:

·  Data Engineering
·  ETL
·  Informatica
·  Insurance
·  Oracle Fusion
·  Postgre SQL
·  Python
·  QlikView
·  Snowflake

What you can expect from us:

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

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.

Come join our team—one of the largest IT and business consulting services firms in the world.