Ssis Developer

Tata Consultancy Services Limited; Plano (TX); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Medical Coverage (Medical & Health, *f

Dental & Vision

Family Leave: Maternal & Parental

Insurance Options: Auto & Home

Certification & Training Reimbursement

Vacation & Holidays

Job summary

Tata Consultancy Services Limited in Plano, TX is seeking an SSIS Developer to join our project team. The role requires strong SSIS package development and execution skills, including data quality checks, validation rules, exception handling, and reconciliation reporting.

Required: bachelor's degree in business or related field, 5+ years of experience with SQL and SSIS, and proven ETL/data integration expertise. Collaboration with cross-functional teams is essential for success.

Qualifications

• Bachelor's degree in business or related field.
• 5+ years experience with SQL and SSIS.
• Experience writing complex SQL queries, stored procedures, and data analysis solutions.
• Experience supporting ETL processes, data validation, exception management, and reconciliation reporting.
• Ability to lead process optimization and communicate with cross-functional teams.

Responsibilities

• Design and develop SSIS packages for data integration tasks.
• Support data quality checks, validation rules, and exception handling in ETL processes.
• Develop reconciliation reporting and data analysis solutions.
• Lead ongoing reviews of business processes and optimization strategies.
• Communicate insights and plans to cross-functional team members and management.
• Perform user acceptance testing and maintain procedures.

Job description

We are hiring a SSIS Developer to join our project team. candidates must have a strong understanding of SSIS package development and execution, including how packages support data quality checks, validation rules, exception handling, and reconciliation reporting processes. To better align candidate Qualifications with the requirements of the role

• A bachelor's degree in business or related field.
• Strong hands-on experience with SQL and SSIS.
• A minimum of 5+ years of experience writing complex SQL queries, stored procedures, and data analysis solutions.
• Proven experience supporting ETL processes, data validation, exception management, and reconciliation reporting. Based on the profiles reviewed, we do not see sufficient evidence of the required SSIS expertise and related data integration
• experience needed to effectively support the PDMART application.
• Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions using SSIS.
• Leading ongoing reviews of business processes and developing optimization strategies.
• Staying up to date on the latest process and IT advancements to automate and modernize systems.
• Effectively communicating your insights and plans to cross-functional team members and management.
• Ensuring solutions meet business needs and requirements.
• Performing user acceptance testing.
• Updating, implementing, and maintaining procedures.
• Prioritizing initiatives based on business needs and requirements.
• Monitoring deliverables and ensuring timely completion of projects.

TCS Employee Benefits Summary:

Discretionary Annual Incentive.

Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support: Maternal & Parental Leaves.

Insurance Options: Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.

Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.