. Experience with Teradata 14.0
. Experience in integration with Cognos BI 10 and later version
. Experience within HealthCare/Pharmaceutical industry
. Experience with ERP system
. 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.
. 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