*Please send resumes to [email protected] <[email protected]>* *Yahoo! IM: premreddyg <[email protected]>*
*Oracle Data Integrator/ODI Lead Consultant * *Location: Plantation, FL* *Duration: 3-4 Months+* *Job Description:* - Oracle Data Integrator (ODI) installation/ repository creation/ configuration, interfaces/packages development - Interpreting and implementing business requirements for ETL development, - Experience in slowly changing dimension - Write complex SQL queries (involving multiple joins, sub-queries and analytical functions) - Preferred to have OWB ETL Experience (code/debug/fix/QA Prod issue) - Ability to document OWB, ODI objects and functionality in the form of ETL specification and design documents - Knowledge of best practices for OWB, ODI versioning - Use of loading and extract hints in OWB, ODI - Knowledge of ODI load plan, scenarios, variables, procedures, check knowledge module, reprocessing error tables, performance tuning, etc. *Main responsibilities will include, but are not limited to:* - Oracle Warehouse Builder (OWB) repository creation/configuration/monitoring, mapping/process flow development, OMB Scripting, deployments – some data modeling (via Erwin) - Oracle Data Integrator (ODI) installation/ repository creation/ configuration, interfaces/packages development - Interpreting and implementing business requirements for ETL development, Experience in slowly changing dimension - Performing in depth unit testing for all enhancements/new development – including data analysis for verification of accuracy and performance tuning for optimal execution - Adhering to existing ETL development and load management Standards and Processes - Write complex SQL queries (involving multiple joins, sub-queries and analtical functions) - Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for management attention and/or escalation *Required Skills:* - Detail-oriented - Strong Communication Skills (verbal and written) - Strong Coordination Skills - 5 years PL/SQL Experience - Preferred to have OWB ETL Experience (code/debug/fix/QA Prod issue) - 3 years ODI ETL Experience (code/debug/fix/QA Prod issue) - Strong Data Analyst Skills (Oracle-SQL,PL/SQL - DB2 a plus) - Strong ETL Architecture Skills (Kimball Methodology) *Preferred Skills:* - Experience with TOAD (Oracle/DB2) - Experience with ERWIN or similar data modeling tool - Experience with ETL Load Tuning and Automation - Production Support; especially with load management and automation *Required Experience Details:* - Knowledge and application of Kimball Methodology in an Oracle 10g or 11g environment leveraging OWB 10gR2 or 11gR2 including Star/Snowflake Schema. - Ability to document OWB, ODI objects and functionality in the form of ETL specification and design documents - Knowledge of best practices for OWB, ODI versioning - Use of loading and extract hints in OWB, ODI - Knowledge of configuration features for Mapping Objects, Mappings, and Process Flows including but not limited to target loading properties, Mapping load types (set based vs. row based and fail-over), parallelism, etc. - Knowledge of best practices for reproc/audit-balance control implementation in ETL (OWB error-tables) - Knowledge of ODI load plan, scenarios, variables, procedures, check knowledge module, reprocessing error tables, performance tuning, etc. Regards, G.Prem | Sr. Talent Acquisition HCL Global Systems Inc., 24543 Indoplex Circle, Suite 220, Farmington Hills, MI 48335 Email: [email protected] | Ph: 248-216-0031 www.hclglobal.com Certified Minority Business Enterprise (MBE) -- You received this message because you are subscribed to the Google Groups "Exact Match" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/exact-match. For more options, visit https://groups.google.com/d/optout.
