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