We are looking for an Engineer II Data Analyst to join our Data Integration team. The role will be responsible for designing, developing, maintaining, and optimizing data integration and ETL pipelines using Microsoft SQL Server technologies.The successful candidate will work with data from multiple enterprise sources such as ERP systems, CRM applications, databases, files, and APIs, transforming and integrating the data into reliable, analytics-ready data platforms.The role requires strong hands-on expertise in SQL Server, SSIS, ETL/ELT processes, data warehousing, and data integration, along with exposure to Power BI and the Microsoft BI ecosystem.

Key Responsibilities

1. Data Integration & ETL Development
- Design, develop, test, deploy, and maintain SSIS packages and ETL workflows.
- Develop robust data pipelines to extract, transform, and load data from ERP, CRM, databases, flat files, and APIs.
- Perform data cleansing, validation, standardization, enrichment, and transformation based on business requirements.
- Develop both full-load and incremental data ingestion processes.




- Integrate data from SQL Server and other relational databases, files, and external systems.
- Support onboarding and integration of current data sources.
- Implement appropriate error handling, logging, validation, and reconciliation mechanisms.
- Troubleshoot and resolve ETL and data integration issues.

2. SQL Server & Data Management
- Develop complex and optimized SQL queries, stored procedures, views, functions, and data transformations.
- Perform SQL query and ETL performance tuning and optimization.
- Work with large datasets and perform advanced data analysis and computations.
- Support data warehouse structures and analytics-ready data models.
- Apply data warehousing concepts such as fact tables, dimension tables, star schema, and dimensional modelling.

3. Job Scheduling & Production Support
- Configure and manage SQL Server Agent jobs and ETL schedules.
- Monitor scheduled data

📌 Engineer II Data Analyst SHIFT: 7 am- 4 Pm (Gurugram)
🏢 Rekrut India
📍 Gurugram