Position:Junior. ETL DeveloperCategory:

Software/OS

City:

Toronto

Province:ON
Branch Name:Direct HireDress Code:
Branch Phone:(905) 5868828Job ID:4748
Pay Info:Order Type:DH

Position Term: Full-Time, Permanent
Location: Toronto/ Mississauga

An IT professional with 2-4 years of extensive experience in Enterprise Data Integration Strategies - SOA Principles, Master Data Management Technology and BI tools. A tactful Negotiator, who can work with concerned stake holders and act as a liaison between teams located in different geographic locations. Excellent interpersonal and communication skills, with the ability to synthesize complex problems in few sentences.
The role will actively participate and contribute to the integration team’s activities.
Responsibilities:
• 3+ years of strong ETL development experience with at least 4 years of experience in designing, developing and testing InfoSphere DataStage jobs using DataStage Designer v 8.5 & above.
• Hands on experience with Microsoft SSIS ETL developments
• Experience in Integration with external data sources including Oracle databases, SQL Server databases, Flat files, XML files, IBM MQ and Web Services (SOAP).
• Knowledge in using DataStage Director and DataStage Manager
• Strong data warehousing and OLTP system knowledge
• Advanced SQL development and performance tuning, Data cleansing, Data profiling skills
• Proficient in designing and implementing data warehouses and data marts using components like Kimball Methodology, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, De-normalization techniques, etc.
• Create technical designs based on business/functional requirements.
• 2-4 years of strong ETL development experience with at least 2 years of experience in designing, developing and testing ETL jobs using MSBI technologies.
• Strong knowledge with Microsoft SSIS ETL developments (SQL server 2012 or greater)
• Expert in designing Parallel jobs using various tasks like Join, Merge, Lookup, remove duplicates, Filter, Dataset, Lookup file set, Modify, Aggregator, XML parsing tasks.
• Advanced SQL development and performance tuning, Data cleansing, Data profiling skills
• Experience in Integration with external data sources including Oracle databases, SQL Server databases, Flat files, XML files and Web Services (SOAP).
• Knowledge in consuming and parsing the XML payloads
• Strong in data validation, Integration and End-to-End testing.
• Strong Oracle and SQL Server database knowledge including database design, development (package, procedure, functions, indexes)
• Experience in handling complex logic with large volumes of data
• Experience with error handling and optimization of SSIS ETL packages

Critical Skills:

• Excellent oral and written communication skills
• Knowledge on Unix commands and shell scripting, Cron jobs
• Experience with MSBI stack (SSIS, SSRS, SSAS)
• Experience with building the web services / web API
• Experience with IBM Datastage
• Experience with QualityStage, Information Analyzer
• Enterprise Data Integration Strategies - SOA Principles
• Experience with Master Data Management Technology
• Experience with Microsoft BI SSRS, SSAS, or any other BI tools
• Experience with building the web services / web API
• Hadoop tools for Big data
• Ability to work independently on development projects with minimal direction.
• Able to communicate well and collaborate with other team members.

If this position is of interest, please forward a copy of your resume in Word format and your Salary Expectation.
Please also indicate a good time for me to call you or feel free to contact me ASAP.