EXPLORE

Business Intelligence Data Warehousing Electronics Training Wireless
Profile cover photo
User Avatar

Vinodh V.

@varmavinodh

0.0
0

0.0

0.0

0%

Data Warehouse Developer (ETL/PL-SQL)

$25 USD / Hour

Flag of

India (10:11 AM)

Joined on July 11, 2008

$25 USD / Hour

IT experience in the business requirements analysis, application design, dimensional data modeling, data modeling, designing, coding, development, testing and implementation of business applications with RDBMS, Data Warehouse/Data marts, ETL, and client/server environment applications for Banking, Retail, financial and Health Care. ETL Tools -: Data stage 7.5/8.1/8.5 PX, Informatica 8.6.1, SAS. Databases (RDBMS) -: Oracle 11i/10g/9i, Teradata, DB2, SQL-Server, MS Access. Languages-:SQL, PL/SQL, UNIX shell scripting, Transact-SQL, PERL. Operating Systems-:UNIX, Windows (95/98/00/XP, vista), HP-UX, Linux. Version Control Tools-: CONTROL-M, Autosys, HP Quality center, Sequencer. Data Modeling Tools-:Erwin 3.0/3.5/4.0/4.1, MS Visio. • Working in banking domain for over 6 yrs. • Dedicated to maintain high quality standards. • Diversified domain experience in banking domain.

0.0 · 0 Reviews
Reviews

No reviews to see here!

Experience

Anti Money Laundering (AML),Saudi Arabian Monetary Agency (SAMA) & Moody's Analytics

May, 2014 - Present

11 years, 6 months

National Commercial Bank (NCB), Saudi Arabia

May, 2014 - Present

11 years, 6 months

• Created Oracle packages, scenarios using interfaces, variables, procedure • Designed the Software Design Document (SDD) for SIMAH project. • Was involved in the Design review and Code Reviews of different projects. • Used Data stage ETL for Designer to create the interfaces. • Performance tuned the Oracle and DB2 queries. • Involved in production support of daily EDW cycle. • Conducted code reviews and planned the knowledge transfer to client.

May, 2014 - Present

11 years, 6 months

Migration Data Cleanse

Apr, 2013 - Apr, 2014

1 year

Barclay’s Direct (UK).

Apr, 2013 - Apr, 2014

1 year

Designed and developed ETL processes to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database. Involved in performance tuning and optimization to manage very large volume of data. Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.

Apr, 2013 - Apr, 2014

1 year

MASDBIP

Nov, 2011 - Mar, 2013

1 year, 4 months

Danske Bank, Denmark

Nov, 2011 - Mar, 2013

1 year, 4 months

• Understanding the Mapping document based on Standard Transformation rules. • Profound knowledge on IBM-BDW (Bank data warehouse model). • Developed Informatica mappings from (CPY to SOR) & (SOR to MART) Type-1 and Type-2 based on mapping rules to generate PIV. • Extracting data, cleansing, transforming, integrating, and loading data into Data Warehouse. • Design and Develop the ETL Parallel jobs in Data Stage. • Experience in Unix Shell Scripting

Nov, 2011 - Mar, 2013

1 year, 4 months

Education

Jawaharlal Nehru Technological University

2004 - 2008

4 years

B.Tech

Flag of

India

2004 - 2008

4 years

Verifications

Registered Users

Total Jobs Posted

Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)

Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)