Title
: Data Migration Engineer – SQL Server to Snowflake & Matillion for a
Finance Data Platform
Location
: Nashville TN
Duration
: Long Term
1.
Business Engagement & Current-State Understanding
Meet
with business stakeholders to understand how they currently use the system,
including day-to-day workflows, reports, and decision-making processes.
Document
current business use cases, dependencies, and expectations from the data
platform.
Act as
a liaison between business users and the technical team to ensure requirements
are clearly understood and translated.
2. Data
Feed Assessment & Gap Analysis
Review
existing data feeds currently available in Snowflake (e.g., QuickBooks,
NetSuite).
Identify
missing or incomplete data feeds required to support business workflows.
Perform
gap analysis between the current environment and Snowflake to determine
additional ingestion or transformation needs.
Define
requirements for building or enhancing data feeds to close identified gaps.
3. Data
Object & Logic Replication
Analyze
existing database objects such as stored procedures, views, and transformations
used in the source environment.
Ensure
equivalent logic is replicated in Snowflake with consistent behavior.
Validate
record counts, data accuracy, and output consistency between source and
Snowflake environments.
Support
testing and reconciliation efforts to ensure parity during migration.
4.
Migration Support & Collaboration
Work
closely with the core engineering and data teams throughout the migration
process.
Help
ensure a smooth transition from the legacy environment to Snowflake with
minimal disruption to business users.
5.
Project Enablement & Knowledge Transfer
Document
findings, assumptions, and decisions to support long-term maintainability.
Assist
in knowledge transfer to internal teams to ensure post-migration
self-sufficiency.
Support
adoption by ensuring business users are confident in the Snowflake-based
solution.
Required
Skills & Experience
Strong
experience with Snowflake for data storage, querying, and validation
Hands-on
experience with SQL Server (on-prem, preferably SQL Server 2016)
Advanced
SQL skills, including stored procedures and views
Experience
rebuilding and migrating data pipelines (not just lift-and-shift)
ETL
& Data Integration
Hands-on
experience with Matillion (mandatory)
Experience
building and maintaining ETL pipelines into Snowflake
Ability
to identify missing data feeds and build new integrations
Experience
working with multiple inbound data sources
Finance
& Source Systems (Preferred)
Experience
working with finance or accounting data
Familiarity
with NetSuite and/or QuickBooks is a strong plus
Understanding
of data accuracy, reconciliation, and reporting needs
Skills Required
- Strong experience with Snowflake for data storage, querying, and validation
- Hands-on experience with on-premises SQL Server, preferably SQL Server 2016
- Advanced SQL skills, including stored procedures and views
- Experience rebuilding and migrating data pipelines beyond lift-and-shift migrations
- Hands-on experience with Matillion
- Experience building and maintaining ETL pipelines into Snowflake
- Ability to identify missing data feeds and build new integrations
- Experience working with multiple inbound data sources
- Experience working with finance or accounting data
- Familiarity with NetSuite and/or QuickBooks
- Understanding of data accuracy, reconciliation, and reporting needs
What We Do
KANINI is a digital transformation enabler, providing cutting-edge software services and solutions that help enterprises drive innovation and business growth. We create impeccable customer experiences through thoughtfully designed digital solutions that help improve our customer’s efficiency, scale, and revenues. We specialize in Product Engineering, Data Analytics & AI, and ServiceNow consultation and implementation. We focus on empowering Banking & Financial Services, Healthcare, Manufacturing, and a few other industries to leverage new-age technologies and solutions by implementing agile development practices and a global delivery framework. We build technology that puts humans first - in line with our core operating principle that technology is for people, not the other way around. The result is happier clients, partners, and employees. We do all this by balancing our customers’ needs with our people’s aspirations, always putting humans first. It means: * We prioritize each individual’s personal goals. * We value relationships more than profits. * We treat our clients as partners. Our people come to work because it makes them happy. They smile more often. They love getting better at what they do. And our offices become a second home. Even as they spend more time away from it. If you think all this is just as important to you, bring us your Energy, Intellect and Integrity. We’ll show you a happier way to work
.png)
