Senior Data Analyst with Informatica

Category: Software Development/ Engineering

Main location: United States, Virginia, Reston

Position ID:J0626-0565

Employment Type: Full Time

Position Description:

CGI is seeking a Senior Data Analyst with Informatica skills to support critical enterprise data platforms within a fast-paced financial services environment. This role combines deep data analysis expertise with hands-on Informatica development and production support responsibilities. The ideal candidate will investigate data variances, troubleshoot production issues, analyze source-to-target mappings, and implement data corrections while collaborating closely with internal business stakeholders and technical teams.

This role is located at a client site in Reston, VA. A hybrid working model is acceptable.

Your future duties and responsibilities:

CGI is seeking a Senior Data Analyst with Informatica skills to support critical enterprise data platforms within a fast-paced financial services environment. This role combines deep data analysis expertise with hands-on Informatica development and production support responsibilities. The ideal candidate will investigate data variances, troubleshoot production issues, analyze source-to-target mappings, and implement data corrections while collaborating closely with internal business stakeholders and technical teams.

The position is heavily focused on data analysis and problem resolution, requiring strong SQL and Informatica skills to identify root causes, validate solutions, and ensure data integrity across multiple systems. The successful candidate will be comfortable navigating complex data flows, explaining technical findings to non-technical users, and making targeted code modifications when needed. This role operates within a modern cloud-based ecosystem utilizing AWS S3 and enterprise data integration technologies.

Key responsibilities include analyzing data issues, reviewing Informatica workflows and mappings, developing and validating data corrections, documenting business and technical requirements, supporting production environments, conducting stakeholder discussions, and ensuring successful implementation of solutions. The role requires a strong analytical mindset, the ability to work independently, and excellent communication skills to support high-visibility initiatives.

Required qualifications to be successful in this role:

. 5+ years of Business Analysis, Data Analysis, or related Data Management experience
. Recent, hands-on experience with Informatica development and production support is required
. Strong experience analyzing complex data issues and identifying root causes in production environments
. Hands-on experience reading, troubleshooting, and modifying Informatica mappings, workflows, and ETL processes
. Advanced Oracle SQL skills for data analysis, validation, troubleshooting, and data correction activities
. Solid understanding of data warehousing concepts, data marts, data lineage, and source-to-target mappings
. Experience comparing and validating data across multiple systems using tools such as Toad
. Ability to perform data corrections, validate results, and certify data quality after implementation
. Strong problem-solving and investigative skills with a focus on resolving production support issues
. Experience working within Agile environments using Jira and Confluence
. Ability to communicate technical findings effectively to business users and internal stakeholders
. Experience gathering, documenting, and translating business requirements into technical solutions
. Comfortable working independently while managing multiple priorities and deadlines
. Familiarity with AWS-based data environments, particularly AWS S3, is beneficial
. Understanding of application development concepts and ability to interpret existing code implementations
. Strong testing and validation skills with the ability to own end-to-end quality verification
. Excellent written, verbal, and presentation skills

Desired Skillset:

. Mortgage industry experience (Single-Family or Multifamily) is a plus
. Python experience is considered a nice-to-have

Education:
Bachelor's degree in Computer Science, Information Systems, or a related field.

Other Information:
CGI is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. To support the ability to reward for merit-based performance, CGI typically does not hire individuals at or near the top of the range for their role. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $83,800.00 - $108,300.00.
CGI's benefits are offered to eligible professionals on their first day of employment to include: . Competitive compensation . Comprehensive insurance options . Matching contributions through the 401(k) plan and the share purchase plan . Paid time off for vacation, holidays, and sick time . Paid parental leave .Learning opportunities and tuition assistance . Wellness and Well-being programs

Skills:

• Agile
• Amazon Web Services Cloud
• Data Analysis
• Data Management
• ETL
• Problem Solving
• SQL