> Markdown version of [/jobs/ext/1987123-sr-lead-etl-developer-informatica](https://www.wearedevelopers.com/jobs/ext/1987123-sr-lead-etl-developer-informatica). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Sr. Lead ETL Developer - Informatica

- **Company:** Atria Group LLC
- **Location:** Philadelphia, PA, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Big Data, Unix, Databases, Extract Transform Load (ETL), Data Warehousing, Database Queries, MySQL, Oracle (Applications), SQL Databases, Informatica Powercenter, Netezza, Information Technology, Data Management
- **Published:** August 8, 2026
- **Apply:** https://jobs.smartrecruiters.com/AtriaGroupLLC/75022967-sr-lead-etl-developer-informatica

## About the Role

* 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

## Description

* 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


## Related Videos

- [WeAreDevelopers LIVE - Node and Package Security](https://www.wearedevelopers.com/videos/2138-wearedevelopers-live-node-and-package-security)
- [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [The Time Paradox: Building Timezone-Safe Python/Django Applications](https://www.wearedevelopers.com/videos/1915-the-time-paradox-building-timezone-safe-python-django-applications)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Coding for Good: Achieving social change with an app](https://www.wearedevelopers.com/videos/1645-coding-for-good-achieving-social-change-with-an-app)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)