What are the responsibilities and job description for the Data Application Specialist Migrations position at NextPhase.ai?
Job Description
WHO WE ARE
NextPhase.ai is a boutique technology services provider helping organizations modernize Cloud and Data infrastructure. Our service portfolio complements our client teams with expertise, automation, and technology to deliver desired business outcomes. Nextphase.ai provides you with a dynamic and fun work environment and encourages you to use creative thinking to solve client challenges.
THE ROLE
We are looking for a data application specialist in a consulting capacity to support our clients with their data migration activities for large data sets. The individual will work with cross-functional teams and stakeholders across the organization. This is a hybrid role, the individual must work from the East Bay, CA office 4 days a week.
RESPONSIBILITIES
- Strong experience with PowerShell, C# .Net Console application, LINQ, SQL Server, CSVHelper module
- Familiarity with building performance-optimized .net Console applications to work with MS SQL Server databases
- Prior & strong experience in working with List, Objects, LINQ, Data Table, and Bulk processing of large datasets and performing CRUD database operation is a must
- Strong hold over dealing with CSV objects in .Net Console application is a must
- Familiarity with the creation of multithreaded applications, with SQL Locks and transactions
- Experience in creating PowerShell scripts for large SQL table creation or performing any scripting needs
- Experience in writing SSIS packages, Stored procedures, Generating Memory usage reports, Data Validation reports, and Schema validation reports is good to have
- Python scripting with “pyodbc”/ “SQL Alchemy”, “pandas”, and "CSV" module, and Informatica ETL Jobs Creation is good to have
- Must be willing to work from the office (East Bay, CA) Monday – Thursday
Pay Rate: $50/hr - $65/hr
Salary : $50 - $65