Virtusa

SSIS Lead

Job Description

JOB DESCRIPTION

Skill: SSIS

Role / Tier: Lead software engineer – Tier 2

Key responsibility:

Responsibilities

·       Design and implement ETL using SSIS for extracting and transforming data from diverse sources, including databases and flat files.

·       Design and develop required database tables along with any required constraints as defined in detailed requirement documents.

·       Collaborate with Team members to understand source system structures and data retrieval methods/techniques, and tools within the organization.

·       Participate in troubleshooting activities to maintain data integrity and process efficiency.

·       Make changes in SSIS packages due to SQL Server upgrade from 2012 to 2022.

·       Work with Client and internal stakeholders and development teams to ensure all project requirements are met.

 

Experience/Skills:

·       Must have min. 6 years experience in performing ETL development & deployment activities for SSIS.

·       The candidate must have the ability to independently understand existing SSIS packages.

·       Experience in developing data transformation logic using SSIS with C#. Python experience is plus.

·       Experience with SQL Server and CloudSQL database technologies.

·       Experience around writing and troubleshooting T-SQL statements, creating/updating stored procedures, views, and SQL functions.

·       Experience working on AWS/GCP environments.

·       Understands different data models like normalized, de-normalized, stars etc.

·       Experience implementing various authentication methods like AD, SQL, LDAP Authentication etc.

·       Excellent communication skills: verbal and written, along with excellent documentation skills.

 

About Virtusa

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 21,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.

Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.

Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.

 

 


Jobs at Bangalore

Amazon

Ads Account Manager, Amazon Adverti…

Freshers/Experienced

Bangalore, Karnataka

View Details

Last Date: Jan. 7, 2025

IBM

Package Consultant: SAP FIN CO

Professional

Bangalore, Karnataka

View Details

Last Date: Dec. 27, 2024

KPMG

Technology Consulting-DT Intelligen…

KI Professional

Bangalore, Karnataka

View Details

Last Date: Jan. 1, 2025

Virtusa

Java DOJO

Full Time

Bangalore, Karnataka

View Details

Last Date: Dec. 31, 2024

Merck KGaA

Specialist - Generative AI

D - Professional (4-9 years)

Bangalore, Karnataka

View Details

Last Date: Dec. 24, 2024

Virtusa

Automation Testing

Full Time

Bangalore, Karnataka

View Details

Last Date: Dec. 31, 2024

Virtusa

Automation Testing

Full Time

Bangalore, Karnataka

View Details

Last Date: Dec. 31, 2024

Virtusa

.NET React Developer

Full Time

Bangalore, Karnataka

View Details

Last Date: Dec. 31, 2024

IBM

Package Consultant: SAP Ariba

Professional

Bangalore, Karnataka

View Details

Last Date: Dec. 27, 2024

Amazon

Engagement Manager , AWS Profession…

Freshers/Experienced

Bangalore, Karnataka

View Details

Last Date: Jan. 7, 2025

Amazon

Sr. Financial Analyst

Freshers/Experienced

Bangalore, Karnataka

View Details

Last Date: Jan. 7, 2025

Merck KGaA

Cloud Infrastructure Engineer

D - Professional (4-9 years)

Bangalore, Karnataka

View Details

Last Date: Dec. 24, 2024




More Jobs at Virtusa

Virtusa

Java FSD

Full Time

Hyderabad, Telangana

View Details

Last Date: June 30, 2025

Virtusa

.Net Developer

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

Component designer

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

Servicenow Developer

Full Time

Chennai, Tamil Nadu

View Details

Last Date: June 30, 2028

Virtusa

AbInitio Developer

Full Time

Pune, Maharashtra

View Details

Last Date: Dec. 31, 2024

Virtusa

Android Developer

Full Time

Hyderabad, Telangana

View Details

Last Date: July 30, 2025

Virtusa

Senior Automation Engineer

Full Time

Bangalore, Karnataka

View Details

Last Date: June 30, 2025

Virtusa

Program Manager

Full Time

Pune, Maharashtra

View Details

Last Date: Dec. 31, 2024

Virtusa

AWS Migration Engineer

Full Time

Pune, Maharashtra

View Details

Last Date: Dec. 31, 2024

Virtusa

BA - Capital Markets

Full Time

Chennai, Tamil Nadu

View Details

Last Date: Dec. 31, 2024

Virtusa

Java Developer

Full Time

Hyderabad, Telangana

View Details

Last Date: May 31, 2025

Virtusa

Senior Lead React Developer

Full Time

Chennai, Tamil Nadu

View Details

Last Date: Dec. 31, 2024