Senior Software Engineer/Informatica

The Hartford; Hyderabad; On-site; INR 2,600,000 - 4,200,000; Full time

Benefits offered by this job

Competitive compensation

Comprehensive benefits

Learning opportunities

Job summary

The Hartford in Hyderabad, India is seeking a Senior Software Engineer with 5+ years of hands-on data engineering and ETL experience to design, build, and optimize data pipelines using Informatica and Oracle PL/SQL. This role supports reporting, analytics, and business operations within the reinsurance team in Hyderabad.

You will collaborate with data architects, DBAs, analysts, and developers in an Agile environment, participate in code reviews, and contribute to scalable data solutions.

Qualifications

• Bachelor’s degree in computer science or related field.
• 8+ years in application software development.
• 5+ years in data engineering or ETL development.
• Proficient in Informatica PowerCenter for ETL workflows.
• Strong Oracle PL/SQL development and tuning.
• Advanced SQL development with performance optimization.
• Experience with data integration across multiple sources.
• Familiarity with job scheduling tools (Autosys or similar).
• Agile methodologies and strong communication skills.

Responsibilities

• Design, develop, and maintain ETL workflows in Informatica to load data from multiple source systems.
• Write, optimize, and troubleshoot Oracle PL/SQL procedures, functions, and packages.
• Analyze business and data requirements and translate them into scalable technical data solutions.
• Perform data mapping, transformation logic design, and data validation to ensure high data quality.
• Tune ETL jobs and database queries for performance, scalability, and reliability.
• Work with large datasets related to reinsurance.
• Monitor and support ETL jobs, perform root cause analysis, and resolve data issues quickly.
• Collaborate with business analysts, data architects, DBAs, and reporting teams to deliver end‑to‑end data solutions.
• Participate in code reviews and follow best practices for version control and release management.

Skills

Data engineering

ETL development

Oracle PL/SQL

SQL performance tuning

Data integration

Agile methodologies

Communication

Informatica PowerCenter

Education

Bachelor’s degree in computer science or related field

Tools

Autosys

Job description

IND Senior Software Engineer - GCC024

We’re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals – and to help others accomplish theirs, too. Join our team as we help shape the future. Senior Software Engineer

Location: Hyderabad, India Employment Type: Full-Time Experience Level: 5+ Years

Position Overview

We are seeking an experienced Software Engineer with 5+ years of hands‑on expertise in building and maintaining robust data solutions. The role focuses on designing, developing, and optimizing ETL workflows using Informatica, strong Oracle PL/SQL development skills along with DevSecOps and working with generative AI development tools to support complex data processing needs. The ideal candidate will play a key role in delivering high‑quality, reliable data pipelines that power reporting, analytics, and business operations within a reinsurance team in Hyderabad, India.

Key Responsibilities

• Design, develop, and maintain ETL workflows in Informatica to load data from multiple source systems
• Write, optimize, and troubleshoot complex Oracle PL/SQL procedures, functions, and packages
• Analyze business and data requirements and translate them into scalable technical data solutions
• Perform data mapping, transformation logic design, and data validation to ensure high data quality
• Tune ETL jobs and database queries for performance, scalability, and reliability
• Work with large datasets related to reinsurance
• Monitor and support ETL jobs, perform root cause analysis, and resolve data issues quickly
• Collaborate with business analysts, data architects, DBAs, and reporting teams to deliver end‑to‑end data solutions
• Participate in code reviews and follow best practices for version control and release management

Required Skills & Experience

• Bachelor’s Degree with 8 or more years of experience in application software solution development
• 5+ years of experience in data engineering or ETL development roles
• Strong hands‑on experience with Informatica PowerCenter for building and maintaining ETL workflows
• Advanced proficiency in Oracle PL/SQL, including procedures, functions, packages, and performance tuning
• Expertise in complex SQL development, query optimization, and indexing strategies
• Experience with data integration across multiple source systems (databases, flat files, etc.)
• Familiarity with job scheduling tools (e.g., Autosys, or similar)
• Strong analytical and problem‑solving skills with attention to detail
• Ability to work in Agile or iterative development environments
• Excellent communication skills and ability to collaborate with technical and business teams

Nice to Have Skills

• Experience in reinsurance domain
• Knowledge of ProCede or similar reinsurance administration systems
• Exposure to financial data, policy systems, or claims data
• Hands‑on experience with AWS cloud services
• Experience leveraging AI/ML tools or automation techniques to improve data quality, streamline ETL processes, or optimize data operations
• Exposure to scripting or automation using Python, Shell, or similar tools to enhance data engineering workflows

What We Offer

• Opportunity to work on advanced cloud automation and AI technologies
• Collaborative and innovative work environment
• Competitive compensation and comprehensive benefits
• Continuous learning and professional development opportunities

About Us | Our Culture | What It’s Like to Work Here

Every day, a day to do right. Showing up for people isn’t just what we do. It’s who we are – and have been for more than 200 years. We’re devoted to finding innovative ways to serve our customers, communities and employees—continually asking ourselves what more we can do. Is our policy language as simple and inclusive as it can be? Can we better help businesses navigate our ever-changing world? What else can we do to destigmatize mental health in the workplace? Can we make our communities more equitable? That we can rise to the challenge of these questions is due in no small part to our company values that our employees have shaped and defined. And while how we contribute looks different for each of us, it’s these values that drive all of us to do more and to do better every day.