Data Engineer - Newark, NJ

Responsibilities:
-Lead, participate in gathering business requirements, analysis of source systems, define underlying data sources and transformation requirements, design suitable data model, and develop metadata for the Data Warehouse/Analytical Reporting.
-Prepare Technical Design / Specifications; develop routines for data extraction and loading.
-This is a highly technical role requiring critical thinking, hands on development, and attention to detail from analysis through implementation and post-production QA/oncall. Provide technical/user documentation and training; perform peer reviews of work items produced at various stages of the project.
-Effectively communicate with various teams and stakeholders, escalate technical and managerial issues at the right time and resolve conflicts.
-Demonstrate passion for quality and productivity by use of efficient development techniques, standards and guidelines.
-Analyze and determine the impact of technology capabilities and limitations, translate high level design to detailed design specifications, develop, test and deploy code/application in various environments.
-Perform effort estimation for various Data Warehouse activities; meet project deliverables as per requirements, on time within budgets.

Qualifications:
-Bachelor Degree (or higher) in Computer Science
-5+ years of industry experience in building scalable distributed systems based on SOA, ideally in an ecommerce environment
-Minimum 6-8 years experience in data warehousing projects with at least 4 years of full life cycle experience in implementation and support of DW Solutions on Oracle Platform.
-Minimum 2-3 Years of experience in implementing OBIEE OOB solutions analytics like Marketing, Finance Analytics etc.
-Must have extensive knowledge in ETL and above, OBIEE, Oracle 9i and PL/SQL.
-Must have extensive knowledge in Data warehouse designing techniques like Star Schema/Snowflake.
-Hands-on experience with OBIEE suite in developing OBIEE Repository (.rpd) in three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
-Experience defining processes for OBIEE Repository Merging ,OBIEE WEB Catalog Merging, Change Control Management, Migration of Metadata and Catalog across environments, Refresh strategy, Backup Strategy, Purge Strategy, Upgrade Strategy for Metadata and Catalog
-Should have very good technical expertise and strong business skills, as he/she will lead the team in delivering Business Intelligence solutions.
-Must be aware of testing process and DW implementation methodologies.
-Candidates with experience in implementing DW Solutions around Oracle Applications preferred.
-Knowledge of Hyperion, Discoverer 10g etc will be an added advantage.
-Excellent interpersonal skills with the ability to interact with credibility at all levels of the organization and a team player outlook with the ability to work well with peers.
-Working experience with offshore development is must.
-Excellent oral and written communication skills.
-Effective analytical, troubleshooting and problem-solving skills.
-Experience in Erwin Data modeling and Data Quality tool.

Jobs in New Jersey, Jobs, New Jersey, Data Engineer, Datawarehouse, data warehousing, OBIEE, Oracle, PL/SQL