Lead Engineer Support - IT

Guardian; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Guardian in Chennai seeks a motivated Data Ingestion and Integration Engineer to design, build, and optimize automated data pipelines supporting data technology integration and ingestion. You will work as an individual contributor, performing production support, ETL development using Informatica PowerCenter and Cloud, SSIS, and related tools, with a focus on data quality and scalable solutions.

This role emphasizes collaboration with IT and business stakeholders for data warehousing, data

Qualifications

• Experience with ETL platforms and data integration.
• Knowledge of data warehousing, data integration, and metadata management.
• Strong SQL and Unix shell scripting basics.

Responsibilities

• Provide Production Support for ETL platforms.
• Review and understand business data related ETL requirements.
• Develop and enhance data systems.
• Participate in development plans and task estimation.
• Assist with logical data modeling.
• Monitor production jobs and resolve issues promptly.
• Collaborate with IT to improve processes.
• Develop Informatica or ETL workflows.
• Design, build, and maintain automated data pipelines.
• Implement data validation and quality checks.
• Optimize pipelines for large data volumes.
• Document pipeline processes and maintenance routines.

Skills

ETL concepts

Informatica

Informatica Cloud

SSIS

SQL

Unix

Pyspark

Databricks

Lakehouse concepts

Delta format

Tools

Informatica PowerCenter

Informatica Cloud

Syncsort DMX-h

Control-M

SSIS

Job description

Unlock Premium Benefits

Get Immediate Access to 3,694,000 premium jobs

• Direct Access to Top Employers

  Gain full access to exclusive job listings from leading companies worldwide.

• Verified, High-Quality Jobs Only

  No ads, scams, or junk-just genuine opportunities.

• Focus on Real Opportunities

  Explore thousands of open positions tailored to your lifestyle, including flexible remote jobs.

• Exclusive Resume Review

  Receive expert feedback with personalized suggestions to enhance your resume.

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.

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