ETL Data Analyst

Computer Task Group, Inc•Atlanta, GA

1d•Onsite

About The Position

CTG is seeking to fill an ETL Data Analyst position for our client. This is a 12-month contract role located in Atlanta, GA, Charlotte, NC, or Raleigh, NC, with no remote work option. The role involves analyzing banking regulatory reporting requirements, identifying data for these reports, performing data analysis using SQL, and developing ETL workflows using Informatica PowerCenter. The analyst will also be responsible for documentation, supporting data integration, and collaborating with various teams.

Requirements

Informatica PowerCenter
ETL Design & Development
Advanced Oracle SQL
Data Profiling, Validation & Reconciliation
Source-to-Target Mapping & Data Lineage
Data Warehousing & Data Integration
Regulatory Reporting Data Sourcing
Data Quality & Root Cause Analysis
Requirements Analysis & Impact Analysis
ETL Performance Tuning
Production Support & Release Management
Data Governance & Regulatory Compliance
Axiom Data Sourcing / Regulatory Reporting
Basel 3 Standards
Strong banking and financial services domain experience, including Loans, Deposits, Customer, General Ledger, Treasury, Risk, and Financial Reporting data.
Hands-on Informatica PowerCenter development experience, including complex mappings, transformations, sessions, workflows, reusable components, performance tuning, and production support.
Experience supporting Axiom regulatory reporting solutions and banking regulatory reports such as Call Reports (FFIEC 031/041), FR Y-9C, and FR Y-14.
Advanced SQL experience in data warehouse and regulatory reporting environments, including profiling, validation, reconciliation, and data quality analysis.
Experience with data warehousing concepts, dimensional modeling, ETL best practices, and enterprise data integration frameworks.
Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

Responsibilities

Analyze banking regulatory reporting requirements, including Call Reports, FR Y-9C, FR Y-14, Basel 3, and other regulatory submissions.
Analyze source systems, data structures, relationships, and business rules to identify data required for regulatory reporting.
Perform advanced SQL-based data profiling, validation, reconciliation, data quality analysis, and root cause investigation.
Design, develop, enhance, and support ETL workflows, mappings, sessions, and transformations using Informatica PowerCenter.
Develop and maintain source-to-target mappings, data lineage, data definitions, ETL specifications, and business rule documentation.
Gather and translate business and regulatory requirements into data sourcing, mapping, and ETL specifications.
Investigate data discrepancies, ETL failures, reconciliation breaks, and reporting issues; perform root cause and impact analysis.
Support data integration, batch processing, production validation, testing, releases, and regulatory reporting enhancements.
Optimize ETL workflows for performance, scalability, and reliability.
Collaborate with Regulatory Reporting, Finance, Risk, Compliance, Business, and Technology teams.
Maintain documentation and controls supporting data governance, audits, regulatory compliance, and examination requests.