Sr. Lead ETL Developer - Informatica

Posted 5 Hours Ago
Be an Early Applicant
Philadelphia, PA, USA
In-Office
Senior level
Information Technology • Professional Services • Software • Consulting
The Role
Lead ETL developer responsible for designing and implementing an operational data store and data warehouse on platforms like Netezza, MySQL, or Oracle; implement, standardize, and optimize Informatica PowerCenter ETL; manage onsite/offshore teams; perform data analysis, root cause investigation, data quality remediation, troubleshooting, batch job maintenance, and documentation; advise BI leadership on advanced technical BI, analytics, data warehousing, and MDM issues.
Summary Generated by Built In
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!

Skills Required

  • 8+ years of experience with Informatica PowerCenter ETL (9.1 or 9.5)
  • Hands-on design (HLD and LLD) and implementation of operational data store and data warehouse on Netezza, MySQL, or Oracle
  • Strong SQL skills; able to write SQL to compare and reconcile source and target databases
  • Strong Unix skills
  • Experience in large data warehouse implementations
  • Experience managing onsite and offshore teams or global delivery center model
  • Ability to conduct discovery, perform root cause analysis, and remediate data quality issues
  • Troubleshoot data and system issues; create and maintain batch jobs and systems documentation
  • Excellent interpersonal, client-facing, verbal and written communication skills
  • Ability to advise enterprise BI management on advanced technical BI, analytics, data warehousing, and MDM topics
  • MS/BS degree in computer science or related discipline
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
125 Employees

What We Do

Atria Group LLC, also operating as Atria IT, is a specialized IT staffing and consulting firm headquartered in Plano, Texas. The company provides comprehensive workforce solutions, including staffing, consulting, software development, and training services, specializing in enterprise solutions for small to medium-sized businesses. Their primary objective is to assist these enterprises in maximizing their IT resources to meet evolving technological challenges.

Similar Jobs

Samsara Logo Samsara

Technical Support

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
46K-62K Annually

Tapestry - Coach and Kate Spade Logo Tapestry - Coach and Kate Spade

Temporary Sales Associate

eCommerce • Fashion • Retail • Sales • Wearables • Design
Hybrid
Pottstown, PA, USA
16000 Employees
15-20 Hourly

Tapestry - Coach and Kate Spade Logo Tapestry - Coach and Kate Spade

Sales Associate III

eCommerce • Fashion • Retail • Sales • Wearables • Design
Hybrid
King of Prussia, PA, USA
16000 Employees
15-24 Hourly

Acquia Logo Acquia

Senior Product Marketing Manager

AdTech • Cloud • Marketing Tech • Productivity • Software • Analytics • Automation
Easy Apply
Remote or Hybrid
United States
1100 Employees
130K-150K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account