Senior Data Analyst with Informatica

CGI Group, Inc.

Reston (VA)

Hybrid

USD 84,000 - 108,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Competitive compensation

Insurance options

401(k) plan

Share purchase plan

Paid time off

Parental leave

Tuition assistance

Wellness programs

Job summary

CGI Group, Inc. seeks a Senior Data Analyst with Informatica to support enterprise data platforms in a fast-paced financial services setting.

The role involves data analysis, Informatica development, and production support from a Reston, VA client site with a hybrid work model. Responsibilities include investigating data variances, troubleshooting production issues, and validating data integrity across multiple systems.

Qualifications

Minimum 5 years in data analysis, data management, or related roles.
Hands-on Informatica development and production support experience.
Strong ability to analyze complex data issues and identify root causes in production environments.
Experience reading, troubleshooting, and modifying Informatica mappings, workflows, and ETL processes.
Advanced Oracle SQL skills for data analysis, validation, troubleshooting, and data correction.
Understanding of data warehousing concepts, data marts, data lineage, and source-to-target mappings.
Experience using tools like Toad for data verification across systems.
Ability to communicate findings to business users and stakeholders.

Responsibilities

Investigate data variances and troubleshoot production issues.
Analyze source-to-target mappings and implement data corrections.
Collaborate with business and technical teams; document requirements.
Support production environments and data integrity across systems.
Explain technical findings to non-technical users and navigate complex data flows.

Skills

Data analysis

Root cause analysis

Production support

Data quality

Communication

Stakeholder management

Tools

Informatica

Oracle SQL

AWS S3

Toad

Jira

Confluence

Python

Job description

Senior Data Analyst with Informatica supporting enterprise data platforms in a fast paced financial services setting, delivering data analysis, Informatica development, and production support from a Reston, VA client site with a hybrid work model.

Responsibilities

Investigate data variances
Troubleshoot production issues
Analyze source to target mappings
Implement data corrections
Collaborate closely with internal business stakeholders and technical teams
Analyze data issues
Review Informatica workflows and mappings
Develop and validate data corrections
Document business and technical requirements
Support production environments
Conduct stakeholder discussions
Ensure successful implementation of solutions
Identify root causes
Validate solutions
Ensure data integrity across multiple systems
Explain technical findings to non technical users
Make targeted code modifications when needed
Navigate complex data flows
Operate within a modern cloud based ecosystem leveraging AWS S3 and enterprise data integration technologies

Requirements

Minimum 5 years in business analysis, data analysis, or related data management roles
Recent, hands on Informatica development and production support experience
Strong track record of 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
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 focus on resolving production issues
Experience in 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 end to end quality verification ownership
Excellent written, verbal, and presentation skills
Mortgage industry experience (single family or multifamily) is a plus
Python experience is a nice-to-have