Atria Group
Direct SmartRecruiters career site

Sr. Lead ETL Developer - Informatica

Location
Philadelphia, PA
Listed
Yesterday
Free · No account needed

How well does your resume fit this job?

Upload your resume to see your score for this Atria Group role, what matches, what's missing, and your best other matches.

Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.

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:

Read the original posting

From Atria Group's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.

How Rolev.ai helps with this application

Rolev.ai is a job search and application tool for US job seekers. For this Sr. Lead ETL Developer - Informatica role at Atria Group, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.

  • See how you fit

    Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.

  • Tailor without inventing

    Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.

  • Draft the full kit

    Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.

  • 1-Click Extension Autofill

    The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.

Common questions

Where is the Sr. Lead ETL Developer - Informatica job at Atria Group located?

This Sr. Lead ETL Developer - Informatica position at Atria Group is located in Philadelphia, PA. Always check Atria Group's application page for specific state eligibility or relocation policies.

How do I apply for the Sr. Lead ETL Developer - Informatica position at Atria Group?

This listing links directly to Atria Group's SmartRecruiters application page. You can apply directly on Atria Group's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.