Senior Software Engineer - Data Integration Lead

Delivery Module Lead

Job Description

Role: Senior Software Engineer

Location : Bangalore / Mumbai (L&T)

Who are we looking for?

• A highly skilled individual with strong experience in Informatica, Control-M, Unix, Oracle, SQL with 7 + years of relevant experience.

Technical Skills:

Skill set: Informatica, Oracle, SQL, Unix, Shell Scripting,

• Agile: JIRA, Confluence
• Build: Jules
• Scheduling : Control-M, Autosys (Good to have)

Basic knowledge of Java is a plus

The ideal candidate will have a strong background in data integration and database management, with expertise in Informatica PowerCenter and Oracle SQL. This role involves supporting current asset management tools (Eagle, XSP, etc.) and maintaining data integration solutions to support our business needs, with end-to-end ownership.

60% Support / 40% Development

Key Responsibilities:

• Design, develop, and implement data integration solutions using Informatica PowerCenter.
• Experience with Control-M for job scheduling and automation.
• Write complex SQL queries and optimize Oracle SQL code for performance.
• Provide monthly one-week L1 support for the vendor application.
• Collaborate with the business team and stakeholders to understand and address data gaps during the support week.
• Perform data analysis and data profiling to ensure data quality and integrity.
• Working knowledge of basic Unix commands.
• Monitor and troubleshoot data integration processes to ensure timely and accurate data delivery.
• Develop and maintain documentation for data integration processes and solutions.
• Participate in code reviews and provide constructive feedback to team members.
• Stay updated with the latest industry trends and best practices in data integration and database management.
• Basic knowledge of Java is a plus.

Certifications Needed:

• NA

About Mphasis

Mphasis applies next-generation technology to help enterprises transform businesses globally. Customer centricity is foundational to Mphasis and is reflected in the Mphasis’ Front2Back™ Transformation approach. Front2Back™ uses the exponential power of cloud and cognitive to provide hyper-personalized (C=X2C2TM=1) digital experience to clients and their end customers. Mphasis’ Service Transformation approach helps ‘shrink the core’ through the application of digital technologies across legacy environments within an enterprise, enabling businesses to stay ahead in a changing world. Mphasis’ core reference architectures and tools, speed and innovation with domain expertise and specialization are key to building strong relationships with marquee clients.