ETL Lead

Avance Consulting Services; Somerville (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology consulting firm is seeking an ETL Lead to work on projects involving Informatica in Somerville, NJ & Pittsburg, PA. The ideal candidate will have a deep understanding of ETL processes and data warehousing, with strong problem-solving skills and the ability to work collaboratively with various departments. Responsibilities include software development methodologies, designing data solutions, troubleshooting BI issues, and performance tuning. This is a full-time position offering the opportunity to lead and innovate in data management projects.

Qualifications

• Experience in ETL projects, particularly with Informatica.
• Understanding of ERP business processes.
• Ability to provide innovative solutions to business challenges.

Responsibilities

• Use software development methodologies to gather requirements.
• Design Enterprise Business Intelligence Solutions.
• Troubleshoot data warehouse and BI issues.

Skills

Informatica

SQL

Data warehouse architecture

Business intelligence

Interpersonal skills

Problem solving

Job description

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

Job Description

Candidate must be experienced working in ETL based projects involving Informatica. Must 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 problem 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

Qualifications

Additional Information

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