Data Engineer

Location: Mumbai (Andheri East)

Designation: Data Engineering/Analytics

Job Summary:

We are looking for a Data Engineer with up to 5 years of experience in ETL processes to lead the migration of MongoDB data to MSSQL. The ideal candidate will design, develop, and optimize data pipelines, ensuring seamless data transformation, integrity, and performance.

Key Responsibilities:

• Design and implement ETL workflows for migrating data from MongoDB to MSSQL.
• Develop data transformation and cleansing processes to ensure data integrity.
• Optimize data pipelines for performance, scalability, and reliability.
• Collaborate with database administrators and business teams to define migration strategies.
• Work with SQL Server tools (SSIS, T-SQL) for data integration.
• Monitor and troubleshoot ETL workflows to ensure smooth operations.
• Maintain documentation for migration processes, data models, and pipeline configurations.

Required Skills & Qualifications:

• Proficiency in MongoDB and MSSQL (schema design, indexing, query optimization).
• Strong knowledge of ETL tools (SSIS, Talend, Informatica).
• Experience in data migration strategies and performance tuning.
• Expertise in SQL Server (stored procedures, triggers, views).
• Understanding of data governance, security, and compliance.

Preferred Qualifications:

• Experience with cloud-based data migration (AWS RDS).
• Knowledge of MongoDB aggregation framework.
• Exposure to CI/CD pipelines for database deployments.