Please send resumes to preddy@hclglobal.com
Yahoo! IM: premreddyg
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.
G.Prem | Sr. Talent Acquisition
HCL Global Systems Inc.,
24543 Indoplex Circle, Suite 220,
Farmington Hills, MI 48335
Email: preddy@hclglobal.com | Ph: 248-216-0031
Certified Minority Business Enterprise (MBE)
You received this message because you are subscribed to the Google Groups "IT JOBS in USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to it-jobs-in-usa+unsubscribe@googlegroups.com.
To post to this group, send email to it-jobs-in-usa@googlegroups.com.
Visit this group at http://groups.google.com/group/it-jobs-in-usa.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment