Senior Data Engineer

Job Summary:

We are seeking a highly skilled Lead/Senior Data Engineer to provide L2 and L3 production support for enterprise-scale data platforms. The ideal candidate should have strong experience in Informatica PowerCenter, Informatica Power Exchange, Yellow brick (or any RDBMS), Unix Shell Scripting, and Tivoli Workload Scheduler. You will be responsible for ensuring seamless, reliable, and efficient data processing operations.

Key Responsibilities:

• Provide L2/L3 production support for complex ETL/data integration workflows using Informatica PowerCenter and Power Exchange.
• Monitor and troubleshoot ETL failures, data quality issues, and performance problems in batch and real-time pipelines.
• Support and maintain data pipelines involving Yellow brick/ 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 Power Exchange (including support for mainframe, flat files, and RDBMS sources/targets).
• Strong SQL and database experience with Yellow brick 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:

Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation.Apexon brings together distinct core competencies in AI, analytics, app development, cloud, commerce, CX, data, DevOps, IoT, mobile, quality engineering and UX, and our deep expertise in BFSI, healthcare, and life sciences – to help businesses capitalize on the unlimited opportunities digital offers. Our reputation is built on a comprehensive suite of engineering services, a dedication to solving clients’ toughest technology problems, and a commitment to continuous improvement. Backed by Goldman Sachs Asset Management and Everstone Capital, Apexon now has a global presence of 15 offices (and 10 delivery centers) across four continents. We enable #HumanFirstDigitalOur Website - https://www.apexon.com/