Candidate should be flexible to work in shift timings based on project requirements.
Role Summary
We are looking for an experienced Informatica Developer with strong expertise in Informatica PowerCenter, SQL, and Unix, along with extensive experience in Data Warehousing and the Banking domain. The candidate should be capable of working in a fast-paced production support and development environment and collaborate effectively with global teams.
Key Responsibilities
- Design, develop, enhance, and support ETL solutions using Informatica PowerCenter.
- Develop and optimize complex SQL queries, stored procedures, and database objects.
- Perform data analysis, data validation, and reconciliation activities.
- Work on Data Warehousing projects involving data integration, transformation, and reporting.
- Analyze business requirements and translate them into technical solutions.
- Troubleshoot and resolve ETL, database, and production issues.
- Collaborate with business users, analysts, and cross-functional teams.
- Ensure adherence to data quality, security, and governance standards.
- Participate in production support activities and shift-based operations.
Required Skills
- 7 to 8 years of hands-on experience in Informatica PowerCenter.
- Strong proficiency in SQL and performance tuning.
- Positive experience in Unix/Linux shell scripting.
- Strong understanding of Data Warehousing concepts, ETL architecture, and data modeling.
- Proven experience in the Banking/Financial Services domain.
- Experience in production support and incident management.
- Excellent analytical, problem-solving, and communication skills.
Preferred Skills
- Knowledge of Microsoft Copilot and Generative AI (GenAI) concepts and use cases.
- Exposure to cloud-based data platforms and modern data engineering practices.
- Experience working in Agile delivery models.