Job Title: ETL Developer
Location: Markham, ON (Hybrid)
Estimated Duration: 6 Months
Responsibilities:
• Design, develop, and maintain ETL 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 Adhoc reports as per Business requirements.
• Perform data analysis and troubleshooting to resolve 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.
Requirements:
• Experience in the insurance industry & able to understand underwriting data terminology.
• Experience in supporting finance systems.
• Proven experience as an ETL Developer (Informatica PowerCenter and Informatica BDM)
• 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.
• Experience on automation tools like Control-M, ASG ZENA Experience in writing Unix scripts.
• Experience in any Reporting tool ( SAP Business Objects, Qlik Reporting)
• Knowledge of data warehousing concepts and best practices.
• Excellent problem-solving skills and attention to detail.
• Experience in Agile methodology & JIRA.
• Above average communication and collaboration skills.
• Proficiency in drafting and comprehending business requirement documents.
• Ability to work both independently and as part of a team.
Preferred Qualifications:
• Informatica Certified Professional (ICP) and/or Informatica Foundation Level Certifications (IDMC, CDCG, MDM etc.)
• 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, SAP BO ).
The pay range that the employer reasonably expects to pay for this position is between CA$90.00 and CA$115.00
Our voluntary benefits offering includes medical, dental, vision and retirement benefits.
Applications will be accepted on an ongoing basis.
Tundra Technical Solutions would like to thank you for the interest you have demonstrated in this opportunity. However, only candidates with the required skills will be contacted.
Tundra Technical Solutions is an Equal Opportunity/Affirmative Action Employer. We welcome and encourage diversity in our workplace.
Not interested in this position, but know somebody who might be? Check out our Referral Reward Program, referrals are a big secret behind our success. As always, we’re on the lookout for great people. And we know that you know great people!
Tundra Technical Solutions is among North America’s leading providers of Information Technology and Engineering staffing and consulting services. Our success and our clients’ success are built on a foundation of service excellence. Rather than continually trying to sell to new clients and companies and simply filling databases with candidates, we focus on developing stronger relationships and deeper knowledge of our existing clients’ challenges and opportunities.
Open ears. Open minds. Open futures