{"id":54229,"date":"2024-04-17T15:17:05","date_gmt":"2024-04-17T13:17:05","guid":{"rendered":"https:\/\/astek.pl\/competence-centers\/advanced-data-analytics\/data-integration-and-migration\/"},"modified":"2024-09-02T16:04:32","modified_gmt":"2024-09-02T14:04:32","slug":"data-integration-and-migration","status":"publish","type":"page","link":"https:\/\/astek.pl\/en\/competence-centers\/advanced-data-analytics\/data-integration-and-migration\/","title":{"rendered":"Data integration and migration"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.24.3″ _module_preset=”default” custom_padding=”0px||0px||true|false” global_colors_info=”{}”][et_pb_row _builder_version=”4.24.3″ _module_preset=”default” width_tablet=”90%” width_phone=”90%” width_last_edited=”on|tablet” custom_padding=”0px||19px||false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.24.3″ _module_preset=”default” global_colors_info=”{}”][et_pb_code _builder_version=”4.23.3″ _module_preset=”default” global_colors_info=”{}”]Home<\/a><\/span><\/span><\/pee>[\/et_pb_code][et_pb_text _builder_version=”4.24.3″ _module_preset=”default” text_text_color=”RGBA(255,255,255,0)” header_font=”|700|||||||” header_text_align=”center” header_font_size=”52px” header_line_height=”58px” header_2_font=”|700|||||||” header_2_text_align=”center” header_2_text_color=”#000000″ header_2_font_size=”38px” custom_margin=”||||false|false” custom_margin_tablet=”||42px||false|false” custom_margin_phone=”||42px||false|false” custom_margin_last_edited=”off|desktop” custom_padding=”||||false|false” custom_padding_tablet=”||0px||false|false” custom_padding_phone=”||0px||false|false” custom_padding_last_edited=”off|desktop” hover_enabled=”0″ header_font_size_tablet=”42px” header_font_size_phone=”42px” header_font_size_last_edited=”on|tablet” header_line_height_tablet=”48px” header_line_height_phone=”48px” header_line_height_last_edited=”on|tablet” header_2_text_align_tablet=”” header_2_text_align_phone=”center” header_2_text_align_last_edited=”on|phone” header_2_font_size_tablet=”38px” header_2_font_size_phone=”38px” header_2_font_size_last_edited=”on|phone” header_2_line_height_tablet=”” header_2_line_height_phone=”58px” header_2_line_height_last_edited=”on|phone” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

Data integration and migration<\/h2>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.24.3″ _module_preset=”default” custom_padding=”3rem||3rem||true|false” global_colors_info=”{}”][et_pb_row _builder_version=”4.24.3″ _module_preset=”default” width_tablet=”90%” width_phone=”90%” width_last_edited=”on|tablet” custom_padding=”0px||0px||true|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.24.3″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.24.3″ _module_preset=”default” text_font=”|300|||||||” text_text_color=”#000000″ text_font_size=”18px” text_line_height=”24px” header_text_color=”#FFFFFF” text_orientation=”center” custom_margin=”0px||16px||false|false” custom_padding=”0px||0px||true|false” hover_enabled=”0″ custom_css_free_form=”.strong{|| font-weight :600;||}” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

Client<\/strong>:\u00a0A leading payment service provider<\/span><\/p>\n

Industry<\/strong>:\u00a0Banking and Finance<\/span><\/p>\n

Competence center<\/strong>: Advanced Data Analytics<\/p>\n

Technologies<\/strong>: SQL, PL \/ SQL, JSON, PL\/SQL, REDMINE, GIT, ServiceDesk Plus<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.24.3″ _module_preset=”default” background_image=”https:\/\/astek.pl\/wp-content\/uploads\/2024\/04\/bckg-recomendation-1.png” background_position=”top_left” background_vertical_offset=”0%” custom_margin=”0px||||false|false” custom_padding=”100px||100px||false|false” global_colors_info=”{}”][et_pb_row use_custom_gutter=”on” gutter_width=”2″ make_equal=”on” _builder_version=”4.24.3″ _module_preset=”default” width_tablet=”” width_phone=”90%” width_last_edited=”on|phone” custom_padding=”0px||0px||true|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.24.3″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.24.3″ _module_preset=”default” text_text_color=”RGBA(255,255,255,0)” header_2_font=”|700|||||||” header_2_text_align=”center” header_2_text_color=”#FFFFFF” header_2_font_size=”38px” custom_margin=”19px||19px||false|false” custom_padding=”||||false|false” header_text_align_tablet=”center” header_text_align_phone=”center” header_text_align_last_edited=”on|tablet” header_2_text_align_tablet=”” header_2_text_align_phone=”center” header_2_text_align_last_edited=”on|phone” header_2_font_size_tablet=”38px” header_2_font_size_phone=”38px” header_2_font_size_last_edited=”on|phone” header_2_line_height_tablet=”” header_2_line_height_phone=”58px” header_2_line_height_last_edited=”on|phone” global_colors_info=”{}”]<\/p>\n

Project description<\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”4.24.3″ _module_preset=”default” text_font=”|300|||||||” text_text_color=”#FFFFFF” text_font_size=”18px” text_line_height=”23px” header_text_color=”#000000″ text_orientation=”center” custom_margin=”||50px||false|false” custom_padding=”||||false|false” hover_enabled=”0″ custom_css_main_element=”font-weight: 300;” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

Astek Polska implemented a migration project involving the integration of data from various client systems, while anonymizing the data. Aggregated information has been implemented in a system based on Oracle solutions.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.24.2″ _module_preset=”default” background_color=”#f3f3f3″ custom_padding=”50px||50px||true|false” global_colors_info=”{}”][et_pb_row column_structure=”2_5,3_5″ _builder_version=”4.24.3″ _module_preset=”default” custom_margin=”||||false|false” custom_padding=”||0px||false|false” global_colors_info=”{}”][et_pb_column type=”2_5″ _builder_version=”4.24.3″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.24.3″ _module_preset=”default” header_2_font=”|800|||||||” header_2_font_size=”38px” custom_margin=”0px|||30px|false|false” custom_margin_tablet=”|||0px|false|false” custom_margin_phone=”|||0px|false|false” custom_margin_last_edited=”on|tablet” custom_padding=”0px||0px||false|false” global_colors_info=”{}”]<\/p>\n

Other
Projects<\/h2>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_5″ disabled_on=”on|on|off” _builder_version=”4.24.3″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.24.3″ _module_preset=”default” width_tablet=”90%” width_phone=”90%” width_last_edited=”on|tablet” custom_padding=”0px||0px||false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.23.3″ _module_preset=”default” global_colors_info=”{}”][et_pb_tabs active_tab_background_color=”#f3f3f3″ inactive_tab_background_color=”#f3f3f3″ active_tab_text_color=”#009c43″ _builder_version=”4.24.3″ _module_preset=”default” tab_text_color=”#a4a4a4″ tab_font=”||||||||” background_color=”#f3f3f3″ custom_margin=”-60px||||false|false” custom_margin_tablet=”0px||||false|false” custom_margin_phone=”” custom_margin_last_edited=”on|tablet” custom_padding=”50px||50px||true|false” animation_direction=”right” hover_enabled=”0″ custom_css_main_element=”display:flex;||||” custom_css_after=”||” custom_css_free_form=”ul.et_pb_tabs_controls{|| background-color:#f3f3f3;|| width:100%;|| margin-top:70px;||}||@media all and (max-width: 980px) {||ul.et_pb_tabs_controls{|| background-color:#f3f3f3;|| \twidth:100%;||\t margin-top:0px;||\t}||}||||\/*||.et-pb-moved-slide{|| transform:translate(1000px);|| transition-duration:0s!important;||}*\/||” custom_css_tab=”width:100%;||font-weight:500!important;||border:none!important;||||||” custom_css_active_tab=”\t\topacity:1!important;||animation-name:fadeInOut,moveLeft300px!important;||\tanimation-duration:1s!important;||||” custom_css_tabs_content=” width:100%;” border_radii=”off||15px|15px|” border_width_all=”0px” global_colors_info=”{}” custom_css_main_element_last_edited=”on|tablet” custom_css_main_element_tablet=”display:block;” custom_css_main_element_phone=”display:block;” sticky_enabled=”0″][et_pb_tab title=”Data anonymization under RODO” _builder_version=”4.24.3″ _dynamic_attributes=”link_option_url” _module_preset=”default” body_font=”|300|||||||” body_text_align=”left” body_text_color=”#FFFFFF” body_font_size=”18px” tab_font_size=”22px” background_color=”#f3f3f3″ background_enable_color=”on” background_image=”https:\/\/astek.pl\/wp-content\/uploads\/2024\/04\/przemysl_projektowanie.jpg” background_enable_image=”on” position_origin_a=”center_center” custom_padding=”10%|50px|50px|50px|false|true” custom_padding_tablet=”10%|25px|50px|25px|false|true” custom_padding_phone=”10%|25px|50px|25px|false|true” custom_padding_last_edited=”on|tablet” link_option_url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjUyMDg2In19@” hover_enabled=”0″ custom_css_main_element=”border-radius:15px;||justify-content:center!important;||width:100%;||margin-left:50px;||animation: 3s linear 1s infinite running slidein!important;||” global_colors_info=”{}” custom_css_main_element_last_edited=”on|tablet” custom_css_main_element_tablet=”border-radius:15px;||justify-content:center!important;||width:100%;||animation: 3s linear 1s infinite running slidein!important;||” custom_css_main_element_phone=”border-radius:15px;||justify-content:center!important;||width:100%;||animation: 3s linear 1s infinite running slidein!important;||” sticky_enabled=”0″]<\/p>\n

Ubezpieczenia<\/span><\/p>\n

<\/span><\/p>\n

Data anonymization under RODO<\/span><\/strong><\/h3>\n

<\/span><\/p>\n

The goal of the project was to bring the client’s systems into compliance with the RODO directive regarding the deletion and anonymization of customer data. Our team was involved in: development and maintenance of the data warehouse, creation of analytical and operational reports, verification of the correctness of data exchange between systems, creation of extracts to other client systems and third-party partner systems.<\/span><\/p>\n

\"\"<\/span><\/p>\n

[\/et_pb_tab][et_pb_tab title=”Building an analytical platform” _builder_version=”4.24.3″ _dynamic_attributes=”link_option_url” _module_preset=”default” body_font=”|300|||||||” body_text_align=”left” body_text_color=”#FFFFFF” body_font_size=”18px” tab_font_size=”22px” background_color=”RGBA(255,255,255,0)” background_enable_color=”on” background_image=”https:\/\/astek.pl\/wp-content\/uploads\/2024\/04\/platforma-scaled-1.jpeg” background_enable_image=”on” position_origin_a=”center_center” custom_padding=”10%|50px|50px|50px|false|true” custom_padding_tablet=”10%|25px|50px|25px|false|true” custom_padding_phone=”10%|25px|50px|25px|false|true” custom_padding_last_edited=”on|tablet” link_option_url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjUyMDkwIn19@” hover_enabled=”0″ custom_css_main_element=”border-radius:15px;||justify-content:center!important;||height:410px;||margin-left:50px;||animation: 3s linear 1s infinite running slidein!important;||||” global_colors_info=”{}” custom_css_main_element_last_edited=”on|tablet” custom_css_main_element_tablet=”border-radius:15px;||justify-content:center!important;||height:410px;||animation: 3s linear 1s infinite running slidein!important;” custom_css_main_element_phone=”border-radius:15px;||justify-content:center!important;||height:410px;||animation: 3s linear 1s infinite running slidein!important;” title_text=”Two business people talk project strategy at office meeting room. Businessman discuss project planning with colleague at modern workplace while having conversation and advice on financial data report.” sticky_enabled=”0″]Medicine and pharmacy<\/span><\/p>\n

<\/span><\/p>\n

Building an analytical platform<\/span><\/strong><\/h3>\n

<\/span><\/p>\n

As part of the project, ASTEK Poland has created a platform that automatically and intelligently manages the loading, extraction, transformation, verification, validation and storage of data making it ready for use by analysts and data scientists. It is used globally in various areas of diagnostic medicine and bioinformatics.<\/span><\/p>\n

\"\"<\/span>[\/et_pb_tab][\/et_pb_tabs][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.24.3″ _module_preset=”default” background_color=”#00606f” custom_margin=”||||false|false” custom_padding=”50px||50px||true|false” locked=”off” global_colors_info=”{}”][et_pb_row _builder_version=”4.24.3″ _module_preset=”default” custom_padding=”0px||||false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.23.3″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.24.3″ _module_preset=”default” header_2_font=”|800|||||||” header_2_text_align=”center” header_2_text_color=”#FFFFFF” header_2_font_size=”38px” custom_margin=”19px||15px||false|false” global_colors_info=”{}”]<\/p>\n

Contact us<\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”4.24.3″ _module_preset=”default” text_font=”|300|||||||” text_text_color=”#FFFFFF” text_font_size=”20px” text_orientation=”center” custom_margin=”||16px||false|false” global_colors_info=”{}”]<\/p>\n

Do you want to know more? Do you have additional questions?
Feel free to contact us!<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_2,1_2″ use_custom_gutter=”on” gutter_width=”1″ make_equal=”on” _builder_version=”4.24.3″ _module_preset=”default” background_color=”#FFFFFF” width_tablet=”90%” width_phone=”90%” width_last_edited=”on|tablet” min_height=”760px” custom_margin=”||||false|false” custom_padding=”0px||0px||true|false” border_radii=”on|15px|15px|15px|15px” global_colors_info=”{}”][et_pb_column type=”1_2″ _builder_version=”4.24.3″ _module_preset=”default” background_image=”https:\/\/astek.pl\/wp-content\/uploads\/2023\/12\/formularz-scaled.webp” background_position=”top_left” background_horizontal_offset=”52%” custom_padding=”||||false|false” global_colors_info=”{}”][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.23.3″ _module_preset=”default” global_colors_info=”{}”][et_pb_code _builder_version=”4.24.3″ _module_preset=”default” custom_padding=”50px|30px|50px|30px|true|true” locked=”off” global_colors_info=”{}”]<\/p>\n

\n
\n

<\/p>

    <\/ul><\/div>\n
    \n
    \n<\/fieldset>\n
    \n\t
    \n\t\t

    First Name <\/span> E-mail <\/span>\n\t\t<\/p>\n\t<\/div>\n\t

    \n\t\t

    Last Name <\/span> Phone <\/span>\n\t\t<\/p>\n\t<\/div>\n<\/div>\n

    \n\t