Specialist, Software Engineer [Informatica & Teradata] - 098713

Nationwide; Hyderabad; Hybrid; INR 2,800,000 - 4,200,000; Full time

Job summary

Nationwide Mutual Insurance in Hyderabad is seeking a seasoned Software Engineer to lead a team of developers offshore and drive strategic data initiatives. This role supports Sales Data Mart and Sales IQ applications and requires strong technical leadership and coordination across functions.

Candidates should have hands-on experience with ETL, data warehousing, and modern data platforms, along with excellent communication and collaboration skills to align business needs with scalable solutions.

Qualifications

• 6+ years hands-on Informatica, Teradata, SQL, and Perl experience.
• Experience with cloud-based data platforms and Databricks.
• Strong understanding of data modeling, data warehousing, and performance tuning.
• Familiarity with version control systems and CI/CD pipelines.
• Proven track record in leading projects and solving complex technical challenges.
• Strong communication and analytical skills.
• Experience in Agile methodologies and cross-functional collaboration

Responsibilities

• Design, develop, and maintain ETL pipelines using Informatica, Teradata, SQL, Perl, and Databricks.
• Lead development efforts and mentor junior team members.
• Collaborate with stakeholders to define and deliver effective data solutions.
• Troubleshoot production issues and perform root cause analysis.
• Manage competing priorities in a fast-paced environment.
• Support application run operations and perform data analysis.
• Optimize data workflows for performance and scalability.
• Ensure data quality, integrity, and governance across systems.
• Document technical designs, processes, and standards.
• Experience with Universal Automation Center (UAC).

Skills

Informatica

Teradata

SQL

Perl

Databricks

Leadership

Agile

Communication

Tools

CI/CD

Version control

UAC

Cloud platforms

Job description

Nationwide Mutual Insurance, a Fortune 100 company with nearly a century of strength,

stability, and purpose-driven innovation, is expanding its global technology footprint.

Our Global Capability Centre (GCC) in Hyderabad plays a strategic role in delivering

secure, scalable, and customer-focused digital solutions that support millions of

individuals and businesses across the U.S.

The Nationwide Property and Casualty Sales Technology Solutions team is seeking a

seasoned Software Engineer to lead a team of developers offshore and drive strategic data

initiatives.

This resource will support Sales Data Mart and Sales IQ applications.

This role requires strong technical expertise, leadership skills, and the ability to work

across functions to align business needs with scalable solutions.

Candidates should have strong communication skills and work well within a team

Applicants must have strong analytical skills, the ability to troubleshoot, ability to prioritize

tasks as well as multitask, and communicate effectively with internal and external

stakeholders will be key.

Tosca, Oracle & SQL server.

Key Responsibilities

• Design, develop, and maintain ETL pipelines using Informatica, Teradata, SQL, Perl, and Databricks.
• Lead development efforts and mentor junior team members.
• Collaborate with stakeholders to define and deliver effective data solutions.
• Troubleshoot production issues and perform root cause analysis.
• Manage competing priorities in a fast-paced environment.
• Support application run operations and perform data analysis.
• Optimize data workflows for performance and scalability.
• Ensure data quality, integrity, and governance across systems.
• Document technical designs, processes, and standards.
• Experience with Universal Automation Center (UAC).

Qualifications

• Over 6 years of hands-on experience with Informatica and strong proficiency in Teradata, SQL and Perl.
• Experience with cloud-based data platforms and tools (Databricks preferred).
• Strong understanding of data modeling, data warehousing, and performance tuning.
• Familiarity with version control systems and CI/CD pipelines.
• Proven track record in leading projects and solving complex technical challenges.
• Strong communication and analytical skills.
• Experience in Agile methodologies and cross-functional collaboration

Working Hours

Aligned to India business hours with flexibility for global collaboration.

Location Flexibility

[Hybrid/Remote/In-office] with periodic in-office collaboration.

Equal Opportunity Statement

Nationwide is committed to diversity and inclusion. All qualified applicants will be considered without regard to race, gender, disability, religion, or other protected