Senior Oracle Data Warehouse Developer w Informatica

Senior Oracle Data Warehouse Developer w Informatica

Jersey City, NJ
Intermedia Group has the following open position with one of our clients:
TITLE: Senior Oracle Data Warehouse Developer w Informatica
LOCATION: Jersey City, NJ
TYPE: Contract
DURATION: 10 months +
CLIENT: Fortune 100 International BANK
PAY RATE: $69 per hour w2 or $125,000 + benefits
  • 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 and Business Objects and related database technology such as DB2, Oracle.
  • 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.
  • 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
  • Current contact information
  • Availability
Upon receipt, one of our managers will contact you to discuss in full
Jason Denmark
131 Varick Street
New York, NY 10013
Voice: 212-248-0100




Recruiter Contact

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