Pune, Maharashtra, India
Information Technology
Full-Time
Guardian Life
Overview
Job Description:
Certification Preferred: Databricks Certified Data Engineer, Informatica (IDMC)
Job Summary
We are seeking a skilled and motivated Data Engineer with strong experience in Data Warehousing concepts, ETL/ELT development, and hands-on expertise in Informatica. The ideal candidate will have a solid understanding of data modeling, excellent communication skills, and experience working in Agile environments. Certification in Databricks is a plus.
Key Responsibilities
This position can be based in any of the following locations:
Chennai
Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday
Certification Preferred: Databricks Certified Data Engineer, Informatica (IDMC)
Job Summary
We are seeking a skilled and motivated Data Engineer with strong experience in Data Warehousing concepts, ETL/ELT development, and hands-on expertise in Informatica. The ideal candidate will have a solid understanding of data modeling, excellent communication skills, and experience working in Agile environments. Certification in Databricks is a plus.
Key Responsibilities
- Design and develop ETL/ELT processes using Guardian-approved tools such as Informatica, SSIS, and Syncsort.
- Work with big data technologies including HIVE, HAWQ, Spark SQL, Python, PySpark and AWS EMR.
- Perform hands-on development in UNIX, PL/SQL, HQL, and conduct unit testing for all deliverables.
- Interpret and work with logical, physical, and conceptual data models and ER diagrams.
- Create and maintain technical documentation including functional specs, test plans, deployment guides, mapping documents, and runbooks.
- Optimize ETL and query performance, conduct impact analysis, and contribute to solution design.
- Collaborate with on-site/offshore teams to clarify requirements and resolve issues.
- Participate in all SDLC activities including requirement analysis, effort estimation, development, testing, and deployment.
- Provide production support including Level 2 on-call support and incident resolution.
- Ensure compliance with Guardian’s security and development standards.
- Engage with Guardian SMEs for knowledge transition and steady-state support.
- Drive ETL architecture design, enforce best practices, and assess existing applications for improvements.
- Identify and implement automation opportunities to improve efficiency.
- Strong understanding of Data Warehousing and Data Modeling.
- Proficiency in ETL/ELT tools – Informatica, SSIS, Syncsort.
- Experience with PL/SQL – procedures, triggers, constraints, cursors, functions.
- Familiarity with SAFe Agile methodology.
- Experience with big data tools and cloud platforms (AWS EMR, Spark SQL).
- Excellent Communication Skills – ability to clearly articulate technical concepts to both technical and non-technical stakeholders.
- Analytical Thinking – strong problem-solving skills and ability to perform root cause analysis.
- Collaboration – experience working in cross-functional teams and coordinating with on-site/offshore teams.
- Self-Motivation – ability to work independently and take ownership of deliverables.
- Adaptability – comfortable working in a dynamic environment with changing priorities.
- Attention to Detail – thorough in documentation, testing, and quality assurance.
- Proactive Mindset – ability to identify opportunities for improvement and automation.
This position can be based in any of the following locations:
Chennai
Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday
Similar Jobs
View All
1 Day ago
Network Security Architect
Healthcare & Life Sciences
- 11 - 16 Yrs
- Hyderabad
We’re hiring a Network Security Architect for our esteemed client, a leading healthcare provider in Hyderabad, to design and secure cutting-edge network infrastructure. If you have 11-16 years of experience in network security and a passion for build...
1 Day ago
IT Operations Lead
Fintech
- 8 - 13 Yrs
- Pune
Role- IT Operations Lead
Exp - 8 to 12 years
Location- Pune
Domain -Cards and Payments
Work model - 5 days’ work from office.
As an IT Operations Lead you shall be responsible to ensure the technical operation of RUN IT Electronic Payment reso...
1 Day ago
Application Engineer Team Lead
Fintech
- 8 - 13 Yrs
- Pune
Application Engineer Team Lead
Location: Pune, India
Experience: 8 – 12 years
Business Unit: PS (Payment services)
Job Role: Application Engineering, Investigation of incidents, change request (Small Enhancement), Application de...
1 Day ago
IT Project Manager - Capital Markets Domain
Fintech
- 8 - 14 Yrs
- Mumbai
Job Title: IT Project Manager - Capital Markets Domain
Location: Prabhadevi, Mumbai
Experience: 8-14 years
Employment Type: Full-Time
About the Role: We're hiring a Product Project Manager to lead the execution of high-impact products in the ca...
1 Day ago
Sr Technical Consultant
Information Technology
- 700000 - 2300000 INR - Annual
- 5 - 8 Yrs
- Pune
Position: Sr. Technical Consultant (Dotnet 6.0+) Experience:
5+ Years
Job Title: ASP.NET Core 6.0 / Full stack Developer for Pune Location
We are looking for a seasoned ASP.NET Core 6.0 / MVC Developer to join our innovative team. This
ro...
1 Day ago
Director - Artificial Intelligence
Health & Wellbeing
- 5000000 - 5500000 INR - Annual
- 10 - 15 Yrs
- Chennai, Hyderabad
Summary role description:
Hiring for the Director – Artificial Intelligence for a leading healthcare technology provider delivering AI-driven solutions to modernize care for millions nationwide.
Company description:
Our client i...
1 Day ago
Senior AI Engineer
Information Technology
- Pune, Maharashtra, India
Company OverviewMilestone Technologies is a global IT managed services firm that partners with organizations to scale their technology, infrastructure and services to drive specific business outcomes such as digital transformation, innovation, and ...
1 Day ago
Data Scientist - Python/Spark
Information Technology
- Pune, Maharashtra, India
Description : Summary : ResponsibilitiesWe are seeking a highly skilled Data Engineer / Data Scientist with strong expertise in Python, Pandas, PySpark, SQL, and NLP libraries. The ideal candidate will be responsible for developing scalable data sol...
Talk to us
Feel free to call, email, or hit us up on our social media accounts.
Email
info@antaltechjobs.in