Position Description:

Skills Required with 7+ Years experience

Proficient in designing, developing, and maintaining ETL processes using tools such as Informatica, and 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 Informatica, 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 Informatica mappings and implement various performance tuning techniques.

Skills:

• Data Warehousing
• Informatica
• Oracle
• GIT
• GIT

What you can expect from us:

Insights you can act on

While technology is at the heart of our clients’ digital transformation, we understand that people are at the heart of business success.

When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes. We call our employees “members” because they are CGI shareholders and owners, and, as owners, we enjoy working and growing together to build a company we are proud of. This has been our Dream since 1976, and it has brought us to where we are today—one of the world’s largest independent providers of IT and business consulting services.

At CGI, we recognize the richness that diversity brings. We strive to create a work culture where everyone belongs, and we collaborate with clients in building more inclusive communities. As an equal opportunity employer, we empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist.

Ready to become part of our success story? Join CGI—where your ideas and actions make a difference.