Snowflake, DBT, SQL, Kafka (Gurugram)

Krazy Mantra Group of Companies is looking for Snowflake, DBT, SQL, Kafka to join our agile team and embark on a rewarding career journey A SQL Developer, also known as a Database Developer, is responsible for designing, implementing, and managing database systems and writing SQL queries to retrieve and manipulate data. The job description (JD) of a SQL Developer typically includes the following responsibilities and qualifications:Job Database Design and Modeling: Create and maintain database schema designs, including tables, indexes, and relationships, using tools like ER diagrams. SQL Query Development: Write complex SQL queries, stored procedures, and triggers to extract, manipulate, and manage data efficiently. Database Optimization: Identify and resolve performance bottlenecks by optimizing SQL queries, indexing, and database configurations. Data Integration: Develop ETL (Extract, Transform, Load) processes to move data between different systems and databases. Data Security: Implement and maintain database security measures, including user access control, encryption, and data masking as necessary. Backup and Recovery: Establish and manage database backup and recovery procedures to ensure data integrity and availability. Performance Monitoring: Monitor database performance using tools like performance counters and query execution plans, and make necessary adjustments. Data Validation and Testing: Verify data accuracy through validation checks and perform unit testing and integration testing of SQL scripts. Documentation: Maintain comprehensive documentation of database schemas, processes, and code changes. Collaboration: Collaborate with other teams, such as software developers and data analysts, to understand their data needs and provide necessary support. Version Control: Use version control systems to manage database code changes and collaborate effectively with team members. Troubleshooting: Diagnose and resolve database-related issues and pro .