Job Description

Title: Data Conversion Specialist - Senior
Location: Toronto, ON M7A 0B6(Hybrid - 3 days Onsite)
Duration: 144 days with possibility of extension
Must Haves:

• 3+ years of experience in data migration, conversion, or ETL processes.
• Hands-on experience with AWS Connect, Databricks or other data platform, and data transformation techniques.
• Data Transformation Tools: Expertise in ETL tools and data engineering processes.
• Programming Languages: Proficiency in Python and SQL; experience with Scala is a plus.
• AWS Services: working knowledge of AWS Connect, Amazon S3, AWS Lambda, and AWS Glue.

Skillet:

• Data Extraction and Transformation: Design and execute data extraction processes to gather data from AWS Connect, ensuring that all relevant contact center data is accurately transferred. (25%)
• ETL Process Development: Create and manage ETL pipelines for the efficient transfer of large data sets from AWS Connect to Databricks, optimizing for performance and scalability. (25%)
• Data Quality and Validation: Implement data validation, cleansing, and transformation protocols to ensure that data is accurate, consistent, and accessible post-migration. (20%)

Ideal Candidate:

• 3+ years of experience in data migration, conversion, or ETL processes.
• Hands-on experience with AWS Connect, Databricks or other data platform, and data transformation techniques.
• Data Transformation Tools: Expertise in ETL tools and data engineering processes.
• Programming Languages: Proficiency in Python and SQL; experience with Scala is a plus.
• AWS Services: working knowledge of AWS Connect, Amazon S3, AWS Lambda, and AWS Glue

Responsibilities:

• Oversee all the facilities of the conversion process.
• Completes mapping, interfaces, mock conversion work, enhancements, actual conversion, and verifies completeness and accuracy of converted data.
• Establish a strong working relationship with all clients, interact effectively with all levels of client personnel, and provide conversion support.
• Analyzes and coordinates data file conversions.
• Works with importing files from heterogeneous platforms.

General Skills:

• Full life-cycle data conversion experience with Enterprise Resource Planning (ERP) Systems, including deployment experience
• Proficiency in query languages
• Familiarity with and construction of complex query statements
• Knowledge of various database structures
• Data analysis, investigative and logic skills
• Experience with data conversion scripts and tools
• 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

Desirable Skills:

• Knowledge and experience in business case development
• Knowledge and understanding of Information Management principles, concepts, policies and practices
• Excellent understanding of master data and transactional data concepts and interdependence

Skills Required