Informatica ETL Lead
Phoenix, AZ
Experience: 0
Category: Information Technology
Contractor Work Model: Hybrid
Brand: System One
Job ID: 341977
Date Posted: 10/03/2025
Shortcut: http://jobs.systemone.com/FrXhgZ
Position Title: Informatica ETL Lead – Regulatory Risk & Compliance
Provide locations/flexible work by preference: 1. Most preferred - Phoenix - Biltmore AND North Texas Market TX - Dallas Innovation Center - Luna Rd AND Pittsburgh PA - Two PNC Plaza 2. Remaining hubs - no particular order - Cleveland OH - Strongsville Technology Center, Birmingham AL - Birmingham - Brock,
Ability to work remote: Hybrid - 3 days in office, 2 remotely
Acceptable time zone(s): Flexible based on location
Reason for open position: Backfill
Function of the Group: Mitigates risks
Industry background: Banking background is a plus, but open to all backgrounds
Regulatory Risk and Compliance Reporting
The Regulatory Risk and Compliance Reporting team in Business Technology and Innovation Group at PNC is dedicated to developing innovative technology solutions to support the Regulatory submissions of the Bank. The specific role is for an ETL lead who will work on data intensive Applications that support business and regulatory requirements. The role requires proficiency in leading, collaborating, designing, and programming data related changes from consumption to reporting.
General
- Aligns business strategy with software solutions.
- Must possess strong communication skills, both written and verbal.
- Candidate must actively and independently strive to broaden technology and business knowledge.
- Displays an innovative approach to apply modern software development principles, methodologies, and tools to advance business initiatives and capabilities.
- Formal experience in working in projects with a methodology (waterfall, agile)
- Banking and Regulatory Reporting experience a plus
Must Have Technical Skills:
- Advanced design and programming skills in Informatica power center 9.6 & above and Oracle SQL/PLSQL
- Proficiency in developing and debugging the PL/SQL Code.
- Develop SCD mappings with difference source formats using necessary Transformations.
- Performance tuning of Targets, Source, Mappings, Sessions, and Workflows.
- Design HTTP Transformations.
- Experienced in handling the ETL Code deployments using DevOps Tools
- Hands on knowledge with UNIX shell scripting and CA7 job scheduler
- Intermediate level skills in data analysis and data modeling
Flex Skills/Nice to Have:
- Experience with Alteryx
- BI tools such as Microsoft Power BI / Tableau / Oracle BI
- Hands on Knowledge using Teradata
- Working knowledge of software design patterns and architecture
- Leads complex problem solving and provides technical guidance and support to colleagues and solution development.
- Proposes, designs & codes software solutions to address complex business needs.
- Oversees technical and procedural documentation as required.
Education/Certifications:
- Bachelor's Degree is required
- Any JAVA certifications is a plus
Role Differentiator: Exposure to new technology, great team, rich culture. Scope of the project is different - get lots of opportunity to explore and grow in their role.
Interview Process:
2 Rounds
1st Round - 2-3 person panel - 30-45mins - technical
2nd Round - 2-3 person panel - 30-45mins - technical
Skills:
- Advanced design and programming skills in Informatica power center 9.6 & above and Oracle SQL/PLSQL
- Design HTTP Transformations.
- Develop SCD mappings with difference source formats using necessary Transformations.
- Experienced in handling the ETL Code deployments using DevOps Tools.
- Hands on knowledge with UNIX shell scripting and CA7 job scheduler
- Intermediate level skills in data analysis and data modeling.
- Performance tuning of Targets, Source, Mappings, Sessions, and Workflows.
- Proficiency in developing and debugging the PL/SQL Code.
Share your resume with ariz.khan@systemone.com. Also connect me at LinkedIn : (16) Ariz J. Khan | LinkedIn
System One, and its subsidiaries including Joulé, ALTA IT Services, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.
#M-
#LI-
#DI-
Ref: #404-IT Pittsburgh
-
Senior Big Data Engineer (Python/PySpark)
Strongsville, OH
Position Title: Senior Big Data Engineer (Python/PySpark) Provide locations/flexible work by preference: 1. Pittsburgh PA - Two PNC Plaza OR Cleveland OH - Strongsville Technology Center **Please note, the hiring team is not looking to source out of an...
Date Posted: 09/30/2025 Recommended
-
Data Engineer
Washington, DC
Job Title: Data Engineer Location: Remote - Eastern Time Zone Type: Contract - I year to start Compensation: $95000 - $140000 annually Contractor Work Model: Remote Security Clearance: US Citizenship Required The Data Engineer supports data platforms, ...
Date Posted: 11/09/2025 Recommended
-
Senior Data Engineer (SQL/Informatica)
Birmingham, AL
Position Title: Senior Data Engineer (SQL/Informatica) Position Location: Open to all locations including the listed satellite locations - no preference of order Pittsburgh PA - Two PNC Plaza 620 Liberty Ave Pittsburgh, PA 15222 Cleveland OH - Strongsv...
Date Posted: 09/26/2025 Recommended
-
Lead Sterling B2B ITX Engineer - Hybrid - 1 day month onsite
Reston, VA
Job Title: Lead Sterling B2B ITX Engineer Location: REMOTE Type: Contract To Hire Compensation: NEGOTIABLE Contractor Work Model: Remote Interview Process: Two. First is via Teams. 2nd and final interview is onsite in DC - candidate must be able to do ...
Date Posted: 11/25/2025 Recommended
-
Data Engineer
Crystal City, Virginia
Title: Data Engineer Timeline to Start: ASAP Clearance: TS/SCI required. CI Poly preferred Worksite Address: Crystal City, VA, On-Site in SCIF Work Schedule: M-F 9-5 pm EST, Full-time 40 hours Required Education Bachelor’s degree in data engineering, c...
Date Posted: 12/09/2025 Recommended
-
Java Developer
Fairfield, Ohio
Job Title: P & C industry mandatory -Java Developer W2 ONLY Location: Fairfield, Ohio Type: Contract Compensation: Contractor Work Model: Remote Hours: Add the job’s scheduled days and times (delete if not needed) Security Clearance: List security clea...
Date Posted: 12/16/2025 Recommended
-
Senior Mainframe Programmer
Pittsburgh, PA
Request: Mainframe Programmer Position Location: Most of team in Pittsburgh (preferred) Pittsburgh PA Two PNC Plaza 620 Liberty Ave, Pittsburgh, PA 15222 Cleveland OH Strongsville Technology Center 8100 Mohawk Dr., Strongsville, OH 44136 Birmingham AL ...
Date Posted: 09/25/2025 Recommended
-
SME Oracle APEX Developer
Washington, DC
Oracle APEX Developer 100% Onsite in Washington DC 20036 Per Federal Contract U.S. Citizenship Required Must be able to pass federal background investigation (3-8 weeks) for DOJ Public Trust Clearance 6- 18 month Contract (Possibly Permanent based on p...
Date Posted: 12/16/2025 Recommended
-
Business Systems Analyst Lead
Pittsburgh, PA
Position Title: Business Systems Analyst Lead Provide locations/flexible work by preference: 1. Most preferred - Pittsburgh PA . Second preferred - North Texas Market TX - Dallas Innovation Center - Luna Rd 3. Remaining hubs - no particular order - Cle...
Date Posted: 09/22/2025 Recommended
-
SQL Server / Oracle DBA (onsite)
Washington, DC
SQL Server / Oracle DBA Washington, DC - 100% ONSITE Must be U.S. citizen or Green Card Holder who has resided in the U.S. for at least 3 years and the ability to obtain a Public Trust $57-58/hr W2 NO C2C This role is responsible for the installation, ...
Date Posted: 12/10/2025 Recommended
-
Strategic Sourcing Analyst
Ashburn, VA
Job Title: Strategic Sourcing Analyst Location: Vienna, VA Hybrid: onsite 2-3 days a week Pay Rate: $40-42/hr W2 Position Type: Multiyear Contract We are looking for candidates with 1-2 years of experience - this is NOT a senior role. Description: Resp...
Date Posted: 12/02/2025 Recommended
-
Lockbox Application Developer Lead
Pittsburgh, PA
Position Title: Lockbox Application Developer Lead Pittsburgh PA - Two PNC Plaza 620 Liberty Ave Pittsburgh, PA 15222 Provide locations/flexible work by preference: Most Preferred – Pittsburgh*Manager is not looking to source out of any other tech hub ...
Date Posted: 09/26/2025 Recommended
-
Senior Devops Engineer
Pittsburgh , Pennsylvania
Additional Skills and Notes: Position Title: Senior Devops Engineer Position Location: PNC Tech Hub Provide locations/flexible work by preference: 1. Pittsburgh PA OR Cleveland OH - Strongsville Technology Center **Please note, the hiring team is not l...
Date Posted: 10/06/2025 Recommended
-
MuleSoft Developer
Lenexa, KS
Job Title: MuleSoft Developer Location: Lenexa, KS Contractor Work Model: Hybrid Onsite Job Summary: System One is seeking a MuleSoft Developer for a long-term, hybrid-onsite opportunity in Lenexa, KS. The MuleSoft Developer builds, enhances, and suppo...
Date Posted: 12/01/2025 Recommended
-
ADABAS Database Specialist/DB2
Bethesda, Maryland
Job Title : ADABAS Database Specialist/DB2 Location: US-Remote (EST Hours) Clearance Requirements: Successful completion of a Public Trust background investigation and/or a Public Trust clearance. Min Citizenship Status Required: Must be a U.S. Citizen...
Date Posted: 10/03/2025 Recommended
-
Lead Axiom Developer
Pittsburgh, PA
Position Title: Lead Axiom Developer Position Location: PNC Tech Hub Provide locations/flexible work by preference: 1. Most preferred - Pittsburgh PA - Two PNC Plaza 2. Remaining hubs - no particular order - Cleveland OH - Strongsville Technology Cente...
Date Posted: 09/30/2025 Recommended
-
Backend Technical Lead – AI Driven
Frisco, Texas
Job Title: Backend Technical Lead – AI Driven Location: 100% Remote – CST, EST, MST preferred Role Type: 8 + month contract + good chance of extensions US Citizenship required A highly respected digital product studio is expanding its backend capabilit...
Date Posted: 12/05/2025 Recommended
-
CPM Leak Detection Engineer
Tulsa, Oklahoma
System One has an exciting opportunity with one of our clients here in Tulsa, Oklahoma. We are looking for a CPM Leak Detection Engineer. This role is a mix of IT & Engineering skillsets! This role is a hybrid work schedule located here in Tulsa, Oklah...
Date Posted: 12/02/2025 Recommended
-
SailPoint Developer
Fort Belvoir, VA
SailPoint Developer Fort Belvoir, VA - hybrid (2-3 days a week onsite) Secret Clearance is required to start Must be Security+ certified SailPoint Developer Role requires Java Development Experience. We are looking for candidates who are true developer...
Date Posted: 12/11/2025 Recommended
-
Business Intelligence Engineer
Melbourne, FL
System One is looking for a Business Intelligence Engineer. As a Business Intelligence Engineer, you will lead the design and delivery of robust data pipelines and scalable data?warehouse solutions that power actionable insights. Apply expertise in dat...
Date Posted: 12/16/2025 Recommended
-
Workday HCM Techno-Functional Consultant - Remote -W-2
Towson, Maryland
Job Title: Workday HCM Techno-Functional Consultant Location: Remote Type: W-2 only Local County Government client is seeking a Workday Application Developer to assist with the implementation and ongoing support of Workday HCM and Financial System. Dev...
Date Posted: 12/15/2025 Recommended
-
Business Systems Analyst Lead
Pittsburgh, PA
Job Title: Business Systems Analyst Lead Location: Pittsburgh, PA/Cleveland, OH/Dallas, TX/Birmingham, AL/Phoenix, AZ Function of the Group: Mitigating RiskInitiatives/Projects: STX Enhancements, Data Fabric and Landing ZoneIndustry background: Anti Mo...
Date Posted: 10/30/2025 Recommended
-
AWS GovCloud Consultant
Washington, DC
Sr AWS GovCloud Systems Engineer 100% ONSITE Washington DC (New York Ave) Long Term Contract Start Date- 2/2/26- 12/31/26 Possible Multi year extension based on performance Per Federal contract U.S. Citizenship Required Must be able to pass enhanced ba...
Date Posted: 12/08/2025 Recommended
-
IT Senior Specialist-DX Automation
Erlanger, Kentucky
Job Title: Senior Specialist- Digital Transformation (DX) Automation Location: Erlanger, Kentucky Type: Direct Hire Compensation: $92500 - $115625 annually Contractor Work Model: Hybrid Hours: M-F 3 days onsite in Erlanger USC or GC, no H1B sponsorship...
Date Posted: 11/25/2025 Recommended
-
Database Administrator III
Pittsburgh, Pennsylvania
Title: Database Administrator III Location: Onsite, Pittsburgh, PA 15219 Type: Direct-Hire/Permanent Hours: Standard business hours M-F Start: January Overview: We are seeking a full-time Database Administrator to support the Core’s data infrastructure...
Date Posted: 12/16/2025 Recommended
-
Security Administrator
Cincinnati, Ohio
Job Title: Security Administrator Location: Cincinnati, Ohio Type: Direct Hire Compensation: $80000 - $100000 annually Contractor Work Model: Hybrid We are looking for a Security Administrator at our Corporate Home Office. This person is responsible fo...
Date Posted: 12/08/2025 Recommended
-
Technical Architect - Google Artificial Intelligence
Auburn Hills , Michigan
Technical Architect – Artificial Intelligence, Google AI 1 YEAR+ CONTRACT AUBURN HILLS, MI – Hybrid, must be local to the Auburn Hills area $65/HR. W2 ONLY, NO C2C Work hours - 8:30 am-5:30 pm EST ALTA IT Services is seeking an experienced Senior Techn...
Date Posted: 11/07/2025 Recommended
-
DevOps Engineer
Huntsville, Alabama
Job Title: DevOps Engineer Location: Huntsville, Alabama DevOps Engineer Huntsville, AL Direct Hire Top Secret <- Must be willing to sit for a CI Poly $200k Responsibilities Responsible for the design, deployment, testing, certification, operations, pa...
Date Posted: 09/26/2025 Recommended
-
RF Engineer
Morrisville , NC
Job Title: RF Engineer Location: Hybrid (onsite ~3x weekly) – Morrisville, NC Role Type: Full Time, Direct Hire Clearance/Residency Requirement: US Citizenship or Permanent Residency Required A NC-based defense technology company is developing disrupti...
Date Posted: 12/02/2025 Recommended
-
Android Developer
Ashburn, VA
Job Title: Android Developer Location: Hybrid Work Model Reporting to Vienna, VA, Winchester, VA, or Pensacola, FL Pay Rate: Open to Both C2C and W2 options Position Type: Multiyear Contract Description To support the development, maintenance, and enha...
Date Posted: 10/08/2025 Recommended