ETL Lead

Avance Consulting USA, UK, India

Job Title: ETL Lead
Location: Somerset, NJ & Pittsburg, PA
Duration: Fulltime

Job Description:
Candidate must be experienced working in ETL based projects involving InformaticaMust be fully versed in working with Informatica
Must have an understanding of ERP business processes, data warehouse and BI concepts and ability to apply educational and practical experience to improvise business intelligence application
Must be able to provide simplified and standardized solutions to achieve the business objectives.
Ability to provide both innovative and improvement solutions to current and anticipated business challenges.
Expert knowledge of data warehouse architecture
Well versed with database administration tasks and working with DBAs to monitor and resolve ETL (Informatica) issues
Well versed with SQL.
Independent problems solving skills.
Strong interpersonal and communication skills and ability to interact positively with peer groups within IT and outside IT and management

Responsibilities:
Use appropriate software development methodologies prescribed by Mylan
Interact with users to gather requirements from various departments and document business requirements; and to prepare functional specifications and mockup designs as necessary.
Design and develop various Enterprise Business Intelligence Solutions including interfacing and integration with ERP systems of records, ETL (Informatica) design, Data modeling and database design, reporting and analytics solutions.
Design data warehouse development and enhancement projects including data modeling, end to end solutions
Troubleshoot data warehouse and BI issues using SQL development and querying tools (e.g. Toad
Provide performance tuning and enhancement of ETL (Informatica) processes, including supporting technical documentation

Key Skills: ETL Lead

Bachelors

All your information will be kept confidential according to EEO guidelines.