3 days onsite each week, must be local and under 60 mins
Need valid LinkedIn, 10/10 comms, Last 4 of SSN and MM/DD
Possible CTH role
this is more of a SQL Data Analyst role with some BA skills and NOT a data warehouse role)
They Will Ask About Migration And Conversion
SQL questions
Need Some Business Analysis Skills
- Data quality
- Look at data to see if they want to convert all the data.
- How many distinct values. Maybe we don’t need all of them.
- The project is a migration from mainframe to another tool.
- This role will help with a data migration.
- Look at data on mainframe, data quality, opportunities for improvement.
- Business rules, to convert data
- Extract data
- Data validation
- Query the source and target
- Run validations to make sure data was moved properly
- Reconciliation
- Strong SQL, need to be able to write SQL
- Azure SQL
- Talk to business, about their findings, asking for guidance
- Convert data from one system to another. It’s not determined yet.
- Staging data in Azure/Cloud.