Aishwarya Kongari

Gcp Data Engineer @Broadridge

TX, US

Developed and implemented robust ETL/ELT workflows tailored for asset management data using Azure Data Factory and Informatica PowerCenter.• Integrated structured and unstructured data from various sources by leveraging Kafka, Spark Streaming, Flume, and AWS Kinesis.Develop and implement robust ETL/ELT workflows tailored for asset management data, ensuring efficient extraction, transformation, and loading processes using Azure Data Factory, Informatica PowerCenter, dbt, Talend, and Apache NiFi.Integrate structured and unstructured data from trading platforms, market data feeds, financial APIs, and on-premises databases by leveraging Kafka, Spark Streaming, Flume, Sqoop, Azure Event Hubs, and AWS Kinesis. Architect and optimize scalable, high-performance data lakes and cloud data warehouses using Azure Synapse Analytics, Snowflake, Google BigQuery, AWS Redshift, and Databricks. Apply advanced optimization techniques such as partitioning, clustering, and materialized views to enhance data retrieval and query performance.Ensure compliance with regulatory standards such as SEC, GDPR, and FINRA by implementing data governance and security frameworks using Collibra, Alation, Apache Atlas, and Azure Purview. Enforce encryption, masking, access control policies, and comprehensive lineage tracking to maintain data security and integrity.Enhance database performance for asset management data systems by optimizing SQL queries, indexing, and partitioning strategies across SQL Server, PostgreSQL, MySQL, Oracle, Apache Hive, Presto, and Trino environments. Implement caching, query federation, and advanced tuning methods for improved responsiveness and scalability.Implement CI/CD pipelines to automate data workflows using Apache Airflow, Prefect, Dagster, Azure DevOps, Jenkins, and GitHub Actions. Establish seamless deployment strategies with version control, rollback mechanisms, and automated testing to ensure consistent and reliable pipeline delivery.

Osmania University

Bachelor of computer science