Sign In
Looking for talent?
Check out our hiring section
Login to your account
Remember me?
Login
Forgot password?
Not a user yet?
Click here to register.
LOADING
Select Login
Uploaded File
Sudarvizhi
dsudarvizhi@gmail.com
804-714-9497
Nashville Elec Serv, TN 37246
Sr. ETL Consultant
17 years experience
C2C
0
Recommendations
Average rating
219
Profile views
Summary
9+ Years of experience in IT - Data Warehouse implementations using
InformaticaPowerCenter
9.x/8.x/7.x,
Oracle
11g/10g/9i,
Teradata, Hadoop,Mainframes, XML and flat files.
Extensive experience in analysis, design, development, implementation, enhancement and support of BI applications which includes strong experience in Data Warehousing (ETL & OLAP) environment as a Data Warehouse consultant.
Proficiency in utilizing ETL tool Informatica Power Center 9.x/8.x/7.x for developing the Data Warehouse loads with work experience focused in data acquisition and data integration.
Around 2 years of comprehensive hands on experience in Big Data processing using Apache Hadoop and its ecosystem (
Pig, Hive, Sqoop and Oozie
).
Expertise in designing confirmed and traditional ETL Architecture involving source databases Mainframe systems (COBOL files), Oracle, flat files (fixed width, delimited), DB2, SQL server, XML and target databases Oracle, SQL server, XML and flat files (fixed width, delimited).
Have good understanding of ETL/Informatica standards and best practices, Slowly Changing Dimensions (
SCD1, SCD2, and SCD3
).
Strong knowledge of Dimensional Modeling, Star and Snowflake schema. Designed Fact and Dimension tables as per the reporting requirements and ease of future enhancements.
Extensive Experience in designing and developing complex mappings applying various transformations such as
lookup
,
source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter
transformations.
Extensive experience in developing the
Workflows
,
Worklets, Sessions, Mappings
and configuring the Informatica Server using Informatica Power Center.
Excellent knowledge in identifying performance bottlenecks and also in tuning the mappings and sessions by implementing various techniques like partitioning techniques and pushdown optimization.
Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance.
Created reusable transformation and mapplets in the designer using transformation developer and mapplet designer.
Experience with pre-session and post-session SQL commands to drop indexes on the target before session runs, and then recreate them when the session completes.
Extensively worked for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error handling methods.
Strong knowledge about the scheduling tool
CONTROL-M.
Provided 24/7 active Data Warehouse production support as part of on-call rotation for both incremental and complete refresh.
Extensively worked with
Teradata
utilities like
BTEQ, Fast Export, Fast Load, Multi Load
to export and load data to/from different source systems including flat files.
Well versed in
UNIX shell
scripting.
SME for application, provide assistance to support team during issues in production.
Lead and provided guidance to both on-site and off-shore teams for various EDW initiatives.
Provided extensive
Production Support
for Data Warehouse for internal and external data flows to
Teradata
, Oracle DBMS from
ETL servers
via remote servers.
Experienced as point of contact to client for enhancement and support related activities.
Support for code deployment in
QA
and
PROD
environment and also responsible for code validation.
Responsible for production support activities like jobs monitoring, log the load statistics, analysis and resolve in case of any production issues, coordinate with business to fix any source file issues, coordinate with DBA to resolve any table space or file system related issues.
Responsible for deliverable out of monthly/Quarterly/Half Yearly/Yearly jobs.
Experience in development and documentation throughout the entire
SDLC using Waterfall and Agile methodologies
.
Excellent communication skills, business interaction skills and strong interpersonal skills to deal effectively with customer groups and clients to the top management.
Knowledge in ETL techniques analysis and reporting tools.
Having experience with working with Insurance, Banking and Telecom domain clients.
Excellent team player and self-starter with good ability to work independently and possess good analytical, problem solving and logical skills.
Experience
Edit Skills
Non-cloudteam Skill
Education
Computer Science
not provided
Record has not been verified.
Periyar University
Record has not been verified.
Skills
ETL
2021
8
Informatica
2021
8
Informatica Powercenter
2021
8
UNIX
2015
7
SQL
2021
6
Unit Testing
2021
6
Oracle
2021
5
Teradata
2021
5
Scripting
2015
4
BTEQ
2012
3
Business Requirements
2021
3
Data Marts
2010
3
ETL Architect
2015
3
IDQ
2021
3
Project Management
2021
3
Shell Scripts
2015
3
Stored Procedure
2021
3
UAT
2021
3
XML
2015
3
Auditing
2015
2
Data Cleansing
2015
2
Data Conversion
2015
2
Data Warehousing
2012
2
Ember.JS
2015
2
TOAD
2021
2
Data Mapping
2011
1
HP QC
2011
1
OPTIM
2011
1
PuTTY
2011
1
Requirements Gathering
2011
1
Agile Methodology
0
1
Big Data
0
1
BMC Control-M
0
1
Data Analysis
2021
1
Data Integration
0
1
DB2
0
1
Hadoop
0
1
Hive
0
1
Oozie
0
1
Pig
0
1
PL/SQL
2021
1
Production Support
0
1
Quality Assurance
0
1
Requirement Analysis
2021
1
SDLC
0
1
Snowflake
0
1
SQL Server
2021
1
Sqoop
0
1
Triggers
2021
1
Waterfall
0
1
