Data Integration Engineer

Msys Softsol; Hyderabad, Pune District, Bengaluru; On-site; INR 1,400,000 - 2,400,000; Full time

Job summary

Msys Softsol is seeking a Data & Integration Engineer with 4+ years of experience to design, develop, and maintain scalable data integration solutions across cloud platforms and enterprise systems. You will work on ETL/ELT pipelines, SQL tuning, API integrations (REST, Graph), and data modeling, coordinating with stakeholders and ensuring data governance.

The role emphasizes Azure and AWS exposure, toolchains like Git and VS Code, and hands-on experience with JSON/XML data, aiming to support AI,

Qualifications

• 4+ years of experience in Data Engineering, Data Integration, or ETL development.
• Strong SQL skills including joins, views, stored procedures, and performance tuning.
• Experience with REST APIs, Microsoft Graph APIs, and enterprise integrations.
• Experience with JSON and XML data transformation.
• Experience with Azure (Storage, Azure SQL, Logic Apps) or AWS (Redshift, S3, Lambda, Glue).
• Proficiency with Git and Visual Studio Code.
• Analytical, troubleshooting, and problem-solving skills.

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL/ELT workflows.
• Develop and optimize complex SQL queries and data models for analytics and reporting.
• Integrate data from REST APIs, Graph APIs, and cloud platforms.
• Process, transform, and manage structured, semi-structured, and unstructured data (JSON/XML).
• Design, implement, and support cloud-based data solutions on Azure or AWS.
• Troubleshoot data quality, synchronization, and transformation issues.
• Collaborate with stakeholders to gather data requirements and deliver scalable solutions.
• Maintain technical documentation, data mappings, and integration workflows with governance practices.

Skills

SQL proficiency

ETL/ELT development

REST API integration

Azure/AWS cloud

Data modeling

JSON/XML data

Power Automate / Logic Apps

Git & VS Code

Problem-solving

Python for data processing

Education

Bachelors in CS/IT/Data Engineering

Masters in CS/IT/Data Engineering

Tools

Power Automate

Azure Logic Apps

Azure SQL

AWS Glue

S3

SQL Server

Job description

Note: Immediate joiners only

Role Summary

We are seeking a skilled Data & Integration Engineer with 4+ years of experience in designing, developing, and maintaining scalable data integration solutions. The ideal candidate will have expertise in data engineering, API integrations, cloud platforms, and ETL processes to support AI, automation, and enterprise data initiatives.

Key Responsibilities

• Design, develop, and maintain scalable data pipelines, ETL/ELT workflows, and data integration solutions.
• Develop and optimize complex SQL queries, views, stored procedures, and data models for analytics and operational reporting.
• Integrate data from REST APIs, Graph APIs, enterprise applications, databases, and cloud platforms.
• Process, transform, and manage structured, semi-structured, and unstructured data, including JSON.
• Design, implement, and support cloud-based data solutions on Azure or AWS.
• Troubleshoot and resolve data quality, synchronization, transformation, and integration issues.
• Collaborate with business and technical stakeholders to gather data requirements and deliver scalable integration solutions.
• Maintain technical documentation, data mappings, and integration workflows while adhering to data governance best practices.

Required Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, Data Engineering, or a related field.
• 4+ years of experience in Data Engineering, Data Integration, or ETL development.
• Strong expertise in SQL, including joins, views, stored procedures, query optimization, and performance tuning.
• Hands-on experience with REST APIs, Microsoft Graph APIs, and enterprise application integrations.
• Experience working with JSON, XML, and data transformation techniques.
• Strong understanding of data modeling, normalization, and relational database concepts.
• Experience with Azure services (Storage, Azure SQL, Logic Apps) or AWS services (Redshift, S3, Lambda, Glue).
• Experience with Microsoft Power Automate or Azure Logic Apps for workflow automation.
• Proficiency with Git, Visual Studio Code, and version control best practices.
• Strong analytical, troubleshooting, and problem-solving skills.

Preferred Skills

• Experience integrating with enterprise platforms such as ServiceNow, Dynatrace, SolarWinds, and Nexthink.
• Programming experience using Python for data processing and automation.
• Knowledge of data architecture, metadata management, and data governance principles.
• Experience supporting AI, automation, and cloud-native data solutions.
• Familiarity with Agile/Scrum development methodologies and DevOps practices.