Sr. Lead ETL Developer - Informatica

Atria Group
Philadelphia, PA

Company Description



Job Description

Responsibilities:

  • Hands on , Design ( HLD and LLD) and implementation of an operational data store and data warehouse on one of the leading database platforms (e.g., Netezza,MySQL , Oracle)
  • Able to manage onsite and offshore teams and collaborate with stakeholders, development teams, and QA
  • Review development and test specifications
  • Implement, standardize and optimize ETL processes using Informatica Powercenter ETL( 9.1 / 9.5)
  • Ability to conduct discovery, perform root cause analysis, and make recommendations for the remediation of data quality issues
  • Troubleshoot data and/or system issues; create/maintain batch jobs; create systems documentation
  • Perform data analysis and identify data related issues as needed


Requirements:

  • 8+ years of Solid experience with Informatica ETL tool ( 9.1 or 9.5)
  • Strong SQL skills and should be able to write SQL to compare and reconcile source and target databases.
  • Strong in Unix
  • Experience in large data warehouse implementations is a must
  • Experience in managing onsite and offshore teams or global delivery center model
  • Excellent interpersonal and communication skills; presents technically complex concepts in a way to foster understanding and acknowledgement of critical information
  • Exercises wide latitude in determining objectives and approaches to critical assignments
  • Must have excellent verbal and written communications skills, with an ability to express complex technical concepts in business terms
  • Must have excellent client-facing skills; solid teamwork and interpersonal skills; strong ability to work independently when appropriate
  • Develops solutions to problems of unusual complexity which require a high degree of ingenuity, creativity and innovation
  • Adapts and makes departures from traditional methods or approaches to develop solutions by evaluating a balanced risk based approach to support business objectives
  • Advises the company’s Enterprise Business Intelligence management and customers on advanced technical issues and provides technical expertisewithin the company in the areas of Business Intelligence , Analytics , Data warehousing and Master Data Management


Interacts and/or negotiates effectively with external and/or internal customers at all levels

Education:
  • MS/BS degree in a computer science field or related discipline

Additional Information

Apply today!

Posted 2026-05-24

Recommended Jobs

Motor Coach Bus Driver Wedding and Event Chauffeuring

Ace Limousine & Airport Service
Chester, PA

Motor Coach Bus Driver – Wedding & Event Chauffeuring Part-Time (with clear path to Full-Time)| $35 per hour We are a premier wedding, event planning, and professional chauffeuring company in t…

View Details
Posted 2026-05-15

Appointment Setter - Paid Training - $75k - $150k+ OTE

Soligo
Pittsburgh, PA

Join One of the Nation's Top Solar Companies and Launch Your Career! Appointment Setter  Guaranteed Training & Ramping Pay | $75k - $150k+ OTE | No Experience Necessary Company: Soligo Solar…

View Details
Posted 2026-05-14

Automotive Detailer

Buchanan Auto Stores
Waynesboro, PA

Job Description Job Description Buchanan Auto Stores is seeking a dedicated Automotive Detailer to join our team in Waynesboro, PA.  Opportunity to make up to $100,000 annually!  Training availab…

View Details
Posted 2026-03-23

Licensed Practical Nurse (LPN)/Registered Nurse (RN) for Pediatric Case in Brookville

Interim HealthCare- Christian Miller
Brookville, PA

Home Health Licensed Practical Nurse/Registered Nurse in Brookville LPN/RN needed for a Pediatric Case in Brookville Full Time 1st Shift 8hr/shifts Discover a new lane in nursing and earn …

View Details
Posted 2025-10-21

Registered Nurse - Pennsylvania

Pennsylvania

About Aarris At Aarris Healthcare Staffing, we understand nurses are our best asset and we care about the work that you do. If you’re passionate and committed to patient wellbeing and are looking fo…

View Details
Posted 2025-10-25

Trade Show Sales Professional

Silencer Central
Hershey, PA

Job Description Join one of the fastest growing companies in America, recently recognized as an Inc. 5000 award-winning company with more than 400 percent growth over the past three years. Silencer …

View Details
Posted 2026-05-23

Drug & Alcohol Prevention Specialist

Child & Family Focus, Inc.
Broomall, PA

Child & Family Focus, Inc. is seeking a  Prevention Specialist for their Drug and Alcohol Prevention Education Program  (PEP) in Delaware County, PA. Child and Family Focus's comprehensive preventi…

View Details
Posted 2026-05-12

Entry Level Staff Accountant

Aston Carter
Carlisle, PA

Job Title: Entry Level Staff Accountant Job Description The Staff Accountant will perform core accounting functions, including bank reconciliations, recording journal entries, and analyzin…

View Details
Posted 2026-05-23

Office Manager, New York

Imre
Philadelphia, PA

Imre is an independent, award-winning, brand-engagement creative agency that helps consumer and healthcare brands connect authentically with people in some of the most important decisions of their li…

View Details
Posted 2026-05-24

Clinical Research Coordinator-Recruitment

Temple University
Philadelphia, PA

The Temple University's Lewis Katz School of Medicine's TMS-Pulm/CriticalCare/SleepMed Department is searching for a Clinical Research Coordinator-Recruitment to join our team! Become a part of the…

View Details
Posted 2026-05-23