KEY RESPONSIBILITIES:
• Participate in requirements gathering, database design, testing and production deployments.
• Analyse system/application requirements and design innovative solutions.
• Translating business requirements to technical specifications— data streams, data integrations, data transformations, databases, data warehouses & data validation rules.
• Design and develop SQL Server database objects (i.e., tables, views, stored procedures, indexes, triggers, constraints, etc.)
• Analyze and design data flow, data lineage mapping and data models.
• Optimize, scale and reduce the cost of analytics data platforms for multiple clients.
• Adherence to data management processes and capabilities.
• Enforcing compliance with data governance and data security.
• Performance tuning and query optimizations in terms of all the database objects.
• Perform unit and integration testing.
• Create technical documentation.
• Develop and assist team members.
• Provides training to the team members.
