Atria Group logo

Sr. Lead ETL Developer - Informatica

Atria Group
Contract
On-site
Philadelphia, Pennsylvania, United States

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!