Pasha Mohammed

Data Warehousing and Business Intelligence professional with 18 years of experience in the IT industry worked on industry leading tools and technologies using Informatica PowerCenter, Power exchange, Snowflake, IICS, Informatica IDMC, Oracle SQL, PL/SQL, and Unix Shell Scripting.

Good experience in designing and developing Informatica Power Center ETL mappings and workflows to read the data from different platforms like relational databases, flat files and mainframe source system and generate output files or load into Data warehouse.

Prepare high level design document based on the business requirements, system feasibility and data analysis.

Used most of the transformations like Expression, Aggregator, Lookup, Joiner, Router, Filter, Java, SQL, Union, Rank, Normalizer and XML parser transformations in Power Center Informatica and used the same transformations in Informatica IICS.

Good experience in migrating Power Center ETL mappings and workflows to IICS mappings and mapping tasks.

Performance Tuning of Informatica mappings and SQL queries.

Good Experience in usage of Power Exchange to read and write mainframe files by creating Informatica ETL mappings and workflows.

Good experience in designing and implementing scalable Snowflake data warehouses for enterprise-level applications.

Proficient in design and development of process required to Extract, Transform and Load data into Data Warehouse using Snowflake Cloud Database and AWS S3, Azure and GCP.

Expertise in working with Snowflake Snow pipes, Internal / External stages, Clones, Tasks and Streams.

Involved in zero copy cloning to duplicate a database, schema, or tables without incurring any additional space and costs.

Develop procedures, functions and packages using Oracle PL/SQL and MS SQL server. Expert in transforming complex business logic into Database design and implemented by creating Stored Procedures, Views, and T- SQL scripting.

Good exposure in Informatica IDMC which is used for Data Integration, Data Catalog, Data Quality, Data Governance, API, Data preparation and Data marketplace for the cloud environments.

Implemented a CI/CD pipeline for a web application using Jenkins and Git.

Good experience in designing dimensional modeling using Erwin tool which results in designing star schema and snowflake scheme for rewards enrolment & redemptions for the banking project.

· Relationship Rewards Earnings Quarterly Bonus Calculation ETL job creation and released for Production deployment

· Successfully implemented production releases phase wise.

· Migrated CMF, DTF and BAF ETL workflows to Informatica IICS tasks within agreed time.

· Reduced the ETL execution time from 6 hrs. to 2 hrs. for the DW monthly job which feeds the data from Fact tables to Monthly tables by implementing partitioning concepts in Informatica workflows

· Design and implement scalable Snowflake data warehouses for enterprise-level applications.

· Led the integration of Snowflake with existing systems, speeding up data processing by 40%.

· Crafted complex SQL queries to enhance data retrieval, cutting query execution time by 20%.

· Worked with teams to design data models that boosted accuracy and efficiency by 30%.

· Migration of Legacy data warehouse to EDW.

· Received monthly summit award for resolving production support issues on time

Received Start of the month award for fixing critical issues which impact the business revenue