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

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 ).