Data Integration / ETL Developer
Adastra Corporation
Toronto, ON
Data Integration/ETL Developer

Job Duties and Responsibilities

  • Translate detailed specifications into ETL processes
  • Analyze, design, develop, test and document ETL processes
  • Leverage reusable components when available
  • Identify opportunities to establish new reusable components
  • Assist with troubleshooting of ETL processes in Quality Assurance/SIT or Production environments
  • Complement ETL processes with shell scripts, Python or Perl scripts
  • Define and/or create process orchestration
  • Utilize SQL, scripts and/or other tools to assist with solution development
  • Conduct unit tests and assist in test preparations to ensure data integrity, data quality and program quality
  • Work closely with Designers, Business Analysts and other Developers
  • Liaise with Project Managers, Quality Assurance Analysts and Business Intelligence Consultants
  • Create runbooks and other documentation ahead of deployment to Production environment
  • Design and implement technical enhancements of Data Warehouse or pure Data Integration solutions
Required Skills, Education, Knowledge and Experience

  • 3-5 years of experience working with an ETL tool such Informatica Power Center, IBM Data Stage, MS SSIS or Ab Initio. We will consider applicants who work with other ETL tools like SAP BusinessObjects Data Services or Oracle Data Integrator.
  • Solid knowledge and experience with SQL and relational platforms (Oracle, DB2, SQL Server, Teradata)
  • Experience with UNIX, scripting languages (Korn Shell, Python, Perl), C or Java
  • Solid knowledge and experience with Data Warehousing
  • Understanding data warehouse architecture with a dimensional data model
  • Strong analytical skills
  • Good communication skills
  • Interest and ability to learn new ETL tools
  • Computer Science degree or diploma
Desirable Skills and Experience

  • Data modeling
  • ERwin or Power Designer
  • Java, C++
  • One or more of the following industry experience an asset: Financial Services, Telecommunications, Insurance, Health Care
  • Certification in ETL technology
Equal Opportunity Employer

In our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status or any other ground as described in the Ontario Human Rights Code. In addition, accommodation will be provided during the hiring process. Adastra Corporation’s implementation and support of employment initiatives encourage diversified labour force participation and equal access to opportunities based on merit and performance.