Data Warehouse Development

A. Database / Data Warehouse Development

• Design, develop, and optimize relational databases and data warehouses.
• Implement ETL (Extract, Transform, Load) processes and data pipelines.
• Ensure data synchronization, integrity, availability, and performance tuning.
• Support reporting and business intelligence needs.

B. Middleware & API Development

• Develop and manage middleware solutions for system interoperability.
• Design, build, and maintain RESTful and/or SOAP APIs.
• Support integration with internal and third-party systems.

C. Front-End Programming

• Design and develop web interfaces and dashboards.
• Integrate front-end solutions with back-end services and APIs.

D. General Technical Support

• Provide documentation, knowledge transfer, and training.

Deliverables

• Functional database/data warehouse schemas and ETL workflows.
• Reporting Dashboard (real-time) development
• Working middleware and API services with documentation.
• Technical documentation for all developed components.
• Knowledge transfer and support during handover.

• Strong experience in MS SQL Server, or other RDBMS; exposure to cloud DB instances is an advantage.
• Proven expertise in database/data warehouse design, ETL, and BI/reporting tools.
• Experience in middleware platforms and API development (REST, SOAP, JSON, XML).
• Proficiency in front-end technologies (HTML5, CSS3, JavaScript/TypeScript, React/Angular/Vue).
• Knowledge of security, performance optimization, and scalability.