Uploaded File
no photo
Pavan
Sr. Informatica Consultant
W2 Bryan, TX
Available immediately
Actively seeking
no photo
Pavan
48
views
Sr. Informatica Consultant
0
Recommendations
Average rating
48
Profile views
Informatica PL/SQL ETL SQL Agile Methodology Oracle PL/SQL Developer SVN Project Management Data Warehousing
Remove Note
View Note
Recent Experience
Sr. Informatica Consultant 10/16 - present
Informatica
SQL Developer, SBM teamtrack Sharepoint 02/17 - 02/17
DB2 ETL Informatica Informatica Powercenter Oracle SQL SQL Developer SVN TOAD Compliance Splunk Database Design
Sr. Informatica Developer/Lead 08/12 - 07/16
Agile Methodology ETL Informatica Oracle PL/SQL PL/SQL Developer SQL SVN
Summary

Overall 10 years of IT experience in the Business Analysis, Design, Data Modeling, Coding, Implementation and Testing of Applications using wide range of Technologies including Data Warehousing, Database and reporting systems for Sales, & Distribution, Retail and Finance Industries.
• Having good expertise in migrating various Informatica sessions and mappings from one version to another.
• Well versed with Informatica 8.1, 8.6, 9.1, 9.5, 9.6 64 bit.
• Experience in working with all the transformations in Informatica and applying the logic with the requirement.
• Data warehousing experience using InformaticaPowerCenter 9.x/8.x/7.x/6.2/5.0, Informatica Power Exchange 8.1 and extracting data from Db2, Oracle, MS SQL Server, MS Access, AS400.
• Extensive experience on Data Quality by creating checks to know the Quality of Data in AmeriCredit project.
• Sound knowledge on Informatica Data Qualityconceptsand IDQ tool.
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Warehouse Designer.
• Knowledge on reporting tool Business Objects.
• Experience in integration of various data sources from Databases like MS Access, Oracle, SQL Server and file formats like flat-files, CSV files, COBOL files and XML files.
• Sound knowledge of Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2000, MS Access 2000, PL/SQL, SQL*Plus, DB2 8.0.
• Worked on various database tools like Toad, SQL Developer, PL/SQL Developer, Rapid SQL developer.
• Extensively executed SQL queries on Oracle using Toad and SQL server tables in order to view successful transaction of data and to validate data.
• Good knowledge of Data warehouse concepts and principles (Ralph Kimball / Inman), Star Schema, Snowflake, SCD.
• Experience in integration of various data sources with multiple Relational Databases like Oracle, SQL Server, IBM DB2 and XML filesand worked on integrating data from flat files like fixed width and delimited.
• Used informatica NORMALIZER Transformation to convert the data from Legacy systems.
• Expertise in several key areas of Enterprise Data Warehousing such as Change Data Capture (CDC), Data Quality, and lookup Tables and ETL data movement.
• Experience in identifying Bottlenecks in ETL Processes and Performance tuning of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization/ Denormalization strategies.
• Experience in database performance tuning.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Good knowledge in Informatica BIG data concepts and BDE tool.
• Experience in ETL testing, involved in QA testing with various teams.
• Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member
• Ability to work in multiple projects simultaneously.

Top 5 Skills
SkillsProficiencyLast Used
Informatica
2019
PL/SQL
2016
ETL
2017
SQL
2017
Agile Methodology
2016
Education and Certifications
University of South Alabama 2007
University of Madras S.A Engineering College 2004
Brainbench Oracle PL/SQL Fundamentals,
Brainbench certification in RDBMS Concepts,
Preferences
Availability:Immediately
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:No travel (0%)
Employment Type:Contract
Security Clearance:No clearance
Citizenship:H-1B Visa