ETL Developer - Informatica PowerCenterAviva • Markham, York Region, CA
ETL Developer - Informatica PowerCenter
Aviva • Markham, York Region, CA
30+ days ago
Job type
- Full-time
Job descriptionExperience 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. 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.
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
What you’ll get
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
Create a job alert for this search
Etl Developer • Markham, York Region, CA
Similar jobs
Job Description • • • •You will be working on a 100% remote schedule as part of Fidelity’s dynamic working arrangement.Current work authorization for Canada is required for all openings.This is a • •Fix...Show more
RQ09197 - Software Developer - ETL - Senior About the job RQ09197 - Software Developer - ETL - Senior Hybrid Work Environment : The successful candidate is expected to work onsite at 222 Jarvis St 3...Show more
Job Description You will be working on a 100% remote schedule as part of Fidelity’s dynamic working arrangement.Current work authorization for Canada is required for all openings.At Fidelity, we’ve...Show more
DataStage ETL Developer needed for SDLC, data warehousing, and BI applications.Requires 5+ years of experience with DataStage, SQL, and UNIX commands.Show more
Software Developer ETL 9467-1315.Foilcon 1 day ago Be among the first 25 applicants Join to apply for the.Software Developer ETL 9467-1315.
Foilcon HM Note : This hybrid contract role is three (3) da...Show more
IT consulting firms with operations in US, Canada, Mexico & India.SAT is an Oracle Gold Partner, SAP Services Partner & IBM Certified enterprise.
All SA Technologies requirements are Direct Client R...Show more
A technology company in Toronto is seeking a skilled ETL Developer to design and maintain data integration processes.This role requires expertise in Azure Data Factory and Informatica PowerCenter, ...Show more
Overview Join to apply for the.Design, develop, and implement ETL processes using Informatica to extract, transform, and load data from multiple sources into data warehouses or other data repositor...Show more About the job RQ08100 : Software Developer - ETL General Responsibilities This role is responsible for designing, developing, maintaining, and optimizing ETL (Extract, Transform, Load) processes in ...Show more 
ShoreWise Consulting is a world class IT solution provider offering technology solutions and managed services in verticals such as Customer Contact, Healthcare and Finance (banking & trading).Inves...Show more A leading financial services firm is looking for a skilled ETL Developer to work on remote data integration solutions.This role involves supporting and enhancing data applications using Informatica...Show more 
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.
Overview Join to apply for the...Show more
Get AI-powered advice on this job and more exclusive features.Who We Are Born digital, UST transforms lives through the power of technology.
We walk alongside our clients and partners, embedding inn...Show more A global technology provider is seeking an ETL Informatica Developer to lead data integration initiatives remotely in Canada.
The ideal candidate should possess strong ETL / SQL development skills, de...Show more A leading IT consulting firm is seeking a Data Warehouse Developer in Canada.The ideal candidate will have 5-7 years of hands-on experience with ETL solutions using Informatica PowerCenter and a st...Show more 
ETL Developer - Informatica PowerCenter page is loaded## ETL Developer - Informatica PowerCenterlocations : Markhamposted on : Posted 2 Days Agojob requisition id : R-160066Individually we are p...Show more
A remote data solutions company is looking for an experienced ETL / Data Movement Developer to join their team.The role involves designing, developing, and maintaining ETL processes using Informati...Show more We are currently seeking an ETL developer to design, develop, and maintain ETL processes for data integration and transformation.
Full-Time / Contract This is an onsite role located in Toronto, requir...Show more
ETL Developer
Fidelity International • Toronto, Canada
Temporary
Last updated: 2 hours ago • Promoted • New!
RQ09197 - Software Developer - ETL - Senior
Rubicon Path • Toronto, Canada
Full-time
Last updated: 2 hours ago • Promoted • New!
ETL Developer
Fidelity Canada • Toronto, Canada
Full-time
Last updated: 30+ days ago • Promoted
Contract Datastage Etl Developer — Informatica Expert - $32.4 - $50.6 An Hour
Akkodis group • Toronto, Canada, CA
Full-time
Last updated: 1 day ago • Promoted
Software Developer ETL 9467-1315
Foilcon • Toronto, Canada
Full-time
Last updated: 2 hours ago • Promoted • New!
Informatica ETL Developer
SA TECHNOLOGIES • Toronto, Canada
Full-time
Last updated: 2 hours ago • Promoted • New!
ETL Developer - ADF & Informatica | Onsite Toronto
CloudVital • Toronto, Canada
Full-time
Last updated: 2 hours ago • Promoted • New!
Informatica Developer
J&M Group • Toronto, Canada
Full-time
Last updated: 2 hours ago • Promoted • New!
RQ08100 : Software Developer - ETL
Rubicon Path • Toronto, Canada
Full-time
Last updated: 2 hours ago • Promoted • New!
Guidewire ETL Developer
ShoreWise Consulting • Toronto, Canada
Full-time
Last updated: 2 hours ago • Promoted • New!
Remote ETL Developer — Snowflake & Oracle Expert
Fidelity International • Toronto, Canada
Remote
Full-time
Last updated: 2 hours ago • Promoted • New!
ETL Developer - Informatica PowerCenter
Aviva Canada • Toronto, Canada
Full-time
Last updated: 2 hours ago • Promoted • New!
ETL Informatica Developer
UST • Toronto, Canada
Full-time
Last updated: 2 hours ago • Promoted • New!
Remote ETL Informatica Developer — Snowflake & DBT Expert
UST • Toronto, Canada
Remote
Full-time
Last updated: 2 hours ago • Promoted • New!
Senior Informatica ETL Developer — Data Warehouse Expert
SA TECHNOLOGIES • Toronto, Canada
Full-time
Last updated: 2 hours ago • Promoted • New!
ETL Developer - Informatica PowerCenter
Aviva plc • Markham, York Region, CA
Full-time
Last updated: 30+ days ago • Promoted
Remote Informatica PowerCenter ETL Developer
Compunnel, Inc. • Toronto, Canada
Remote
Full-time
Last updated: 2 hours ago • Promoted • New!
ETL Developer
CloudVital • Toronto, Canada
Full-time
Last updated: 2 hours ago • Promoted • New!