Uploaded File
no photo
Sudarvizhi
Sr. ETL Consultant
Nashville Elec Serv, TN
Available immediately
Actively seeking
no photo
Sudarvizhi
17
views
Sr. ETL Consultant
0
Recommendations
Average rating
17
Profile views
Informatica Powercenter ETL Informatica UNIX SQL Oracle Teradata TOAD IDQ Business Requirements
Remove Note
View Note
Recent Experience
Sr. ETL Consultant 03/16 - present
SQL Business Requirements Stored Procedure SQL Server Oracle ETL Triggers Requirement Analysis IDQ Informatica Informatica Powercenter PL/SQL Data Analysis Teradata TOAD
Technical Lead 12/12 - 02/15
Business Requirements Auditing IDQ Informatica Data Cleansing Data Conversion Ember.JS Stored Procedure ETL Informatica Powercenter Shell Scripts UNIX XML
Informatica Technical Lead 10/11 - 08/12
Informatica Business Requirements Teradata Data Warehousing Informatica Powercenter ETL XML BTEQ Stored Procedure Shell Scripts UNIX
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 sortertransformations.
  • 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.

Top 5 Skills
SkillsProficiencyLast Used
Informatica Powercenter
2018
ETL
2018
Informatica
2018
UNIX
2015
SQL
2018
Education and Certifications
not provided
Periyar University
Preferences
Availability:Immediately
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:No travel (0%)
Employment Type:Any
Security Clearance:No clearance
Citizenship:U.S. Citizen