Tabrez S.

Experience

1. Senior Data Engineer

   Morgan Stanley

   Dec 2024 — Present · Houston, TX, US

   Environment: GCP (BigQuery, Dataflow/Apache Beam, Dataproc, Cloud Storage, Pub/Sub, Cloud Composer, Cloud Functions, Data Catalog), PySpark, Informatica, Databricks, SQL Server, PL/SQL, GitLab, Jenkins, Terraform• Designed, developed, and maintained scalable ETL/ELT pipelines using PySpark on Dataproc and Informatica to ingest, transform, and load data from on-prem databases, APIs, and streaming sources into Cloud Storage and BigQuery.• Built and optimized data workflows on GCP using BigQuery, Dataflow, Dataproc, Cloud Storage (GCS), Pub/Sub, and Cloud Composer, supporting both batch and real-time analytics use cases.• Engineered distributed data processing jobs with PySpark on Dataproc for large-scale joins, aggregations, and complex transformations, leveraging partitioning, broadcast joins, and caching to improve performance and reduce cost.• Implemented data modeling and performance-optimized schemas in BigQuery, including partitioned and clustered tables, star schemas, and denormalized reporting tables, reducing query latency and storage cost.• Collaborated with data architects, analysts, and business stakeholders to translate business requirements into technical design documents, ETL mappings, PySpark jobs, and BigQuery data models.• Developed CI/CD pipelines using GitLab and Jenkins for PySpark code, Informatica workflows, and BigQuery objects, enabling automated testing, code quality checks, and environment-based deployments.• Used Terraform to manage GCP infrastructure-as-code for Dataproc clusters, Composer environments, Pub/Sub topics, and service accounts, ensuring consistent, repeatable environments.

Education

• Osmania University

  Bachelor of Engineering - BE, Mechanical Engineering

• Trine University

  Master's degree, business Analytics