Our client, a leader in the insurance industry, s looking for a PostgreSQL Application Integration Specialist to join their team on a permanent hire basis.BACKGROUND:This is a new role within the Finance Group. They 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 (using the underlying OCI platform and services) and Process and Reporting and solutions utilizing PostgreSQL, Informatica (BDM) and Qlik. They are transitioning from Db2 to the new PostgreSQL based solution.You are an inquisitive, 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.Advantages- Newly created position on a growing team - will be part of migration of older technology to modern platformsResponsibilitiesDUTIES:Understand the relationship between data and business outcomes and can focus on long term strategies for dataIdentify any gaps in the business requirement and assist Business Analyst to rectify the gapsImprove 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 transformationProficient reporting against Oracle Financial GL as needed.Solid understanding in Qlik reporting. Ability to create Qlik reportsKnowledge in basic accounting functionality and able to ommunicate and collaborate with finance community.Design/enhance data model for Accounting Engine-like systems to facilitate optimum data transformationSupport high level end-to-end architecture design from business requirement for Accounting Engine /Enterprise data warehouse type systemsMaintain 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 trailWork with subcontractors and Project Managers to ensure completion of agreed activitiesAdhere to Agile and development best practicesPerform analysis and defect and issue triage during project developmentQualificationsQUALIFICATIONS:- 5 + years of Postgres developer experience (must)- Hands-on experience on ETL development using Informatica PowerCenter V9.1 and BDM. ( IDEAL -will consider Postgre devloper only)5 + Years experience working with Unix and able to rewrite Shell scripts as per application logic in Unix/Linux.Solid skills in writing SQLS for any of the relational Databases (DB2,MS SQL Server, Oracle DB, Postgres, MySQL)Solid database knowledge around partitioning, stored procedures, functions, performance tuning, optimization of SQL.Have experience working on and comfortable with Database migration projects ( DB2 to Postgres or Oracle to Postgres)Experience working on any of automation tools like Autosys, ASG ZENA or Control M .P&C Insurance industry knowledge will be an added assetExtensive Knowledge of Data Modeling Concepts including Dimensional Data Modeling, Star/ Snowflake Schema Modeling.Experience on any Business Intelligence tools like SAP BO , Qlik or MicroStrategy.Ability to evaluate alternative solutions and/or workarounds.Query optimization, index management, integrity checks, statistics and isolation levels.Able to handle various 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 solutionsAn 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 environmentOutstanding communication, teamwork and collaboration skillsCritical and independent thinking skillsStrong Verbal, interpersonal and written communication and presentation skillsSummary- 5 + years of Postgres developer experience (must)- Hands-on experience on ETL development using Informatica PowerCenter V9.1 and BDM. ( IDEAL -will consider Postgre developer only)- 5 + Years experience working with Unix and able to rewrite Shell scripts in Unix/Linux.- Solid skills in writing SQLS for relational Databases (DB2,MS SQL Server, Oracle DB, Postgres, MySQL)- experience working on Database migration projects ( DB2 to Postgres or Oracle to Postgres)Randstad Canada is committed to building a diverse workforce reflective of the diversity of Canada. As a result, we promote employment equity and encourage candidates, especially those who identify as a woman, an Aboriginal person, a person with a disability or a member of a visible minority group, and any others who may contribute to the diversification of our workforce, to apply.Randstad Canada is also committed to developing an inclusive, barrier-free selection processes and work environments.If contacted in relation to a job opportunity, you should advise your Randstad Representative or your local Randstad branch in a timely fashion of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner.Information received relating to accommodation measures will be addressed confidentially.For all feedback on equity and accommodation needs, please contact your local Randstad Canada Branch.