Rajini Rayapati
Data Engineer @American Express
Signup · Get unlimited contacts
WORK HISTORY
Data Engineer @American Express
Phoenix, AZ, US
Developed and optimized ETL processes for migrating financial transaction data from on-premise systems to AWS Redshift.•Supported legacy ETL workflows using Informatica PowerCenter to process financial transactiondata from DB2 and flat files, utilizing session parameters, mapping variables, and workflowautomation for secure and reliable data loads.• Developed and optimized reusable Informatica mappings using Lookup, Joiner, Aggregator, andExpression transformations to enable clean, validated data pipelines for financial reporting andcompliance.•Integrated multiple financial systems into a unified data warehouse to improve reporting capabilities for internal stakeholders.•Worked with SQL Server and PostgreSQL to design, manage, and optimize complex queries for financial reporting.•Leveraged PL/SQL procedures and analytic functions to support ETL transformations and reconciliation tasks, ensuring data integrity across financial systems•Developed automated data transformation workflows using AWS Glue for faster data processing and integration.•Designed and automated end‑to‑end ETL workflows in Azure Data Factory to integrate data from SQL Server, PostgreSQL, and cloud storage into data warehouses, supporting both batch and near real‑time processing.•Built and optimized scalable data pipelines in Databricks using PySpark notebooks and Delta Lake, implementing Medallion architecture to transform raw financial and marketing data into curated datasets for analytics and reporting.•Supported fraud detection by building data pipelines to stream transaction data into a machine learning model for risk assessment.•Worked with business analysts to design data models for financial reporting and business intelligence using Power BI.•Enhanced data extraction capabilities using Python to automate routine data collection tasks.•Built and maintained data pipelines for marketing and sales data, enabling real-time insights into campaign performance.
EDUCATION
Southern Arkansas University
Masters
ABOUT RAJINI RAYAPATI
I am a Data Engineer with 6 years of experience in data analysis, data mining, and data…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.