ETL Development: Design and develop ETL processes using Informatica PowerCenter to extract, transform, and load data from multiple sources into target systems.
Data Mapping: Create and maintain comprehensive documentation for data mapping, workflows, and technical designs.
Performance Tuning: Optimize ETL processes for performance, including tuning SQL queries and Informatica mapping.
Data Quality: Implement data validation and cleansing techniques to ensure data accuracy and integrity.
Collaboration: Work closely with business analysts and stakeholders to gather requirements and deliver solutions that meet business needs.
Support & Troubleshooting: Provide support for production ETL processes, troubleshooting issues and performing root cause analysis.
Training & Mentoring: Mentor junior developers and provide training on best practices for Informatica development.
Relevant Yrs. of experience* | 8 to 10 years |
Detailed JD *(Roles and Responsibilities) | 10+ years experience working on development and support of enterprise software in a distributed environment within the financial services industry -preferably within the area of benchmark, security data in asset management |
Expertise in all aspects of the application development process, from conception to deployment | |
Develop, debug, maintain and test Informatica software applications that support the business needs of an organization. | |
Defining data warehouse architecture and determining the tools to load data into it. | |
Design and implement data integration, data quality, data profiling, data services, and data engineering solutions | |
Mandatory skills* | Informatica Developer |
Any Graduate