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
Related searches