Senior Data Architect

• Liaison with business SME’s to understand Data Migration requirements from source (SAP) to destination (Salesforce and AWS Cloud).
• Work with clients to gain access to their source data systems.
• Understand basic database schemas of source and target, create data model.
• Work with technical SME’s in creating data mapping between source data and target systems.
• Prepare data migration plans including migration risk, milestones, quality and business sign-off details.
• Understand and define data retention rules, transformation rules required to map to target system.
• Design, solution and implement data architecture and ETL for data migration platform.
• Design data archival process and understand integrated system to ensure data is available in required format.
• Define data reconciliation process to ensure required data is migrated to target system
• Review the work packages developed by team to deliverables are meeting customer requirements.
• Perform multiple “Data Rehearsals” with the full data set to flush out configuration problems well before go-live.
• Create technical documentation for all steps required for data migration efforts.
• Support go-live effort including evenings and weekends.

Technical Skills

• 10+ experience in data analytics, ETL and data migration tools.
• Experience is design and development of ETL process using tools like Informatica and AWS ETL tools like AWS S3, Glue, Athena, AWS Aurora my SQL, etc.
• Experience in designing data migration solution, archival process and reconciliation.
• Experience with data quality checks, data de-duplication and data validation processes.
• Perform data migration audit, reconciliation and exception reporting.
• Experience in handling data migration to Salesforce is preferred
• Deep knowledge with SQL language.
• Exposure to deployment/configuration tools – GitHub, DevOps and pipelines
• Proven ability to communicate with functional business users and technical database administrators.
• Strong communication skills, both written and verbal.