Senior Data Analyst with Informatica

CGI•Reston, VA

3d•Hybrid

About The Position

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.

Requirements

5+ years of Business Analysis, Data Analysis, or related Data Management experience
Recent, hands-on experience with Informatica development and production support
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
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
Bachelor's degree in Computer Science, Information Systems, or a related field