Sr. Lead ETL Developer - Informatica

Atria Group LLC
Philadelphia, PA, United States
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours

Tech stack

Data Analysis Big Data Unix Databases Extract Transform Load (ETL) Data Warehousing Database Queries MySQL Oracle (Applications) SQL Databases Informatica Powercenter Netezza
+2 more
Information Technology Data Management

Job 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

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 for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on jobs.smartrecruiters.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

2:18 min

Scaling MySQL databases for massive user growth

Johannes Nicolai Johannes Nicolai +1 · LIVE

2:03 min

Microsoft integrating native Unix coreutils into Windows environments

Chris Heilmann +2 · LIVE

1:34 min

Transitioning from traditional software development to artificial intelligence consulting

Patrick Schnell Patrick Schnell · Coffee With Developers

1:48 min

Analyzing network packets with database protocol tools

Daniël van Eeden Daniël van Eeden · WWC Europe 2026

2:04 min

Defining timestamps and the international standard format

Denny Biasiolli Denny Biasiolli · Europe 2026 Virtual

Videos

See all

Related articles

See all