Data and Integration Engineer

WSP in India; Bengaluru; On-site; INR 2,400,000 - 4,200,000; Full time

Job summary

WSP India is seeking a Data and Integration Engineer to manage data and integration across WSP Digital Products. You will design ingestion, validation, transformation, and reconciliation flows across product systems, cloud services, and external sources to ensure data quality and traceability.

The role requires hands-on work with SQL/NoSQL databases, APIs, and cloud data tools. You will collaborate with architects and developers to implement reliable data movement, governance, and monitoring

Qualifications

• Minimum 6 years of professional experience in data engineering, integration engineering, ETL development, API integration, or enterprise data platforms.
• Experience handling structured, semi-structured, and unstructured data across enterprise applications or digital products.
• Experience building or supporting ingestion pipelines, validation routines, reconciliation checks, and operational data monitoring.
• Experience in working AI/ML frameworks and data pipelines
• Hands-on experience with databases (PostgreSQL, MongoDB, SQL/NoSQL)
• Strong experience with SQL databases, API-based integrations, file-based integrations, and cloud-hosted data movement.
• Experience troubleshooting data defects, ingestion failures, integration issues, schema mismatches, and downstream data inconsistencies.

Responsibilities

• Manage data across digital product platforms including structured, semi-structured and unstructured data.
• Analyze source data formats including SQL tables, JSON, XML, CSV, documents, logs, images, geospatial files, and API payloads.
• Define data mapping, metadata, lineage, validation rules, and data quality expectations.
• Support reporting, analytics, operational dashboards, product insights, and downstream data requirements.
• Design and support batch, scheduled, and near-real-time data ingestion workflows from internal and external sources.
• Build validation, reconciliation, deduplication, enrichment, transformation, and error-handling routines.
• Support ETL/ELT processes, file processing, document ingestion, API-based data exchange, and cloud data movement.
• Monitor ingestion health, failed loads, schema changes, data anomalies, and data completeness.
• Build and maintain APIs, connectors, integration jobs, scripts, and service-based data exchange workflows.
• Integrate product platforms with enterprise systems, external providers, GIS/geospatial platforms, identity services, and data stores.
• Support event-driven, API-based, file-based, and scheduled integration models based on product needs.
• Work with architects and developers to define integration contracts, error handling, retry logic, monitoring, and operational support requirements.
• Define and maintain data quality checks, reconciliation reports, validation dashboards, and exception-handling processes.
• Participate in root-cause analysis of data defects, integration failures, ingestion errors, and downstream inconsistencies.
• Support migration, onboarding, configuration, and release activities involving data and integrations.
• Maintain documentation for data flows, integration dependencies, transformation logic, and support procedures.

Job description

Job Description

Data and Integration Engineer would be responsible for managing data and integration capabilities across WSP Digital Products, including structured, semi-structured, and unstructured data. The role would design and support data ingestion, validation, transformation, reconciliation, and integration flows across product systems, enterprise platforms, APIs, cloud services, and external data sources. The engineer would ensure data quality, integration reliability, secure data movement, and traceability across current and future products.

Responsibilities

Data Management & Data Understanding

• Manage structured, semi-structured, and unstructured data used across digital product platforms.
• Analyze source data formats including SQL tables, JSON, XML, CSV, documents, logs, images, geospatial files, and API payloads.
• Define data mapping, metadata, lineage, validation rules, and data quality expectations.
• Support reporting, analytics, operational dashboards, product insights, and downstream data requirements.

Data Ingestion, Validation & Processing

• Design and support batch, scheduled, and near-real-time data ingestion workflows from internal and external sources.
• Build validation, reconciliation, deduplication, enrichment, transformation, and error-handling routines.
• Support ETL/ELT processes, file processing, document ingestion, API-based data exchange, and cloud data movement.
• Monitor ingestion health, failed loads, schema changes, data anomalies, and data completeness.

Integration Engineering

• Build and maintain APIs, connectors, integration jobs, scripts, and service-based data exchange workflows.
• Integrate product platforms with enterprise systems, external providers, GIS/geospatial platforms, identity services, and data stores.
• Support event-driven, API-based, file-based, and scheduled integration models based on product needs.
• Work with architects and developers to define integration contracts, error handling, retry logic, monitoring, and operational support requirements.

Data Quality, Support & Governance

• Define and maintain data quality checks, reconciliation reports, validation dashboards, and exception-handling processes.
• Participate in root-cause analysis of data defects, integration failures, ingestion errors, and downstream inconsistencies.
• Support migration, onboarding, configuration, and release activities involving data and integrations.
• Maintain documentation for data flows, integration dependencies, transformation logic, and support procedures.

Required Technical Skills

• Data Engineering | Advanced — data ingestion, transformation, validation, reconciliation, structured and unstructured data handling
• Integration Engineering | Advanced — REST APIs, connectors, service integrations, scheduled jobs, event-driven flows, and data exchange patterns
• Databases & Querying | Proficient — SQL, PostgreSQL / SQL Server, relational modelling, query tuning, and data profiling
• Cloud Data Services | Proficient — Azure Data Factory, Logic Apps, Functions, Blob Storage, queues, or equivalent cloud data tooling
• Data Quality | Advanced — validation rules, exception handling, anomaly detection, lineage, completeness, and reconciliation checks
• Programming / Scripting | Proficient — Python, C#, SQL, PowerShell, or equivalent scripting for automation and integrations

Required Experience

• Minimum 6 years of professional experience in data engineering, integration engineering, ETL development, API integration, or enterprise data platforms.
• Experience handling structured, semi-structured, and unstructured data across enterprise applications or digital products.
• Experience building or supporting ingestion pipelines, validation routines, reconciliation checks, and operational data monitoring.
• Experience in working AI/ML frameworks and data pipelines
• Hands-on experience with databases (PostgreSQL, MongoDB, SQL/NoSQL)
• Strong experience with SQL databases, API-based integrations, file-based integrations, and cloud-hosted data movement.
• Experience troubleshooting data defects, ingestion failures, integration issues, schema mismatches, and downstream data inconsistencies.

Preferred

• Experience with Azure Data Factory, Azure Functions, Logic Apps, Event Grid, Service Bus, Blob Storage, or equivalent tools.
• Exposure to GIS/geospatial data, document-heavy platforms, environmental datasets, or engineering data sources.
• Experience supporting data migration, platform transition, MVP stabilization, or SaaS product integrations.
• Exposure to data governance, metadata management, lineage, data quality reporting, and data observability.

Qualifications

• Bachelor’s degree in Computer Science , Information Technology, Data Engineering, Engineering, or related field .
• Azure Data Engineer, cloud data platform, integration, or database certification is preferred but not mandatory.

BGV

Employment with WSP India is subject to the successful completion of a background verification ("BGV") check conducted by a third-party agency appointed by WSP India. Candidates are advised to ensure that all information provided during the recruitment process — including documents uploaded — is accurate and complete, both to WSP India and its BGV partner.

About Us

WSP is one of the world's leading professional services consulting firms. We are dedicated to our local communities and propelled by international brainpower. We are technical experts and strategic advisors including engineers, technicians, scientists, architects, planners, surveyors and environmental specialists, as well as other design, program and construction management professionals. We design lasting solutions in the Transportation & Infrastructure, Property & Buildings, Earth & Environment, Power & Energy, Resources and Industry sectors, as well as offering strategic advisory services. Our talented people around the globe engineer projects that will help societies grow for lifetimes to come.

With approximately 4,000 talented people across 3 locations (Noida, Bengaluru & Mumbai offices) in India and more than 73,000 globally, in 550 offices across 40 countries, we engineer projects that will help societies grow for lifetimes to come.

At “WSP” we draw on the diverse skills and capabilities of our employees globally to compete for the most exciting and complex projects across the world and bring the same level of expertise to our local communities. We are proud to be an international collective of innovative thinkers who work on the most complex problems. Unified under one strong brand, we use our local expertise, international reach and global scale to prepare our cities and environments for the future, connect communities and help societies thrive in built and natural ecosystems. True to our guiding principles, our business is built on four cornerstones: Our People, Our Clients, Our Operational Excellence and Our Expertise.

www.wsp.com

We are

• Passionate people doing purposeful and sustainable work that helps shape our communities and the future.
• A collaborative team that thrives on challenges and unconventional thinking.
• A network of experts channeling our curiosity into creating solutions for complex issues.

Inspired by diversity, driven by inclusion, we work with passion and purpose.

Working with Us

At WSP, you can access our global scale, contribute to landmark projects and connect with the brightest minds in your field to do the best work of your life. You can embrace your curiosity in a culture that celebrates new ideas and diverse perspectives. You can experience a world of opportunity and the chance to shape a career as unique as you.

Our Hybrid Working Module

• Maximize collaboration.
• Maintain product quality and cultural integrity.
• Balance community, collaboration, opportunity, productivity, and efficiency.

Health, Safety and Wellbeing

Our people are our greatest asset, and we prioritize a safe work environment. Health, safety, and wellbeing are integral to our culture, with each of us accountable for fostering a safe workplace through our “Making Health and Safety Personal” initiative. Our Zero Harm Vision drives us to reduce risks through innovative solutions, earning recognition for our global health and safety practices with the prestigious RoSPA Health and Safety Awards for six consecutive years.

Inclusivity and Diversity

WSP India is dedicated to fostering a sustainable and inclusive work environment where our greatest strength - Our People -feel valued, respected, and supported. We ensure an unbiased approach in hiring, promotion, and performance evaluation, regardless of age, gender identity, race, religion, sexual orientation, marital status, physical ability, education, social status, or cultural background.

Imagine a better future for you and a better future for us all.

Join our close-knit community of over 73,300 talented global professionals dedicated to making a positive impact. Together, we can make a difference in communities both near and far.

With us