Data Migration Consultant - Alteryx

Armanino India Llp Data Migration Specialist

At Armanino, you determine your career path. This means it's possible to pursue challenges you are passionate about, in industries you care about.

Armanino (USA) is proud to be among the top 20 Largest Firms in the United States of America and one of the Best Places to Work. Armanino (USA) has more than 2500 employees across the USA and more than 20 offices in different states of the USA. We have a community of resources that are ready and willing to support your ideas, build your skills and expand your professional network. We want you to integrate all aspects of your life with your career. At Armanino, we know you don't check-out of life when you check-in at work. That's why we've created a unique work environment where your passions, work, and family & friends can overlap. We want to help you achieve growth by giving you access to a network of smart and supportive people, willing to listen to your ideas.

This open position is for Armanino India LLP, which is located in India. Armanino India LLP is a fully owned subsidiary of Armanino (USA).

Responsibilities

• Analyze source systems, data structures, and data quality to support migration planning and mapping.
• Design and build Alteryx Designer workflows for extracting, transforming, cleansing, and validating data.
• Configure and manage ODBC/JDBC connections, file-based integrations, and REST API interactions for data extraction and loading.
• Write and optimize SQL queries for profiling, transformation, and validation tasks.
• Load data into target environments such as Microsoft Dynamics 365 and other ERP/CRM platforms using available APIs, staging tables, or native connectors.
• Implement data quality checks, reference/master/transactional data handling, and reconciliation processes.
• Conduct unit testing, system testing, error handling, and performance tuning of migration pipelines.
• Participate in mock migrations, cutover rehearsals, and go-live/hypercare activities.
• Investigate and resolve data issues, discrepancies, and workflow failures.
• Communicate progress, risks, and blockers to project managers and technical leads.
• Produce documentation for workflows, data mappings, migration procedures, and technical designs.
• Contribute to internal best practices, tooling improvements, and migration accelerators.

Requirements

• 3–5 years of experience in data migration, ETL, or data integration roles.
• 2+ years of hands-on experience with Alteryx Designer (building complex, parameterized workflows).
• Strong experience writing and tuning SQL queries (joins, aggregations, indexing concepts).
• Working knowledge of REST/JSON APIs (authentication, pagination, payload structures).
• Experience configuring ODBC/JDBC connections and working with relational databases.
• Solid understanding of data migration concepts: mapping, data cleansing, validation, reconciliation, staging, cutover.
• Exposure to ERP/CRM systems (preferably Dynamics 365, but others acceptable).
• Experience working in a consulting, project-based, or implementation environment.
• Strong communication skills and the ability to interact professionally with cross-functional colleagues and client stakeholders.
• Ability to work independently in a fully remote, distributed team environment.
• Familiarity with Microsoft Dynamics 365 data models, entities, or Data Management Framework.
• Experience across multiple ERP/CRM systems or legacy platforms.
• Alteryx certification(s), Microsoft certifications, or similar credentials.
• Experience with Synapse, Azure Data Factory, and/or Excel PowerQuery
• Experience contributing to reusable templates, frameworks, or automation assets.

Armanino provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Armanino complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Armanino expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Armanino employees to perform their job duties may result in discipline up to and including discharge.