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
Performing 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
Advances 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
Skills Required
- 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 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)
- Experience with DevSecOps practices and working with Generative AI development tools
- Ability to work in Agile or iterative development environments
- Strong analytical, problem-solving, and communication skills; ability to collaborate with technical and business teams
- Participate in code reviews and follow best practices for version control and release management
- 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 ETL/data quality
- Exposure to scripting or automation using Python, Shell, or similar tools
The Hartford Financial Services Group, Inc. Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about The Hartford Financial Services Group, Inc. and has not been reviewed or approved by The Hartford Financial Services Group, Inc..
-
Retirement Support — A 401(k) with matching plus an additional company contribution, alongside an employee stock purchase plan and no‑cost financial planning, signals robust long‑term savings support. HSAs/FSAs and related financial tools further strengthen overall financial well‑being.
-
Leave & Time Off Breadth — At least 25 days of PTO to start, options to buy or roll over time, and paid parental leave indicate broad time‑off support. Paid leave for organ and bone marrow donation and generous disability coverage extend protection for significant life events.
-
Healthcare Strength — Multiple medical, dental, and vision options with the company covering most medical and dental premiums reflect strong core health coverage. Wellness programs, fitness reimbursements, well‑being credits, and accessible behavioral health services expand depth and accessibility.
The Hartford Financial Services Group, Inc. Insights
What We Do
Human achievement is at the heart of what we do. We put our belief into action by not only ensuring individuals and businesses are well protected, but by going even further – making an impact in ways that go beyond an insurance policy
