Lead ETL / Data Warehouse Developer - Consultant

Lead ETL / Data Warehouse Developer - Consultant

Jersey City, New Jersey
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


  • 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.

  • 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
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
Intermedia Group Inc. | New York, NY
Main: (212) 248-0100
this job portal is powered by CATS