PAVAN KUMAR UPPARA Email: acx10v@r.postjobfree.com

Contact No: +1-603-***-****

Summary:

Over 2 years of IT experience as an ETL Informatica Developer in analysis, design, development and testing.

Good Experience in Informatica Power Center (Designer, Workflow Manager, Workflow Monitor and Repository Manager).

Experience in ETL methodology for supporting data extraction, transformations and loading.

Good Knowledge in creating SSIS packages.

Good knowledge in generating various reports using reporting services (SSRS).

Developed various mappings using Mapping Designer and worked with aggregator, lookup, filter, router, joiner, source qualifier, expression, stored procedure, sorter and sequence generator transformations.

Excellent Knowledge of Data warehouse Concepts like Star schema, Snow flake Schema, Slowly Changing Dimensions, Fact Table, Dimension Table etc.

Excellent Knowledge of Database Systems - Oracle, SQL server.

Automated existing ETL operations using Autosys.

Good experience in developing SQL queries to validate the databases tables and reports data for backend database testing.

Experience in RDBMS, Microsoft SQL Server, Oracle (SQL) and associated SQL Programming Knowledge.

Extensive Working experience in applying Relational Database Concepts, and Normalization concepts.

Excellent Knowledge on UNIX Commands.

Strong troubleshooting skills, strong experience in working with complex ETL in a data warehouse environment.

Technical Skills:

ETL: Informatica Power Center 9.6/9.5/9.0/8.6

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2.

Operating Systems: Windows 2010/2008/2007/2000/NT/XP, UNIX, MS-DOS

Languages: SQL, PL/SQL, UNIX Shell scripts, C++

BI Tools: SSIS, SSRS

Education:

Bachelors in information technology, JNTU, 2009-2013.

Masters in computer science, RIVIER UNIVERSITY, 2015-2016.

Experience:

ETL Developer

Vibha Inc

El Dorado Hills, CA June 2016 to Present

Responsibilities:

Responsible for designing and developing of Mappings, Mapplets, Sessions and Work flows for loading the data from source to target database using Informatica Power Center and tuned mappings for improving performance. .

Extracted date from various sources like Flat files, Oracle and loaded it into Target systems using Informatica 9.5.

Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.

Tuned mappings and SQL queries for better performance and efficiency.

Knowledge in creating SSIS packages for file transfer from one location to another.

Good knowledge in generating various reports using reporting services (SSRS).

Automated existing ETL operations using Autosys.

Created & Ran shell scripts in UNIX environment.

Created and ran the Workflows using Workflow manager in Informatica Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.

Created tables and partitions in Oracle Database.

Environment: Power Center 9.5, Oracle, SQL developer, MS Access, PL/SQL, Autosys, DB2, UNIX Shell Scripting, SQL Server 2008, Windows XP, SSIS, SSRS.

Jr. ETL Developer

Greetel Software Solutions

Bangalore, India June 2013 to Nov 2014

Responsibilities:

Designed, developed and supported Extraction, Transformation and Load Process (ETL) with Informatica Power Center 9.0.

Developed various mappings using Mapping Designer and worked with aggregator, lookup, filter, router, joiner, source qualifier, expression, stored procedure, sorter and sequence generator transformations.

Worked extensively on mapping designer to design and create mappings, transformations to implement transformation logic.

Developing Reusable Transformations, Aggregations and created Target Mappings that contain business rules.

Creating Mapplets to reduce the development time and complexity of mappings and better maintenance.

Creating/Building and Running/scheduling workflows and worklets using the Workflow Manager.

Created complex mappings which involved slowly changing dimensions, implementation of business logic and capturing the deleted records in the source systems.

Worked on tuning of sessions and mappings for better performance.

Conducted Unit Testing, System Integrated Testing.

Environment: Informatica Power Center 9.0/8.6.1, Oracle, MS SQL Server 2005 PL/SQL, SQL*Plus, UNIX, Linux, Windows XP.

Contact this candidate