Home  Post Resume Quick IT Job Search  Advanced IT Job Search 
Skip Navigation LinksHome » Job Details
International Business Search
  Company Profile
International Business Search Inc. is one of Canada’s foremost recruitment and placement firms celebrating its 10th year. Although our primary focus has been Information Technology and Computer Professionals, we also specialize in the areas of Engineering, Finance & Administration, Human Resources and Sales, both permanent and contract personnel.

International Business Search Inc.’s commitment to providing comprehensive and integrated services has made us one of Canada’s most innovative and involved organizations in the field.

We believe that enabling an organization to achieve its full potential means working in partnership to define leadership positions and long term goals, and locating the most effective means towards achieving optimal ends – whether by placing individuals or introducing and executing strategic alliances.

 
  Job Details 
Title: 

Sr. ETL Developer : ANSI, PL SQL, PERL, Shell scripting, UNIX, ETL : Toronto, ON

Posted On:  10/31/2020 6:03:38 AM
Designation: 

Sr. ETL Developer

No. of vacancies:  1
Qualifications:  Degree in Computer field
Essential Skills: 
SkillsSpecializationYears
ETL-3
Datawarehousing-3
Minimum Total Experience:  3
Job Tenure:  Full-time Only
Salary Offered:  DOE
Job Location:  Toronto ON Canada

  Job Description
Job Description:
v The Sr. ETL Developer will be primarily responsible for the analysis, acquisition, cleansing and integration of data from internal and 3rd party data sources into the Enterprise Data Warehouse (EDW), Data Marts and other data repositories maintained by the Decision Support Services (DSS) department.
v Other responsibilities include administration of the ETL and Data Quality applications


Key Responsibilities:
v Hands-on design, development and deployment of data integration project tasks and initiatives
v Liaise with business analysts and data stewards to fully understand business/data requirements
v Analyze and gain strong understanding of all source and target data structures; map source system data to data warehouse models
v Design, develop and document ETL mappings/processes for integrating source data into the Enterprise Data Warehouse (EDW) and other data repositories based on industry best practices; ensure data delivery is of high quality, timely, accurate and consistent
v Design, develop and document data cleansing processes to ensure delivery of high quality data to downstream data stores (e.g., customer matching, data standardization, data profiling etc.)
v Author technical specifications based on functional requirements
v Establish and document standards/processes (e.g., naming conventions, object migration, data recovery etc.) based on industry/application best practices
v Identify opportunities for continuous improvement in systems
v Engage in 3rd Level Technical Support to address Production system issues (on-call, rotational basis)

Required Skills/Experience:
* University/College degree in Computer Science / Business Administration
* Minimum 4 years hands-on experience with Informatica PowerCenter (version 7+) or other leading ETL platforms
* Strong theoretical knowledge and practical experience of data warehousing development life-cycle and OLAP-related principles and concepts
* Strong grasp of data modeling techniques and concepts
* Normalized/Denormalized
* Conceptual/Logical/Physical
* Star vs. Snowflake Schemas
* Relational vs. Dimensional
* Strong working knowledge of relational database technologies including Oracle 9i+ and SQL Server 2000+ including:
* Advanced knowledge of reading and writing SQL (ANSI, PL SQL and Transact SQL)
* SQL performance tuning
* Strong business and technical acumen
* Working knowledge of UNIX (e.g., Solaris)
* Strong working knowledge of scripting languages (e.g., PERL, Shell scripting – Unix, Windows)
* Good communication skills (oral, written and presentation)
*Able to work autonomously or with others
*Strong problem-solving skills; logical thinker
* Self-motivated

Nice-to-Have Skills:
*Certified Informatica Designer/Consultant designation
*Oracle Certified Professional designation
*Experience deploying messaging services (e.g., JMS) with Informatica Real-Time Module
*Experience with BI platform technologies including (e.g., MicroStrategy, Cognos, Business Objects etc.)
*Experience with other ETL technologies (e.g., Ab Initio, Data Stage etc.)
*Experience with Data Quality technologies (e.g., Data Flux, First Logic, Group One, Trillium etc.)

If you or your friends meet the above skill sets, please apply online.

  Contact Information
Reference Name (If Any): 





 
Terms and Conditions | Privacy Policy | FAQ | Contact Us | Why?? | Link to us