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/aLqljF
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
-
Data Engineer
Elizabeth, New Jersey
Job Title: Data Engineer Location: Elizabeth, New Jersey Type: Contract Contractor Work Model: Hybrid - remote, occasional travel to the office will be required Data Engineer We’re seeking a Data Engineer who is motivated by variety, is seeking a chall...
Date Posted: 10/17/2025 Recommended
-
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
-
Data Automation Engineer
Washington, DC
Data Automation Engineer REMOTE - Quarterly travel to Washington, DC Type: Contract Pay Rate: $45.50 - $53.00 hourly Security Clearance: Per government contract, must be US citizen and able to obtain a Public Trust clearance. We are seeking a customer ...
Date Posted: 11/21/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
-
Quality Assurance Lead
Pittsburgh, PA
Position Title: Quality Assurance Lead Provide locations/flexible work by preference: 1. Most preferred - Pittsburgh PA 2. Remaining hubs - no specific order - Cleveland OH - Strongsville Technology Center, Birmingham AL - Birmingham - Brock, North Tex...
Date Posted: 09/15/2025 Recommended
-
ETL Quality Assurance Lead
Farmers Branch, TX
Position Title: Quality Assurance Lead - Contractor Reason for open position: Backfill Pittsburgh PA - Two PNC Plaza 620 Liberty Ave Pittsburgh, PA 15222 Cleveland OH - Strongsville Technology Center 8100 Mohawk Dr. Strongsville, OH 44136 Provide locat...
Date Posted: 09/16/2025 Recommended
-
Data Analyst Sr
Farmers Branch, TX
Request: IT - Data Analyst Sr - Contractor Pittsburgh PA Two PNC Plaza 620 Liberty Ave, Pittsburgh, PA 15222 Cleveland OH Strongsville Technology Center 8100 Mohawk Dr., Strongsville, OH 44136 Secondary- Birmingham AL Birmingham - Brock 701 32nd St. So...
Date Posted: 09/11/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
-
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
-
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
-
Data/AI Enterprise Architect
Washington, District Of Columbia
Data/AI Enterprise Architect Washington, DC - 100% ONSITE US citizenship required per government contract Must be able to obtain Public Trust ALTA IT Services is in search of a candidate who has deep knowledge of enterprise architecture principles, AI ...
Date Posted: 11/13/2025 Recommended
-
SME Oracle APEX Developer
Washington, DC
SME Oracle APEX Developer Location: Washington, DC 20036 (100% on-site) if interested reach out directly to kspicer@altaits.com Primary Responsibilities. Work at the direction of the program manager to support the full lifecycle development of custom O...
Date Posted: 11/25/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
-
Risk Analyst
Pittsburgh, PA
Position Title: Niche – Risk Specialist Sr 1st preference - Pittsburgh Tech Hub 2nd preference - Any Technology Hubs - hybrid 2 days in office - 3 remote Pittsburgh, PA - 620 Liberty Ave, Pittsburgh, PA 15222 Birmingham, Alabama - 701 32nd St. South, B...
Date Posted: 09/07/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
-
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
-
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
-
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
-
Lead Full Stack Developer – Java | Angular | DevOps
Pittsburgh, PA
Position Title: Lead Full Stack Developer – Java | Angular | DevOps Provide locations/flexible work by preference: Pittsburgh PA OR Cleveland OH - Strongsville Technology Center. Ability to work remote: Hybrid - 3 days in office, 2 remotes Intended len...
Date Posted: 09/11/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
-
Azure Platform Engineer
Washington, DC
Job Title: Azure Platform Engineer Location: 5th st Washington, DC 20530 Type: Contract Compensation: $58.66 - $70.00 hourly Start Date 1/5/2026 Contractor Work Model: 100% Onsite Security Clearance: Must be able to pass federal background check to obt...
Date Posted: 12/04/2025 Recommended
-
FIPS 140 Security Engineer
Columbia, MD
Job Title: FIPS 140 Security Engineer Location: Columbia, MD (Remote) Compensation: $60.00-$68.00/HR Duration: 6 month contract to hire In joining the team, you will get an exciting opportunity to work in the growing IT Security field in support of Nat...
Date Posted: 11/25/2025 Recommended
-
Senior Big Data Engineer
Pittsburgh, PA
Big Data Engineer Reason for Open Position: Tenure backfill Position Location: Most preferred: Pittsburgh, PA – Two PNC Plaza, 620 Liberty Ave Secondary: Cleveland, OH – Strongsville Technology Center, 8100 Mohawk Dr. Work Arrangement: In-office (some ...
Date Posted: 09/07/2025 Recommended
-
Workday HCM Techno-Functional Consultant
Towson, Maryland
Job Title: Workday HCM Techno-Functional Consultant Location: Towson, Maryland 2-3 days onsite Type: Contract - W2 or C2C Contractor Work Model: Hybrid Local County Government client is seeking a Workday Application Developer to assist with the impleme...
Date Posted: 12/03/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
-
Software Engineer Lead - Contractor
Pittsburgh, PA
Position Tittle: Software Engineer Lead (158899-1) Duration: Contract to Hire Work Location: Pittsburgh, PA or Strongsville, OH Work Mode: Hybrid – (3 days in office, 2 remote) Years of Experience: 15+ years applicable experience required overall ***Fo...
Date Posted: 09/11/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