The Role
Leads hands-on Salesforce data migration execution, including source-to-target mapping, ETL, SQL and SOQL querying, data profiling, test loads, validation, reconciliation, defect resolution, cutover, and documentation. Develops scripts and automation using Python, Shell, PowerShell, or Apex, configures migration tools across Salesforce and enterprise systems, and applies data quality, security, governance, and compliance practices.
Summary Generated by Built In
This experienced, hands-on consultant supports the Technical Data Architect and leads execution across mapping, ETL, validation, test loads, defect resolution, cutover, and documentation. The role partners with Salesforce, integration, business, ERP, and database teams while using automation and AI-enabled tools to improve delivery quality and
efficiency.
Responsibilities
- Execute extraction, transformation, loading, validation, and reconciliation activities within the architect-defined migration strategy.
- Build and maintain field-level source-to-target mappings, transformation rules, picklist mappings, value conversions, and relationship logic.
- Write and tune SQL and SOQL queries for profiling, migration, validation, exception analysis, and reconciliation.
- Configure and run ETL jobs across Salesforce, ERP platforms, relational databases, and other external systems.
- Develop scripts in Python, Shell, PowerShell, Apex, or similar languages for cleansing, transformations, automation, and quality controls.
- Profile source data to identify duplicates, missing values, invalid formats, gaps, and design-level risks.
- Run iterative test loads and mock migrations, then track data defects and mismatches through resolution.
- Troubleshoot validation failures, lookup errors, relationship issues, record locking, throughput, and load performance.
- Support cutover planning and execution, including sequencing, post-load validation, reconciliation, and businesssign-off.
- Document mappings, load procedures, scripts, controls, reconciliation e vidence, and repeatable runbooks.
- Apply data quality, security, governance, and compliance practices throughout the migration lifecycle.
- Use modern automation and AI tools to accelerate analysis while preserving human review and delivery accountability.
Qualifications
- 3+ years of direct experience in data migration, ETL, or data engineering roles.
- Hands-on experience producing detailed data mapping documents and transformation specifications.
- Strong SQL proficiency, including joins, aggregations, exception queries, and validation techniques.
- Working knowledge of SOQL and the Salesforce data model, including standard objects, relationships, and record
ownership. - Experience with Salesforce Data Loader, Bulk API, or comparable loading tools, plus an enterprise ETL platform.
- Experience supporting multiple migration cycles, including mock loads, reconciliation, defect resolution, and cutover.
- Scripting ability in Python, Shell, PowerShell, Apex, or a comparable language.
- Familiarity with Oracle, SQL Server, or other relational database platforms.
- Strong analytical judgment, attention to detail, documentation discipline, and delivery under tight deadlines.
- Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent experience.
- Preferred: Experience with AWS, Azure, or GCP.
- Preferred: Exposure to AI-enabled productivity, data quality, or engineering tools.
About UsPerficient is the global AI and technology consulting firm disrupting the traditional consulting model. Powered by our 7,000+ advisors, engineers, and designers, Perficient implements AI-first solutions that break conventions and deliver outcomes that matter. Proudly serving clients that represent the world’s most innovative brands, and in collaboration with our powerful technology partner ecosystem, we bring deep industry expertise and data-driven design to redefine how businesses run and succeed. Perficient is different. For real. Learn more at perficient.com.
Skills Required
- 3+ years of direct experience in data migration, ETL, or data engineering roles
- Experience producing detailed data mapping documents and transformation specifications
- Strong SQL proficiency, including joins, aggregations, exception queries, and validation techniques
- Working knowledge of SOQL and the Salesforce data model, including standard objects, relationships, and record ownership
- Experience with Salesforce Data Loader, Bulk API, or comparable loading tools, plus an enterprise ETL platform
- Experience supporting multiple migration cycles, including mock loads, reconciliation, defect resolution, and cutover
- Scripting ability in Python, Shell, PowerShell, Apex, or a comparable language
- Familiarity with Oracle, SQL Server, or other relational database platforms
- Strong analytical judgment, attention to detail, documentation discipline, and ability to deliver under tight deadlines
- Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent experience
- Experience with AWS, Azure, or GCP
- Exposure to AI-enabled productivity, data quality, or engineering tools
Perficient Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Perficient and has not been reviewed or approved by Perficient.
-
Retirement Support — Retirement offerings are positioned as robust, including a 401(k) with company match, an Employee Stock Purchase Plan, and an option for after-tax contributions (mega backdoor Roth). Eligibility details are described as clear for core benefits, supporting confidence in plan access timing.
-
Parental & Family Support — Parental benefits are described as structured, with paid maternity recovery time and paid parental leave for all new parents. Company-paid disability coverage is also highlighted, strengthening the overall family support posture.
-
Fair & Transparent Compensation — Compensation is characterized as generally market-aligned for a portion of roles, with examples of pay being viewed as fair or decent in certain contexts (such as remote or region-specific situations). Variable pay potential appears stronger in some tracks, improving perceived competitiveness for those roles.
Perficient Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Perficient is a leading global digital consultancy. We imagine, create, engineer, and run digital transformation solutions that help our clients exceed customers’ expectations, outpace competition, and grow their business. With unparalleled strategy, creative, and technology capabilities, we bring big thinking and innovative ideas, along with a practical approach to help the world’s largest enterprises and biggest brands succeed.
