JUN ZHANG
Phone: 514-***-**** E-mail:ac7qfw@r.postjobfree.com
Experience Summary:
More than 10 years of experience in database and data warehouse.
More than 5 years experience in QA testing.
Experience in the areas of Oracle and PL/SQL based applications using Oracle PL/SQL and SQL Technologies under Windows, Linux Environments.
ETL using Informatica.
Mapping, Mapplet, Session, Workflow and Worklet design.
Performing system, acceptance, regression, load and functional test.
Work independently, strong trouble shouting ability.
Technical skills:
Operating Environments: Linux, Windows
ETL Tools: Informatica
Languages: P/L SQL, Kornshell, C, Python
DataBase: MS SQL Server, Sybase, Oracle
Reporting Tools: Excel, Tableau
Professional Experience:
ETL Developer LaoKen Technology CO., LTD 2014-2018
Database Engineer LaoKen Technology CO., LTD 2009-2014
Responsibilities:
Analyzed the business requirements and functional specifications.
Designing and creating logical & physical star schema and snowflake schema of Sales data mart.
Using Informatica Power Center for performing extraction, transformation and loading (ETL) of data from multiple data sources into Target in accordance with requirements and specifications.
Implemented performance tuning logic to provide maximum efficiency and performance.
Python, Kornshell Script.
Performed complex SQL Querries.
Having experience using Oracle 11g, SQL, PL/SQL, Stored Procedures, Functions, Exception Handling, Constraints, Triggers, Index, Views.
Created Test cases for the mappings developed and then created integration Testing Document.
Understanding of Business logic and ability to work well as a part of a team and as an individual.
Development Environment:
Linux, Windows series, SQL Server series, Oracle series
Informatica
Computer Science Vise Professor: Sichuan Aerospace Polytechnic College 1995-2008
Responsibilities:
Taught computer programs, algorithms, and computer languages to students. Such as “C Programming”, “Data Structure”, “Database Concepts” etc.
Created and assigned projects to students and developed professional skills in them. Such as “Student achievement management system”, “Teacher achievement management system”, “Books Management System” etc.
Strong technical knowledge and ability to troubleshoot complex problems
Strong organization and management ability
Excellent expressive ability, communication skill, persuasive ability
Education:
Technique Training
Informatica Training 2013
ProT QA Training 2010
SQL server Training 2005
Bachelor of Computer science
SICHUAN NORMAL UNIVERSITY, CHINA 1991-1995