Lead ETL / Data Warehouse Developer - Consultant

Lead ETL / Data Warehouse Developer - Consultant

Jersey City, New Jersey
9756126
08-11-2017
or
Intermedia Group has an opening for the following Consultant:

title:   Lead ETL / Data Warehouse Developer

location:  Jersey City, NJ

 
Client: Fortune 100 Bank
 
Type: contract

Target Pay Rate: $78 per hour w2

NO CTC, ONLY W2 CONSIDERED


Summary
  • Involved in eliciting requirements, designing dimensional data models, preparing written design documents, developing extract/transform/load routines using either PL/SQL or Informatica PowerCenter performing intensive data analysis.
  • Testing ETL and reports of others for quality assurance, and migrating releases into testing and production environments.
  • Work with business and technology teams to analyze requirements, estimate, plan, and design solutions.
  • Develop complex workflows and mappings using Informatica ETL and shell scripts to satisfy the business requirements.
  • Develop web services for Data Warehouse and implement near real-time warehousing solutions.
  • Will also support the Enterprise Data Warehouse batch cycle and any required changes to the schedule.
  • Will assist the team by helping them in the data analysis requests, internal controls, performance tuning, BI requests.
  • Lead medium sized projects, lead peer code reviews for all ETL changes.
  • Design, Code, Test, schedule, and Implement project using Informatica/Oracle ETL.
  • Interact with users to identify their requirements and deliver results appropriately.
  • Debug and troubleshoot production issues.

Qualifications
  • ETL Lead with hands-on experience in designing and implementing data warehouses and data marts for large financial institutions.
  • Experience leading a development team to implement high-quality solutions using Informatica and Business Objects and related database technology such as DB2, Oracle.
  • Demonstrated requirements elicitation and analysis experience. Demonstrated strong problem-solving abilities and multitasking capabilities.
  • Ability to perform well in high pressure, time-sensitive environments, strong verbal and written communication skills. Demonstrated ability to understand and document business processes.
  • Strong organizational skills.
  • 8-10+ years experience performing the following: Full system development life cycle (SDLC) experience; Technical team leader experience; Strong background in data and business intelligence project work; Expert with SQL and PL/SQL, Experienced with Oracle databases; Reading and creating dimensional data models (Star Schemas); Reading and creating traditional Codd 3rd Normal Form data models;
  • Experience with Informatica PowerCenter.
  • Must have a BA/BS degree.
 
If you are interested in pursuing this opportunity, please respond back and include the following:
• Full MS WORD Resume
• Current and required compensation
• Contact information
• Availability
 
Upon receipt, one of our managers will contact you to discuss in full
 
Jason Denmark
Managing Director
 
INTERMEDIA GROUP, INC.
131 Varick Street
Suite 936
New York, NY 10013
Voice: 212-248-0100

Email: jdenmark@intermediagroup.com
Corporate Web Site: www.intermediagroup.com
OPEN JOB LIST: http://intermediagroup.com/jobs
 

Recruiter Contact


Steve Fleischner | Managing Partner
sfleischner@intermediagroup.com
Intermedia Group Inc. | New York, NY
Main: (212) 248-0100
this job portal is powered by CATS