Data Warehouse Semantic Developer

Company Name:
GulfStream Strategic Placements
Data Warehouse Semantic Developer
Required Skills:
. Experience with Teradata 14.0
. Experience in integration with Cognos BI 10 and later version
. Experience within HealthCare/Pharmaceutical industry
. Experience with ERP system
Job Description:
. Develop and Analyze Teradata Database modules for a project in a multi-tiered architecture across different environments.
. Responsible for virtual semantic layer using views on a multi-tiered Integrated Data Warehouse
. Responsible for analysis and detailed technical design document for FP&A Data Warehouse.
. Collaborate with cross functional teams within J&J including Engineering & Operations toward successful deployment of deliverables.
. Provide technical support required to resolve complex issues to ensure the on-time delivery of solutions that meet customer expectations.
. Strong analytical and problem-solving skills, ability to react quickly to changing requirements due to product limitation or driven by enterprise/management need
. Works to define and characterize complex technology or process problems and/or develops new solutions, yet works independently to drive technical problems to a solution.
. Provide best practices and processes for day to day operations, performance analysis, tuning of Data Warehouse solutions in operational phase.
. Develop and foster a collaborative working relationship with the Business Intelligence and ETL teams, consultants, and project managers to develop processes, documentation and solutions related to deployments.
. Develop and manage conceptual, logical, and physical data models for data warehouseplatform.
. Interface with architecture, development, and business analysts to capture data information requirements that lead into design artifacts.
. Ability to define work streams and/or tasks and estimate work effort for areas of responsibility.
. Contribute content to data architecture standards, guidelines and common design principles.
Required Competencies:
. The candidate should possess strong design, development and analytical skills
. Experience in ER - Dimensional Data Modeling, Data Analysis & Definition, to support design/implementation of Normalized & STAR/SNOWFLAKE schemas
. Experience in implementing a virtual semantic layer using views on a multi-tiered Integrated Data Warehouse
. Progressive and varied experience in SDLC (software development life cycle) for Data Warehouse applications on Teradata.
. Extensive experience in development and deployment of Data Warehouse solutions
. Proficient in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (change data capture), Audit table, Error Handling Techniques for ETL process
. Experience in physical modeling with knowledge to use Primary, Secondary, PPI and Join Index
. Experience with BTeq to design and develop dataflow paths for loading transforming and maintaining Data Warehouse
. Experience with Windows 7, IE 8, Vista, XP, Office 2007/2010
. Solid verbal and written communication skills, with the demonstrated ability to communicate complex technical topics to team, managers and non-technical audiences

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Data Warehouse Architect
Saddle Brook, NJ Kforce
Microstrategy Data Warehouse Analyst
Edison, NJ Randstad
Data Warehouse Lead
Trenton, NJ U.S. Bank
Enterprise Data Quality Assurance Developer
Princeton, NJ Bloomberg