Uploaded File
no photo
Pavan
Sr. ETL Developer/Lead
Available immediately
Actively seeking
no photo
Pavan
9
views
Sr. ETL Developer/Lead
0
Recommendations
Average rating
9
Profile views
ETL Informatica Informatica Powercenter ETL Developer SQL TOAD DB2 Groovy UNIX JIRA
Remove Note
View Note
Recent Experience
Sr. ETL Developer/Lead 08/12 - 08/12
ETL Informatica Powercenter Informatica Agile Methodology Stored Procedure SQL Oracle PL/SQL JIRA Data Warehousing Production Support Performance Tuning Test Case Preparation ETL Developer SQL Developer SVN
Informatica Consultant 04/09 - 09/09
Netezza ETL Business Intelligence Informatica Powercenter Informatica Data Conversion Data Analysis Shell Scripts SQL Server SQL Data Warehousing Oracle TOAD
ETL Developer 09/08 - 01/09
DB2 ETL ETL Developer Groovy Informatica Informatica Powercenter SQL TOAD UNIX
Summary

of Experience * Overall 8+ 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 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 64 bit. * Experience in working with all the transformations in Informatica and applying the logic with the requirement. * Data warehousing experience using Informatica PowerCenter 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 Quality concepts and 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, Surrogate keys. * Experience in integration of various data sources with multiple Relational Databases like Oracle, SQL Server, and XML files, Main Frames, IBM DB2, SAP R/3 and worked on integrating data from flat files like fixed width and delimited. * Strong experience in performance Tuning of Informatica Mappings, processes and load routines. * 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. * Extensively worked with Oracle PL/SQL Stored Procedures, Functions Cursors, Indexes and Triggers and involved in Query Optimization. * 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 experience in documenting the ETL process flow for better maintenance and analyzing the process flow. * Experience in ETL testing, involved in QA testing with various teams. * Good understanding of BIG DATA concepts. Sound knowledge on Big Data Edition tool. * 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
ETL
2012
Informatica
2012
Informatica Powercenter
2012
ETL Developer
2012
SQL
2012
Education and Certifications
not provided 2007
not provided 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