Job Summary:

We are looking for an experienced Data Integration Engineer with around 5 years of hands-on experience in building and supporting enterprise data integration solutions. The candidate should have strong expertise in SQL, Pentaho Data Integration (PDI/Kettle), ETL processes, IBM Unica, and exposure to AWS cloud services.

Roles and Responsibilities:

* Design, develop, and enhance ETL workflows using Pentaho Data Integration (PDI/Kettle).

* Build data pipelines to extract information from multiple source systems and load it into target databases/data warehouse environments.

* Develop complex and efficient SQL queries, stored procedures, joins, views, and database processes.

* Work with IBM Unica data and integration processes as required for campaign and customer-related data flows.

* Perform data cleansing, transformation, standardization, validation, and reconciliation across source and target systems.

* Analyze data discrepancies and investigate ETL failures, incorrect records, and processing issues.





* Monitor scheduled ETL workflows and ensure successful completion of daily/periodic data loads.

* Troubleshoot production issues and perform root cause analysis (RCA) for recurring data or job failures.

* Identify opportunities to improve ETL performance, SQL execution time, and overall data-processing efficiency.

* Support ETL deployments, job scheduling, production releases, and post-deployment validation.

* Work with AWS-based data environments and support cloud-related data integration activities.

* Collaborate with application, database, reporting, business, and other technology teams to resolve integration issues.

* Prepare and maintain technical documentation covering ETL mappings, workflows, data flows, and operational procedures.

Required Technical Skills:

1. 5+ years of experience in ETL, Data Integration, or Data Engineering.

2. Robust practical knowledge of SQL and relational database concepts.

3. Hands-on experie

📌 Data Integration Engineer (Kurla)
🏢 ComUnus Technologies
📍 Kurla