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 -- -- To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/CBE-Software-Engineer?hl=en --- You received this message because you are subscribed to the Google Groups "CBE Software Engineer" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
