Data Migration Specialist
JourneyBlazers is a boutique Salesforce implementation partner with a proven track record and a perfect 5.0 CSAT score. We are a global team with operations in the US, UK, and India.
Description:
As a JourneyBlazers Data Migration Specialist you will be responsible for designing, testing, and executing one-time and regularly scheduled data conversion routines to migrate data between both legacy on-premises databases and cloud databases. You will ensure that data quality, integrity, and completeness was maintained or improved during the migration, and that adequate data normalization was performed. You will work closely with both JourneyBlazers architects and business analysts to deliver innovative functionality that pushes the boundaries of Salesforce.
This role is primarily responsible for designing, testing and executing one-off and regularly run data conversion routines to migrate data from legacy databases into the TrialWorks SQL server database or the Needles SQL database. Part of this function involves ensuring as part of the data migration that data quality, integrity and completeness is maintained or improved and that duplicate entities are identified and removed.
Translating functional business requirements into well-developed custom solutions that leverage the Salesforce platform and provide intuitive user experiences. You will work closely with both JourneyBlazers architects and business analysts to deliver innovative functionality that pushes the boundaries of what is expected from user interfaces within the public sector. Our developers are not afraid of utilizing the Salesforce platform to accelerate solution development and are open to working with Salesforce resources to fill platform knowledge gaps. As a developer, you will be hands on with the development of new functionality and will be expected to not only deliver functionality to meet requirements, but also ensure solutions follow JourneyBlazers’s philosophy of human centered design and intuitive user experiences. JourneyBlazers developers are committed to continuously learning and aren’t afraid of solving a challenging problem with self-motivation and determination.
Responsibilities:
- Extract, Transform & Load into relational model structures of transactional databases
- Implement transformations, mappings, sessions, workflows, and business rules as per requirements
- Automate exception reporting by parsing logs
- Create necessary documentation and update the project documentation
- Root Cause analysis for ETL job failures/Data issues raised by business.
Required Skills:
- 5+ years experience with Data migrations, data conversions, ETL processesBusiness process analysis
- Previous support for large-scale conversion efforts
Preferred Skills:
- Experience with data migration tools (Mulesoft, Pentaho, Informatica, SAP PI)
- Experience with development language such as Java, Python, JavaScript
- Experience with APIs
- Experience with Salesforce
- Bachelor’s Degree in Computer Science, Business Information Systems, Information Technology or other relevant domain, or equivalent combination of education and experience
Employment Type: Full-time, Remote
Benefits:
- Competitive salary and bonuses
- 100% coverage for Medical, Dental, and Vision Care
- 20 days Paid Time Off (PTO)
- 9 Paid Holidays
- Visa sponsorship