- Full life-cycle data conversion experience with enterprise systems, including deployment experience.
- Experience working with all steps of data migration activities such as data profiling, data mapping, developing data migration solutions, data validation and audit.
- Proficiency in query languages such as SQL, PL-SQL.
- Familiarity with and construction of complex query statements.
- Knowledge of various database structures and RDMS like Oracle DB and MS SQL Server, Azure SQL Database, and write complex SQL queries.
- Knowledge and understanding of mainframe data formats, data types, segments, and non-relational data structures.
- Experience ensuring the data migration solution is scalable.
- Data analysis, investigative and logic skills with high attention to detail
- Experience with migrating file attachments from legacy applications to new solution.
- Experience with data conversion scripts and various ETL tools such as Informatica, Azure Data Factory, etc.
- Experience with overseeing /completing all tasks involved in the conversion process including data extraction, cleansing, transformation, and loading.
- Experience liaising with teams to understand to-be migration requirements.
- Establish a strong working relationship with all groups, interact effectively with all levels of client personnel, and provide conversion support.
- Experience completing mapping, interfaces, conversion work, documentation and verifying completeness and accuracy of converted data.
- Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
- Experience providing support through the cutover process.
- A team player with a track record for meeting deadlines, managing competing priorities and client relationship management experience.
- Communication, facilitation, negotiation, consensus building, and problem-solving skills
- + years of experience in developing data conversion and migration.
- At least one experience of working with migrating data from different legacy platforms to a new solution.
- Full life-cycle data conversion experience with enterprise systems, including deployment experience.
- Data analysis, investigative and logic skills, including the ability to troubleshoot and solve complex technical problems.
- Experience with overseeing /completing all tasks involved in the conversion process including data extraction, profiling, cleansing, import data, manipulate data, transformation, and loading.
- Experience liaising with teams to understand to-be migration requirements.
- Knowledge and understanding of Information Management principles, concepts, policies and practices.
- Experience providing support through the cutover process.
- Knowledge of data model of case management solutions and experience in data migration/conversion of large case management applications.
- Experience with migrating attachment files from legacy applications to new solution.
- Experience with document migration.
- Experience with industry leading ETL tools such as Informatica, Azure Data Factory and cloud technologies.
- Proficiency in query languages such as Oracle SQL, PL-SQL, SQL Server, etc.,
- Exceptional level of knowledge on relationships between tables to perform and construct complex query statements from multiple data sources.
- Knowledge of various database structures and RDMS like Oracle, MS SQL Server, Azure SQL Database, and write complex SQL queries, etc.,
- Knowledge and understanding of mainframe data formats, data types, segments, and non-relational data structures.
- Data analysis, investigative and logic skills with high attention to details, including ability to troubleshoot and solve complex technical problems.
- Experience with data conversion scripts and tools.
- Experience with file migration from different file storages such as Azure BLOB, Azure file share, SharePoint, Oracle BLOBs.
- Experience completing mapping, interfaces, conversion work, data exclusion and inclusion, documentation and verifying completeness and accuracy of converted data, including data dictionary development and updates.
- Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
- Communication, facilitation, negotiation, consensus building, and problem-solving skills
- Provide periodic status reports, present data migration strategy and approach to executives and other stakeholders.
- Previous experience working in Government or Public Sector organizations. Mandatory requirements:
- + years of experience in developing data conversion and migration.
- Extensive experience in data migration in terms of digital transformation, ETL experience in migrating data from legacy applications to modernized solutions.
- 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 in ETL tools such as Azure Data Factory, Informatica, etc.
- Knowledge and experience in development of 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.
-
ETL BI Developer
1 day ago
Maarut Inc Toronto, CanadaResource Profile · This requirement is for a ETL and BI Developer to work with technology and business teams to provide technical leadership in planning, analysis, building, configure, testing, and post implementation support data solutions with experience with enterprise ETL and ...
-
ETL Developer
1 day ago
Procom Toronto, CanadaETL Developer - Informatica DEI On behalf of our client in the Healthcare Sector, PROCOM is looking for an ETL Developer - Informatica DEI. ETL Developer - Informatica DEI - Job Description · This Senior Consultant/Developer will operate (run processes), maintain (small code chan ...
-
ETL Developer
2 days ago
Procom Toronto, ON, CanadaETL Developer - Informatica DEI On behalf of our client in the Healthcare Sector, PROCOM is looking for an ETL Developer - Informatica DEI. ETL Developer - Informatica DEI - Job DescriptionThis Senior Consultant/Developer will operate (run processes), maintain (small code changes ...
-
ETL Developer
1 week ago
Atlantis IT Group Toronto, CanadaETL Developer with Financial Service · Toronto · Min. 10+ years of experience in Financial Services client with atleast 5+ years of experience in Asset Servicing or Capital markets domainMin. 10+ years of years of experience in developing automated scripts using SQL, VB Script a ...
-
ETL Developer
6 days ago
Tata Consultancy Services Toronto, CanadaAbout TCS · TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to ha ...
-
ETL Developer
3 days ago
Tata Consultancy Services Toronto, CanadaAbout TCSTCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have ...
-
Senior ETL Developer
3 days ago
Scotiabank Toronto, CanadaThe Sr. ETL Engineer is responsible for design and development of ETL solutions to integrate with our Salesforce platform for complex business and technology initiatives. Along with providing thought leadership, navigating us through production issues and investigations, and bein ...
-
ETL Cloud Developer
3 days ago
CB Canada Toronto, CanadaThe opportunity · Reporting to the Vice President of Enterprise Applications and working on the integration team, we are looking for an ETL Cloud Developer. You will play a vital role in designing, developing and supporting a new real estate cloud-based data platform that support ...
-
SQL Developer with ETL
6 days ago
Atlantis IT group Toronto, Canada Full time· Role Description: Undergraduate Degree or Technical Certificate. A minimum of 5 years experience with large SQL data marts. Expert relational database experience, Canditate should demonstrat ability to navigate through massive volumes of data to deliver effective and efficient ...
-
IBM Datastage/ETL Developer
6 days ago
Tata Consultancy Services Toronto, CanadaTCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity ...
-
ETL Developer 7422-0114
5 days ago
Foilcon Toronto, Canada Contract Corp-to-CorpHM Note: This hybrid role is three (3) days in office · Responsibilities: · Assist with the design and configuration of the cloud infrastructure to optimally support IDMC. · Mentor and support our ETL developers in their transition to IDMC. · Help with the ETL code conversion fro ...
-
Senior ETL Software Developer
7 hours ago
Global Pharma Tek Toronto, Canada ContractPosition: Senior ETL Software Developer · Location: Toronto, ON (Hybrid) · Duration: Business Days · Job Description: · Responsibilities: Support the branch in developing and implementing the technical solutions needed as well as providing operational support ensuring that a ...
-
IBM Datastage/ETL Developer
3 days ago
Tata Consultancy Services Toronto, CanadaTCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity ...
-
Intern, Junior ETL Developer
3 weeks ago
dentalcorp Toronto, Canada TEMPORARYThis is a full time short-term internship opportunity starting May 2024 until August 2024. · Application Deadline is April 16th, 2024 · Who you are · You are a service-oriented individual who is excited to be a part of a fast-growing organization that enables the best to be even ...
-
ETL Developer with Financial Service
4 days ago
Atlantis IT group Toronto, Canada Full timeRole: Competencies: BPS : SQL Basic, Foundation : JavaScript · Experience (Years): 8-10 Min. 10+ years of experience in Financial Services client with atleast 5+ years of experience in Asset Servicing or Capital markets domain'Min. 10+ years of years of experience in developing a ...
-
ETL Software Developer 7429-0112
6 days ago
Foilcon Toronto, Canada Contract Corp-to-CorpHM Note: This hybrid role is three (3) days in office · Description: · • A senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution · DELIVERABLES: ...
-
Sr. Consultant/Developer – ETL
3 days ago
Randstad Canada North York, Canada FreelanceOur client, a leader in the Healthcare industry, is looking for a Senior ETL developer for doing product updates, operations and maintenance on a series of ETL products. · This Senior Developer must be knowledgeable and experienced in the following technologies to be able to sup ...
-
Business Intelligence Specialist
1 week ago
EBF Toronto, Canadaon behalf of our client on Public Sector. we are looking for contract **Business Intelligence Specialist - ETL Developer** · Description · **General Responsibilities** · - Design, develop and implement ingestion framework from Oracle source to Azure Data Lake - initial load and i ...
-
Business Intelligence 7221-2112
2 days ago
Foilcon Toronto, Canada**Description**: · **General Responsibilities** · - Design, develop and implement ingestion framework from Oracle source to Azure Data Lake - initial load and incremental ETL. Used tools are: · - Azure Data Factory (expert knowledge) to maintain pipeline from Oracle to Azure Data ...
-
Etl Informatica 10
4 days ago
E-Solution Toronto, Canada**Job Title · - ETL, Informatica Developer** · **Job Type · - Fulltime** · **Location · - Toronto, ON** · **JD**: · Technical expertise on ETL Informatica Power center, Informatica ,Data Bricks, ADF, PySpark etc. · - Proficient in UNIX/LINUX and in any one DB (like Oracle/SQL Ser ...
Software Developer ETL - Toronto, Canada - Global Pharma Tek
Description
Title: Software Developer - ETL SeniorLocation: Toronto, ON (Hybrid)
Duration: Business Days + Possible extension
Job Description: