1. Analyze Client Requirements
   • Collect detailed requirements from the given brief requirements & document it (if required)
   • Assess the detailed requirements & create technical specifications document that includes the database architecture and test plans
   • Assist developers with complex query development and schema designing
2. Design & Develop Queries
   • Design queries on GCP/Local platform
   • Schedule queries to run on a recurring basis
   • Refine and automate regular processes, track issues, and document changes
   • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
3. Design & Develop Enterprise Cloud Applications/Solutions
   • Learn and use Google Cloud/ AWS products to use managed cloud services to develop and deploy enterprise data warehouse solution
4. Maintain & Monitor SQL Servers and Data Warehouse
   • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
   • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
   • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
5. Conduct research to answer industry and business questions
6. Review data for deficiencies or errors, correcting any incompatibilities, and checking output using various validation techniques
7. Maintain coding standards & Building reusable code and libraries for future use
8. Data security and Data Protection
   • Configure / set up the systems / services to maintain Cloud Servers/Warehouses securely using managed cloud security services
   • Provide limited access to users as per requirements

Functional Competencies Required:

• SQL/NoSQL
• Data Warehouse/SQL Server management
• Python/Node JS
• Cloud Technology(AWS/GCP)
• Cloud Technology(AWS/GCP)
• Data Analysis
• Reports and Visualization