Talent's Information
-
Location
Gorakhpur, India
-
Rate
$13.0 per Hour
-
Experience
7 Year
-
Languages Known
English,Hindi
Available for
Background Verification
40 Hr/Week
About Rahul
Extensive experience in the following:
Data warehousing using ETL tool Informatica Power Center and ADF.
Knowledge of Fact and Dimension in DATA Warehouses.
Experience in the Analysis, design, development, testing and Implementation of Business Solutions using Data Warehouse Design, ETL, OLTP, OLAP, Client/Server applications.
Hands on experience in Implementing SCD Type-1 and SCD Type-2 Dimensions.
Extensive experience in working with business analysts to identify, study and understand Requirements and translated them into ETL code in Requirement Analysis phase.
Experience in implementing and deploying applications on Azure.
Experience in Azure services ADLS, Azure Data Factory, Azure Functions, Azure SQL DB
Ability to debug data load issues, transformation/translation problems etc...
Strong understanding of various data formats such as CSV, XML, JSON, PARQUET etc.
Experience in preparing technical design document, Mapping documents, Detail Design Document for the Source/Target mapping.
Excellent interpersonal and communication skills, and is experienced in working with senior level managers, Tech leads, businesspeople, and developers across multiple disciplines.
Understanding the requirements from the Business users and functionalities. Actively involved in Agile Methodology of software development and actively involved in Scrum Meeting.
Tech Stack Expertise
-
Oracle
Oracle
4 Years -
AWS
AWS S3
2 Years -
Python
Python
3 Years -
Azure
Azure data factory,Azure Storage
4 Years
Work Experience
Data Engineer
- January 2016 - January 2023 - 7 Year
- India
Projects
EDW-Inbound (Enterprise Data Warehouse)
- September 2016 - July 2017 - 11 Months
Technologies
Role & Responsibility
-
EDW-Inbound is a project which loading and maintaining the data in data warehouse or teradata FSLDM.
There are two types of data which loading into data warehouse/FSLDM such as integrated and non- Integrated data (Ancillary data). The data is flowing from different sources for EDW-Inbound like flat files and relational databases such as sql server, oracle, salesforce etc. Data cleansing, CDC, SCD type-2 techniques are using to load the data.
Roles and Responsibilities:
End to end project handling- requirement gathering, design & deployment.
Data warehousing using ETL tool Informatica Power Center.
Analyse current ETL process, define and design new systems.
Coordinated with team, leading with team and submitting the day-by-day activity to client.
Prepare technical design document, Mapping documents, Detail Design Document for the Source/Target mapping.
Work on UNIX work environment, file transfers, job scheduling and error handling.
Handle the job monitoring/Migration activity from one environment to another environment.
Customer 360
- August 2017 - December 2018 - 17 Months
Technologies
Role & Responsibility
-
Customer-360 is a project deals with the detail information about customers and their activities with the VMware. Source data come from different sources like flat file and relational databases such as Oracle, SQL Server etc.. and then loaded into the Greenplum database by using Informatica and PL/SQL. Information will provide to the business by generating reports using Tableau tool. Outcome of the project is tableau reports and source is flat files and relational sources.
Roles and Responsibilities:
End to end project handling- requirement gathering, design & deployment.
Data warehousing using ETL tool Informatica Power Center.
Analyse current ETL process, define and design new systems.
Coordinated with team, leading with team and submitting the day-by-day activity to client.
Prepare technical design document, Mapping documents, Detail Design Document for the Source/Target mapping.
Work on UNIX work environment, file transfers, job scheduling and error handling.
Handle the job monitoring/Migration activity from one environment to another environment.
CECL (Current Expected Credit Losses)
- January 2019 - February 2021 - 26 Months
Technologies
Role & Responsibility
Current Expected Credit Losses (CECL) is a new credit loss accounting standard (model) that was issued by the Financial Accounting Standards Board (FASB) on June 16, 2016. CECL replaces the current Allowance for Loan and Lease Losses (ALLL) accounting standard. The CECL standard focuses on estimation of expected losses over the life of the loans, while the current standard relies on incurred losses.
The financial crisis of 2007-2008 demonstrated that the Allowance for Loan and Lease Losses (ALLL) accounting standard does not allow for timely adjustment of reserve levels based on reasonable expectation of future conditions. It relies on losses that are incurred but not realized, i.e., when it is known with some certainty that future cash flows will not be collected. During the crisis, negative outlook of the economy was not considered for losses calculations. As a result, reserves were not adjusted for future expected losses. The FASB reviewed the standard and replaced it with CECL. CECL requires expected losses to be estimated over the remaining life of the loans, as opposed to incurred losses of the current standard.
Roles and Responsibilities:
End to end project handling- requirement gathering, design & deployment.
Data warehousing using ETL tool ADF.
Analyse current ETL process, define and design new systems.
Coordinated with team, leading with team and submitting the day-by-day activity to client.
Prepare technical design document, Mapping documents, Detail Design Document for the Source/Target mapping.
Work on UNIX work environment, file transfers, job scheduling and error handling.
Handle the job monitoring/Migration activity from one environment to another environment.
CTR (Currency Transaction Report)
- February 2021 - January 2022 - 12 Months
Technologies
Role & Responsibility
A currency transaction report (CTR) is a report that U.S. financial institutions are required to file with FinCEN for each deposit, withdrawal, exchange of currency, or other payment or transfer, by, though, or to the financial institution which involves a transaction in currency of more than $10,000. Used in this context, currency means the coin and/or paper money of any country that is designated as legal tender by the country of issuance. When the first version of the CTR was introduced, the only way a suspicious transaction less than $10,000 was reported to the government was if a bank teller called law enforcement. This was primarily due to the financial industry's concern about the right to financial privacy. The Bank Secrecy Act requires financial institutions to report currency transaction amounts of over $10,000. The outcome of the project is demographic file which is generating by CDC process. This file will be using further as report for federal government. The main source of this project is EPH data and AML ODS. The overall ETL flow is LAND, STAGE and Demographic file.
Roles and Responsibilities:
End to end project handling- requirement gathering, design & deployment.
Data warehousing using ETL tool ADF.
Analyse current ETL process, define and design new systems.
Coordinated with team, leading with team and submitting the day-by-day activity to client.
Prepare technical design document, Mapping documents, Detail Design Document for the Source/Target mapping.
Work on UNIX work environment, file transfers, job scheduling and error handling.
Handle the job monitoring/Migration activity from one environment to another environment.
Vendor Data Flow
- March 2022 - January 2023 - 11 Months
Technologies
Role & Responsibility
-
This project is based on retail Domain. It was a data migration project where I was involved as a ETL developer and my role was to extract the data from the various databases and feed it to centralized database.
Roles and Responsibilities:
End to end project handling- requirement gathering, design & deployment.
Data warehousing using ETL tool ADF.
Analyse current ETL process, define and design new systems.
Coordinated with team, leading with team and submitting the day-by-day activity to client.
Prepare technical design document, Mapping documents, Detail Design Document for the Source/Target mapping.
Work on UNIX work environment, file transfers, job scheduling and error handling.
Handle the job monitoring/Migration activity from one environment to another environment.
Soft Skills
Industry Expertise
Education
in Data Science with SAS
Gorkhpur- May 2015 - October 2015
