Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Rizwan Mohammed

San Francisco,CA

Summary

Seasoned Data Engineer with extensive experience in data integration, analysis, and development. Proven expertise in ETL methodologies (Informatica, SSIS, dbt, Airflow) and reporting (SSRS, Tableau, Power BI). Skilled in data modeling (Ralph Kimball), designing enterprise data solutions, and optimizing data pipelines to drive efficiency and improve decision-making. Strong communicator with a collaborative approach to problem-solving and solution delivery.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Principal Data Engineer

JPMorgan Chase & Co
San Francisco, CA
07.2023 - Current
  • Performing similar duties to First Republic as it was acquired by JPMC
  • Created Integration Requirements and Design Specification Documents
  • Collaborated with data and solutions architects on data warehouse design
  • Analyzed source data to develop data models with business users and developers
  • Maintained Informatica mappings and workflows for legacy data loading
  • Enhanced ETL framework on Snowflake Developed SQL queries for ETL processes using a custom Snowflake framework
  • Analyzed source/target systems and created mapping documents
  • Implemented Snowpipe for file data loading
  • Standardized ETL procedures with Python, improving ingestion speed by 20%
  • Created materialized views, stored procedures, and functions in Snowflake
  • Scheduled jobs using Snowflake Tasks Enabled data sharing across environments with Snowflake database shares
  • Conducted unit testing and facilitated user acceptance testing (UAT)
  • Provided production support, resolving issues with job failures
  • Designed and optimized dynamic SQL batches to perform bulk operations in OLTP environment.
  • Analyzed source OLTP systems and created data mapping documents for the ETL process.
  • Developed reports and dashboards in SSRS for Finance and Credit Admin teams
  • Built daily data quality check reports in SSRS and Beacon
  • Managed data migration from FRB (Snowflake) to JPMC (Snowflake, AWS S3, Glue, Athena)
  • Lead code review and testing schedules, overseeing production deployments
  • Redesigned the data warehouse, implementing dbt for automated transformations
  • Developed models, macros, and references in dbt
  • Created custom dbt macros for data validation and testing.
  • Orchestrated data pipelines using Airflow.
  • Managed dbt project configurations via YAML files. Tools/Technologies: Snowflake, dbt, Airflow, SSRS, AWS, Python, GitHub, and Jira.

Principal Data Engineer

First Republic Bank
San Francisco, CA
06.2018 - 07.2023
  • Created Integration Requirements and Design Specification Documents
  • Collaborated with data and solutions architects on data warehouse design
  • Analyzed source data to develop data models with business users and developers
  • Built and maintained DataMarts for Deposits, Loans, Transactions and Originations Processed data from multiple payment rails: ACH, Wires, Cards
  • Enhanced ETL framework on Snowflake Developed SQL queries for ETL processes using a custom Snowflake framework
  • Executed queries in Snowflake using SnowSQL
  • Implemented Snowpipe for file data loading
  • Created Python scripts for Control-M jobs to execute daily SQL Server tasks
  • Managed data migration from SQL Server to Snowflake with zero downtime
  • Transferred data from Snowflake to SQL Server using an in-house utility, Zip-Line
  • Created materialized views, stored procedures, and functions in Snowflake
  • Scheduled jobs using Snowflake Tasks Enabled data sharing across environments with Snowflake database shares
  • Conducted unit testing and facilitated user acceptance testing (UAT) Provided production support, resolving job failure issues
  • Offered technical guidance to development teams
  • Developed base and derived views, joins, and data service layers in Denodo
  • Created parameterized, drill-down, and drill-through reports in SSRS
  • Developed reports and dashboards in SSRS for Finance and Credit Admin teams
  • Generated daily data quality check reports in SSRS and Beacon
  • Assigned tasks to developers and scheduled progress follow-ups
  • Lead code review and testing schedules for production deployments
  • Authored use cases for POCs on new technologies (dbt, Airflow, Fivetran
    Tools/Technologies: Snowflake, dbt, SSRS, Python, Informatica, Jira, Control-M, Denodo,, Matillion, IntelliJ, Airflow, Fivetran

Sr. Informatica Developer

ConocoPhillips
Houston, TX
02.2018 - 06.2018
  • Developed ETL mappings using Informatica to support data extraction, transformation, and loading processes for financial data.
  • Worked with Teradata for data extraction and optimization, ensuring efficient data flows.
  • Led performance tuning for large data sets and identified issues to improve process efficiency.
    Tools/Technologies: Informatica PowerCenter, Teradata, Oracle, SQL, PL/SQL

Sr. Informatica / OBIEE Developer

Stanford University, School of Medicine
Palo Alto, CA
09.2017 - 02.2018
  • Designed and developed OBIEE dashboards and reports for university departments.
  • Optimized data integration and transformation processes using Informatica, addressing critical performance issues.
    Tools/Technologies: Informatica PowerCenter, OBIEE, Oracle, PL/SQL

Data Developer

Blue Shield of California
San Francisco, CA
05.2017 - 09.2017
  • Developed and maintained ETL workflows to integrate data from diverse sources into data marts.
  • Created and optimized SQL queries and Informatica mappings for data processing.
    Tools/Technologies: Informatica PowerCenter, Netezza, Oracle, SQL, PL/SQL

Informatica Cloud Developer

AppDynamics Inc
San Francisco, CA
10.2016 - 04.2017
  • Developed real-time data integration processes using Informatica Cloud to sync data across applications.
  • Created Service Connectors to pull data from APIs, improving integration efficiency.
    Tools/Technologies: Informatica Cloud, Salesforce, Concur, Workday, APIs

Sr. ETL Developer

Gap Inc
San Francisco, CA
06.2016 - 09.2016
  • Worked with ad-hoc analysis teams to deliver tailored reports and build robust data pipelines.
  • Developed Hive scripts and SQL queries for data analysis and warehouse management.
    Tools/Technologies: Informatica, Hadoop, Hive, Power BI, SQL

Education

Master of Science - Systems Engineering

University Of Arkansas At Little Rock
Little Rock, AR
12-2012

Skills

  • Data Tools & Technologies: Informatica PowerCenter, SSIS, dbt, Matillion, Airflow, Fivetran, Snowflake, AWS Glue, Athena
  • Data Modeling: Star Schema, Snowflake Schema, Dimensional Modeling (Kimball)
  • Programming: SQL, Python, PL/SQL, C, UNIX Shell Scripting
  • Data Warehousing & Architecture: Data Integration, ETL/ELT, Data Migration, OLTP, OLAP
  • BI & Reporting: SSRS, Tableau, Power BI, OBIEE, Denodo
  • Database Management: Snowflake, Oracle, SQL Server, Teradata, Netezza
  • DevOps/Version Control: GitHub, Jira, ServiceNow, Control-M

Certification

  • AWS Cloud Practitioner
  • dbt Fundamentals

Timeline

Principal Data Engineer

JPMorgan Chase & Co
07.2023 - Current

Principal Data Engineer

First Republic Bank
06.2018 - 07.2023

Sr. Informatica Developer

ConocoPhillips
02.2018 - 06.2018

Sr. Informatica / OBIEE Developer

Stanford University, School of Medicine
09.2017 - 02.2018

Data Developer

Blue Shield of California
05.2017 - 09.2017

Informatica Cloud Developer

AppDynamics Inc
10.2016 - 04.2017

Sr. ETL Developer

Gap Inc
06.2016 - 09.2016

Master of Science - Systems Engineering

University Of Arkansas At Little Rock

Similar Profiles

CREATE PROFILE
Rizwan Mohammed