data engineer
Posted on
September 27, 2024
by
Employer details
HRC Global Services
Job details
*Designation : Data Engineer*
*Experience Range: 12 to 16 Years *
*Hybrid work model*
*Must Have Skills:*
* ETL
* Postgre SQL
* Oracle Fusion
* Guidewire Experience
Job description:
? 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
? Ability to work both independently and as part of a team.
Job Type: Full-time
Pay: $85.00-$92.00 per hour
Benefits:
* Dental care
* Extended health care
* Paid time off
-
LocationToronto, ON
-
Workplace information
On site
-
Salary$85.00 to $92.00HOUR hourly
-
Terms of employment
Full time
-
Starts as soon as possible
- vacancies
1 vacancy
- Source
indeed.com
#9463600427
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.