| Need SSIS Senior Data Engineer at Remote, Remote, USA |
| Email: [email protected] |
| From: Nikhil, CCIT INC [email protected] Reply to: [email protected] Job Title: SSIS Senior Data Engineer Duration: 6 months 1 year Location: Remote Key Skills: ADF, SSIS, SQL and Stored Procedures, Azure MI( Azure MI (Managed Instance) ) AND Azure SQL (Candidate must have hands on experience on these skills and all these skills must be mentioned properly in the resume). Job Description: Maintain existing SSIS/ADF pipelines. Work with senior developers to understand and acquire knowledge to support existing processes in EDW. Collaborates effectively with the development groups to deliver projects to the satisfaction of the client in a timely fashion. Designs and develops EDW processes and documentation, based on the requirements of the company. This includes collecting data, analyzing data, designing algorithms, drawing flowcharts and implementing code. Assist with code review. Write and deploy SQL code. Support existing steady state data ingestion pipelines. Ensure the distribution of knowledge for processes being designed and built within the team to ensure assigned jobs are completed accurately and according to schedule and that all deadlines are met. Ensure the design of sufficient documentation for easy and smooth hand-over of projects. Monitor and troubleshoot data pipelines to identify and resolve performance issues, bottlenecks, and data anomalies. Monitor steady state recurring monthly data ingestion tasks. The skills and qualifications you need: 8+ years related experience in data engineering with bachelors degree; or a masters degree . Ability to architect simple and complex solutions related to integration with other applications and design. High attention to detail to ensure data accuracy and consistency throughout the ETL process. Excellent communication skills, both verbal and written. Experience working under tight deadlines while maintaining high product relevance and quality. Strong advanced SQL skills: stored procedures, CTEs, cursors, database notifications and sql server agent Strong understanding of ETL process. Experience in data transformation tasks like data cleaning and aggregation. Proficiency in scripting languages used in SSIS, such as C#. Experience with Git for version control for managing SSIS packages. Proficiency in developing, deploying, and managing SSIS packages. Experience with various SSIS components like Data Flow Tasks, Control Flow Tasks, and Event Handlers. Knowledge of SSIS expressions and variables. 8 years experience working with SSIS ETL packages. Extensive experience with MS SQL stack. (SSIS and ADF) Nice to have: Databricks/Python experience. Thanks & Regards Nikhil Pathania [email protected] Keywords: csharp microsoft Michigan Need SSIS Senior Data Engineer [email protected] |
| [email protected] View all |
| Fri Sep 20 01:49:00 UTC 2024 |