Data Engineer

About the Company:

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 #HumanFirstDigital.

About the Role:

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 PowerExchange, Yellowbrick (or any RDBMS), Unix Shell Scripting, and Tivoli Workload Scheduler. You will be responsible for ensuring seamless, reliable, and efficient data processing operations.

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.

Qualifications:

• 7 to 12 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.

Required Skills:

• Informatica PowerCenter and PowerExchange expertise.
• Strong SQL and database experience.
• Unix/Linux Shell Scripting proficiency.
• Tivoli Workload Scheduler experience.
• Problem-solving skills.
• Understanding of data warehousing concepts.
• Experience with ticketing tools.
• Excellent communication skills.

Preferred Skills:

• Experience with additional RDBMS platforms.
• Knowledge of data quality principles.
• Familiarity with incident management tools.

Pay range and compensation package:

Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning/upskilling experience and provide care and support for you and your loved ones. As an Apexon Associate, you get continuous skill-based development, opportunities for career advancement, and access to comprehensive health and well-being benefits and assistance.

• Group Health Insurance covering family of 4
• Term Insurance and Accident Insurance
• Paid Holidays & Earned Leaves
• Paid Parental Leave
• Learning & Career Development
• Employee Wellness

Equal Opportunity Statement:

Did you know that Apexon has been Certified by Great Place To Work, the global authority on workplace culture, in each of the three regions in which it operates: USA (for the fourth time in 2023), India (seven consecutive certifications as of 2023), and the UK. Apexon is committed to being an equal opportunity employer and promoting diversity in the workplace. We take affirmative action to ensure equal employment opportunity for all qualified individuals. Apexon strictly prohibits discrimination and harassment of any kind and provides equal employment opportunities to employees and applicants without regard to gender, race, color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other applicable characteristics protected by law. You can read about our Job Applicant Privacy policy here.

Our Commitment to Environment:

Actively contribute to Apexon's commitment to environmental responsibility by following sustainable practices and supporting ESG initiatives.