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.
- 5+ yrs of experience in data integration and ETL development - preferably using PostgreSQL.
- Strong understanding of SQL and database structures.
- Strong expertise in PostgreSQL, including query optimization, database design, and stored procedures
- Knowledge of any one ETL tool (preferably Azure Data Factory).
- Experience with cloud platforms (AWS, Azure, or Google Cloud) and their data services.
- Knowledge of scripting languages (Python, Shell, or Bash) for data processing and automation.
- Ability to set priorities and undertake complex tasks with minimal supervision.
- Good written and verbal communication skills.
- SaaS and Cloud Experience a plus.
Education:
Bachelor's degree in Computer Science or equivalent
