| Lead or Architect SQL - SSIS Data Engineer - hybrid in NJ at Remote, Remote, USA |
| Email: [email protected] |
| From: Abhijeet, CAGUS [email protected] Reply to: [email protected] Role: Lead SSIS/ SQL Data Engineer Location: Hybrid in NJ Duration: Contract Job Description: 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. Thank You, Abhijeet Karika Senior Technical Recruiter T: 732-313-0710 Extn 407 M: 732-250-0702 E: [email protected] W: www.cagus.com Core Alliance Group Inc | 370 Richard Mine Road | Wharton, NJ 07885 This email message from Core Alliance Group Inc is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Opinions, conclusions and other information in this message that do not relate to the official business of Core Alliance Group Inc shall be understood as neither given nor endorsed by it. The company accepts no liability for any damage caused by any virus transmitted by this email. Keywords: information technology New Jersey Lead or Architect SQL - SSIS Data Engineer - hybrid in NJ [email protected] |
| [email protected] View all |
| Sat Nov 09 01:38:00 UTC 2024 |