Canada DBA Job



 
 


DBA Resources
 

Search dbajobs.ca

 


ETL Developer - Thoughtcorp


More Database and SAP Jobs in Toronto , Ontario

Company Profile:

Thoughtcorp - Toronto , Ontario; Throughout its history, Thoughtcorp has been a technology-focused IT services company. We have helped hundreds of clients achieve significant business advantage by developing and implementing information technology. By employing some of Canada's sharpest minds who thrive on solving complex business challenges, Thoughtcorp has been successful in delivering high value IT solutions to many of Canada's most prominent companies. ; Past job postings: ETL Developer ; DBMS: ETL, SQL, Pl/SQL, Informatica, Oracle & UNIX; Career Opportunities .

ETL Developer

The ETL Developer will play a key role on Thoughtcorp engagements through the implementation of Data Warehousing solutions.  In addition to strong Data Warehouse implementation experience and technical expertise the developer possesses strong analytical skills and has excellent communication skills.   The consultant may lead projects, and will deliver project artifacts, interface with clients, and deliver high quality Business Intelligence solutions. The Developer will report directly to the Project Manager of the engagement.  Travel within the GTA is a requirement as the Developer will work primarily onsite at client locations. 

Accountable for:

  • Designing, Developing and testing and implementing new Data Warehousing applications as well as enhancements to existing applications
  • Produce detailed system functional design and programming specification that satisfy business requirements and development standards
  • Development of extensible and easy to maintain ETL process that adhere to standard practices and is maintainable and operational with minimum manual interferences by creating data extraction, transformation, cleansing and load programs to move data from source systems to target Data Warehouse
  • Document and execute test plans for data loading and data validation scripts

Required Skills:

  • Expert knowledge and experience with ETL, SQL, Pl/SQL, Informatica, Oracle & UNIX
  • Data Mart Modeling experience
  • Experience with ER/Studio Modeling Tools
  • Experience with OLAP environments and tools

Experience Base - Consultant:

  • Minimum 2-5 years experience as an ETL Developer focusing on Data Warehousing
  • Minimum 2-5 years progressive experience in programming and analysis
  • Familiar with analysis and design methodologies for full system development life cycle.
  • Excellent knowledge of Data warehousing, Informatica, Oracle, SQL & PL/SQL
  • Good knowledge of Unix, Korn Shell and C
  • Excellent knowledge of ETL Processes in Data Warehouses and ETL Tools such as Informatica
  • Knowledge of Business Intelligence and related software, preferably Cognos & SAS
  • Working knowledge of Web Application development such as .Net, WebLogic and Java

Experience Base - Senior Consultant:

  • Minimum 5 years experience as an ETL Developer focusing on Data Warehousing
  • Minimum 7 years progressive experience in programming and analysis
  • Familiar with analysis and design methodologies for full system development life cycle
  • Excellent knowledge of Data warehousing, Informatica, Oracle, SQL & PL/SQL
  • Advanced knowledge of Unix, Korn Shell and C
  • Advanced knowledge of ETL Processes in Data Warehouses and ETL Tools such as Informatica
  • In-depth knowledge of Business Intelligence and related software, preferably Cognos Working knowledge of Web Application development such as .Net, WebLogic and Java

Please note - no agency referrals will be accepted. Preference will be given to candidates interested in permanent full-time however contract applications will be considered.



To apply for this position, please click here and send us your resume.
Please note - no agency referrals will be accepted.
Preference will be given to candidates interested in permanent full-time however contract applications will be considered.




Last updated on September 04, 2011