ICF yra pasaulinė konsultacijų ir technologijų paslaugų įmonė, dirbanti su valdžios institucijų ir komercinio sektoriaus klientais sprendžiant sudėtingus federalinių IT sistemų modernizavimo, energetikos ir komunalinių paslaugų, visuomenės sveikatos, atsparumo klimato kaitai, nelaimių valdymo ir transporto iššūkius. Įmonės komandos derina duomenis ir analitiką, dirbtinį intelektą, kibernetinį saugumą bei konkrečių sektorių žinias, kad kurtų ir įgyvendintų praktinius sprendimus. ICF taip pat daug dėmesio skiria įmonių pilietiškumui ir tvarumui, įskaitant iniciatyvas, remiančias socialines programas, bendruomenių plėtrą ir mažesnių emisijų ateitį. Įmonė veikia tarptautiniu mastu ir turi reikšmingą veiklą Europoje – Belgijoje, Ispanijoje ir Jungtinėje Karalystėje.
Cloud Data Migration Specialist – Salesforce
Lead Salesforce data migrations for ICF’s GrantLens grants management platform, onboarding federal grant programs through ETL, SQL, validation, and reconciliation.
Aprašymas
- Assess source data and lead migrations from planning and extraction through transformation, loading, and validation.
- Review source and target data models, structures, relationships, dependencies, and data quality.
- Create and maintain source-to-target mapping documents, data dictionaries, and transformation rules.
- Use ETL tools, SQL, and Salesforce migration utilities to cleanse, transform, and load data.
- Manage Salesforce data dependencies, including object relationships, external IDs, record ownership, and parent-child links.
- Run mock conversions, troubleshoot issues, and improve migration processes ahead of production deployment.
- Perform production migrations, reconcile records, and validate data after migration.
- Work with business stakeholders to verify migrated data, resolve discrepancies, and secure formal sign-off.
- Keep migration documentation, runbooks, validation reports, and issue logs up to date.
- Help onboard federal grant programs to GrantLens, a large-scale Salesforce grants management application.
Reikalavimai
- Bring at least 3 years of experience in enterprise data migration, data conversion, ETL development, or data integration.
- Have at least 3 years of experience with data modeling, relational databases, and complex data relationships.
- Have at least 3 years of experience planning and carrying out end-to-end migrations into Salesforce.
- Have at least 2 years of experience with Salesforce Data Loader, Salesforce Inspector, Workbench, Salesforce APIs, or similar migration utilities.
- Have at least 2 years of experience with ETL tools for data extraction, transformation, cleansing, and loading.
- Have at least 2 years of SQL experience, including queries and scripts for profiling, transformation, and validation.
- Have at least 2 years of experience creating source-to-target mappings and managing data quality, reconciliation, and migration exceptions.
- Have experience with Salesforce Public Sector Solutions, Service Cloud, or other enterprise Salesforce applications.
- Understand Salesforce data architecture, including standard and custom objects, lookup and master-detail relationships, and external IDs.
- Have experience with ETL platforms such as Informatica, Talend, MuleSoft, Azure Data Factory, or SSIS.
- Have experience with Salesforce Bulk API and large-volume data migration methods.
- Have experience automating migration, validation, and reconciliation processes.
- Have experience preparing migration cutover plans, rollback procedures, and production runbooks.
- Have experience supporting federal government or other complex enterprise data migration initiatives.
- Be familiar with FISMA, FedRAMP, and NIST security and compliance requirements.
- Hold relevant Salesforce or data management certifications.
Privalumai
- ICF is an equal opportunity employer.
- Reasonable accommodations are available for disabled veterans, people with disabilities, and individuals with sincerely held religious beliefs.
- Benefits information is provided under the Transparency in (Benefits) Coverage Act.