SSIS ETL Developer

We are looking strong SSIS ETL Developer candidate.

Experience -5-9 Years..

work location -Bangalore,Hyderabad,Pune, Chennai.

Notice period- Immediate or 15 Days.

Job Summary: We are seeking a skilled SSIS ETL Developer to join our team. The successful candidate will be responsible for designing, developing, testing, and maintaining ETL processes using Microsoft SQL Server Integration Services (SSIS). The SSIS ETL Developer will collaborate with stakeholders to gather requirements, design data integration solutions, and ensure data quality and integrity throughout the ETL lifecycle.

Responsibilities:

Design, develop, and implement ETL processes using Microsoft SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources into target databases.

Collaborate with business analysts and stakeholders to gather ETL requirements and translate them into technical specifications.

Perform data profiling, cleansing, and validation to ensure data accuracy and completeness.

Optimize ETL processes for performance and scalability, tuning SQL queries and optimizing data transformation logic.

Develop and maintain documentation for ETL processes, including data mappings, transformation rules, and system dependencies.

Troubleshoot and debug ETL issues, identify root causes, and implement solutions to resolve data integration errors.

Perform unit testing and integration testing of ETL processes to validate data accuracy and integrity.

Monitor ETL jobs and workflows, analyze job logs, and proactively address job failures or performance issues.

Collaborate with database administrators, data architects, and other IT teams to ensure ETL solutions align with organizational standards and best practices.

Stay current with emerging technologies and trends in data integration and ETL development, and make recommendations for continuous improvement.

ETL Development: Creating and maintaining SSIS packages to extract data from various sources, transform it according to business requirements, and load it into target databases or data warehouses.

Data Transformation: Designing and implementing data transformations within SSIS packages using SQL queries, data conversion functions, and other SSIS components.

Performance Tuning: Optimizing the performance of SSIS packages and ETL processes to ensure efficient data extraction, transformation, and loading.

Error Handling: Implementing robust error handling and logging mechanisms within SSIS packages to capture and report errors, ensuring data integrity and reliability.

Integration: Collaborating with database administrators, data analysts, and other stakeholders to integrate SSIS solutions with existing systems and applications.

Documentation: Documenting SSIS packages, data flows, and ETL processes to facilitate maintenance, troubleshooting, and knowledge transfer