SSIS Data Engineer
SSIS Data Engineer
Posted on :
23-09-2024
Employer Active
The job posting is outdated and position may be filled
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Contact Details:
1.Sandeep Bisane
Email:
Cell: (732)
Email:
Cell: (732)
2.Savitha Chinnappa
Email:
Cell: (732)
Email:
Cell: (732)
Location: Remote
Duration: 6 12 Months
Years of Experience: 8 Yrs.
Required Hours/Week: 40hrs./Week
Notes:
- ADF SSIS Azure MI or Azure SQL databases skills is mandatory.
Job Description:
- Strong background in data engineering.
- This position requires using current Data warehouse technologies design test plan implement maintain EDW databases.
Duties and Responsibilities:
- 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 handover 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.
Skills and Experience:
- 58 years related experience in data engineering with bachelors degree; or a masters degree with 3 years experience.
- 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.
- 5 years experience working with SSIS ETL packages.
- Extensive experience with MS SQL stack. (SSIS and ADF)
- Nice to have: Databricks/Python experience.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
