Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Migration Engineer (Informatica/DBT)

NTT America

Req ID: 392719 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Data Migration Engineer (Informatica/DBT) to join our team remotely in the US. Role Overview o The Senior Data Migration Engineer serves as a hands-on technical contributor and delivery anchor, responsible for designing and implementing Python-based extract/load pipelines, dbt-based transformations, and Airflow-based orchestration for a large-scale migration from Informatica PowerCenter to a modern data stack. o This role requires deep expertise in converting complex Informatica workflows into Python, dbt, and Airflow, and the ability to deliver production-quality, functionally equivalent output at enterprise scale. Key Responsibilities:

  • Assess complex Informatica workflows including sessions, mappings, and parameterizations and translate them into equivalent Python EL scripts and dbt transformation models.
  • Develop and maintain Python EL pipelines to land high-volume data, including billion-row tables, into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc, and bulk export tools such as Oracle Data Pump and SQL Server BCP.
  • Design and develop dbt transformation models based on Informatica mapping logic, incorporating dbt best practices including model layering, macros, incremental strategies, and snapshot patterns.
  • Develop dbt-native tests as well as custom Python unit tests to validate transformation correctness and data quality.
  • Develop Airflow DAGs to orchestrate Python EL and dbt scripts end-to-end, producing output that is functionally equivalent to the source Informatica workflows.
  • Contribute to GitLab CI/CD pipeline for dbt and Airflow code, including lint gates, automated testing, and deployment to shared NAS.
  • Perform peer code reviews and provide constructive technical feedback to fellow engineers.
  • Troubleshoot performance issues and data discrepancies during SIT and UAT, including row-count reconciliation between source Oracle/SQL Server systems and the target warehouse.
  • Contribute to technical documentation, runbooks, and handover materials.
Required Skills & Experience:
  • 5+ years of Informatica PowerCenter experience - mappings, sessions, workflows, and parameterization
  • 3+ years of hands-on dbt Core experience - model layering, macros, tests, incremental materializations
  • Any number of years of Airflow experience - DAG authoring, task dependencies, and incorporation with scheduling tool
  • 5+ years of Python experience, including production use of parallelism and batch data processing
  • 5+ years of SQL experience - complex joins, window functions, aggregations across large datasets
  • Experience with Oracle Data Pump (expdp/impdp) or SQL Server BCP / BULK INSERT for high-volume data movement
Preferred:
  • Experience with SQLAlchemy, cx_Oracle, or pyodbc for Python-based database connectivity
  • Experience mentoring junior and mid-level engineers in offshore delivery models
#LI-NorthAmerica About NTT DATA NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers and application services. our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50 countries. We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D. Whenever possible, we hire locally to NTT DATA offices or client sites. This ensures we can provide timely and effective support tailored to each client’s needs. While many positions offer remote or hybrid work options, these arrangements are subject to change based on client requirements. For employees near an NTT DATA office or client site, in-office attendance may be required for meetings or events, depending on business needs. At NTT DATA, we are committed to staying flexible and meeting the evolving needs of both our clients and employees. NTT DATA recruiters will never ask for payment or banking information and will only use @nttdata.com, @nttdatafed.com and @talent.nttdataservices.com email addresses. If you are requested to provide payment or disclose banking information, please submit a contact us form, . NTT DATA endeavors to make accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at . This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here ( . If you'd like more information on your EEO rights under the law, please click here ( . For Pay Transparency information, please click here ( . NTT America

Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the Data Migration Engineer (Informatica/DBT) in Austin, TX vacancy
  • $87k - $161.3k

    Position Purpose: The Senior Data Engineer designs, builds, and supports scalable, reliable...  ...-on technical expert in Snowflake, DBT, Informatica, and SQL, and plays a key part in modernizing...  ..., and resource monitoringSupport migration and modernization of legacy data platforms... 
    Suggested
    Full time
    Part time
    H1b
    Work at office
    Remote work
    Flexible hours

    Centene

    Austin, TX
    3 days ago
  • Senior Data Engineer Anywhere Type: Permanent Category: Data Industry...  ...transformation layers, migrate legacy SQL views and user-maintained...  ...into versioned, tested dbt models with lineage, and define...  ...tool such as Fivetran, Airbyte, Informatica, or Matillion and one... 
    Suggested
    Hourly pay
    Permanent employment
    Full time
    Local area
    Remote work

    Eliassen Group

    Austin, TX
    3 days ago
  • $25.48 - $63.65 per hour

    Job Description The Data Migration Engineer II is responsible for designing, building, testing, and executing data migration solutions that support Oracle Health implementation and interface projects. As part of the Data Management and Migration Delivery Team , this role... 
    Suggested
    Hourly pay
    Contract work
    Temporary work
    Local area
    Flexible hours

    Oracle

    Austin, TX
    3 days ago
  •  ...Employment Type: Full TimeCompany: SRI Tech SolutionsJob Title: Data Engineer (Snowflake & Python)- DBTLocation: Day 1 Sunnyvale, CA or...  ...Exposure to machine learning pipelines and AI workflows is a plus. DBT is a plus on top of thisSRI Tech Solutions is an equal opportunity... 
    Suggested
    Full time

    SRI Tech

    Austin, TX
    5 days ago
  • Database Migration EngineerLocation: Remote, aligned to EST working hoursEmployment Type: Project...  ...are seeking a Senior Database Migration Engineer to support the development of an AI-...  ...validate conversion outcomes, and ensure data integrity throughout the migration lifecycle... 
    Suggested
    Local area
    Remote work
    Flexible hours

    Slalom

    Austin, TX
    3 days ago
  • $88k - $122k

     ...we co-create custom software, data, AI, and cloud solutions with...  ....Our Data Architecture & Engineering team sees data as the foundation...  ...include Spark, Kafka, Airflow, dbt, Dagster, Azure Data Factory,...  ...legacy data environments or migrating workloads to cloud platforms.... 
    Temporary work
    Work at office
    Local area

    Slalom

    Austin, TX
    5 days ago
  •  ...Systems Analyst 3 Title/Level: Systems Analyst 3 Category: Applications/Software Development Full Time Seeking a Cloud Data Migration Engineer with hands-on experience migrating Oracle workloads to AWS using AWS DMS, supporting full-load, CDC, and real-time streaming... 
    Full time

    CLOUDSCOUTS SOFTWARE SOLUTIONS LLC

    Austin, TX
    3 days ago
  •  ...Job Description Job Description Senior Informatica ETL/Data Engineer (PowerCenter, Snowflake & Oracle) Total Required Experience in Years...  ...change-management processes. Large-scale data migration and integration experience. Cloud-based ETL/ELT implementation... 
    Remote work

    Siritech Solutions Corp

    Austin, TX
    5 days ago
  •  ...Strategy, Experience & Design, Engineering and Managed Services. We...  ...Endless possibilities.As a Senior Data Engineer, AI & Agents, you...  ...datasets, performing lakehouse migrations, and onboarding new data...  ...with pipeline orchestration (dbt, Apache Airflow, or Databricks... 
    Contract work

    Appnovation

    Austin, TX
    3 days ago
  • $137.7k - $229.5k

     ...Summary Our Deloitte AI & Engineering team works to transform...  ...innovation.Work You’ll DoAs a Lead Data Engineer II on the team, you...  ...integration layer and data migration workstreams across...  ...Data Import (SDI) pipeline in Informatica for migration of legacy data... 
    Local area

    Deloitte

    Austin, TX
    2 days ago
  •  ...JOB SUMMARYThe Central Health System's Data Engineer is responsible for designing, developing...  ...ETL pipelines using Azure Data Factory, dbt, Python, and Snowflake.• Build and optimize...  ...failures.Cloud Modernization & Platform Migration:• Participate in the assessment and... 
    Full time

    Central Health

    Austin, TX
    3 days ago
  • Associate Data Engineer Austin, Texas, United States Who We Are MAP | WPP Enterprise Solutions...  ...best practices in cloud data architecture, migrations, and data management. Who Are You Going...  ...) and modern data stack tools (e.g., dbt, Airflow, BigQuery, or Snowflake) through... 
    Internship

    VMLY&R

    Austin, TX
    3 days ago
  • $169.13k - $281.81k

     ...to apply today.Job OverviewThe VPII, Data Engineering Manager will lead a team and provide the...  ..., batch modernization, and migration of legacy workloads to the Data Foundations...  ...inconsistent and legacy patterns across Informatica, SQL Server and stored procedures, .NET... 
    Full time
    Work from home

    LPL Financial

    Austin, TX
    2 days ago
  •  ...scale its next generation of data, analytics, and AI...  ...the Analytical Data Platform Engineering team plays a critical role in...  ...initiatives, including cloud migration, AI enablement, and modernization...  ...experience with technologies such as Informatica, IDMC, BigQuery, Java,... 
    Work at office

    Forge Global

    Austin, TX
    4 days ago
  •  ...scale its next generation of data, analytics, and AI...  ...the Analytical Data Platform Engineering team plays a critical role in...  ...initiatives, including cloud migration, AI enablement, and modernization...  ...experience with technologies such as Informatica, IDMC, BigQuery, Java,... 
    Full time
    Work at office

    The Charles Schwab Corporation

    Austin, TX
    3 days ago
  • We Are The beginning of a new Data & AI decade that will reshape...  ...WorkWe are seeking a Data Engineering, Management & Governance Manager...  ..., and data cataloging (e.g., Informatica, Alation, Collibra, or...  ...delivery using tools such as dbt, Apache Spark, Azure Data Factory... 
    Live in
    Work at office
    Local area

    Accenture

    Austin, TX
    1 day ago
  •  ...Job Description Job Description JD: NextGen PLM Data Migration is the end to end process of moving Item, BOM, Change, and File Vault data from Agile PLM into the new cloud based PLM platform. It covers base migration for full data load and delta migration for incremental... 

    TechDigital Corporation

    Austin, TX
    26 days ago
  •  ...Job Description Job Description Role - DevOps and Engineering - Data Center Engineer Duration - 6 months Location - Austin TX -...  ...Experience working on large-scale data centre builds or migrations Familiarity with DCIM platforms (e.g. Sunbird, Nlyte, Schneider... 
    Work at office

    Talent Software Services, Inc.

    Austin, TX
    5 days ago
  •  ...you will partner with our internal Business stakeholders and Data Engineering team to design and develop data solutions for data science,...  ...developers, using best-in-class technologies including BigQuery and Informatica. You will lead the use case analysis, design, solutioning... 
    Full time

    The Charles Schwab Corporation

    Austin, TX
    1 day ago
  •  ...Location: Austin, TXCompany: Realtor.comData Engineer, SrLocation: Austin, TX, United...  ...TechnologyJob ID: 3314Apply NowDescriptionSenior Data Engineer — Marketing Technologies (CRM Marketing...  ...with Snowflake, Airflow, dbt, or similar data platformsHands-on experience... 
    Work at office
    Local area

    Realtor.com

    Austin, TX
    1 day ago
  • $150.1k - $225.1k

     ...name synonymous with entertainment excellence and creativity.Data Engineer II, JVMAustin, TXThe Data Engineering Team fuels real-time, intelligent...  ..., and monitoring of the data pipeline stackSupport migration efforts of our on-premises Kafka to new cloud technologiesPerform... 
    Remote work

    Sony Interactive Entertainment America

    Austin, TX
    2 days ago
  •  ...a name synonymous with entertainment excellence and creativity.Data Engineer PlayStation's Infrastructure Business Operations team is looking...  ...data platforms and tooling such as Snowflake, Databricks, dbt, and automated ETL/ELT pipelines. Strong analytical skills—you’... 

    Sony Interactive Entertainment America

    Austin, TX
    2 days ago
  •  ...this role, you will work closely with experienced engineers to design, implement, test, and operate cloud-native, data-driven services and applications across Q2’s...  ...architectureData Movement and Pipelines: Apache Airflow, dbt, KafkaData Warehouse: SnowflakeDatabases: SQL... 
    Full time
    Work experience placement
    Work visa

    Q2 Software

    Austin, TX
    5 days ago
  • Data EngineersJob#: 3057729Job Description:Data EngineerLocation: Austin, TX (Hybrid)...  ...professional engagement requires two senior data engineering professionals to accelerate the...  ...and production rollout of enterprise data migration utilities and analytical pipelines.... 

    Apex Systems

    Austin, TX
    3 days ago
  • $101.3k - $160k

     ...solutions that keep Amazon systems and data secure on behalf of our customers. We leverage...  ..., developers, Business Intelligence Engineers to explore new data sources and deliver...  ...EMR- Experience with any ETL tool like, Informatica, ODI, SSIS, BODI, Datastage, etc.Amazon... 
    Flexible hours

    Amazon

    Austin, TX
    16 hours ago
  •  ...together, we’ll advance your career.THE ROLE:AMD is seeking a Staff Data Engineer within the Marketing Analytics team to build and operationalize...  ...model deployment and retraining. Experience with tools such as dbt or Airflow is a plus.Experience designing canonical data models... 
    Immediate start

    AMD

    Austin, TX
    5 days ago
  •  ...procedures, and triggers to meet business requirements and ensure data integrity.Data Modeling: Creating data models that represent...  ...be stored and accessed.Table partitions and archiving.Database Migration: Planning and executing database migrations ensuring data integrity... 

    Mindlance

    Austin, TX
    4 days ago
  • $141.8k - $173.3k

     ...volunteer time off + donation matchIMPACT YOU'LL MAKE:The Senior Data Engineer is responsible for writing data workflows according to design...  ...tools (Alation, Erwin, Collibra, Azure Purview, Infosphere, Informatica MDM.Experience in Test Driven Development concepts, methods,... 
    Full time
    Work experience placement
    Remote work

    Boeing Employees Credit Union

    Austin, TX
    1 day ago
  •  ...About the role Teza's Data Platform team owns the data the firm trades on: every...  ...scheduled jobs: run by cron today, actively migrating to Apache Airflow ~ Alternative data...  ...hands-on position on a small team of data engineers with growth potential. The firm is... 
    Full time
    Internship
    Work at office
    Flexible hours

    teza-technologies

    Austin, TX
    9 days ago
  •  ...Job Description Job Description Title: Informatica/ETL Data Engineer Location: Hybrid - Austin, Texas - within a 50-mile radius of Austin Texas Health & Human Services Commission (HHSC) has issued a request for an Informatica/ETL Data Engineer (Job ID... 

    Expert In Recruitment Solutions

    Austin, TX
    5 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Migration Engineer (Informatica/DBT). Be the first to apply!