I have finished 6 projects in Telecommunication, Banking, warehouses areas, my:
Responsibilities:
• Modified ETL process;
• Develop new function/procedure/package;
• Bugs fixing, bugs filling;
• Create developer test reports;
• Analyzed troubles/defects.
• Database design;
• Create ETL process for load data from files;
• Create sources/targets and backup for them;
• Develop Subject areas;
• Develop load mappings and publication mappings;
• Develop analytic reports;
• Create sources/targets/mappings/sessions/worklets/workflows in Informatica;
• Create analytic metrics.
• Develop automated test cases for DWH data and ETL-process;
Tools and Technologies:
• Informatica 9.5.1, Oracle 11g, PL/SQL Developer, JIRA, Git, SVN, JMS
• IBM Netezza, Aginity Workbench for Netezza, Customer Intelligence Appliance (CIA) for Netezza, Informatica, BI Cognos, Selenium, IDEA.
• OeBS, Oracle Forms/Reports Builder, PL/SQL Developer