对应专业:Computer Science, Electrical and Computer Engineering, Management Information Systems, or a related
所需培训:N
培训时长:
所需培训领域:
前置经验:Y
经验时长（月）:36
替代领域学历:N
替代专业:
可替代教育及经验组合:N
所需教育层级:
其他可替代教育层级:
认可经验年限:
境外教育背景:Y
可替代职业:Y
可替代职业时长（月）:36
可替代职业名称:In job offered or related occupations
是否为正常职业要求:N
是否需要外语:N
特殊技能:2 years of experience utilizing Informatica Power Center to execute ETL procedures, create mappings, sessions, and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems; developing and maintaining ETL mapping to extract data from various source such as Oracle, SQL Server, Sybase, Flat files, and xml files; utilizing table functions, indexes, table partitioning, collections, analytical functions, materialized views, query rewrite and transportable table spaces; SQL query performance tuning; performing requirement gathering for production releases, review of functional design and impact analysis, planning of testing scenarios and preparation of test cases, working closely with project managers and business users to formalize a business idea and define requirements, and coordinating joint application development sessions with business analysts and source developers for performing data analysis; performing data warehousing design and applying data modeling concepts, including Ralph Kimball Methodology and star schemasnowflake schema; and data cleansing and scrubbing large data sets. Employee reports to LexisNexis Risk Solutions FL, Inc. office in Alpharetta, GA but may telecommute from any location within the U.S. Experience can be concurrent.