Informatica System Analyst- L2/L3

We are seeking an experienced Informatica System Analyst to support enterprise data warehousing initiatives within the banking domain. The role involves system analysis, solution design, ETL development, and L2/L3 production support across complex data platforms including Informatica, Teradata, Hadoop, and Oracle. The ideal candidate will act as a bridge between business stakeholders and technical teams, translating business requirements into scalable, high-quality data solutions while ensuring data integrity and adherence to governance standards.                                                                     

Informatica Certification is mandatory, along with hands-on experience in Teradata (TD) or Hadoop (HD) & Oracle — any one is mandatory.                                                                     

Key Responsibilities                 

• System Analysis & Solution Design — Perform end-to-end system analysis, solution design, and implementation for Enterprise Data Warehouse (EDW) projects. Gather and translate business requirements into functional specifications and technical designs.                                                                     
• ETL Development & Optimization — Design, develop, and implement ETL processes using Informatica PowerCenter / IICS. Ensure accurate extraction, transformation, and loading of data from various source systems into target databases. Optimize ETL processes for performance and data quality.                                                                     
• L2/L3 Production Support — Provide L2/L3 support including incident management, root cause analysis (RCA), and performance tuning of data pipelines. Monitor and troubleshoot production issues related to ETL jobs and data integration failures.                                                                     
• Data Modeling & Mapping — Design and review data models, data marts, data flows, and data mappings aligned with business requirements. Work on OLTP and OLAP processes to ensure efficient data retrieval and reporting.                                                                     
• Data Platform Management — Support and manage data platforms including Teradata, Hadoop (Hive), and Oracle (at least one). Ensure data consistency, accuracy, and integrity across data lake and warehouse environments.                                                                     
• Governance & Compliance — Ensure adherence to SDLC, ITSM/ITSC, and data governance standards. Maintain comprehensive documentation for ETL processes, data mappings, transformations, and technical designs.                                                                     
• Automation & CI/CD — Drive automation and continuous improvement initiatives. Work with CI/CD tools (Jira, Jenkins, Bitbucket) for deployment and release management.                                                                     
• Stakeholder Collaboration — Collaborate with business analysts, data architects, data scientists, and cross-functional teams to deliver high-quality data solutions. Participate in Agile sprint planning, estimation, and retrospectives.                                                                     
• Mentoring — Mentor and guide junior team members on best practices in ETL development, data integration, and system analysis.                                                                                                                                  

Skills Requirements                                                                                                                              

1. Informatica (Certified)   Informatica Certification is mandatory. Strong hands-on experience with Informatica PowerCenter / IICS (Data Integration, CDI, CAI, CDQ).                                                               
2. Teradata OR Hadoop (Hive) & Oracle   Hands-on experience in at least one: Teradata (TD) or Hadoop (HD/Hive) & Oracle. Any one is mandatory.                                                               
3. SQL & PL/SQL   Strong proficiency in SQL and PL/SQL for data manipulation, querying, stored procedures, and performance tuning.                                                               
4. Data Warehousing Concepts   Strong knowledge of data modeling, data marts, star/snowflake schema, SCD Type-1 & Type-2, and ETL best practices.                                                               
5. Banking / Financial Domain   Prior experience in the banking or financial services domain is mandatory.                                                               
6. SDLC & Release Management   Understanding of SDLC, release management, IT support processes, and governance standards.                                                               
7. Unix/Linux Shell Scripting   Experience with Unix/Linux environments and shell scripting for automation and scheduling.