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.
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.
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…
You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
Come join our team—one of the largest IT and business consulting services firms in the world.