Senior ETL Developer
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- 7+ years of experience in developing and documenting ETL for data conversion and migration
- Posting language
- English
- Posted
Original job description
- 7+ years of experience in developing and documenting ETL for data conversion and migration
- Extensive experience in data migration and migration planning in terms of digital transformation, ETL experience in migrating data from legacy applications to modernized solutions.
- Extensive experience with various database structures and RDMS like Oracle, MS SQL Server, Azure SQL Database, and write complex SQL queries, conduct data analysis, data validation, and solve complex technical problems
- Experience in migrating document attachments from legacy solution to a new modernized solution.
- Experience working in cloud DB technologies (such as Azure SQL).
- Experience working with ETL tools such as Azure Data Factory, Informatica, etc.
- Experience in development of documentation such as ETL mappings, data dictionaries, business case, data migration strategy and plan.
- Knowledge and understanding of Information Management principles, concepts, policies and practices.
- Excellent understanding of master data and transactional data concepts and interdependencies.
More about this job
Responsibilities
Develop and document ETL processes for data conversion and migration, including moving data and document attachments from legacy applications to modernized solutions. Plan and execute migrations, analyze and validate data, write complex SQL queries, and resolve technical problems across database and cloud environments.
Requirements
Requires 7 or more years of experience developing and documenting ETL, with extensive experience in data migration and migration planning. Candidates should have experience with relational databases, Azure SQL or other cloud database technologies, ETL tools, migration documentation, information management principles, and master and transactional data concepts.
Skills
- ETL Development
- Data Migration
- Migration Planning
- Data Conversion
- SQL
- Oracle
- Microsoft SQL Server
- Azure SQL Database
- Azure Data Factory
- Informatica
- Data Analysis
- Data Validation
- Data Documentation
- Information Management
- Master Data
- Transactional Data
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
- Consulting
Keywords
- ETL
- Data Conversion
- Data Migration
- Migration Planning
- Digital Transformation
- Legacy Applications
- Modernized Solutions
- Document Attachments
- Relational Databases
- Oracle
- Microsoft SQL Server
- Azure SQL Database
- SQL Queries
- Azure Data Factory
- Informatica
- Cloud Databases
- Data Analysis
- Data Validation
- ETL Mappings
- Data Dictionaries
- Business Case
- Data Migration Strategy
- Data Migration Plan
- Information Management
- Master Data
- Transactional Data