Skip to content
getdataengineeringjobs
Back to results

Senior Lead ETL Developer (Informatica)

Atria Group LLC
Philadelphia, PA, United States Lead Posted

Summary

Written in English from the original posting

This role is a senior lead ETL developer position focused on designing and implementing operational data stores, data warehouses, and Informatica ETL processes. Responsibilities include data quality analysis, batch job management, documentation, and leading onsite and offshore delivery teams. Required experience includes large data warehouse implementations, SQL, Unix, and stakeholder communication.

Job description

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!

Similar jobs

Atria Group LLC Apply