| Looking for Lead SSIS/ SQL Data Engineer at NJ (Hybrid) at Remote, Remote, USA |
| Email: [email protected] |
| Job Title: Lead SSIS/ SQL Data Engineer Location: New Jersey (Hybrid) Experience 12+ Years Must Visa - USC/H4EAD/TNVISA/ H1B (PP is must for all except USC) Note - We have 4 positions. Should have data designing experience. Submit profiles with below matrix. Skill Rate out of 10 Years of experience Design and Development: Build flexible, performant, and scalable data solutions using Microsoft SQL Server, SSIS (SQL Server Integration Services) ETL and Data Pipelines: Data Modeling and Architecture: Performance Tuning and Optimization: Requirement: Job Purpose/Summary The Lead or Architect SQL/SSIS Data Engineer will be responsible for designing, developing, and maintaining robust data infrastructures, ensuring the efficient transformation of raw data into actionable insights. This role involves working closely business stakeholders, and other IT teams to implement data management strategies and solutions. Key Responsibilities Design and Development: 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. ETL and Data Pipelines: 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. Implement various transformations, error handling, and event handling techniques in SSIS to ensure efficient package execution. Data Modeling and Architecture: 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. Performance Tuning and Optimization: Optimize database performance through query tuning, indexing, and other optimization techniques. Ensure data consistency and integrity by implementing data governance and quality control measures. Warm regards, Reena Felix Recruitment Manager Email: [email protected] linkedin.com/in/reena-felix-747260248 Elite Tech Inc / www.elitetecinc.com -- Keywords: information technology Looking for Lead SSIS/ SQL Data Engineer at NJ (Hybrid) [email protected] |
| [email protected] View all |
| Fri Nov 08 22:13:00 UTC 2024 |