At a Glance
- Tasks: Lead data migration projects and develop innovative ETL solutions.
- Company: Join a forward-thinking tech company focused on digital transformation.
- Benefits: Enjoy competitive pay, health benefits, remote work options, and growth opportunities.
- Other info: Collaborative environment with strong career advancement potential.
- Why this job: Make a real impact by transforming legacy systems into modern solutions.
- Qualifications: 7+ years in ETL development and data migration experience required.
The predicted salary is between 103500 - 126500 $ per year.
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 applications to a new solution. Responsibilities include:
- Establishing a strong working relationship with clients and interacting effectively at all levels.
- Analysing legacy data and files stored in a variety of data sources and formats.
- Completing data profiling and suggesting any pre-migration data cleansing activities.
- Developing data migration strategy, data mapping, defining interfaces, performing mock conversion, defining enhancements, and performing actual conversion.
- Translating technical systems specifications into working, tested applications.
- Resolving and troubleshooting technical problems which arise during the use and operation of software packages.
- Working with importing files from heterogeneous platforms and coordinating data file migration.
- Defining testing strategy, planning and conducting testing to ensure data integrity and data comparisons.
- Performing post-migration audit and data reconciliation.
- Generating data migration exception reporting and performing data cleansing as required.
- Providing pre- and post-effective conversion support to business clients.
Requirements Experience and Skill Set Requirements:
- Must Haves: 7+ years of experience developing and documenting ETL processes for data conversion and migration projects.
- Extensive experience with data migration and migration planning for digital transformation initiatives.
- Migrating data from legacy applications to modernized solutions using ETL methodologies.
- Relational databases such as Oracle, MS SQL Server, and Azure SQL Database.
- Complex SQL development, data analysis, data validation, and technical problem resolution.
Experience with:
- Migrating document attachments from legacy systems to modernized solutions.
- ETL tools such as Azure Data Factory, Informatica, or similar technologies.
- Developing ETL and data migration documentation, including ETL mappings, business cases, and data migration strategies and plans.
Desired Skills and Experience:
- 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.
- 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 solutions.
- Experience with data conversion scripts and various ETL tools.
- Experience 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.
- Knowledge and understanding of Information Management principles, concepts, policies, and practices.
- Experience providing support through the cutover process.
Technical Skills:
- 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.
- 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.
- 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.
Communication Skills:
- Communication, facilitation, negotiation, consensus building, and problem-solving skills.
- Provide periodic status reports, present data migration strategy and approach to executives and other stakeholders.
Public Sector Experience:
- Previous experience working in Government or Public Sector organizations.
11784 in Toronto employer: Maarut
At Maarut, we pride ourselves on being an exceptional employer in Ottawa, offering a dynamic work culture that fosters collaboration and innovation. Our commitment to employee growth is evident through mentorship opportunities and professional development programs tailored for actuarial leaders. With a focus on strategic impact and a supportive environment, we empower our team to make meaningful contributions while enjoying the unique advantages of working in Canada's vibrant capital.
We think you need these skills to ace 11784 in Toronto
ETL Development
Data Migration Planning
Legacy Application Migration
Relational Databases (Oracle, MS SQL Server, Azure SQL Database)
Complex SQL Development
Data Analysis
Data Validation
