ETL Developer

ETL Developer - Informatica PowerCenter page is loaded## ETL Developer - Informatica PowerCenterlocations: Markhamposted on: Posted Todayjob requisition id: R- Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.We are seeking a dedicated ETL Developer / Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team.If you would like to be part of a leading company in the insurance industry, dedicated to providing top-notch financial solutions, then come join our team**What you'll do**:* Design, develop, and maintain ETL(Informatica Power Center) 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 solve 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.**What you'll bring:*** Experience in the insurance industry & able to understand underwriting data terminology.* Experience in supporting finance systems.* Demonstrable experience as an ETL Developer (Informatica PowerCenter and Informatica BDM)* Experience as a PostgreSQL Developer.* Proven experience as Database Developer, hands on experience in writing DDLS and DMLS for relational databases* Experience in writing complex SQL queries for Adhoc reporting.* Expertise in ETL tools (especially Informatica) and PostgreSQL.* Strong expertise in Postgres and database design.* Knowledge of data warehousing concepts and best practices.* Experience on automation tools like Control-M, ASG ZENA Experience in writing Unix scripts.* Experience in Qlik & Python reporting. (Nice to have).* Experience with Snowflake. (Nice to have).* Excellent problem-solving skills and attention to detail.* Experience in Agile methodology & JIRA.* Good communication and collaboration skills.* Ability to work both independently and as part of a team.* Bachelor’s degree in computer science, Information Technology, or a related field preferred, but equivalent experience will also be considered.* Experience with database systems (e.g., Oracle, Postgres, MySQL). SQL Associate Certification an asset.* Knowledge of data visualization tools (e.g., Qlik, Python, Power BI) an asset.**What you’ll get*** Compelling rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.* Outstanding Career Development opportunities.* We’ll support your professional development education.* Competitive vacation package with the option to purchase 5 extra days off per year.* Employee driven programs focused on gender, LGBTQ+, origins, diversity, and inclusion.* Corporate wellness programs to support our employees’ physical and mental health.* Hybrid flexible work model.Please note that we may use AI tools to help us through the recruitment process. This is an existing position which has been posted both internally & externally.Aviva Canada has an accommodation process in place to provide accommodations for employees with disabilities. If upon commencement of employment you require a specific accommodation because of a disability, please contact your Talent Acquisition Partner so that an appropriate accommodation can be arranged. This process applies throughout your career with Aviva Canada.#LI-PS1 #LI-Hybrid#J-18808-Ljbffr