Data Engineer - Tek Leaders Inc

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.