Server Side Integration Services (SSIS) is a Microsoft data integration tool that allows developers to extract transform and load (ETL) data between different relational databases and file formats. It's a powerful tool for data warehousing data migration and data cleansing. About The Role : for an SSIS Developer: An SSIS developer is responsible for designing developing and maintaining data integration solutions using SSIS. They work closely with business analysts data architects and database administrators to understand data requirements and create efficient ETL processes. Key Responsibilities: Data Analysis:Analyze source and target data systems to understand data structures relationships and quality requirements. ETL Process Design:Design ETL processes including data extraction transformation and loading logic to meet business requirements. SSIS Package Development:Develop SSIS packages using the SSIS Designer incorporating control flow data flow and script tasks. Data Transformation:Implement data transformations such as filtering sorting aggregating joining and deriving new data. Data Quality:Ensure data quality by implementing data cleansing and validation rules. Performance Optimization:Optimize SSIS packages for performance by identifying bottlenecks and improving execution time. Error Handling:Implement error handling mechanisms to address data integrity issues and prevent package failures. Documentation:Create clear and concise documentation for SSIS packages including design specifications user manuals and troubleshooting guides. Maintenance:Maintain and support existing SSIS packages making necessary updates and troubleshooting issues. Required Skills: Strong understanding of SQL and database concepts (e.g. relational databases data warehousing data modeling) Proficiency in SSIS development including control flow data flow and script tasks Knowledge of data extraction and loading techniques from various sources (e.g. databases files web services) Experience with data transformation and cleansing techniques Ability to write efficient SQL queries and stored procedures Problem-solving and analytical skills Attention to detail and accuracy Strong communication and teamwork skills Additional Skills (Preferred): Experience with data warehousing and business intelligence concepts Knowledge of other ETL tools (e.g. Informatica Talend) Experience with cloud-based data platforms (e.g. Azure Data Factory AWS Glue) Scripting skills (e.g. PowerShell Python) By effectively combining technical expertise with a strong understanding of business requirements SSIS developers play a crucial role in ensuring data accuracy consistency and timely delivery for organizations. Named Job Posting? (if Yes - needs to be approved by SCSC)Additional Details

Global Grade :B

Level :To Be Defined

Named Job Posting? (if Yes - needs to be approved by SCSC) :No

Remote work possibility :Yes

Global Role Family :60236 (P) Software Engineering

Local Role Name :6504 Developer / Software Engineer

Local Skills :5161 Microsoft SQL Server Integration Services (SSIS)

Languages Required::English

Role Rarity :To Be Defined

More Jobs at Growel Softech Pvt. Ltd.

Data Engineer

andhra pradesh

10.0 - 14.0 yrs

INR 8 - 16 Lacs

Tester

karnataka

7.0 - 10.0 yrs

INR 10 - 12 Lacs

SAP FI Professional

maharashtra

4.0 - 6.0 yrs

INR 5 - 8 Lacs

Sub con recruiter

maharashtra

2.0 - 4.0 yrs

INR 4 - 7 Lacs

VT&M_LST-ESTAR_B2_PYTHON_IN-PNQ

maharashtra

2.0 - 7.0 yrs

INR 3 - 6 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

Growel Softech Pvt. Ltd.

Information Technology Services

Thane

Login to

Please Verify Your Phone or Email

Confirm Action

SSIS