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