Foster City, CA
-- Long Term Project, C2C / W2 ok
Direct
Thanks,
Uday
Contractor position is being requested to support data analysis and data architecture function for Global BI data model project. Existing resources are allocated to other projects.
Responsibilities
The ideal candidate will function as a Senior Data Architect, participating in the design and implementation of data models that can support ongoing company projects. An understanding OLTP, OLAP, normalization, ETL, naming standards and metadata is key to this position. The position requires utilizing data modeling tools to develop logical and physical data models and documenting design documents. The ability to work independently is essential.
Responsibilities/Duties
• Design and review logical and physical data models for OLTP and OLAP in compliance with corporate standards.
• Use business requirements to document clear and concise technical database and ETL design.
• Maintain design and naming standards
• Maintain data dictionaries and integration of systems through database design.
• Create DDL, View SQL, and contribute to performance tuning.
• Contribute to project planning discussions, provide status updates for development progress and be a critical resource for issue resolution.
• Collaborate with report builders on design for optimum performance.
Qualifications
• Bachelor's degree in Computer Science or related discipline.
• Minimum 5 years as data architect.
• Strong oral and written communication skills.
• Banking or financial experience.
Technical Knowledge
• Expert knowledge of normalized and dimensional modeling techniques
• Expert knowledge of Erwin or System Architect.
• Experience with RDBMS (DB2 UDB, Oracle preferred).
• Experience with Hadoop (preferred)
• Prior experience working with data modeling repository server environment.
• Excellent SQL and DDL skills.
• Experience with project lifecycle development.
• Ability to write clear design and process documentation.
• Experience with Microstrategy and/or Cognos
• AbInitio EME/EMMS for the analysis of metadata
• Extremely detail-oriented and able to follow clear methodologies for troubleshooting and development.
Responsibilities
The ideal candidate will function as a Senior Data Architect, participating in the design and implementation of data models that can support ongoing company projects. An understanding OLTP, OLAP, normalization, ETL, naming standards and metadata is key to this position. The position requires utilizing data modeling tools to develop logical and physical data models and documenting design documents. The ability to work independently is essential.
Responsibilities/Duties
• Design and review logical and physical data models for OLTP and OLAP in compliance with corporate standards.
• Use business requirements to document clear and concise technical database and ETL design.
• Maintain design and naming standards
• Maintain data dictionaries and integration of systems through database design.
• Create DDL, View SQL, and contribute to performance tuning.
• Contribute to project planning discussions, provide status updates for development progress and be a critical resource for issue resolution.
• Collaborate with report builders on design for optimum performance.
Qualifications
• Bachelor's degree in Computer Science or related discipline.
• Minimum 5 years as data architect.
• Strong oral and written communication skills.
• Banking or financial experience.
Technical Knowledge
• Expert knowledge of normalized and dimensional modeling techniques
• Expert knowledge of Erwin or System Architect.
• Experience with RDBMS (DB2 UDB, Oracle preferred).
• Experience with Hadoop (preferred)
• Prior experience working with data modeling repository server environment.
• Excellent SQL and DDL skills.
• Experience with project lifecycle development.
• Ability to write clear design and process documentation.
• Experience with Microstrategy and/or Cognos
• AbInitio EME/EMMS for the analysis of metadata
• Extremely detail-oriented and able to follow clear methodologies for troubleshooting and development.
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To post to this group, send email to sureshotjobs@googlegroups.com.
Visit this group at http://groups.google.com/group/sureshotjobs.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment