Jeet John

 Currently working in a project where cloud migration is being done using Azure Data Factory for data ingestion and Databricks for data transformations like filter, joins using data frames into Azure data lake.
 Setup of security groups using Azure active directory.
 In my previous project, migrated the PowerCenter objects to IICS by RPA tool where I was involved with planning, designing, and transforming Informatica workflows from on-premises to cloud-based within 6 months of duration.
 Developed ETL flows in IICS based on Informatica Power Center. Developed and validated the mappings, MCTs and taskflows and formed the unit testcases in IICS.
 Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup, Aggregator, Joiner, Router, Sorter and Union.
 Analysis of long running taskflows and did performance tuning. Tuned the Oracle queries so that it runs faster in Snowflake as part of performance improvement.

Currently working in a project where cloud migration is being done using Azure Data Factory for data ingestion and Databricks for data transformations like filter, joins using data frames into Azure data lake.
Setup of security groups using Azure active directory.
Migrated the PowerCenter objects to IICS by RPA tool.
Was involved with planning, designing, and transforming Informatica workflows from on-premises to cloud-based within 6 months of duration.
Developed ETL flows in IICS based on Informatica Power Center.
Developed and validated the mappings, MCTs and taskflows.
Formed the unit testcases in IICS.
Performed data manipulations using various Informatica transformations like Filter, Expression, Lookup, Aggregator, Joiner, Router, Sorter and Union.
Analysis of long running taskflows and did performance tuning.
Tuned the Oracle queries so that it runs faster in Snowflake as part of performance improvement.

Created and modified mappings using Informatica BDM to load the data from various sources using different transformations into Oracle DB/Hive for calculation of PD values.
IFRS9 implementation using the sources like Finacle/Finnone/Calypso/Cards for different entities-KSA, LON, EGY, UAE, EIB, SGP.
Understanding the Requirements through SMEs.
Unit testing and Analysis of source data to resolve the defects arising out of data inconsistency.

Migrated existing on-prem database to cloud using Azure technologies.
Data Ingestion where pipelines were implemented using ETL tool, Azure Data Factory to load them in as-is L1 layer.
Data transformation like filter and joins was done using Azure databricks to load them in L2 layer.
Reports were generated using the tables used in L2 layer.

Data Governance Project where we load data from multiple sources (Oracle/JDBC/ODBC/DB2/External Feeds/Internal feeds/Flat file objects) using Informatica BDM Developer(v10.2).
SQL query on source connection.
Create DQ rules based on 6 dimensions of data quality.
Profile and Scorecard are created based on the rules.
Load the exception data of rules to target Oracle tables.
Building business rules and Human Task workflows for the stage to Enterprise Data Warehouse using the Informatica Data Quality Developer tool.
Building Data lineage using Enterprise Data Catalog (EDC) v10.4.
Building organization-wide business glossary (assets, policies, relationships and other facets) and integrating the data quality rules using Informatica Axon 10.4.
Building subject area specific Data Quality scorecards using Informatica analyst tool 10.4.

BCBS 239 Data Refinery Project to build Data Quality and Reconciliation.
Understanding the Functional and Design Requirements through BRD’s (Business Requirement Document).
Enhanced ad-hoc changes in mappings in Informatica IDQ to load the data from various sources using different transformations.
Query building in Impala/Hive for data load.
Unit Testing and Analysis of source data to resolve the defects arising out of data inconsistency.
Performing data quality checks on file to remove data inconsistency or incompleteness.
SLA check analysis for source file through Informatica Analyst tool.
Creation of Profile and Scorecard and loading the exception data in Oracle.
Handled and coordinated a team of 6 members.

Understood the Functional and Design Requirements through TSD’s (Target Source Description) and created SCD2/SCD1 mappings for loading dimensions.
ETL developer where prepared DDLs for new business requirement, optimized the queries on database side and query side.
Enhanced ad-hoc changes in mappings in Informatica PowerCenter to load the data from various sources using different transformations.

Enterprise Information Platform(EIP)- It is data warehouse project for one of the US’s largest bank.
EIP involves creating a BASEL II compliance business and migration of data from Data Warehouse to staging Data Marts, which is used by BI team for reporting.
Data from various source systems is transformed to staging database.
At staging layer, data is formatted and arranged into different tables at SIF according to different types of products like Equities, Mortgage etc.
From SIF to EDR/BDW, data is further divided into different work areas like Arrangement, Product.
All the transformations in the different layers were done using Informatica PowerCenter.
Database used was Oracle.
From BDW to EDXF, data is converted into flat file system.
Data from EDXF to Reveleus is transformed to calculate various Basel II norms and generating various reports.
At each layer data is extracted, transformed and loaded from source to target and has been tested for values, data types and length.
Perform troubleshooting on issues from the source side and fixed it to load correct data in the final target database.
Played a role as a team lead and handled various clients onshore and offshore independently for requirement gathering and daily status calls.
Familiar with migration from on-prem to cloud using IICS and Azure technologies (ADF, Azure Databricks).
Performance tuning for faster runs to run jobs within SLA.
Good understanding of ETL tools (Informatica and Azure Data Factory).
Exposure in Data governance project where we analyzed trend charts from Data Quality scorecards to analyze the threshold which is useful for further DQ development activities.
Expert in the development of business rules for standardizing, cleansing and validating data in various formats.
Willingness to take initiatives & responsibilities.