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.