Lead Software Engineer/ Data Engineer
thehartford
Stand out for this role — generate a tailored resume and cover letter in about a minute.
Benefits offered by this job
Job summary
The Hartford in Hyderabad, India seeks an experienced Software Engineer focusing on robust data pipelines and ETL workflows. You will design, develop, and optimize data solutions, leveraging Informatica PowerCenter, Oracle PL/SQL, and modern DevSecOps practices to support reporting and analytics in a reinsurance context.
The role requires 5+ years of hands-on data engineering, strong SQL skills, and collaboration with cross-functional teams in an Agile environment.
Qualifications
- Bachelor's Degree with 8+ years in software solution development.
- 5+ years in data engineering or ETL development roles.
- Hands-on Informatica PowerCenter for ETL workflows.
- Strong Oracle PL/SQL proficiency and performance tuning.
- Advanced SQL development, queries and indexing.
- Experience with multiple source systems and data integration.
Responsibilities
- Design, build, and maintain ETL workflows with Informatica PowerCenter.
- Develop and optimize Oracle PL/SQL procedures, functions, packages.
- Translate business requirements into scalable data solutions.
- Perform data mapping, transformation logic, and validation.
- Tune ETL jobs and queries for performance and scalability.
- Collaborate with BAs, data architects, DBAs, and reporting teams.
- Participate in code reviews and release management.
Skills
Education
Tools
Job description
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.
Location: Hyderabad, India
Employment Type: Full-Time
Experience Level: 5 + Years
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 .
- 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 Reinsuranc e
- 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
- 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
- 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
- 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
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
