Informatica Developer

We are looking for an experienced Informatica Developer with strong ETL development and data integration expertise. The ideal candidate will have hands-on experience designing, developing, testing, and maintaining ETL workflows, integrating data from multiple sources, and delivering reliable data solutions in a banking or financial services environment.

The candidate should possess strong SQL skills, data warehousing knowledge, and experience working with complex data transformations, data quality processes, and production support.

Key Responsibilities

• Design, develop, test, and maintain ETL workflows using Informatica PowerCenter.
• Develop reusable mappings, mapplets, sessions, workflows, and transformations to support data integration requirements.
• Extract, transform, and load data from multiple source systems into target databases and data warehouses.
• Write and optimize complex SQL queries, stored procedures, and database scripts.
• Perform data profiling, data validation, reconciliation, and quality checks to ensure data accuracy and consistency.
• Analyze business requirements and technical specifications to develop efficient ETL solutions.
• Troubleshoot ETL failures, investigate data discrepancies, and resolve performance-related issues.
• Optimize ETL workflows, session performance, and SQL queries to improve processing efficiency.
• Collaborate with business analysts, data engineers, database administrators, QA teams, and other stakeholders.
• Support production releases, scheduled batch processing, incident resolution, and root-cause analysis.
• Maintain technical documentation, mapping specifications, source-to-target documents, and operational procedures.
• Follow banking data governance, security, compliance, and development standards.

Required Skills and Qualifications

• 5+ years of experience in ETL development and data integration.
• Strong hands-on experience with Informatica PowerCenter.
• Proficiency in SQL, including complex joins, subqueries, analytical functions, and query optimization.
• Experience with relational databases such as Oracle, SQL Server, or DB2.
• Strong understanding of data warehousing concepts, dimensional modeling, and data integration patterns.
• Experience with ETL mappings, workflows, sessions, transformations, and scheduling.
• Knowledge of data quality, data reconciliation, error handling, and performance tuning.
• Experience with Unix/Linux shell scripting for ETL automation and support.
• Familiarity with batch processing, job scheduling, production monitoring, and incident management.
• Strong analytical, troubleshooting, communication, and problem-solving skills.