- Jan 6, 2013
- 6
- Category........
- NOC Code......
- 2172
- Job Offer........
- Pre-Assessed..
- Doc's Request.
- CELPIP-spouse-sept 23- same day submitted
- AOR Received.
- sept 14
- Med's Request
- sept 24-passed/recv'd
- Med's Done....
- sept 24
- Passport Req..
- FEB 24
hi all,
need your valuable information. i guess OOPNP is not issuing PT's for NOC2172 so would like to ask what else NOC code can we use for the below job responsibilities.
Description:
Was Responsible for ensuring SPI (sensitive customer information) in all non-production environments has been scrambled (masked) as per Rogers ISO standards Delivering timely scrambled data as required by development, QA or environment support teams that has data consistency across multiple applications.
Responsibilities:
• Informatica Designer tools were used to design the Source definitions, Target definitions, Mappings and Transformations to build mappings.
• Designed and implemented complex data transformation mappings using Informatica Power Center. Used transformations like Connected and Unconnected Lookups, Aggregator, Expression, Joiner, Update, Router and Sequence generator.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Coordinate development effort with offshore development team and participate and conduct Code reviews once the code is unit tested and ready for QA
• Create project documentation (Detailed design, Source-to-target mappings, Implementation plans, Run books, etc.)
• Assist in QA activities and resolve issues raised by QA team
• Created error handling strategy with checking on data integrity and data quality ensured high quality and clean data in the data warehouse
• Developed and scheduled Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Validated the Mappings, Sessions & Workflows, Generated & Loaded the Data into the target database.
• Performed performance tuning to remove bottleneck on source, target, mapping, session reduced 30% ETL loading time. Optimized the Performance of the mappings to load the data quicker.
• Analyze business and system requirements, manage development of specifications to create and execute detailed test plans, and verify bug fixes. Corrected testing defects and supported all levels of testing, ensured high quality of ETL program.
• Use Clear-Quest for reporting and tracking bugs, and providing updates on resolved bugs.
need your valuable information. i guess OOPNP is not issuing PT's for NOC2172 so would like to ask what else NOC code can we use for the below job responsibilities.
Description:
Was Responsible for ensuring SPI (sensitive customer information) in all non-production environments has been scrambled (masked) as per Rogers ISO standards Delivering timely scrambled data as required by development, QA or environment support teams that has data consistency across multiple applications.
Responsibilities:
• Informatica Designer tools were used to design the Source definitions, Target definitions, Mappings and Transformations to build mappings.
• Designed and implemented complex data transformation mappings using Informatica Power Center. Used transformations like Connected and Unconnected Lookups, Aggregator, Expression, Joiner, Update, Router and Sequence generator.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Coordinate development effort with offshore development team and participate and conduct Code reviews once the code is unit tested and ready for QA
• Create project documentation (Detailed design, Source-to-target mappings, Implementation plans, Run books, etc.)
• Assist in QA activities and resolve issues raised by QA team
• Created error handling strategy with checking on data integrity and data quality ensured high quality and clean data in the data warehouse
• Developed and scheduled Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Validated the Mappings, Sessions & Workflows, Generated & Loaded the Data into the target database.
• Performed performance tuning to remove bottleneck on source, target, mapping, session reduced 30% ETL loading time. Optimized the Performance of the mappings to load the data quicker.
• Analyze business and system requirements, manage development of specifications to create and execute detailed test plans, and verify bug fixes. Corrected testing defects and supported all levels of testing, ensured high quality of ETL program.
• Use Clear-Quest for reporting and tracking bugs, and providing updates on resolved bugs.