Data Integration Consultant

Acespire Solutions; India; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Acespire Solutions seeks a techno-functional data integration expert to design end-to-end pipelines and resolve data quality issues for global clients. You will ensure seamless data flow across enterprise platforms, analyze requirements, and coordinate with cross-functional teams.

The role focuses on ETL/ELT methodologies, API integrations, and cloud/digital data architectures with a strong emphasis on data governance and real-time vs. batch processing.

Qualifications

• 3–5 years implementing data integration solutions.
• Experience with REST/SOAP API integrations is required.
• Strong SQL and scripting (Python/JSON/XML) is highly desirable.

Responsibilities

• Act as a techno-functional expert in data integration best practices and end-to-end pipeline design.
• Analyze client data requirements and design integration solutions for accurate data flow.
• Identify data quality issues and reconciliation gaps across systems.
• Configure and maintain data integration pipelines based on change requests and enhancements.
• Execute data transformation, validation, and reconciliation test cases; track issues.
• Support Super User and End User training on integration tools and workflows.

Skills

API integration REST/SOAP

SQL/T-SQL/MDX

Python/JSON/XML

ETL/ELT

Data warehousing

Data governance

Education

BTech / MCA / MTech / MBA in CS/IS/Data Eng

Tools

Informatica

Dell Boomi

Talend

AWS Glue

Apache NiFi

SnapLogic

Job description

Act as a techno-functional expert in data integration - designing end-to-end pipelines, resolving data quality issues, and ensuring seamless data flow across enterprise platforms for global clients.

Job Responsibilities

• Act as a techno-functional expert in data integration best practices, ETL/ELT methodologies, enterprise data architectures, and end-to-end pipeline design.
• Analyze client data requirements and design integration solutions that ensure accurate, seamless, and timely data flow across systems and platforms.
• Identify data quality issues, reconciliation gaps, and system compatibility challenges; coordinate with cross-functional teams to deliver reliable integration outcomes.
• Configure and maintain data integration pipelines based on change requests and post go-live enhancements, ensuring continuous data accuracy and operational efficiency.
• Execute data transformation, validation, and reconciliation test cases; track and resolve bugs and discrepancies using internal support tools.
• Support Super User and End User training on integration tools, workflows, and best practices for a global user base.

Qualifications

• BTech / MCA / MTech / MBA in Computer Science, Information Systems, Data Engineering, or a related field.
• 3–5 years implementing data integration solutions using tools such as Informatica, Dell Boomi, Talend, AWS Glue, Apache NiFi, or SnapLogic. API integration (REST/SOAP) and cloud platform experience is a must.
• Proficiency in SQL, T-SQL, or MDX; working knowledge of Python, JSON, or XML for pipeline scripting is highly desirable.
• Strong understanding of ETL/ELT, data warehousing, data mapping, data governance, API integration, and real-time vs. batch data processing.

Characteristics

• Leads by example with deep proficiency in both integration technology and the data domain.
• Communicates complex integration concepts clearly to non-technical stakeholders, even under pressure.
• Detail-oriented and analytical, with a structured approach to troubleshooting across multi-system environments.
• Collaborative team player, comfortable working across global business, IT, and data engineering teams.
• Self-motivated with a continuous improvement mindset and strong ownership over data quality and integration performance.