Job Description:Seeking a motivated Data Ingestion and Integration Engineer to join our team as an individual contributor.
In this role, resource will be responsible for primarily support and designing, building, and optimizing automated data pipelines to support data technology
integration and ingestion needs.Qualifications:
osition Objective:
Informatica Platform Administration, Development & Production Support Review & analyze business data requirements working with IT and Business stake holders for Data warehousing, Data integration, Reporting projects. Prepare Technical ETL design document, develop, & support ETL processes using Informatica Power center, Informatica Cloud, Syncsort DMX-h (precisely) tools and production support 24/7 with on call support.
Competencies/Skills: Individual Contributor Competencies
Proficient in the following
Any ETL tool knowledge (eg: Precisely/Informatica)
Datalake/Databricks Concepts
Pyspark
SQL/Unix (basics)
Strong Understanding of LakeHouse concepts (eg : Delta format ,Workflow creation etc)
Knowledge:
Strong knowledge of ETL concepts especially as applied to Informatica, Informatica cloud.
Strong knowledge of data analysis, data transformation, conceptual data modeling, data transformation &metadata management.
Strong knowledge of data design for various applications.
Strong knowledge of SQL.
Good knowledge of various RDBMS, Mainframe
Good knowledge of Project Life Cycles methodologies.
Strong verbal & written communication skills.
Strong knowledge of Unix & Unix Shell scripting
Experience with Enterprise Scheduling tools such as Control-M is a plus.
Job responsibilities:
Provide Production Support, on call support for all ETL platforms.
Review & understand business data related ETL requirements for database, application and reporting projects.
Develop & make enhancement on new & existing data systems.
Participate in the development plans & resource estimation for task planning.
Assist with the development of logical data models.
Monitor production jobs & resolve any issues in a timely manner.
Partner with other IT areas in resolving issues & improving processes
Develop Informatica or ETL Workflows.
Develop ETL code both in Informatica & at the shell script level.
Design, build, and maintain automated data pipelines that ensure smooth data ingestion and integration from various sources.
Develop scalable and efficient solutions for data ingestion, using best practices in ETL/ELT processes.
Implement data validation and quality checks to ensure data integrity throughout the pipeline.
Optimize data pipelines to handle large volumes of data in real-time and batch processing environments.
Collaborate with data engineers, analysts, and other stakeholders to understand data requirements and deliver seamless solutions.
Monitor pipeline performance, troubleshoot issues, and continuously improve pipeline efficiency.
Document pipeline processes, configuration, and maintenance routines to facilitate knowledge sharing and onboarding.
Location:
This position can be based in any of the following locations:
Chennai, Gurgaon
Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday
Top Skills
What We Do
Who we are
Guardian makes a difference in the lives of people when they need us most. With over 160 years of stability and fiscal integrity, we are a trusted resource to generations of families and business owners, inspiring well-being and helping build financial confidence.
Today, we stand behind 29 million consumers, helping them prepare and plan for a bright future for themselves and their families. We help business owners care for their employees. And we help people recover and thrive in times of unexpected loss.
As a modern mutual insurance company, we believe in driving value beyond dividends. We invest in our colleagues and are building a progressive, innovative and inclusive culture. We uplift individuals and communities through thoughtful social and environmental programs.
What we stand for
In 1860, a community of immigrants joined together to insure and protect their businesses and families. They were guided by powerful ideals that we’ve continued to stand behind and evolved throughout the years: we do the right thing, we believe people count, we courageously shape the future together, and we go above and beyond for the people we serve.
Guardian employees embrace and live by these values every day. They remind us to put people at the heart of all we do so that we can help protect what matters most to you. Want to help bring these values to life? Join us for a rewarding career and the opportunity to shape the future.
Disclosures:
Financial information concerning Guardian as of December 31, 2022, on a statutory basis: Admitted assets = $76.0 billion; liabilities = $67.2 billion (including $55.0 billion of reserves); and surplus = $8.8 billion. Dividends are not guaranteed. They are declared annually by Guardian’s Board of Directors.
Guardian® is a registered trademark of The Guardian Life Insurance Company of America. © Copyright 2023 The Guardian Life Insurance Company of America 2023-156184 Exp. 5/25
