Specialist Software Engineer( Teradata)

Nationwide; Hyderabad; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Nationwide in Hyderabad is seeking a seasoned Software Engineer to lead an offshore development team and drive strategic data initiatives for Sales Data Mart and Sales IQ applications.

You will design and maintain ETL pipelines with Informatica, Teradata, SQL and Databricks, mentor juniors, collaborate with stakeholders, and ensure data quality and governance across systems.

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

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

Strong communication

Analytical skills

Leadership

Agile methodologies

Cross-functional collaboration

Education

Undergraduate studies in computer science, MIS or related degree

Tools

Informatica

Teradata

SQL

Perl

Databricks

UAC (Universal Automation Center)

Job description

About Nationwide

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. At Nationwide, youll join a forward-thinking team that embraces agile ways of working, fosters a collaborative and inclusive culture, and invests in emerging technologies like cloud, data, AI, and cybersecurity. Our associates contribute to meaningful work that protects futures and strengthens communitiesmaking a real impact every day.

Job Description

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 environment.Applicant 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.Technology stack includes Databricks, Teradata, Informatica, DIF (PERL), UAC (Scheduling), Legacy/Mainframe, Unix, GitHub Actions, Harness, UCD (code deployment), 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

Qualifications & Experience:

Education:

Undergraduate studies in computer science, management information systems, or other related degree. Technology experience or non-traditional technology certificates can be substituted for an undergraduate degree.

Experience:

Four or more years of analysis and technology experience.

[Optional: Mention exposure to Indian data systems or regulations.]

Technical Skills:

• CI/CD
• Cloud Computing
• Programming Languages
• Software Development Life Cycle (SDLC)
• Software Engineering
• Software Security
• Software Testing
• Systems Integration

Soft Skills & Attributes:

• Strong communication and collaboration skills
• Analytical and problem-solving mindset
• Ability to work in agile and global environments
• Time management and prioritization
• Proficiency in one or more programming language such as Java, C++, Python, JavaScript.
• Strong knowledge of software development lifecycle.
• Proven ability to tackle complex business and development problems.
• Ability to thrive in a team environment.
• Insurance/financial services industry knowledge a plus.

Additional Information:

Reporting Structure:

Reports to Manager or Director.

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 categories. .