Datastage Engineer with Payment background - our client UST/FCB at Remote
0 views
Skip to first unread message
Aphrosoft Technologies
1:15 PM (2 hours ago) 1:15 PM
to anir...@aphrosoft.com
Please send resume to anir...@aphrosoft.com
Datastage Engineer with Payment background
Client : UST/FCB
Remote
Mandatory Skills
Data Stage
SAP Bods
Payment background
Designed, developed, and maintained enterprise ETL solutions using IBM InfoSphere DataStage and SAP BusinessObjects Data Services (SAP BODS) to support large-scale data integration and migration initiatives.
Developed complex DataStage parallel and server jobs for extracting, transforming, cleansing, and loading data from multiple heterogeneous sources into enterprise data warehouses.
Built and maintained SAP BODS workflows, data flows, transforms, and jobs to support data migration, synchronization, and master data management initiatives.
Designed ETL processes to extract data from Oracle, SQL Server, DB2, Sybase, flat files, XML, CSV, and web services while ensuring data quality and consistency.
Worked extensively in the Payments domain, supporting payment processing applications including ACH, Wire Transfers, SWIFT, SEPA, RTP (Real-Time Payments), Card Payments, and ISO 20022 message transformations.
Developed ETL solutions to process high-volume payment transaction data while ensuring compliance with banking and regulatory standards.
Integrated payment processing systems with enterprise data warehouses for financial reporting, reconciliation, fraud monitoring, and regulatory reporting.
Performed data mapping, source-to-target analysis, transformation rule development, and data validation for payment processing applications.
Collaborated with business analysts, payment operations teams, and solution architects to gather business requirements and translate them into scalable ETL solutions.
Implemented advanced DataStage stages including Transformer, Join, Lookup, Merge, Funnel, Aggregator, Change Capture, Remove Duplicates, Sequential File, Dataset, Peek, and Copy stages.
Developed reusable ETL components and parameterized jobs to improve maintainability and reduce development effort.
Optimized ETL performance through partitioning, parallel processing, memory tuning, indexing strategies, and efficient SQL optimization techniques.
Created SAP BODS reusable objects, custom functions, validation transforms, query transforms, map operations, and data quality rules.
Worked extensively with Control-M, Autosys, and Unix shell scripting to schedule, monitor, and automate ETL batch jobs.
Performed data profiling, cleansing, deduplication, standardization, and reconciliation to ensure high-quality financial and payment data.
Participated in data migration projects involving legacy payment platforms to modern enterprise payment systems.
Supported payment settlement, reconciliation, exception handling, transaction monitoring, and audit reporting processes.
Implemented robust error handling, exception management, restartability, logging, and recovery mechanisms within ETL workflows.
Collaborated with QA teams during unit testing, system integration testing (SIT), user acceptance testing (UAT), and production validation.
Monitored ETL production jobs, analyzed failures, performed root cause analysis, and resolved production issues within SLA timelines.
Maintained ETL documentation including technical design documents, source-to-target mappings, process flow diagrams, operational runbooks, and deployment documentation.
Followed SDLC, Agile/Scrum methodologies, version control practices, and change management procedures throughout project execution.
Worked closely with infrastructure, database administrators, application development, and production support teams to ensure reliable and scalable ETL solutions.
Environment:
IBM InfoSphere DataStage 11.x, SAP BusinessObjects Data Services (SAP BODS), Oracle, SQL Server, DB2, Sybase, PL/SQL, SQL, Unix/Linux, Shell Scripting, XML, CSV, Flat Files, Control-M, Autosys, Git, Jira, ServiceNow, Agile/Scrum, Data Warehousing, ETL, Payment Processing, ACH, SWIFT, SEPA, RTP, ISO 20022, Financial Services, Banking.
Developed complex DataStage parallel and server jobs for extracting, transforming, cleansing, and loading data from multiple heterogeneous sources into enterprise data warehouses.
Built and maintained SAP BODS workflows, data flows, transforms, and jobs to support data migration, synchronization, and master data management initiatives.
Designed ETL processes to extract data from Oracle, SQL Server, DB2, Sybase, flat files, XML, CSV, and web services while ensuring data quality and consistency.
Worked extensively in the Payments domain, supporting payment processing applications including ACH, Wire Transfers, SWIFT, SEPA, RTP (Real-Time Payments), Card Payments, and ISO 20022 message transformations.
Developed ETL solutions to process high-volume payment transaction data while ensuring compliance with banking and regulatory standards.
Integrated payment processing systems with enterprise data warehouses for financial reporting, reconciliation, fraud monitoring, and regulatory reporting.
Performed data mapping, source-to-target analysis, transformation rule development, and data validation for payment processing applications.
Collaborated with business analysts, payment operations teams, and solution architects to gather business requirements and translate them into scalable ETL solutions.
Implemented advanced DataStage stages including Transformer, Join, Lookup, Merge, Funnel, Aggregator, Change Capture, Remove Duplicates, Sequential File, Dataset, Peek, and Copy stages.
Developed reusable ETL components and parameterized jobs to improve maintainability and reduce development effort.
Optimized ETL performance through partitioning, parallel processing, memory tuning, indexing strategies, and efficient SQL optimization techniques.
Created SAP BODS reusable objects, custom functions, validation transforms, query transforms, map operations, and data quality rules.
Worked extensively with Control-M, Autosys, and Unix shell scripting to schedule, monitor, and automate ETL batch jobs.
Performed data profiling, cleansing, deduplication, standardization, and reconciliation to ensure high-quality financial and payment data.
Participated in data migration projects involving legacy payment platforms to modern enterprise payment systems.
Supported payment settlement, reconciliation, exception handling, transaction monitoring, and audit reporting processes.
Implemented robust error handling, exception management, restartability, logging, and recovery mechanisms within ETL workflows.
Collaborated with QA teams during unit testing, system integration testing (SIT), user acceptance testing (UAT), and production validation.
Monitored ETL production jobs, analyzed failures, performed root cause analysis, and resolved production issues within SLA timelines.
Maintained ETL documentation including technical design documents, source-to-target mappings, process flow diagrams, operational runbooks, and deployment documentation.
Followed SDLC, Agile/Scrum methodologies, version control practices, and change management procedures throughout project execution.
Worked closely with infrastructure, database administrators, application development, and production support teams to ensure reliable and scalable ETL solutions.
Environment:
IBM InfoSphere DataStage 11.x, SAP BusinessObjects Data Services (SAP BODS), Oracle, SQL Server, DB2, Sybase, PL/SQL, SQL, Unix/Linux, Shell Scripting, XML, CSV, Flat Files, Control-M, Autosys, Git, Jira, ServiceNow, Agile/Scrum, Data Warehousing, ETL, Payment Processing, ACH, SWIFT, SEPA, RTP, ISO 20022, Financial Services, Banking.
Reply all
Reply to author
Forward
0 new messages