Data Engineer (ssis, Sql Server, Etl Tools)

Job Description

Role: Data Engineer (SSIS, SQL Server, ETL Tools) Type: Contract Duration: 1 year Experience: 7-10+years Location: Remote Job Description: Detailed Job/ Role Description: Data Engineer Key Responsibilities: 1. Designing, developing, and maintaining database solutions using Microsoft SQL Server. 2. Developing and optimizing SQL queries, stored procedures, and functions for efficient data retrieval and manipulation. 3. Designing and implementing data models, schemas, and data warehouses to support business requirements and analytical needs. 4. Building and maintaining SSIS ETL processes and data pipelines to extract, transform, and load data from various sources into the SQL Server database. 5. Implementing data quality checks, data validation rules, and data cleansing processes to ensure data accuracy and integrity. 6. Performance tuning and optimization of database queries, indexes, and server configurations to improve data processing speed and efficiency. 7. Collaborating with data scientists and analysts to understand data requirements, design data structures, and implement solutions for advanced analytics and reporting. 8. Working closely with software engineers to integrate database solutions with application systems and ensure data consistency and integrity across the entire technology stack. 9. Monitoring database performance, diagnosing and resolving issues, and implementing proactive measures to prevent downtime and optimize performance. 10. Documenting database designs, data models, ETL processes, and data governance policies for knowledge sharing and compliance purposes. Requirements:- 1. Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent work experience). 2. Proven experience as a SQL Server developer or data engineer with expertise in designing and developing database solutions using Microsoft SQL Server. 3. Strong proficiency in SQL programming, including advanced querying techniques, stored procedures, functions, and performance optimization. 4. Experience with database design and data modeling concepts, including normalization, denormalization, and dimensional modeling. 5. Hands-on experience with ETL tools and technologies such as SSIS (SQL Server Integration Services) or similar data integration platforms. 6. Knowledge of data warehousing principles and best practices, including data ingestion, transformation, and storage. 7. Familiarity with data governance, data quality, and data security principles and practices. 8. Experience working with large-scale databases, high-volume transactional systems, and distributed computing environments. 9. Strong analytical and problem-solving skills, with the ability to analyze complex data sets and troubleshoot database-related issues. 10. Excellent communication and collaboration skills, with the ability to work effectively in a cross-functional team environment. Preferred Qualifications:- 1. Experience with other database technologies such as Oracle, PostgreSQL, or MySQL. 2. Familiarity with cloud-based data platforms such as Microsoft Azure SQL Database, ADF,

Employement Category:

Contact Details: