Enterprise Data Integration Engineer for JSON & Pega

Castello Systems, Inc.; Corridor North (MD); On-site; USD 90,000 - 140,000; Full time

Job summary

Castello Systems, Inc. is seeking a data engineer to support enterprise data modernization and integration across critical workflows.

The role focuses on ingesting, transforming, validating and managing operational data spanning acquisition, finance, HR, logistics, training, security and program management systems. The ideal candidate will combine database engineering, data integration and automation experience, with the ability to implement structured ingestion workflows, JSON-based

Qualifications

• Experience with data ingestion workflows and JSON representations.
• Ability to validate, troubleshoot and optimize data ingestion processes.
• Experience collaborating with engineers and stakeholders on data mappings and integration requirements.

Responsibilities

• Support ingestion of spreadsheet and structured data sources into enterprise databases and applications.
• Develop and maintain data transformation workflows including conversion of source data into JSON representations.
• Validate, troubleshoot and optimize data ingestion and synchronization processes.
• Support enterprise database operations and ensure integrity, availability and consistency of operational data; assist with integration into Pega workflows.
• Collaborate with software engineers, systems engineers and stakeholders to define data mappings, validation rules and integration requirements.
• Support development and maintenance of reporting and downstream data consumption capabilities.
• Monitor database performance and assist with troubleshooting operational issues.
• Participate in automation and modernization initiatives across enterprise services.
• Document database structures, data flows, ingestion processes and operational procedures.

Skills

Database engineering

Data integration

Automation

JSON transformations

Pega systems

Tools

Pega

Job description

Castello Systems, Inc. is seeking a data engineer to support enterprise data modernization and integration across critical workflows.

The role focuses on ingesting, transforming, validating and managing operational data spanning acquisition, finance, HR, logistics, training, security and program management systems. The ideal candidate will combine database engineering, data integration and automation experience, with the ability to implement structured ingestion workflows, JSON-based