Data Engineer - Production Support -3-7 Year exp - Pune | Hyd

Position               :  Data Engineer (ETL Informatica Powercenter)

Work Location   :

Interview Mode  : 1st round Virtual (Assessment Test)   | 2nd round (Technical round) | 3rd Round F2F at Apexon office

Job Summary:

Key Responsibilities:

• Provide L2/L3 production support for complex ETL/data integration workflows using Informatica PowerCenter and PowerExchange.
• Monitor and troubleshoot ETL failures, data quality issues, and performance problems in batch and real-time pipelines.
• Support and maintain data pipelines involving Yellowbrick/ Netezza or other RDBMS platforms.
• Develop and enhance Unix Shell Scripts to automate operational and support tasks.
• Manage job scheduling, dependencies, and batch cycles using Tivoli Workload Scheduler (TWS).
• Perform incident triage, root cause analysis, and implement long-term fixes.
• Collaborate with development, infrastructure, and business teams to resolve issues and drive stability.
• Maintain and update operational documentation, SOPs, and knowledge base articles.
• Participate in on-call rotation and adhere to SLA and escalation procedures.

Required Skills and Experience:

• 4 to 8 years of experience in Data Engineering/ETL with a strong focus on L2/L3 support.
• Expertise in Informatica PowerCenter and PowerExchange (including support for mainframe, flat files, and RDBMS sources/targets).
• Strong SQL and database experience with Yellowbrick or any other RDBMS (e.g., Netezza, Oracle, PostgreSQL, SQL Server).
• Proficient in Unix/Linux Shell Scripting.
• Hands-on experience with Tivoli Workload Scheduler (TWS) or equivalent job scheduling tools.
• Strong problem-solving skills for production issue analysis and resolution.
• Understanding of data warehousing concepts, job orchestration, and data quality principles.
• Experience with ticketing and incident management tools like ServiceNow or JIRA.
• Excellent communication, documentation, and coordination skills.

About Apexon: