AWS Data Migration Architect

About Us:

LTM is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700+ clients, LTM brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by nearly 90,000 talented and entrepreneurial professionals across more than 30 countries, LTM a Larsen & Toubro Group company combines the industry-acclaimed strengths of erstwhile Larsen and Toubro Infotech and Mindtree in solving the most complex business challenges and delivering transformation at scale. For more information, please visit

Title: AWS Data Migration Architect

Location: Irving, Tx (Remote)

  1. This role does not offer have Independent Authorization to work in the United States.
  2. The client is a banking client they have few obligations like -- trading restrictions, including the requirement to disclose brokerage accounts and trading activities and, if necessary, close certain accounts (for example, Robinhood). Kindly let me know If that ok with you.

Key Responsibilities

  • Design and execute migrations of relational databases (Oracle, SQL Server, PostgreSQL) to AWS (Aurora PostgreSQL, RDS, ODB@AWS).
  • Perform schema and PL/SQL conversion/refactoring; plan and run migration waves (assessment cutover validation tuning).
  • Produce targetstate data models, migration runbooks, ADRs, and guidance for application teams.
  • Ensure migrated databases meet security and compliance requirements (leastprivilege IAM, KMS encryption at rest/in transit).

Must Have

  • Relational databases (Level 400): Deep handson with at least two of Oracle, SQL Server, PostgreSQL; advanced SQL and PL/SQL.
  • Database migration to AWS (Level 300400): Proven delivery migrating production databases to Aurora PostgreSQL / RDS, using AWS DMS and SCT (Schema Conversion Tool).
  • Core AWS data stores (Level 300): RDS / Aurora PostgreSQL, S3, IAM, KMS.

Should Have

  • Programming: Python for data processing and migration automation.
  • PL/SQL conversion at scale (Oracle PostgreSQL) and heterogeneous migration experience.
  • ODB@AWS familiarity.
  • Financialservices / regulatedenterprise delivery (PCIDSS / SOC2 awareness).
  • IaC: Terraform. (CDK not required.)
  • Agile / Jira (Level 200): Manage own user stories within the sprint.
  • Nice to Have
  • Agentic AI / Amazon Bedrock for data accelerators (code analysis/conversion, datadomain tagging) differentiator, not a gate.
  • Datalake / lakehouse exposure (Glue, Lake Formation, Athena, Redshift).
  • Legacy source familiarity (Exadata, Sybase, DB2, mainframe).
  • GenAI coding assistants (Q Developer, Kiro).
  • AWS certifications: Database Specialty or Solutions Architect (Associate/Pro).

Benefits/perks listed below may vary depending on the nature of your employment with LTM (LTIM):

Benefits and Perks:

  • Medical Plan Covering Medical, Dental, Vision
  • Term and Long-Term Disability Coverage
  • Plan with Company match.
  • Insurance
  • Time, Sick Leave, Paid Holidays
  • Paternity and Maternity Leave

The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.

Disclaimer: The compensation and benefits information provided herein is accurate as of the date of this posting.

LTM is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.

Safe return to office:

In order to comply with LTM s company COVID-19 vaccine mandate, candidates must be able to provide proof of full vaccination against COVID-19 before or by the date of hire. Alternatively, one may submit a request for reasonable accommodation from LTM s COVID-19 vaccination mandate for approval, in accordance with applicable state and federal law, by the date of hire. Any request is subject to review through LTM s applicable processes.

Back to blog

Other Jobs To Apply

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...