Executive Summary

• Over 7 years of experience in implementing extract, transform and load ETL solutions across for multiple clients across Mortgage, Healthcare, Insurance and Banking sectors.
• Extensive experience across all phases of the SDLC lifecycle with tools such as Informatica Power Center, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS and SQL Server Analysis Services SSAS .
• Expertise in integrating various relational source/targets like Oracle, MS SQL Server, DB2, MS Access/Excel and Flat files.
• Proficient in developing stored procedures, functions, views, triggers and complex queries using Oracle PL/SQL and TSQL.
• Extensive experience developing/debugging/tuning complex mappings, sessions and tasks using transformations Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators .
• Strong knowledge in data modeling relational, dimensional, star and snowflake schema , FACT and Dimensions table design, and Physical and Logical Database design.
• Experience in developing UNIX Shell and Perl Scripts in UNIX environment and Autosys for scheduling Workflows
• Experience in creating Deployment groups to migrate objects to Test and Prod environments

Technical Skills

Educational Background: BS, Computer Science, Osmania University, India.

Professional Experience

Confidential

ETL Developer

Responsibilities:

• Worked closely with Business analysts, third party vendors and architects to understand and analyze the requirements.
• Developed source to target mappings document and by analyzing the source/target schemas, tables and fields.
• Designed the ETL processes using Informatica to extract and integrate relational data from SQL server and Oracle Databases.
• Followed ETL best practices by using techniques such as using shortcuts for sources and targets, sorting the data before aggregate transformation.
• Performed data manipulations using various Informatica transformations like Aggregate, Filter, Lookup, Sequence Generator.
• Used SQL overrides in Source Qualifier in order to filter the data more effectively at the source level and used Stored Procedure transformation to call the procedures created at database level.
• Implemented variables and parameters in the mappings to reduce hard-coding at mapping level.
• Used Email Task for auto generation of email success and failure of sessions and Command Task in the workflows for file archiving and ftp scripts for dropping files at requested locations for consumption by third parties.
• Developed deployment groups to deploy all the objects in Test and Prod environments
• Performed Unit testing for the Informatica mappings and resolved issues raised in Testing and production environments.

Environment: Informatica Power Center 9.0/8.6, Erwin, UNIX Shell Scripting, SQL server 2012,Oracle 11g/10g, PL/SQL, UNIX Shell Scripting, TOAD.

Confidential

ETL Developer

Responsibilities:

• Developed Informatica mappings to facilitate Source/target mappings and loaded into staging tables from the source systems
• Biggest challenge was to integrate the originations data after Greenlight acquisition where files received were high in volume and had duplicate values.
• Developed Informatica mappings to populate the staging tables with sources like flat files, excels and Oracle and SQL server databases
• Used Normalizer transformation to normalize the source files.
• Implemented Slowly Changing Dimensions methodology to keep track of historical data. The mart had to hold 3 years of historical data.
• Loaded the data into audit tables before loading into the target tables.
• Created Parameter files to accommodate dynamic changes to the mappings instead of hardcoding in the mapping level.
• Performed tuning at database and mapping level by analyzing the root-cause by monitoring session performance and techniques like Explain plans, Oracle hints.
• Involved in using the Stored Procedures, Functions and Triggers at database level and imported them in Informatica for ETL.
• Scheduled the jobs using Informatica scheduler and supported Production changes during the scheduled days and provided post-production and maintenance support.

Environment: Informatica Power Center 9.0/8.6, Erwin, UNIX Shell Scripting, SQL server 2012,Oracle 11g/10g, PL/SQL, UNIX Shell Scripting, TOAD.

Confidential

Informatica developer

Responsibilities:

• Used ETL Informatica to develop data flows from source to staging and staging to target mappings.
• Extracted data from sources like CS Files, DB2, SQL server and loaded into ODS SQL Server .
• Developed complex mappings in Informatica using variety of transformations and workflow tasks like Event Raise, Event Wait, Timer, Email tasks.
• Implemented indirect source file loading to use single workflow for loading data from various flat files with similar file structure.
• Applied appropriate field level validations like date validations for cleansing the data.
• Implemented slowly changing dimension SCD Type 1 and Type 2 according to the requirement on dimension tables.
• Configured Pre/post session commands with UNIX scripts and used them in Command task.
• Used PMCMD for executing Sessions from the command mode also embedded the same in UNIX shell scripts
• Utilized Debugger to validate the mappings and gain troubleshooting information about data and error conditions and tested the validity of data in the warehouse by using SQL queries in TOAD.

Environment: Informatica Power Center 8.6, Erwin, T-SQL, SQL Server 2008 R2, UNIX Scripting, Informatica Scheduler.