Post Job Free

Resume

Sign in

ETL developer

Location:
Montreal, QC, Canada
Posted:
November 18, 2018

Contact this candidate

Resume:

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



Contact this candidate