Data Warehouse Semantic Developer (Los Angeles, CA)

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