Virtusa

SSIS Lead

Posted On

June 22, 2024

Location

Bangalore, Karnataka

Experience Level

Full Time

Job Type

Experienced

Apply By

Dec. 31, 2024

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

SSIS Lead Apply Now

Job Description

Jobs at Bangalore

More Jobs at Virtusa

Actively Recruiting Companies at Bangalore, Karnataka

SSIS Lead