Job Title: Data Engineer Location: India(Remote) Job Type: Fulltime Introduction: We are seeking a highly skilled Data Engineer to join our technology team. The ideal candidate will have a robust background in database design, query optimization, and performance tuning, with expertise in SQL Server and TSQL development. Prior hands-on experience with MongoDB and familiarity with AWS Redshift are highly desirable. This role involves managing large scale data processing projects and contributing to our data warehousing solutions. Responsibilities: Database Development and Maintenance:

• Advanced expertise in crafting complex MS SQL queries and developing robust stored procedures. Applicants should demonstrate a strong ability to optimize and troubleshoot SQL code for enhanced database performance.

• Develop and maintain SQL Server databases, optimizing for performance and scalability.

• Design and implement robust database solutions, including tables, views, indexes, and stored procedures.

• Conduct regular database schema reviews and adjust to support evolving business needs.

  Data Integration and ETL Processes:

• Design, develop, and maintain SSIS packages for seamless ETL processes.

• Manage data ingestion and integration using SQL and NoSQL databases, specifically MongoDB.

• Ensure data integrity and consistency across distributed systems.

  Performance Optimization:

• Optimize SQL queries and server performance to handle complex data operations efficiently.

• Implement and maintain performance metrics and monitoring tools to ensure system stability and quick resolution of issues.

  Cloud Data Management:

• Utilize AWS Redshift for data warehousing solutions, managing data storage and retrieval for analytical processing.

• Monitor and optimize data storage in AWS S3, ensuring data availability and security.

  Cross functional Collaboration:

• Work closely with business analysts, software developers, and project managers to meet strategic business goals.

• Provide technical guidance and support to team members, ensuring best practices in database management and data integration.

  Requirements:

• Master's degree in technology, Computer Science, or related field.

• Minimum 5 years of experience in database development, preferably with MS SQL Server.

• At least 2 years of experience working with MongoDB and AWS Redshift.

• Proven track record in designing and implementing largescale data warehouses.

  Technical Skills:

• Expertise in SQL, TSQL, and database administration.

• Proficiency in MSSSIS for ETL processes.

• Experience with MongoDB operations and database management.

• Familiarity with cloud services, particularly AWS (Redshift, S3), and data integration tools.