Data Integration Engineer

DemandTec team, part of Acoustic, is looking for a dynamic Data Integration Engineer with end-to-end vision of what and how data would be processed and used by Merchandising applications hosted in SaaS environment. This candidate would work with a team of talented Engineers in delivering quality features using agile development methodology. Candidate should be proficient in ETL technologies with modern Big Data technologies to efficiently process ever increasing data volumes in near real-time to support merchandising apps and analytics. Ideal candidate would have performance and scalability front and center in design decisions and implementation. To succeed in this role, you need to be versatile, smart and have innate desire to build product features the right way. Finally you should be able to collaborate and communicate with major stakeholders - product manager, other application teams, support and operations.

Responsibilities:

• Design and develop robust data integration pipelines to enable seamless data movement across systems.
• Develop and optimize complex queries, stored procedures, and functions in PostgreSQL.
• Optimize PostgreSQL databases, including schema design, indexing, query optimization, and performance tuning.
• Ensure data integrity, performance, and availability of PostgreSQL databases.
• Build, maintain, and enhance ETL workflows using tools like Azure Data Factory.
• Provide ongoing support and troubleshooting for integration processes and database issues.