PostgreSQL Application Integration Specialist

Job Description

We have an exciting career opportunity for hands-on PostgreSQL Specialist to work within our IT Finance Systems department in Toronto.

Supporting IFRS17/Fusion and Finance Data delivery roadmaps, and maturing into the de facto target operating model, work is non-routine and highly complex, involving the application of advanced technical/business skills. We are looking for leading contributors, individually and as team members, capable of providing direction and mentoring to others.

To support Aviva Group Finance vision we are building a platform that manages end-to-end Finance data lifecycles and aim to provide a self-service cloud-based experience for the Oracle Fusion SaaS product (leveraging the underlying OCI platform and services) and Process and Reporting and solutions utilizing PostgreSQL, Informatica (BDM) and Qlik.

You are a smart, practical PostgreSQL Database Integration Engineer with a good understanding of Financial data with deep knowledge of PostgreSQL – able to translate compute, ETL storage, networking, database & security into Finance Application solutions. You will be in the forefront of leading the effort to build scalable, fault-tolerant systems in support of our business needs and end customers. To be able to successfully migrate existing legacy systems to new platforms you are going to have solid understanding of Java and JVM mechanics. You will have Financial Services (preferably Insurance industry) knowledge and ideally be comfortable navigating ledgers and operating statements.

What you’ll do:

  • Understand the relationship between data and business outcomes and can focus on long term strategies for data
  • Identify any gaps in the business requirement and assist Business Analyst to rectify the gaps
  • Improve Informatica ETL performance for Accounting Engine and enterprise data warehouse system to shorten batch run completion time. Performance improvement from better table/index design and ETL code design.
  • Use appropriate ETL tools (listed below) to facilitate efficient data transformation
  • Support high level end-to-end architecture design from business requirement for Accounting Engine /Enterprise data warehouse type systems
  • Maintain build and release plans for new functionality and enhancements.
  • Introduce and familiarize effective software development practices, coding standards and methodologies aimed at controlling costs and delivering quality solutions on a timely basis while building a strong well-motivated development team.
  • Maintain reconciliation procedure to facilitate audit trail
  • Work with subcontractors and Project Managers to ensure completion of agreed activities
  • Adhere to Agile and development best practices
  • Perform analysis and defect and issue triage during project development

What you’ll bring: 

  • Hands-on experience on ETL development using Informatica PowerCenter V9.1 and BDM.
  • 5 + years of Postgres developer experience
  • 5 + Years experience working with Unix and able to rewrite Shell scripts as per application logic in Unix/Linux.
  • Strong skills in writing SQLS for any of the relational Databases (DB2,MS SQL Server, Oracle DB, Postgres, MySQL)
  • Have experience working on Database migration projects ( DB2 to Postgres or Oracle to Postgres)
  • Ability to evaluate alternative solutions and/or workarounds.
  • Query optimization, index management, integrity checks, statistics and isolation levels.
  • Able to handle multiple tasks in a fast paced environment.
  • Good Understanding of Software Development Lifecycle (SDLC) (Agile, Waterfall, Iterative)
  • A consistent track record in building and maintaining a reliable, high performance data pipeline that processes a large amount of structured data from various sources.
  • Experience being a member of a design, development project team crafting Business Intelligence and reporting solutions
  • An appetite for problem solving with a creative and resourceful approach to finding the right solution for the job.
  • Ability to lead multiple responsibilities with tight deadlines in a fast-paced agile environment
  • Strong communication, teamwork and collaboration skills
  • Critical and independent thinking skills
  • Strong Verbal and written communication and presentation skills

What you’ll get:

  • Competitive rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.
  • Exceptional Career Development opportunities.
  • We’ll support your professional development education.

Any interested party, please forward your resume  and cover letter to: canadaresume@gmail.com