Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by CGI Group Team. If you also belong to the team, you can get access from here

CGI Group Verified Tick

Compare button icon Compare button icon Compare
4.0

based on 4.3k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern
filter salaries All Filters

43 CGI Group Jobs

Sr. SSIS Support Analyst

5-10 years

Bangalore / Bengaluru

1 vacancy

Sr. SSIS Support Analyst

CGI Group

posted 4hr ago

Job Role Insights

Flexible timing

Job Description

Job Title: Sr. SSIS Support Analyst
Position: Sr. SSIS Support Analyst
Experience: 5 to 10 Years
Category: Software Development/Engineering
Job Location: Bangalore
Shift Timings: 9:00 AM to 6:00 PM
Mode of Work: Hybrid (3 Days WFO)
Position ID: J0125-0928

Skills Required with 7+ Years experience
Proficient in designing, developing, and maintaining ETL processes using tools such as SSIS.
Solid understanding of data integration concepts, data mapping, and data modeling.
Expertise in SQL programming and relational database management systems (e.g., Oracle SQL Server, MySQL). Ability to write complex queries, optimize performance, and troubleshoot database-related issues.
Experience in automating ETL processes, data validation, and system monitoring tasks.
In-depth knowledge of data warehousing concepts,
production support and resolving issues in a fast-paced environment. Proficient in troubleshooting ETL job failures, system errors, and data discrepancies.
Roles Responsibilities:
Design, develop, and maintain ETL processes using SSIS, extracting data from diverse sources, transforming it according to business rules, and loading it into target systems.
Collaborate closely with business analysts and stakeholders to gather requirements, perform data analysis, and design robust data integration solutions that align with business needs.
Provide exceptional production support, promptly diagnosing and resolving ETL job failures, system errors, and data discrepancies to minimize downtime and ensure uninterrupted business operations.
Create and maintain detailed technical documentation, including ETL specifications, data mappings, and process flow diagrams.
Actively collaborate with cross-functional teams, including database administrators, developers, and testers, to coordinate release deployments and successfully implement enhancements and bug fixes.
Identify performance issues in existing sources, targets, and mappings by analyzing data flow, evaluating transformations, and tuning accordingly for better performance.
Document unit test cases and Informatica mappings, prepare documentation for business data flow from source to target, and provide weekly status reports to the Project Manager.
Perform unit testing and integration testing of mappings and implement various performance tuning techniques.
Design, develop, and maintain ETL processes using SSIS, extracting data from diverse sources, transforming it according to business rules, and loading it into target systems.
Collaborate closely with business analysts and stakeholders to gather requirements, perform data analysis, and design robust data integration solutions that align with business needs.
Provide exceptional production support, promptly diagnosing and resolving ETL job failures, system errors, and data discrepancies to minimize downtime and ensure uninterrupted business operations.
Create and maintain detailed technical documentation, including ETL specifications, data mappings, and process flow diagrams.
Required qualifications to be successful in this role:
Proficient in designing, developing, and maintaining ETL processes using tools such as SSIS.
Solid understanding of data integration concepts, data mapping, and data modeling.
Expertise in SQL programming and relational database management systems (e.g., Oracle SQL Server, MySQL). Ability to write complex queries, optimize performance, and troubleshoot database-related issues.
Experience in automating ETL processes, data validation, and system monitoring tasks.
In-depth knowledge of data warehousing concepts,
production support and resolving issues in a fast-paced environment. Proficient in troubleshooting ETL job failures, system errors, and data discrepancies.
Skills:
  • GIT
  • GIT
  • .Net Remoting
  • Database
  • GitHub
  • SoapUI




.






Employment Type: Full Time, Permanent

Read full job description

Prepare for Support Analyst roles with real interview advice

People are getting interviews at CGI Group through

(based on 290 CGI Group interviews)
Job Portal
Referral
Campus Placement
Company Website
Walkin
Recruitment Consultant
50%
12%
12%
10%
2%
2%
12% candidates got the interview through other sources.
High Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.

What people at CGI Group are saying

5.0
 Rating based on 1 Support Analyst review

Likes

Work life balance,one of the best service based company

Dislikes

Nothing

Read 1 review

Support Analyst salary at CGI Group

reported by 4 employees with 2-7 years exp.
₹6.2 L/yr - ₹9.6 L/yr
14% more than the average Support Analyst Salary in India
View more details

What CGI Group employees are saying about work life

based on 4.3k employees
80%
88%
68%
81%
Flexible timing
Monday to Friday
No travel
Day Shift
View more insights

CGI Group Benefits

Submitted by Company
Be recognized
Be well
Be rewarded
Be heard
Submitted by Employees
Work From Home
Soft Skill Training
Cafeteria
Health Insurance
Team Outings
Gymnasium +6 more
View more benefits

Compare CGI Group with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Tech Mahindra

3.6
Compare

LTIMindtree

3.8
Compare

Mphasis

3.4
Compare

Hexaware Technologies

3.6
Compare

KPIT Technologies

3.5
Compare

Accenture

3.9
Compare

Cognizant

3.8
Compare

Capgemini

3.8
Compare

Genpact

3.9
Compare

IBM

4.1
Compare

DXC Technology

3.7
Compare

NTT Data Information Processing Services

4.0
Compare

Sutherland Global Services

3.7
Compare

Virtusa Consulting Services

3.8
Compare

GlobalLogic

3.7
Compare

Eviden

3.6
Compare

Similar Jobs for you

Ssis Developer at CriticalRiver Inc.

Hyderabad / Secunderabad

8-12 Yrs

₹ 8-11 LPA

Senior Developer at Jade Global Software Pvt. Ltd.

Pune

4-8 Yrs

₹ 7-11 LPA

Ssis Developer at Luxoft

Gurgaon / Gurugram

5-9 Yrs

₹ 7-11 LPA

Ssis Developer at Luxoft

Bangalore / Bengaluru

5-9 Yrs

₹ 7-11 LPA

Senior Software Engineer at CGI Information Systems and Management Consultants

Hyderabad / Secunderabad

6-9 Yrs

₹ 9-12 LPA

Senior Software Engineer at CGI Information Systems and Management Consultants

Hyderabad / Secunderabad

6-9 Yrs

₹ 9-12 LPA

Ssis Developer at Evnek

Hyderabad / Secunderabad

7-10 Yrs

₹ 12-14 LPA

Software Engineer at Stream Global Services Pvt Ltd

Bangalore / Bengaluru

3-6 Yrs

₹ 11-16 LPA

Software Engineer at Stream Global Services Pvt Ltd

Ahmedabad

3-6 Yrs

₹ 11-16 LPA

Software Engineer at Stream Global Services Pvt Ltd

Chennai

3-6 Yrs

₹ 11-16 LPA

Sr. SSIS Support Analyst

5-10 Yrs

Bangalore / Bengaluru

12hr ago·via naukri.com

Senior Software Engineer - Mainframe Engineer

6-9 Yrs

Hyderabad / Secunderabad

12hr ago·via naukri.com

SAP IS OIL - Downstream

4-7 Yrs

Bangalore / Bengaluru

12hr ago·via naukri.com

Senior Software Engineer

6-9 Yrs

Hyderabad / Secunderabad

12hr ago·via naukri.com

Project / Program PMO Analyst

4-8 Yrs

Bangalore / Bengaluru

12hr ago·via naukri.com

Sr. Azure iPaaS Developer / Azure iPaaS Developer

5-9 Yrs

Bangalore / Bengaluru

12hr ago·via naukri.com

SE-ES Elastic Search

3-4 Yrs

Bangalore / Bengaluru

12hr ago·via naukri.com

Dataiku Administrator

0-4 Yrs

Hyderabad / Secunderabad

12hr ago·via naukri.com

Senior Test Analyst (Automation)

5-6 Yrs

Bangalore / Bengaluru

12hr ago·via naukri.com

Salesforce Sales Cloud Developer

7-10 Yrs

₹ 20 - 25L/yr

Hyderabad / Secunderabad, Chennai, Bangalore / Bengaluru

14hr ago·via naukri.com
write
Share an Interview