ETL Lead
- Location
- Somerville, NJ · On-site
- Job type
- Full-time
- Level
- Lead / Staff
- Listed
- Yesterday
Skills & highlights for this role
- Informatica
- SQL
- data warehouse architecture
Also useful
- Toad
How well does your resume fit this job?
Upload your resume to see your score for this Avance Consulting role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
- Job Title: ETL Lead
- Location: Somerset, NJ & Pittsburg, PA
- Duration: Fulltime
About the role
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 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
Qualifications & Requirements
Bachelors
Additional Information
All your information will be kept confidential according to EEO guidelines.
About the Company
Avance Consulting USA, UK, India
From Avance Consulting's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this ETL Lead role at Avance Consulting, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
- ETL DeveloperSaxon Global · Hoboken, NJ
- ETL/SQL developerCollabera · Rockville, MD
- ETL DevelopersSTEM Expert · Fishers, IN
- DataStage ConsultantSonsoft · Agoura Hills, CA
- ETL DeveloperIntegrated Resources · Wilmington, NC
- Informatica Developer/applications Development Analyst IIIUSM Business Systems · Washington, DC
Common questions
Where is the ETL Lead job at Avance Consulting located?
This ETL Lead position at Avance Consulting is located in Somerville, NJ (On-site). Always check Avance Consulting's application page for specific state eligibility or relocation policies.
What qualifications are required for ETL Lead at Avance Consulting?
For the ETL Lead role, Avance Consulting highlights experience with Informatica, SQL, data warehouse architecture. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the ETL Lead position at Avance Consulting?
This listing links directly to Avance Consulting's SmartRecruiters application page. You can apply directly on Avance Consulting's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.