Title: Data Engineer
Duration: 12 Months (C2H)
Location: Iselin NJ
Responsibilities:
- Build flexible performant and scalable data solutions using Microsoft SQL Server SSIS (SQL Server Integration Services)
- Create complex SQL objects such as tables stored procedures functions views indexes and triggers to facilitate efficient data manipulation and consistency.
- Develop and maintain ETL packages using SSIS to extract data from various sources (e.g. flat files XML files CSV files Access Excel) and load it into data warehouses.
- Design and develop conceptual logical and physical data models to support analytic data requirements and business intelligence needs.
- Translate business needs into data models and database schema based on requirements gathered from business stakeholders.
- Optimize database performance through query tuning indexing and other optimization techniques
- Implement various transformations error handling and event handling techniques in SSIS to ensure efficient package execution.
ETL SSIS,SSIS,SQL,Data Engineering,AWS