Job Description – SQL / PostgreSQL Developer (EDI & Data Integration)

Experience: 5–10 Years
Role: SQL / PostgreSQL Developer – EDI & Data Integration
Location: As per project requirement

About the Job
We are looking for an experienced SQL / PostgreSQL Developer with robust database development, data processing, and troubleshooting skills. The ideal candidate should have excellent communication skills and experience working with EDI, standardized file formats, file generation, and secure file transfers (SFTP).
Candidates with hands-on experience in PostgreSQL and EDI will be preferred. Experience with Pentaho Data Integration (PDI/Kettle) is an advantage; however, candidates with strong SQL skills and relevant data integration experience may also be considered.

Key Responsibilities
• Develop, maintain, and optimize complex SQL queries, joins, subqueries, views, functions, and stored procedures.
• Work with relational databases, preferably PostgreSQL, to support data processing and integration requirements.
• Develop and maintain data extraction, transformation, and loading (ETL)



processes.
• Work with EDI transactions, standardized file formats, and data exchange processes.
• Generate, transform, validate, and troubleshoot output files according to defined formats and business requirements.
• Manage and troubleshoot secure file transfers using SFTP.
• Investigate data discrepancies, processing failures, and production issues, ensuring data accuracy and integrity.
• Monitor scheduled jobs and file-processing workflows to ensure timely completion.
• Collaborate with technical teams, business stakeholders, and external partners to understand requirements and resolve issues.
• Document technical processes, file specifications, database changes, and troubleshooting procedures.
• Support production deployments, incident resolution, and ongoing process improvements.

Required Skills
• Strong hands-on SQL development experience, including complex queries, joins, subqueri

📌 SQL / PostgreSQL Developer (EDI & Data Integration) (India)
🏢 InfoBeans
📍 India