ETL Data Analyst

CTG is seeking to fill an ETL Data Analyst position for our client.

Location: Atlanta, GA / Charlotte, NC / Raleigh, NC - No Remote
Duration: 12 months

• 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 Power Center
  .

• 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.

• Informatica Power Center

• 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 Power Center 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.

• Bachelor’s degree in Computer Science, Information Systems, Business, Finance, or a related field preferred, or equivalent experience.

Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role.

CTG, a Cegeka company, delivers IT and business solutions that enhance clients' digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years' experience and a commitment to being a reliable, results-driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts.

With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's highest-growth industries.

Together, we shape what's next - working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities.

At CTG, you'll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visit

CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the…