SUMMARY

About * years of Information Technology Experience in Data Warehouse using Informatica Power Center 9.5/9.1/8.6

Good experience in Full Life Cycle Implementation of applications on multi-platforms.

Data Processing experience in designing and implementing Data Mart applications using ETL tool, developed ETL mapping/mapplet, transformation & workflows.

Experience in using heterogeneous sources like flat files, XML, Oracle, SQL Server, DB2, and Teradata.

Experienced in loading data into Data Warehouse/Data Marts.

Developed Complex mappings from various transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Normalizer, Joiner, Union, and Update Strategy.

Experienced in configuring Nodes and Repositories in Informatica Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager.

Created and maintained Informatica users and privileges.

Experience in Shutdown and Restarting Informatica.

Strong Knowledge on E-R modeling and Dimensional Data Modeling Methodologies like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.

Experience in Dimensional Data Modeling (Dimensions and Fact Table) using Erwin Modeling (Erwin 4.0/3.5.5) like Physical & logical data modeling.

Experience in implementing SCD (Slowly Changing Dimension) Type 1, Type 2, and Type 3.

Experience on performance tuning in various levels like source, target, mapping, session, databases.

Good experience in performance techniques like pass-through, round-robbin, key-range, hash-partitioning and push-down optimization.

Good experience in using mapping, Session variables/parameters.

Experience on Informatica Data Quality tools like IDE, IDQ.

Conducted System, UAT and Functionality testing and investigated software bugs.

Extensive experience in conducting Requirement-gathering sessions, writing Business Requirement Document, Functional Requirement Document.

Working experience using SQL, PL/SQL, SQL*Loader, SQL*Plus, Import/Export utilities.

Worked with Oracle Stored Procedures, Triggers, Indexes, DML, DDL, Database Links, Sequences.

Experienced in Data Profiling, Data Mining and using Cleansing tools like Trillium.

Worked on UNIX shell scripts used in scheduling Informatica pre/post session operations.

Advanced analytical and problem solving ability, Good organizational skills, Hardworking, Team player and self-starter, capable of working independently and motivate a team of professional.

EDUCATION

BTech in Information Technology, JNTU, India

TECHNICAL SKILLS

ETL TOOLS

Informatica Power Center.

LANGUAGES

SQL, C, C++, JAVA.

OS

UNIX,LINUX,WINDOWS.

DATABASE

ORACLE, SQL SERVER, TERADATA, MS-ACCESS.

REPORTING TOOLS

COGNOS, MICRO STRATEGY,BUSINESS OBJECTS.

SCRIPTS

HTML, UNIX, SHELL, PERL.

DEVELOPMENT TOOLS

SQL * PLUS, TOAD, SQL NAVIGATOR, SQL DEVELOPER

WORK EXPERIENCE

American Red Cross – Fairfax, VA FEB’17 – TILL DATE

Sr. ETL Developer

Responsibilities:

Worked with Product Analyst and business users to clarify requirements and translate the requirement into

technical specifications. Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.

Good experience in communicating with offshore team and helped the team in analyzing the data to identify

the data quality issues.

Created Dimensions and Fact tables for the data mart and also implemented SCD (Slowly Changing Dimensions) Type I and II for data load.

Extraction, Transformation and Load was performed using Informatica Power Center to build Data warehouse. Worked on Informatica power center tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer.

Developed standard and re-usable mappings, mapplets using various transformations like expression, aggregator, joiner, source qualifier, lookup, and Router. Also, developed mappings using parameters and variables.

Used reverse engineering in Erwin 4.x to understand the existing data model of the data warehouse.

Involved in Relational and Dimensional Data Modeling Techniques to design ERWIN data models.

Accomplished automated data extraction from various RDBMS via UNIX shell scripts, ETL processing using Informatica and loading into Data Mart.

Developed complex mappings in Informatica Power Center to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router.

Created and scheduled Sessions and Batches through the Informatica Server Manager.

Designed and documented validation rules, error handling and test strategy of ETL process.

Tuned Informatica mappings/sessions for better ETL performance by eliminating bottlenecks. Used Informatica ETL to load data from flat files, which includes fixed-length as well as delimited files and SQL Server to the Data mart on Oracle database.

Created mappings, complex workflows with multiple sessions, worklets with consecutive/concurrent sessions for loading fact and dimension tables into data mart presentation layer.

Conducted performance tuning of Informatica components for daily and monthly incremental loading tables.

Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.

Used Workflow Manager for creating, validating, testing and running sequential and concurrent batches.

Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time.

Analyzed workflow, session, event and error logs for trouble shooting Informatica ETL process.

Worked with Informatica Debugger to debug the mappings in Informatica Designer.

Involved in creating test plans, test cases to unit test Informatica mappings, sessions and workflows.

Migrated Informatica ETL application and Database objects through various environments such as Development, Testing and Production environments.

Environment: Informatica Power center 8.x, Oracle 11g, DAC, Unix & PL/SQL.

UPMC - Pittsburg, PA Jan'16 – JAN’17

Sr. ETL CONSULTANT

Responsibilities:

Interacted with Business users/customers to confirm the requirements needed for developing and modifying the jobs and also to identify the different sources of data in operational systems and developed strategies to build data warehouse.

Analyzed the business and functional requirements and provided high level technical design specifications to drive ETL Development efforts.

Actively involved in the Design and development of the STAR schema data model.

Designed ETL specification documents to load the data in target using various transformations according to the business requirements.

Extensively worked with Informatica Power Center to load data from flat files, oracle and other source systems into target database.

Designed and developed Complex Informatica mappings using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank for populating target tables/Files in an efficient manner.

Designed and developed ETL workflows with job dependencies and scheduling, participated in code reviews of ETL processes.

Created Visio diagrams of ETL process to include in the design documents.

Created check-lists for coding, reviewing, bug logging, troubleshooting, testing and release for smooth functioning of the entire project.

Created and Configured Workflows, Worklets, and Sessions to load the data to target warehouse Oracle tables using Informatica Workflow Manager.

Wrote Unix Scripts to invoke Informatica Workflows and sessions.

Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.

Extensively used Teradata Utilities including FAST LOAD, FASTEXPORT, TPump and TPT.

Implemented Error handling logic to capture Invalid/Null records coming from staging tables.

Tuned and optimized ETL jobs for performance and throughput.

Created test plans for unit testing, integration testing and UAT.

Developed SQL Scripts and ad-hoc queries for data verification and validation processes.

Managed QA and PROD deployments and automation of ETL Jobs.

Provided assistance in diagnosing production problems related to the project.

Environment: Informatica Power Center 9.5, MS SQL server 2008, Erwin - 4.0, Oracle 11g/10g, TOAD 9.x, Quality Center, Teradata 13.10 and UNIX.

American Express – New York, NY AUG'14 - DEC'15

ETL DEVELOPER

Responsibilities:

Prepared TSD and ETL Specification documents based on BSD and Mapping document.

Worked extensively on Source Analyzer, Mapping Designer, Target Designer, Workflow Manager and Workflow Monitor

Used various Transformations like Joiner, Aggregate, Expression, sorter, Filter, Union, Update Strategy, Stored Procedures, Connected/Unconnected Lookups, and Router to implement the business logic and to populate target table in efficient manner.

Created mappings with PLSQL Procedures and Functions to build business rules to load data.

Worked on Unix shell scripts used in scheduling Informatica pre/post session operations

Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait.

Involved in Folder Migrations from one environment to the other environments and Migrated the Code from Informatica Power center 8.6.1 to 9.5.1 and tested them.

Developed Parameter files for passing values to the mappings for each type of client

Responsible for developing the Jobsets, installing and running the jobsets in CA scheduling tool

Responsible for checking in the code to Tortoise SVN

Responsible for monitoring the jobs while deploying to other testing environments like SIT, UAT and production.

Responsible for updating the cycle scope documents before start of a test cycle.

Worked with flat files like fixed and de-limited.

Worked extensively on lookup and update strategy transformations to implement SCD Type2.

Developed test cases, conducted unit tests, monitoring the jobs and running the validations in testing environments.

Involved in the releases and validations in PROD.

Hands on experience on memory management and pipeline partitioning of workflow for better performance.

Environment: Informatica Power Center 9.1/9.5.1, SQL Server 2000, Oracle 9i, UNIX, Erwin 4.0, TOAD, SVN 1.6.15.

NeoApp Technologies - Hyderabad, INDIA JAN'12 - JUN'14

ETL/INFORMATICA DEVELOPER

Responsibilities:

Worked on Informatica tools like Power Center Designer, Workflow Manager and Workflow Monitor.

Performed data manipulations using various Informatica Transformations like Joiner,

Expression, Lookup, Sorter, Aggregate, Filter, Update Strategy, Normalizer and Sequence Generator.

Developed Informatica Type-1 and Type-2 Mappings based on the requirements.

Involved in Mapping, Session and database level optimization techniques to improve the performance.

Involved in creating complex workflows which utilize the various tasks like Event Wait, Command, Mail decision and Session.

Extracted data from Flat files and Oracle to load them into Teradata.

Worked on WLM Scheduler to automate the Workflows.

Prepared SDLC Work book and conducted walk through before moving to SIT, UAT and Production.

Debugged invalid mappings using break points, tested stored procedures, functions, Informatica sessions, batches and the target data

Wrote stored procedures in PL/SQL and UNIX Shell Scripts for automated execution of jobs

Identified performance bottlenecks and resolved those issues by Query optimization, dropping Indexes and Constraints, bulk loading.

Created reusable transformations and Mapplets to use in multiple mappings.

Created complex/ad-hoc reports using Business Objects reporter and exported to the repository.

Defects were tracked, reviewed and analyzed.

Environment: Informatica Power Center 9.0, Teradata V12, Oracle 11g/10g, DB2, WLM, UNIX, Windows XP.

Contact this candidate