Talent.com
Senior ETL Developer
Senior ETL DeveloperEncore Technical Solutions Inc. • Markham, York Region, CA
Senior ETL Developer

Senior ETL Developer

Encore Technical Solutions Inc. • Markham, York Region, CA
1 day ago
Job type
  • Full-time
Job description

4 days per week in office requirement - Markham, ON

Job Requirements

  • A degree in Computer Science, Software Engineering, or comparable professional experience.
  • Approximately 5–6 years of hands‑on work with ETL processes ( ideally using Microsoft SSIS / SSDT ), Azure DevOps pipelines, data profiling, data cleanup, data modeling, CDC techniques, and crafting / optimizing SQL queries.
  • Background in legacy system data migration , including practical use of MS SSIS / SSDT and Pitney Bowes migration utilities.
  • Familiarity with working across a broad set of data sources and database technologies such as Oracle (versions 8i, 9i), Microsoft SQL Server (2012 and later), XML datasets, Excel spreadsheets, Access databases, and various flat‑file formats.
  • Experience with programming or scripting languages including DS Script and T‑SQL.
  • Strong communication abilities, both written and verbal.
  • Bonus skills : exposure to SAP BODS , SAP Information Steward , SAP ERP , Clarify CRM , Power BI , or Zuora’s billing platform .

Responsibilities

  • Gain a solid understanding of business logic and operational rules that drive complex data migration and integration efforts.
  • Participate in analyzing requirements, conducting data mapping sessions, and collaborating with both project teams and external customers to resolve issues.
  • Build data extraction and transformation processes using MS SSIS / SSDT.
  • Compare, validate, and reconcile information between source environments and target systems to ensure accuracy.
  • Manage several tasks at the same time, prioritize appropriately, and meet deadlines that may overlap.
  • Troubleshoot technical challenges related to data conversion, integration, and migration workflows.
  • Produce well‑organized documentation that supports repeatable migration procedures for applications and data processes.
  • Mentor and support other developers by providing guidance, recommendations, and constructive feedback.
  • Deliver clear, consistent progress updates and status reporting.
  • Assist other technology teams and operational support areas when required, along with handling any additional duties assigned.

    • #J-18808-Ljbffr

    Create a job alert for this search

    Senior ETL Developer • Markham, York Region, CA