data engineer
Posted on
September 30, 2024
by
Employer details
HRC Global Services
Job details
Job Profile Summary :
Data Engineer
Location: Markham, Hybrid role
Experience: 5+ years
Skills: ETL, Guidewire policy, Oracle Fusion, PostgreSQL
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.
Requirements:
? 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.
Aviva: Internal
? Above average communication and collaboration skills.
? Ability to work both independently and as part of a team.
Job Type: Full-time
Pay: $37,590.09-$53,832.37 per year
Benefits:
* Dental care
* Extended health care
* Paid time off
Schedule:
* Monday to Friday
Work Location: Hybrid remote in Toronto, ON M6J 2G5
-
LocationToronto, ON
-
Workplace information
On site
-
Salary$37,590.09 to $53,832.37YEAR annually
-
Terms of employment
Full time
-
Starts as soon as possible
- vacancies
1 vacancy
- Source
indeed.com
#9466642732
Important notice: This job posting has been provided by a partner site. Job Bank is not responsible for this content.
Report a problem with this job posting
Thank you for your help!
You will not receive a reply. For enquiries, please contact us.