ETL Developer - Informatica PowerCenter

ETL Developer - Informatica PowerCenter page is loaded## ETL Developer - Informatica PowerCenterlocations : Markhamposted on : Posted Todayjob requisition id : R-160066Individually 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