- Oracle PLS SQL scripting in a development environment not production support.
- Documenting technical specification
- Documenting unit test case & execute them
- Source to Target data map that maps the data structures including the translation rules.
- Oracle ETL software built for both Initial (Historical) load and Synchronous (real-time) load of Data Migration.
- Technical Specification
- Unit test case procedure documents.
- Software deployment documents
Key skills- must have :
- Minimum 5 yrs Oracle PL SQL # active hands on
- Minimum 3 yrs hands-on performance tuning experience
Nice to have :
- Documentation of design specification & Unit test case procedures
- Basic shell scripting that supports ETL, File deli very to Amazon S3 storage in AWS Cloud.
Responsibilities of the resources:
- Undergo required training on standards, best practices & regulated SOPs to develop software for medical devices as Red Cross Biomedical IT is a highly regulated environment.
- Design, Build & Test the software to migrate data from current BECS system to the new, based on documented requirements.
- Document and maintain design & build in technical specifications and the corresponding test cases procedures for qualification.
- Performance tune the software built during the project life cycle from build to deployment,
- Automate software build process to deliver code packages in modular fashion.
- Work as a team following both Waterfall and Agile Methodologies.
- Coordinate & collaborate with other IT, business workstreams & the vendors to refine the requirements for all anomalous data conditions.