BI DEVELOPER
Location - Los Angeles, CA
Duration - 6 Months
60/hr on W2 (All Inclusive)
Experience with COGNOS & TM1 areas is a MANDATORY
- 5 years of experience BI Database Experience
- Cognos BI experience 3 years (Framework Manager/Data Modeling)
- Extensive experience on multiple full life cycle Data Warehouse implementations
- Extensive experience in business intelligence and OLAP
- SSIS(SQL Server Integration Services) ETL Experience, as well as ETL Design and Programming
- Hands-on skills in data modeling; logical, physical and dimensional modeling
- Extensive experience in metadata management and master data management preferred.
- Successful experience working on complex data flow and processing and with large transactional and reporting databases
- Experience working with data teams, acting as a mentor in the design and development of Business Intelligence Data Environments. The candidate will have a desire for providing guidance for businesses cultivating their OLAP expertise
Experience in providing guidance in Data Normalization and Cardinality Issues
- Experience in providing guidance in data handling and cleansing / scrubbing processes
Sybase ASE Experience – Including Analyzing and Applying Recommendations for Data and Metadata
- SSIS(SQL Server Integration Services) ETL Exposure, as well as generally extensive ETL Design and Programming
- Hands-on experience with data integration tools such as Informatica, DataStage, etc.
- Expert knowledge of Relational Databases (e.g., MS SQL Server, SQL, Stored Procedures)
- Expertise and experience in the development and support of OLAP cubes, data mining and data analysis tools
- Skilled in Data Warehouse, including logical and physical star schema data models, extraction/transformation of data
- Skilled in SQL, Database and Transaction / OLTP processing concepts, knowledge of query analysis tools and performance optimization of queries
- Teradata, TM1, and/or RedShift experience development
experience
- Recent Experience with leading Cognos BI tools
Bachelor's Degree in Computer Science / MIS or equivalent experience