Data Warehouse Developer / ETL Lead (Oracle / Informatica)

Data Warehouse Developer / ETL Lead (Oracle / Informatica)

Jersey City, NJ
11245412
08-07-2018
or
Intermedia Group has an opening for the following Consultant
 
JOB TITLE: Data Warehouse Developer / ETL Lead (Oracle / Informatica)
LOCATION: Jersey City, NJ (zip 07311)
TYPE: Contract (we can only work with candidates on a w2 basis)
CLIENT: Fortune 100 Bank
 
 
JOB DETAILS:
  • Data Warehouse Developer will be 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.
  • 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
  • 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.
  • 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.
 
REQUIREMENTS:
  • 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:
 
  • MS WORD Resume
  • Current and required compensation
  • Contact information
  • Availability
Upon receipt, one of our managers will contact you to discuss the position in full detail.
 
 
Jason Denmark
INTERMEDIA GROUP, INC.
131 Varick Street
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

Jason Denmark
INTERMEDIA GROUP, INC.
131 Varick Street
New York, NY 10013
Voice: 212-248-0100
this job portal is powered by CATS