L2 Sr. Application Support

• Provide operational support for Informatica PowerCenter DWH applications.
• Monitor and maintain ETL workflows to ensure smooth and uninterrupted operation.
• Investigate, troubleshoot, and resolve data pipeline and workflow issues.
• Optimize ETL processes, data flows, and overall DWH performance.
• Collaborate with cross-functional teams on automation and process enhancement initiatives.
• Document processes, incidents, resolutions, and continuous improvement efforts.

• Strong analytical and problem-solving mindset.
• High attention to detail with a strong focus on data accuracy and quality.
• Excellent communication skills with the ability to explain technical concepts clearly.
• Strong stakeholder management skills.
• Ability to work effectively with cross-functional teams.
• Proactive approach toward automation and continuous improvement initiatives.

Strong hands-on experience with Informatica PowerCenter.
Solid understanding of ETL concepts and data integration processes.
Proven experience in ETL workflow management, monitoring, and maintenance.
Strong troubleshooting skills in data pipeline environments.
Proficiency in SQL for querying, analysis, and performance tuning.
Working knowledge of Unix/Linux environments and basic scripting.
Solid understanding of Data Warehouse (DWH) architecture.
Good knowledge of Data Modeling principles.
Experience in DWH performance tuning and optimization techniques.