Junia Josephine

Radial Omnichannel Technologies provides end-to-end eCommerce solutions, optimizing order management, inventory, and customer service for brands, enhancing efficiency and growth across digital and physical touchpoints.

• Designed and implemented a robust integration solution for an external API source by IBM DataStage's Hierarchical Stage. The project involved extracting chargeback data from an API, transforming complex XML into a flattened format, and loading it into a database for reporting and analytics.
• Led the integration of a multi-tender split pay solution, enabling the system to process payments using multiple credit cards for a single order. Modified existing ETL workflows in IBM DataStage to handle multi-tender payment data, ensuring accurate processing and transaction reconciliation.
• Developed an ETL solution to integrate fraud transaction data from multiple sources (Payment service XML, Gateway service JSON) using IBM DataStage's Hierarchical Stage. Processed and loaded the data into a unified table, enabling fraud analysts to create enriched rules for enhanced fraud detection.
• Worked in Customer Portal to centralize customer-related information, including address, phone number, and IP address. The portal enables real-time tracking of customer orders, allowing users to view order details for specific dates. Integrated data from various systems to provide a comprehensive view of customer interactions and transactions.

Mastech Infotrellis specializes in data management, integration, and analytics, helping businesses transform data into insights and drive growth. During my tenure, I worked on 4 client projects.

Leading retailer in the UAE

• Designed and developed ETL jobs using Informatica PowerCenter to integrate data across various lines of business, including food, cinema, and CRM. Created business-specific reports using Microsoft Power BI, offering actionable insights to stakeholders across departments

Leading bank in Greece

• Extracted data from various sources and loaded it into Netezza through an ETL process using IBM DataStage. Optimized data extraction and transformation processes to ensure scalability and efficiency, handling large financial datasets

Leading telecom company in the UAE

• The objective of the project is to comply with TRA regulations, and my KRA in the project was to develop jobs that transform the customer data to comply with TRA. Collaborated with cross-functional teams to meet project requirements and ensure data was processed and stored according to legal and compliance standards

Customer 360

• Worked in HIVE to obtain customer insights using Informatica Customer 360 Insight to enrich the customer data within a Data Lake