Talent.com
Informatica ETL Lead

Informatica ETL Lead

System OnePhoenix, AZ, US
job_description.job_card.variable_hours_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

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.
  • Soft Skills : Verbal and written communication

    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 resumewith 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-

    DI-

    Ref : #404-IT Pittsburgh

    Seniority level

  • Mid-Senior level
  • Employment type

  • Contract
  • Job function

  • Information Technology
  • Industries

  • Business Consulting and Services
  • Referrals increase your chances of interviewing at System One by 2x

    Get notified about new ETL Lead jobs in Phoenix, AZ

    We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

    J-18808-Ljbffr

    serp_jobs.job_alerts.create_a_job

    Etl Lead • Phoenix, AZ, US

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    Insite Lead Developer

    Insite Lead Developer

    Resource Informatics Group IncTempe, AZ, US
    serp_jobs.job_card.full_time
    Greetings from Resource Informatics Group!.We are urgently looking for a “Insite Lead Developer” in Tempe, AZ.JD & send me the matching profiles : .Role &...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Information Technology Application Manager (Phoenix)

    Information Technology Application Manager (Phoenix)

    IMPACT Technology RecruitingPhoenix, AZ, United States
    serp_jobs.job_card.permanent
    This is a Direct Hire positions that is only available to US Citizens or GC holders (no exceptions).This position is not open to remote, it is HYBRID in AZ. Please only apply if you are in AZ or are...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Information Technology Application Manager

    Information Technology Application Manager

    IMPACT Technology RecruitingPhoenix, AZ, United States
    serp_jobs.job_card.permanent
    This is a Direct Hire positions that is only available to US Citizens or GC holders (no exceptions).This position is not open to remote, it is HYBRID in AZ. Please only apply if you are in AZ or are...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Tech Lead, Web Core Product & Chrome Extension - Glendale, USA

    Tech Lead, Web Core Product & Chrome Extension - Glendale, USA

    SpeechifyGlendale, AZ, US
    serp_jobs.job_card.full_time
    The mission of Speechify is to make sure that reading is never a barrier to learning.Over 50 million people use Speechify's text-to-speech products to turn whatever they're reading – ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Data Engineering Lead

    Data Engineering Lead

    VirtualVocationsGlendale, Arizona, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Engineering Lead.Key Responsibilities Own and evolve the data pipeline to ensure accuracy and reliability of metrics and dashboards Modernize the data stack and e...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Information Management Analyst (mid level)

    Information Management Analyst (mid level)

    USAA CareersPhoenix, Arizona, US
    serp_jobs.job_card.full_time
    Why USAA? At USAA, our mission is to empower our members to achieve financial security through highly competitive products, exceptional service and trusted advice. We seek to be the #1 choice for th...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Tech Lead, Web Core Product & Chrome Extension - Peoria, USA

    Tech Lead, Web Core Product & Chrome Extension - Peoria, USA

    SpeechifyPeoria, AZ, US
    serp_jobs.job_card.full_time
    The mission of Speechify is to make sure that reading is never a barrier to learning.Over 50 million people use Speechify's text-to-speech products to turn whatever they're reading – ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Global Strategic Workforce Planning Lead

    Global Strategic Workforce Planning Lead

    VirtualVocationsGilbert, Arizona, United States
    serp_jobs.job_card.full_time
    A company is looking for a Head of Global Strategic Workforce Planning & Insights.Key Responsibilities Contribute to the development of the Talent, Performance and Development strategy and overse...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Clinical Integration Lead

    Clinical Integration Lead

    VirtualVocationsChandler, Arizona, United States
    serp_jobs.job_card.full_time
    A company is looking for a Clinical Automation and Integration Lead - Remote.Key Responsibilities Serve as the clinical subject matter expert and lead for project teams defining clinical requirem...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior-Level Product Engineer - Battery Management Systems

    Senior-Level Product Engineer - Battery Management Systems

    1010 Analog Devices Inc.East Elliot, AZ, United States
    serp_jobs.job_card.full_time +1
    NASDAQ : ADI ) is a global semiconductor leader that bridges the physical and digital worlds to enable breakthroughs at the Intelligent Edge. ADI combines analog, digital, and software technologie...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    TÉCNICO INFORMÁTICO - DESARROLLADOR NAV-BC

    TÉCNICO INFORMÁTICO - DESARROLLADOR NAV-BC

    VOLMAEorganizacionesAlbacete, Castile-La Mancha, Spain
    serp_jobs.filters_job_card.quick_apply
    Perfil de informático desarrollador / a de Microsoft Dynamics Navision( 365 –.Desarrollar, personalizar e implementar soluciones en Microsoft Dynamica 365 Business Central. Desarrollo de integraciones...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Analyst, End User Technologies

    Senior Analyst, End User Technologies

    Nest HealthPhoenix, AZ, US
    serp_jobs.job_card.full_time
    As the first value-based care provider built for families, Nest is on a mission to make comprehensive medical, behavioral, and social care radically accessible to America’s highest risk famil...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Tech Lead, Web Core Product & Chrome Extension - Surprise, USA

    Tech Lead, Web Core Product & Chrome Extension - Surprise, USA

    SpeechifySurprise, AZ, US
    serp_jobs.job_card.full_time
    The mission of Speechify is to make sure that reading is never a barrier to learning.Over 50 million people use Speechify's text-to-speech products to turn whatever they're reading – ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    Technical Lead

    Technical Lead

    Episcopal School of Baton RougePhoenix, Arizona, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    As a Remote Technical Lead at SoSimple Interactive, you will play a key role in guiding the technical direction of projects, leading engineering efforts (both front-end and back-end), maintaining a...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Tech Lead, Web Core Product & Chrome Extension - Gilbert, USA

    Tech Lead, Web Core Product & Chrome Extension - Gilbert, USA

    SpeechifyGilbert, AZ, US
    serp_jobs.job_card.full_time
    The mission of Speechify is to make sure that reading is never a barrier to learning.Over 50 million people use Speechify's text-to-speech products to turn whatever they're reading – ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    GCP Application Technical Lead

    GCP Application Technical Lead

    Axiom Software Solutions LimitedPhoenix, AZ, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Big Data, ETL - Big Data / Data Warehousing, GCP, Java.Must Have : Bigdata (Spark, Hadoop), GCP BigQuery, APIs with Java framework. Good to have : Kubernetes (GKE), containerization, GitHub Actions.S...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Information Management Analyst (mid level)

    Information Management Analyst (mid level)

    USAAPhoenix, Arizona, US
    serp_jobs.job_card.full_time
    Why USAA? At USAA, our mission is to empower our members to achieve financial security through highly competitive products, exceptional service and trusted advice. We seek to be the #1 choice for th...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Tech Lead, Web Core Product & Chrome Extension - Mesa, USA

    Tech Lead, Web Core Product & Chrome Extension - Mesa, USA

    SpeechifyMesa, AZ, US
    serp_jobs.job_card.full_time
    The mission of Speechify is to make sure that reading is never a barrier to learning.Over 50 million people use Speechify's text-to-speech products to turn whatever they're reading – ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Tech Lead, Web Core Product & Chrome Extension - Goodyear, USA

    Tech Lead, Web Core Product & Chrome Extension - Goodyear, USA

    SpeechifyGoodyear, AZ, US
    serp_jobs.job_card.full_time
    The mission of Speechify is to make sure that reading is never a barrier to learning.Over 50 million people use Speechify's text-to-speech products to turn whatever they're reading – ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Texas Licensed Tech Lead

    Texas Licensed Tech Lead

    VirtualVocationsMesa, Arizona, United States
    serp_jobs.job_card.full_time
    A company is looking for a Tech Lead, Digital API (Node.Key Responsibilities Design and build domain-driven, event-aware microservices in Node. TypeScript Own production readiness and lead incide...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day