Dynamic and results-oriented Data Integration Specialist with 2.9 years of experience in designing, developing, and implementing data extraction, transformation, and loading (ETL) solutions. Proficient in utilizing SQL Server Integration Services (SSIS) for extracting, transforming, and loading data into data warehouses and other target systems. Adept at writing stored procedures and optimizing data flow processes to ensure efficient data migration and integration.
Overview
3
3
years of professional experience
Work History
Software Engineer
Motherson Technology Service Limited
Chennai
09.2021 - Current
Design and develop ETL processes using SQL Server Integration Services (SSIS) to extract data from various sources, transform it according to business requirements, and load it into the data warehouse.
Create and optimize stored procedures for data extraction, transformation, and loading operations, ensuring data integrity and performance efficiency.
Collaborate with cross-functional teams including database administrators, developers, and business analysts to understand data requirements and implement appropriate solutions.
Perform data modeling and design to ensure scalability and efficiency of the data warehouse infrastructure.
Conduct thorough testing and quality assurance procedures to validate data integrity and accuracy throughout the ETL process.
Monitor and optimize ETL processes for performance and efficiency, identifying and resolving bottlenecks and issues as they arise.
Provide support and troubleshooting assistance for data integration processes, resolving issues in a timely manner to minimize downtime and disruptions.
Document ETL processes, data mappings, and system configurations for reference and future maintenance.
Stay abreast of industry trends and best practices in data integration and warehousing technologies, continuously enhancing skills and knowledge to drive innovation and improvement.
Education
Bachelor of Science - Computer Science Engineering
Bharath University
Chennai
06-2021
Skills
Data Extraction, Transformation, and Loading (ETL)
SQL Server Integration Services (SSIS)
Stored Procedure Development
Data Warehousing
Data Modeling
Performance Tuning
Database Administration
Quality Assurance and Testing
Problem Solving
Communication and Collaboration
Looker
Python
Accomplishments
Received 'Raising Star' Award from the CEO for
the best performances throughout the year