15 Sep
|
Guardian Life Insurance
|
Chennai
15 Sep
Guardian Life Insurance
Chennai
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.
Position 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, & SSIS (SQL Server Integration Services) 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.
Robust 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 developme
📌 Lead Engineer Support (Chennai)
🏢 Guardian Life Insurance
📍 Chennai