Senior Bi/Data ArchitectLocation: Pleasanton, CA Duration: 12 + months on (C2C/ Full Time) For H1B passport no is mandatoryJob Description:• Well versed in complete Software Life Cycle Development process including requirement analysis, documentation, development, testing, implementation, and maintenance.• Strong & Proven experience in architecting and designing business intelligence reporting model and developing complex reporting solutions using IBM Cognos Business Intelligence Suite 10.2 / 8.4 / series 7 ver 4 & Cognos Analytics (V11)• Hands-on experience in building cubes, reports, dashboards, visualizations and mobile BI applications using IBM Cognos BI/Cognos Analytics(BI Architecture)• Hands on experience in data modeling,database design, ETL design and development( Data Architecture)• Excellent communication Skills and need to collaborate with Business Team and drive requirements gathering and reporting solution design• Expert level with developing metadata models in Framework Manager following best practices• Expert level with developing Cognos Dynamic Cubes.• Expert Level Dashboard design and Development Skills• Experience with building solutions with Cognos SDK• Experts level development skill within metrics studio• Strong skills developing DMR models in Framework Manager and dimensional reports in Report Studio• Skilled at training users to use Query Studio and Analysis Studio, Cognos Workspace• Strong understanding of designing dimensional and relational models, star and snowflake schemas and different DW design paradigms.• Strong proficiency in different SDLC methodologies.• Experience in PL/SQL and query optimization techniques• Solid experience in creating PL/SQL scripts and Stored Procedures to retrieve, load and manipulate data• Experience with working with offshore• Debug, monitor, and troubleshoot code and deployed solutions• Should be able to handle change requests• Should have a very good exposure in client interaction• Strong Knowledge in IBM Cognos Go Office• Mentor other team members in building Cognos skills