{"id":46245,"date":"2023-06-08T11:19:38","date_gmt":"2023-06-08T11:19:38","guid":{"rendered":"https:\/\/www.bitwiseglobal.com\/en-us\/?post_type=case-study&#038;p=46245"},"modified":"2026-02-02T07:46:02","modified_gmt":"2026-02-02T07:46:02","slug":"migrate-legacy-informatica-etl-code-to-aws-glue","status":"publish","type":"case-study","link":"https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/migrate-legacy-informatica-etl-code-to-aws-glue\/","title":{"rendered":"Migrate Legacy Informatica ETL Code to AWS Glue"},"content":{"rendered":"","protected":false},"excerpt":{"rendered":"<p>A national full-service restaurant company needed to migrate its ETL from on-premise Informatica application to AWS Glue to maintain and enhance its EDW, reporting and analytics applications in order to provide accurate and timely data to users and ensure data availability for Reporting and BI functions.<\/p>\n","protected":false},"author":6,"featured_media":52416,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_crdt_document":"","footnotes":""},"categories":[273],"tags":[447],"class_list":["post-46245","case-study","type-case-study","status-publish","format-standard","has-post-thumbnail","hentry","category-etl-migration","tag-restaurants"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.0 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Migrate Legacy Informatica ETL Code to AWS Glue | Bitwise<\/title>\n<meta name=\"description\" content=\"A national full-service restaurant needed to Migrate Legacy Informatica ETL Code to AWS Glue to to provide accurate and timely data to users and ensure data availability for Reporting and BI functions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/migrate-legacy-informatica-etl-code-to-aws-glue\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrate Legacy Informatica ETL Code to AWS Glue\" \/>\n<meta property=\"og:description\" content=\"A national full-service restaurant needed to Migrate Legacy Informatica ETL Code to AWS Glue to to provide accurate and timely data to users and ensure data availability for Reporting and BI functions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/migrate-legacy-informatica-etl-code-to-aws-glue\/\" \/>\n<meta property=\"og:site_name\" content=\"Bitwise\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-02T07:46:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn2.bitwiseglobal.com\/bwglobalprod-cdn\/2023\/06\/Migrate-Legacy-Informatica-ETL-Code-to-AWS-Glue-2-1-1_11zon.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1170\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/case-study\\\/migrate-legacy-informatica-etl-code-to-aws-glue\\\/\",\"url\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/case-study\\\/migrate-legacy-informatica-etl-code-to-aws-glue\\\/\",\"name\":\"Migrate Legacy Informatica ETL Code to AWS Glue | Bitwise\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/case-study\\\/migrate-legacy-informatica-etl-code-to-aws-glue\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/case-study\\\/migrate-legacy-informatica-etl-code-to-aws-glue\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn2.bitwiseglobal.com\\\/bwglobalprod-cdn\\\/2023\\\/06\\\/Migrate-Legacy-Informatica-ETL-Code-to-AWS-Glue-2-1-1_11zon.webp\",\"datePublished\":\"2023-06-08T11:19:38+00:00\",\"dateModified\":\"2026-02-02T07:46:02+00:00\",\"description\":\"A national full-service restaurant needed to Migrate Legacy Informatica ETL Code to AWS Glue to to provide accurate and timely data to users and ensure data availability for Reporting and BI functions.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/case-study\\\/migrate-legacy-informatica-etl-code-to-aws-glue\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/case-study\\\/migrate-legacy-informatica-etl-code-to-aws-glue\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/case-study\\\/migrate-legacy-informatica-etl-code-to-aws-glue\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cdn2.bitwiseglobal.com\\\/bwglobalprod-cdn\\\/2023\\\/06\\\/Migrate-Legacy-Informatica-ETL-Code-to-AWS-Glue-2-1-1_11zon.webp\",\"contentUrl\":\"https:\\\/\\\/cdn2.bitwiseglobal.com\\\/bwglobalprod-cdn\\\/2023\\\/06\\\/Migrate-Legacy-Informatica-ETL-Code-to-AWS-Glue-2-1-1_11zon.webp\",\"width\":1170,\"height\":500,\"caption\":\"Migrate-Legacy-Informatica-ETL-Code-to-AWS-Glue\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/case-study\\\/migrate-legacy-informatica-etl-code-to-aws-glue\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Case Studies\",\"item\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/case-study\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Migrate Legacy Informatica ETL Code to AWS Glue\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/#website\",\"url\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/\",\"name\":\"Bitwise\",\"description\":\"Technology Consulting and Data Management Services\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/#organization\",\"name\":\"Bitwise\",\"url\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/cdn2.bitwiseglobal.com\\\/bwglobalprod-cdn\\\/2022\\\/11\\\/cropped-header-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/cdn2.bitwiseglobal.com\\\/bwglobalprod-cdn\\\/2022\\\/11\\\/cropped-header-logo.jpg\",\"width\":226,\"height\":62,\"caption\":\"Bitwise\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bitwiseglobal.com\\\/en-us\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Migrate Legacy Informatica ETL Code to AWS Glue | Bitwise","description":"A national full-service restaurant needed to Migrate Legacy Informatica ETL Code to AWS Glue to to provide accurate and timely data to users and ensure data availability for Reporting and BI functions.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/migrate-legacy-informatica-etl-code-to-aws-glue\/","og_locale":"en_US","og_type":"article","og_title":"Migrate Legacy Informatica ETL Code to AWS Glue","og_description":"A national full-service restaurant needed to Migrate Legacy Informatica ETL Code to AWS Glue to to provide accurate and timely data to users and ensure data availability for Reporting and BI functions.","og_url":"https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/migrate-legacy-informatica-etl-code-to-aws-glue\/","og_site_name":"Bitwise","article_modified_time":"2026-02-02T07:46:02+00:00","og_image":[{"width":1170,"height":500,"url":"https:\/\/cdn2.bitwiseglobal.com\/bwglobalprod-cdn\/2023\/06\/Migrate-Legacy-Informatica-ETL-Code-to-AWS-Glue-2-1-1_11zon.webp","type":"image\/webp"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/migrate-legacy-informatica-etl-code-to-aws-glue\/","url":"https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/migrate-legacy-informatica-etl-code-to-aws-glue\/","name":"Migrate Legacy Informatica ETL Code to AWS Glue | Bitwise","isPartOf":{"@id":"https:\/\/www.bitwiseglobal.com\/en-us\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/migrate-legacy-informatica-etl-code-to-aws-glue\/#primaryimage"},"image":{"@id":"https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/migrate-legacy-informatica-etl-code-to-aws-glue\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn2.bitwiseglobal.com\/bwglobalprod-cdn\/2023\/06\/Migrate-Legacy-Informatica-ETL-Code-to-AWS-Glue-2-1-1_11zon.webp","datePublished":"2023-06-08T11:19:38+00:00","dateModified":"2026-02-02T07:46:02+00:00","description":"A national full-service restaurant needed to Migrate Legacy Informatica ETL Code to AWS Glue to to provide accurate and timely data to users and ensure data availability for Reporting and BI functions.","breadcrumb":{"@id":"https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/migrate-legacy-informatica-etl-code-to-aws-glue\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/migrate-legacy-informatica-etl-code-to-aws-glue\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/migrate-legacy-informatica-etl-code-to-aws-glue\/#primaryimage","url":"https:\/\/cdn2.bitwiseglobal.com\/bwglobalprod-cdn\/2023\/06\/Migrate-Legacy-Informatica-ETL-Code-to-AWS-Glue-2-1-1_11zon.webp","contentUrl":"https:\/\/cdn2.bitwiseglobal.com\/bwglobalprod-cdn\/2023\/06\/Migrate-Legacy-Informatica-ETL-Code-to-AWS-Glue-2-1-1_11zon.webp","width":1170,"height":500,"caption":"Migrate-Legacy-Informatica-ETL-Code-to-AWS-Glue"},{"@type":"BreadcrumbList","@id":"https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/migrate-legacy-informatica-etl-code-to-aws-glue\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bitwiseglobal.com\/en-us\/"},{"@type":"ListItem","position":2,"name":"Case Studies","item":"https:\/\/www.bitwiseglobal.com\/en-us\/case-study\/"},{"@type":"ListItem","position":3,"name":"Migrate Legacy Informatica ETL Code to AWS Glue"}]},{"@type":"WebSite","@id":"https:\/\/www.bitwiseglobal.com\/en-us\/#website","url":"https:\/\/www.bitwiseglobal.com\/en-us\/","name":"Bitwise","description":"Technology Consulting and Data Management Services","publisher":{"@id":"https:\/\/www.bitwiseglobal.com\/en-us\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bitwiseglobal.com\/en-us\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.bitwiseglobal.com\/en-us\/#organization","name":"Bitwise","url":"https:\/\/www.bitwiseglobal.com\/en-us\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bitwiseglobal.com\/en-us\/#\/schema\/logo\/image\/","url":"https:\/\/cdn2.bitwiseglobal.com\/bwglobalprod-cdn\/2022\/11\/cropped-header-logo.jpg","contentUrl":"https:\/\/cdn2.bitwiseglobal.com\/bwglobalprod-cdn\/2022\/11\/cropped-header-logo.jpg","width":226,"height":62,"caption":"Bitwise"},"image":{"@id":"https:\/\/www.bitwiseglobal.com\/en-us\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.bitwiseglobal.com\/en-us\/wp-json\/wp\/v2\/case-study\/46245","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bitwiseglobal.com\/en-us\/wp-json\/wp\/v2\/case-study"}],"about":[{"href":"https:\/\/www.bitwiseglobal.com\/en-us\/wp-json\/wp\/v2\/types\/case-study"}],"author":[{"embeddable":true,"href":"https:\/\/www.bitwiseglobal.com\/en-us\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bitwiseglobal.com\/en-us\/wp-json\/wp\/v2\/comments?post=46245"}],"version-history":[{"count":0,"href":"https:\/\/www.bitwiseglobal.com\/en-us\/wp-json\/wp\/v2\/case-study\/46245\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bitwiseglobal.com\/en-us\/wp-json\/wp\/v2\/media\/52416"}],"wp:attachment":[{"href":"https:\/\/www.bitwiseglobal.com\/en-us\/wp-json\/wp\/v2\/media?parent=46245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bitwiseglobal.com\/en-us\/wp-json\/wp\/v2\/categories?post=46245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bitwiseglobal.com\/en-us\/wp-json\/wp\/v2\/tags?post=46245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}