DataStage AND SSIS Developer

Infosys; Charlotte (NC); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Insurance

401(k) plan

Paid holidays

Paid Time Off

Job summary

Infosys is hiring for a Technology Consultant 2 in the Data and Analytics DNA unit in the United States. You will contribute to requirements, design discussions, coding, and production support, ensuring data workflows run reliably and efficiently.

Strong SSIS and IBM DataStage experience is essential, with SQL Server expertise to optimize performance. You will work with cross-functional teams, document processes, and help train users on new systems, while maintaining quality and incident

Qualifications

• Experience in Data Integration, ETL Development, and Production Support.
• Strong experience in SQL Server Integration Services (SSIS) development, maintenance, and support.
• Hands-on experience in IBM DataStage development and support.
• Strong proficiency in SQL Server, T-SQL, Stored Procedures, Query Optimization, and Performance Tuning.
• Experience in monitoring and supporting batch processing and ETL workflows in production environments.
• Strong troubleshooting skills with the ability to identify and resolve data, application, and performance issues.
• Experience with incident management, problem management, and change management processes.
• Good understanding of data warehousing concepts, dimensional modeling, and ETL best practices.
• Excellent analytical, problem-solving, and communication skills.
• Strong stakeholder management and coordination abilities.

Responsibilities

• Contribute to requirements elicitation by documenting assigned parts of business requirements.
• Facilitate software design discussions and document design decisions for the technical team.
• Participate in coding and integrate new features with a focus on stability.
• Conduct code reviews and maintain code repositories.
• Implement test strategies and coordinate bug fixes to uphold quality.
• Develop user training programs, documentation, and support frameworks for new software.
• Resolve production issues and suggest preventive measures to improve reliability.
• Maintain detailed records of code, testing techniques, and support activities to enrich knowledge base.

Skills

Data Integration

ETL Development

Production Support

SSIS

IBM DataStage

SQL Server

T-SQL

Stored Procedures

Query Optimization

Performance Tuning

Batch Processing

Incident Management

Problem Management

Change Management

Data Warehousing

Dimensional Modeling

ETL Best Practices

Analytical Skills

Communication Skills

Stakeholder Management

Education

Bachelor's degree

Tools

SSIS

IBM DataStage

SQL Server

T-SQL

Job description

Overview

The Infosys Data and Analytics (DNA) unit is at the forefront of transforming data into actionable insights, driving business growth and operational efficiency. We specialize in leveraging advanced AI and analytics to create innovative solutions that address complex business challenges. Our team is dedicated to pioneering the future of data-driven decision-making, enabling organizations to unlock new opportunities and achieve sustainable success. Join us to be part of a dynamic team that is revolutionizing the way businesses harness the power of data and AI. At Infosys DNA, you'll have the opportunity to work with cutting-edge technologies, collaborate with industry experts, and contribute to transformative projects that shape the future of business. We are committed to fostering a culture of continuous learning and growth, ensuring that our team members thrive in a dynamic and supportive environment. If you're passionate about AI and eager to make a significant impact, the Infosys DNA unit is the perfect place for you to grow and excel.

Overview

The Infosys Data and Analytics (DNA) unit is at the forefront of transforming data into actionable insights, driving business growth and operational efficiency. We specialize in leveraging advanced AI and analytics to create innovative solutions that address complex business challenges. Our team is dedicated to pioneering the future of data-driven decision-making, enabling organizations to unlock new opportunities and achieve sustainable success. Join us to be part of a dynamic team that is revolutionizing the way businesses harness the power of data and AI. At Infosys DNA, you'll have the opportunity to work with cutting-edge technologies, collaborate with industry experts, and contribute to transformative projects that shape the future of business. We are committed to fostering a culture of continuous learning and growth, ensuring that our team members thrive in a dynamic and supportive environment. If you're passionate about AI and eager to make a significant impact, the Infosys DNA unit is the perfect place for you to grow and excel.

In the assigned Job Role of Technology Consultant 2, your Area Of Responsibility will be as below:

• Contribute to the requirements elicitation process by documenting assigned parts of business requirements, in line with guidance provided
• Facilitate software application design discussions, and document design decisions to guide the technical team towards building software solutions
• Participate in coding and integrate new features or updates into existing applications, with a focus on maintaining system stability
• Conduct code reviews, do changes to the codebase and maintain code repositories
• Implement test strategies, analyse results, and coordinate bug fixes to uphold the software quality standards
• Develop user training programs, documentation, and support frameworks to ensure a smooth transition to new software applications
• Actively participate in resolving production issues and recommend preventive strategies to enhance system reliability
• Maintain detailed records of code, testing techniques, and support activities to enrich the knowledge base and assist other similar projects

Your Contribution To The Team

• A collaborative spirit and excellent communication skills.
• The ability to handle end to end SDLC phases from requirement gathering to implementation.
• A knack for translating complex requirements into actionable development tasks.
• A passion for design and hands‑on coding experience
• A proactive approach to testing, troubleshooting, and refining our applications.
• The ability to work with cross-functional teams and do software integration.

Required Skill And Experience

• Experience in Data Integration, ETL Development, and Production Support.
• Strong experience in Microsoft SQL Server Integration Services (SSIS) development, maintenance, and support.
• Hands‑on experience in IBM DataStage development and support.
• Strong proficiency in SQL Server, T‑SQL, Stored Procedures, Query Optimization, and Performance Tuning.
• Experience in monitoring and supporting batch processing and ETL workflows in production environments.
• Strong troubleshooting skills with the ability to identify and resolve data, application, and performance issues.
• Experience with incident management, problem management, and change management processes.
• Good understanding of data warehousing concepts, dimensional modeling, and ETL best practices.
• Excellent analytical, problem‑solving, and communication skills.
• Strong stakeholder management and coordination abilities.

Preferred Skill And Experience

• Provide L2/L3 production support for ETL applications developed
• Monitor, troubleshoot, and resolve ETL job failures, data issues, and performance bottlenecks within defined SLA timelines.
• Analyze production incidents, perform root cause analysis (RCA), and implement preventive measures.

Additional Required Qualifications

• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• This position may require relocation and/or travel to work/project location.
• Candidates authorized to work for any employer in the United States without employer‑based visa sponsorship are welcome to apply. Infosys is unable to provide immigration sponsorship for this role now or in the future.

Benefits

Along with competitive pay, as a full‑time Infosys employee you are also eligible for the following benefits:

• Medical/Dental/Vision/Life Insurance
• Long‑term/Short‑term Disability
• Health and Dependent Care Reimbursement Accounts
• Insurance (Accident, Critical Illness , Hospital Indemnity, Legal)
• 401(k) plan and contributions dependent on salary level
• Paid holidays plus Paid Time Off

About Us

Infosys is a global leader in next‑generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI‑powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always‑on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.

EEO

Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.