Sr. Lead ETL Developer - Informatica

Atria Group LLC

Apply to this job
Philadelphia, PA, us on site Until 8/21/2026 First posted February 23, 2026 Last posted February 23, 2026
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


Apply today!

About this role

Summary

Design, implement, and optimize ETL processes; manage teams; troubleshoot data issues.

Job title

Sr. Lead ETL Developer - Informatica

Experience level

8+ years

Industry

software

Location requirements

Philadelphia, PA, US; remote not specified

Salary

Not specified

Management role

Yes

Skills & keywords

Required skills

Informatica ETL 9.1 9.5SQLUnixdata warehouseteam management

Preferred skills

None specified

Specializations

ETLInformaticaSQLdata warehousedata quality
Locations

Structured locations inferred from the posting.

Philadelphia, PA, USA

On-site City