ETL Developer (Informatica PowerCenter and Informatica BDM)
About the role
Position Name – ETL Developer
Type of hiring – Fulltime
Location – Markham, ON (Hybrid - 3 days’ work from office)
Job Description:
Top Skills Required:
- Proven experience as an ETL Developer (Informatica PowerCenter (10.5.7) and Informatica Big Data Management)
- 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
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 ).
About Yochana
Yochana: Your Trusted Workforce Partner Across North America & Beyond For over 15 years, Yochana has been a leading talent acquisition firm, connecting businesses with top professionals across industries. Headquartered in Farmington Hills, Michigan, we specialize in temporary workforce solutions, permanent placements, contract-to-hire, and recruitment process outsourcing (RPO) across the USA, Canada, Mexico, and India.
At Yochana, we go beyond traditional hiring agencies—our customized recruitment strategies and AI-driven talent solutions help businesses scale faster and smarter. Whether you need IT specialists, engineering professionals, healthcare experts, logistics personnel, or niche industry talent, our extensive candidate network ensures the right fit for your business needs.
Why Yochana? ➤ End-to-End Workforce Solutions – Temporary, Permanent, Contract, RPO & On-Site Talent Acquisition ➤ Industry-Specific Hiring – IT, Healthcare, Engineering, Finance, Logistics & More ➤ Diversity & Inclusion Focus – Promoting diverse hiring and equal opportunities ➤ Expansive Global Reach – Serving businesses across USA, Canada, Mexico & India ➤ Local Expertise – Proudly based in Farmington Hills, Michigan, connecting businesses with top professionals
Looking for recruitment agencies near me? Searching for workforce solutions in Michigan? Yochana is your trusted talent acquisition partner—connecting top companies with exceptional professionals.
📍 Learn more: www.yochana.com 📩 Contact us: hello@yochana.com | 📞 +1 248-213-6465
#TalentAcquisition #WorkforceSolutions #HiringExperts #ProfessionalRecruitment #BusinessGrowth #MichiganJobs #TopTalent #USACanadaMexico #HiringNearMe #CareerOpportunities
ETL Developer (Informatica PowerCenter and Informatica BDM)
About the role
Position Name – ETL Developer
Type of hiring – Fulltime
Location – Markham, ON (Hybrid - 3 days’ work from office)
Job Description:
Top Skills Required:
- Proven experience as an ETL Developer (Informatica PowerCenter (10.5.7) and Informatica Big Data Management)
- 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
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 ).
About Yochana
Yochana: Your Trusted Workforce Partner Across North America & Beyond For over 15 years, Yochana has been a leading talent acquisition firm, connecting businesses with top professionals across industries. Headquartered in Farmington Hills, Michigan, we specialize in temporary workforce solutions, permanent placements, contract-to-hire, and recruitment process outsourcing (RPO) across the USA, Canada, Mexico, and India.
At Yochana, we go beyond traditional hiring agencies—our customized recruitment strategies and AI-driven talent solutions help businesses scale faster and smarter. Whether you need IT specialists, engineering professionals, healthcare experts, logistics personnel, or niche industry talent, our extensive candidate network ensures the right fit for your business needs.
Why Yochana? ➤ End-to-End Workforce Solutions – Temporary, Permanent, Contract, RPO & On-Site Talent Acquisition ➤ Industry-Specific Hiring – IT, Healthcare, Engineering, Finance, Logistics & More ➤ Diversity & Inclusion Focus – Promoting diverse hiring and equal opportunities ➤ Expansive Global Reach – Serving businesses across USA, Canada, Mexico & India ➤ Local Expertise – Proudly based in Farmington Hills, Michigan, connecting businesses with top professionals
Looking for recruitment agencies near me? Searching for workforce solutions in Michigan? Yochana is your trusted talent acquisition partner—connecting top companies with exceptional professionals.
📍 Learn more: www.yochana.com 📩 Contact us: hello@yochana.com | 📞 +1 248-213-6465
#TalentAcquisition #WorkforceSolutions #HiringExperts #ProfessionalRecruitment #BusinessGrowth #MichiganJobs #TopTalent #USACanadaMexico #HiringNearMe #CareerOpportunities