Job Description

:

MSBI Developer (ETL SSIS Package)

Job Location: Hyderabad / Bangalore / Chennai / Kolkata / Noida/ Gurgaon / Pune / Indore / Mumbai

Responsibilities:

• Proven 4+ years\xe2\x80\x99 experience as an SSIS and T-SQL developer, with a strong understanding of ETL concepts and data integration methodologies.
• Proficiency in designing and developing SSIS packages using SQL Server Integration Services.
• Expertise in writing complex T-SQL queries, stored procedures, and functions for data manipulation and integration.
• Solid understanding of relational database concepts and experience working with Microsoft SQL Server.
• Familiarity with data modelling, data warehousing, and dimensional modelling concepts.
• Design, develop, and maintain SSIS packages to extract, transform, and load data from various data sources into target systems.
• Write and optimize/tune T-SQL queries, stored procedures, and functions to support data integration, manipulation, and reporting needs.
• Perform data profiling, validation, and cleansing to ensure data quality and integrity throughout the ETL processes.
• Identify and resolve performance bottlenecks, data quality issues, and data integration errors through troubleshooting and optimization techniques.
• Monitor and maintain data integration workflows, ensuring scheduled jobs run successfully and handling error handling and recovery processes.
• Implement and adhere to best practices and coding standards for SSIS and T-SQL development, ensuring scalability, maintainability, and reusability of solutions.
• Conduct unit testing and participate in system testing and user acceptance testing (UAT) to ensure the accuracy and reliability of data integration processes.

DXC Technology