|Data Analyst - ODI
* We are looking for someone with a solid background within ODI (Oracle Data Integrator)
* Solid Migration Experience
* Develop SQL scripts for advance profiling based on business rule provided.
* Extensive experience of Datamodelling.
* Development of PL/SQL scripts to extract, standardize, clean up and normalise data from source systems & various excel sheets; based on business rules provided.
* Develop scripts to validate, repair and enrich data for various complex data objects.
* Experience of development of scripts to identify and process duplicates include merging of records.
* Develop script to process data and extract data set based on hierarchy provided.
* Exposure to data model development based on design provided.
* Development of Conversion Procedures to populate conversion staging tables as per the target system file-based data import framework
* Developing SQL reconciliation scripts for source vs destination systems.
* Collaborate with the test team to execute regression tests on the destination system.
* Leveraging your previous experience to enhance the approach to data migration testing
* Exposure to data migrations that include on premise to cloud would be a benefit
* Strong Data Analysis Skill and expert knowledge of MS Excel, Oracle SQL, Data Loader, TOAD/PL/SQL Developer, Oracle Database 12c, Java. Leading ETL Tools