EY

Senior Data Migration Factory Specialist

EY

full-time

Posted on:

Location Type: Office

Location: Chennai • 🇮🇳 India

Visit company website
AI Apply
Apply

Job Level

Senior

Tech Stack

Amazon RedshiftAWSCloudETLInformatica

About the role

  • Responsible for designing, developing, and executing large-scale data migration factory and ETL build using Informatica and AWS services within a Data Migration Factory framework.
  • Refine the conceptual design for data migration, finalize tech architecture for Data migration factory (technologies / tools for ETL)
  • Alignment on infrastructure and readiness, services installations
  • Recommend appropriate method for on-prem/cloud connections and pipeline configurations
  • Define process for source data extraction into staging area
  • Design and implement scalable ETL/ELT workflows using Informatica PowerCenter/IDMC.
  • Build and configuration for data factory (infrastructure, connectivity, etc.)
  • Develop migration strategies for structured and unstructured data across multiple source and target systems.
  • Utilize AWS services (S3, Glue, Redshift, Lambda) for data storage, transformation, and orchestration.
  • Ensure data quality, integrity, and compliance during migration.
  • Collaborate with architecture and business teams to define migration patterns and reusable components.

Requirements

  • Strong experience in Informatica ETL tools and AWS cloud ecosystem.
  • Expertise in data mapping, transformation, and validation.
  • Knowledge of data security, encryption, and compliance standards.
  • Hands-on experience with performance tuning and error handling in large-scale migrations.
  • Understanding the Banking domain including core and non-core banking terminologies.
  • At-least 7+ years’ experience is required.
  • Client facing skills and proven ability in effective planning, executing and problem-solving
  • Excellent communication, inter-personal, and teamworking skills
  • Multi-tasking attitude, flexible with ability to change priorities quickly
  • Methodical approach, logical thinking, and ability to plan work and meet deadlines
  • Accuracy and attention to details
  • Written and verbal communication skills
  • Ability to plan resource requirements from high level specifications
Benefits
  • Support, coaching and feedback from some of the most engaging colleagues around
  • Opportunities to develop new skills and progress your career
  • The freedom and flexibility to handle your role in a way that’s right for you

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
InformaticaETLELTdata migrationdata mappingdata transformationdata validationperformance tuningerror handlingdata quality
Soft skills
client facing skillsplanningexecutingproblem-solvingcommunicationinterpersonal skillsteamworkingmulti-taskingflexibilityattention to detail