Design and develop ETL/ELT packages using Oracle Data Integrator (ODI) • Troubleshoot bugs, enhance and support existing ETL packages for the data warehouse • Participate in requirements gathering and design of ETL/data integration solutions • Create and maintain documentation for developed ETL processes • Optimize and convert existing ETL/ELTs • Experience in Oracle SQL, SQL Tuning • Interface with QA, Production DBAs and Production Support team to test, deploy and support ETL packages
Requirements: • 6+ years experience in Oracle ETL development • 2+ years experience working with Oracle Data Integrator (ODI) • Knowledge of ETL/ELT design principals such as change data capture, slowly changing dimensions, surrogate keying and fact aggregation • Experience on data warehousing/ MDM projects, data warehouse ETL design and best practice. • Translate user requirements into technical architecture vision and implementation plans. • Integrate ODI with multiple Source / Target, Error Management. • Experience with Informatica Powercenter tool is a plus. • Expert PL/SQL developer, Oracle SQL, SQL Tuning and Oracle Database experience -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/groups/opt_out.
