Report this Job
Position- Data Migration Analyst
Duration-Full Time
Location- St of KS or Milford OH
JD
Required skills:
- Required 2 years hands-on experience with AWS Glue
- Required 2 years hands-on experience writing ETL scripts in Python and Scala
- Proficient in writing SQL queries
Preferred skills:
- AWS Certification in Associate or Professional Level in one of the Developer/Solution Architect
- PostrgresSql
Design data transformation workflows using AWS Glue Studio environment.
Design AWS Glue Data Catalog that is a highly scalable collection of tables organized into target state system.
Understand legacy system and business requirements by discussing with the legacy system staff/users.
Develop migration strategies, understand source data, perform data quality analysis on source data; develop cleansing scripts to remove or replace invalid/bad data based on the output of source data profiling.
Prepare data mapping specification document to map data from legacy system to new system.
Develop migration programs and write software code to load data into target system; unit testing of migration programs; testing the migrated data by creating and executing validation and verification scenarios.
Execute migration test cycles to test all the stand-alone migration programs and to test the migrated data and resolve any issues before the go live cycle. Ensure software programming, reviews and tests are performed as per standards.
Log, analyze and fix defects using the defect management processes.
Thanks and Regards,
Pallavi Verma
IDC Technologies, Inc
Cell : 408-359-1188/ 302-515-2910
Email : pallavi.verma@idctechnologies.com
IDC Technologies
