ETL Developer - Informatica PowerCenter

Job Description

<p><p>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.</p><p>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.</p><p>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!</p><h3>What you'll do</h3><ul><li>Design, develop, and maintain ETL(Informatica Power Center) processes to extract, transform, and load data from various sources into our finance systems.</li><li>Develop and optimize complex SQL queries and stored procedures in PostgreSQL.</li><li>Monitor daily/monthly jobs and resolve failures (if any)</li><li>Collaborate with finance and insurance teams to understand data requirements and ensure data integrity and accuracy.</li><li>Build Qlik reports.</li><li>Perform data analysis and solve data-related issues.</li><li>Implement data quality checks and validation processes.</li><li>Provide solutions by building complexed Finance calculations using Postgres store procedure or ETL.</li><li>Monitor and improve the performance of ETL processes and database systems.</li><li>Document technical specifications and maintain comprehensive documentation of ETL processes and database schemas.</li><li>Stay up to date with the latest industry trends and best practices in ETL and database management.</li></ul><h3>What you’ll bring</h3><ul><li>Experience in the insurance industry & able to understand underwriting data terminology.</li><li>Experience in supporting finance systems.</li><li>Demonstrable experience as an ETL Developer (Informatica PowerCenter and Informatica BDM).</li><li>Experience as a PostgreSQL Developer.</li><li>Proven experience as Database Developer, hands on experience in writing DDLS and DMLS for relational databases</li><li>Experience in writing complex SQL queries for Adhoc reporting.</li><li>Expertise in ETL tools (especially Informatica) and PostgreSQL.</li><li>Strong expertise in Postgres and database design.</li><li>Knowledge of data warehousing concepts and best practices.</li><li>Experience on automation tools like Control-M, ASG ZENA Experience in writing Unix scripts.</li><li>Experience in Qlik & Python reporting. (Nice to have).</li><li>Experience with Snowflake. (Nice to have).</li><li>Excellent problem-solving skills and attention to detail.</li><li>Experience in Agile methodology & JIRA.</li><li>Good communication and collaboration skills.</li><li>Ability to work both independently and as part of a team.</li><li>Bachelor’s degree in computer science, Information Technology, or a related field preferred, but equivalent experience will also be considered.</li><li>Experience with database systems (e.g., Oracle, Postgres, MySQL). SQL Associate Certification an asset.</li><li>Knowledge of data visualization tools (e.g., Qlik, Python, Power BI) an asset.</li></ul><h3>What you’ll get</h3><ul><li>Compelling rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.</li><li>Outstanding Career Development opportunities.</li><li>We’ll support your professional development education.</li><li>Competitive vacation package with the option to purchase 5 extra days off per year.</li><li>Employee driven programs focused on gender, LGBTQ+, origins, diversity, and inclusion.</li><li>Corporate wellness programs to support our employees’ physical and mental health.</li><li>Hybrid flexible work model.</li></ul><p>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.</p><p>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.</p><p>#LI-PS1<br/>#LI-Hybrid</p></p>
#J-18808-Ljbffr