PROFESSIONAL SUMMARY:

• Having 9 years of experience in teh field of Information Technology, with extensive experience in analysis, design, development, data conversion, Data Warehouse, Unit testing and documentation. strong experience in using ETL (Extraction, Transformation, Loading) utilizing Informatica Powercenter 8.6.1, 9.1, 9.6,10.2.
• Strong knowledge of Data warehousing concepts, dimensional Star Schema and Snowflake schema methodologies.
• Experience in database design, Entity - Relationship modeling and Dimensional modeling
• Participated in Design team and Requirement gathering meetings.
• Was Responsible for understanding User requirements and translating those requirements into well designed solutions.
• Proficient in understanding business processes/requirements and translating them into technical design
• Solid understanding of Data Warehousing and BI life cycle and strong working experience in Data Warehousing and reporting applications, directly responsible for teh Extraction, Transformation and Loading of data from multiple sources, OLTP into teh Data Warehouse using Informatica.
• Extensive experience in database technologies (Creating indexes, tables, views and performing SQL tuning )
• Experience in writing Unix Shell Scripts .
• Worked on Teradata utilities (BTEQ, Fload, and Mload).
• Extensive experience in end to end ETL design, documentation, development, testing and client support.
• Involved in migration of code from informaticapowercenter 9.1 to informaticapowercenter 9.6, 10.2 and testing teh code in all environments (DEV, QA, and UAT).
• Worked under Waterfall model (SDLC) and TEMPhas knowledge on agile methodology.
• Extensively worked on Informatica Power Center client tools including Mapping Designer, Workflow manager, Workflow Monitor and Repository Manager
• Highly motivated team player with excellent analytical& problem solving skills possessing teh ability to effectively communicate with higher management and stake holders.
• Worked in post development production support in all teh projects.
• Handled production activities along with teh development tasks.

TECHNICAL SKILLS:

ETL Tool: InformaticaPowercenter 8.6.1/9.1/ 9.6/10.2

Databases: Teradata 13,14, Oracle 10g/11g

Tools: /Utilities SQL developer,Teradata SQL Assistant,SQL Server 2014

Operating Systems: UNIX, Linux, Microsoft Windows XP/Windows 7

Scheduler Tools: Ctrl-M,Autosys

Defect Tracking Tools: SVN, GIT

Languages: UNIX Shell Script

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Informatica ETL Lead Developer

Responsibilities:

• Designed and created ETL mappings using Informatica Mapping Designer.
• Followed Iterative Waterfall model for Software Development Life Cycle Process (SDLC).
• Worked extensively on performance tuning by making changes to SQL in Source Qualifier.
• Used various Informatica transformations like expressions, filters, joiners, aggregators, routers and lookups to load better and consistent data into teh targets.
• Fine-Tuned Existing Mappings for better performance. Documented Mappings and Transformations.
• Responsible for Technical documentation of ETL Process.
• Interacted with end users and gatheird requirements.
• Wrote procedures, functions in PL/SQL, troubleshooting and performance tuning of PL/SQL scripts in Teradata.
• Used hue tool to analyze teh source data.
• Monitoring and improving performance of daily jobs on Oracle database.
• Wrote complex queries in sql and edited teh existing stored procedures.
• Identifying integrity constraints for tables.
• Developed procedures and functions using PL/SQL and developed critical reports.
• Worked with autosys for triggering and scheduling teh jobs.

Environment: Informatica 9.1, Informatica 9.6, Teradata 14, SQL Assistant, Flat Files,SFTP, Control-M, UNIX Shell script,SVNtool, Autosys,Tortoise Tool,DB2,SFDC, TSQL, IDQ, Sybase,OFSA,Sql Server 2014

Confidential, Jersey City, NJ

InformaticaETL Lead Developer

Responsibilities:

• Involved in gathering and analyzing teh requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract teh data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with teh mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into teh existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
• Generated queries using SQL to check for consistency of teh data in teh tables and to update teh tables as per teh Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Good understanding of source to target data mapping and Business rules associated with teh ETL processes.
• Worked with control-m for triggering and scheduling teh jobs.

Confidential

InformaticaETL Lead Developer

Responsibilities:

• Developed Informatica mappings based on Star schema model.
• Involved in Analyzing teh LDM (logical design model) and PDM (Physical Design Model).
• Involved in preparing teh LLD (Low Level Design documents).
• Tuned teh Performance of Informatica processes and efficiently reduced teh run time of some of teh critical sessions.
• Worked on shell scripts to handle flat files which include files from source system and transferring files to downstream systems.
• Worked extensively on Informatica Power Center using Source Analyzer, Mapping designer.
• Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator, and Joiner on teh extracted source data according to teh business rules and technical specifications.
• Developed several Complex Informatica Mappings to facilitate daily, Weekly, Monthly loading of Data.
• Used pushdown optimization to utilize teh teradata
• Worked extensively with Offshore Team for completing teh ING Integration Projects.
• Onsite Point of Contact for Off-shore team in designing and developing ETL mappings as part of Data Warehousing project.
• Coordinated with teh Change Management to deploy ETL mappings into QA, Production environments.
• Used informatica PDO(Push Down Optimization) to load data in to teh ware house which is on Teradata
• Used Fast load to load teh data into staging work tables, after staging used informatica to load integration and symantic layers.
• Wrote procedures, functions in PL/SQL, troubleshooting and performance tuning of PL/SQL scripts in Teradata.
• Worked on ODS loading and ETL mapping development.
• Actively participate in design reviews. Identified gaps in requirements at teh design stage and probe for detailed explanation of expectations.
• Obtained Business and Management’ sign off on teh Design documents
• Conducted Walkthrough meeting with developers, testers and Data sourcing Teams to review Client requirements documents(CRD)
• Used COGNOS for generating teh reports based on teh under lying aggregate views.
• Acted as teh point of contact for any files sending to downstream applications from Development/Pre-Prod Environment.
• Worked on converting teh code from Abnitio to Informatica (migration of code from EDW to BDW environment)
• Pushed teh files to downstream Mainframe server.
• Gave production support post development.
• Used Kshell for scripting for source file manipulations .
• Working closely with code migration team to deploy teh ETL code from Dev to QA, UAT and Prod to make sure code is migrating without any issues.

Environment: Informatica 9.1, Informatica 9.6, Informatica power exchange, Teradata 14, SQL Assistant, Flat Files,SFTP, Control-M, UNIX Shell script,SVNtool,COGNOS,Tortoise Tool,DB2,SFDC, TSQL, IDQ, Sybase

Confidential

Informatica Developer

Responsibilities:

• Interacted with teh business users in order to understand teh business and functional requirements.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows.
• Data validation from sources through teh dashboards.
• Responsible for unit and integration testing
• Involved in migrating teh code from DEV toQA, QA to UAT,UAT to PROD
• Involved in developing teh mappings for staging, Integration and symantic layers.
• Designing teh data base objects using SQL Server management studio as per teh project specifications.
• Wrote procedures, functions in PL/SQL, troubleshooting and performance tuning of PL/SQL scripts in Teradata.
• Created tables with PI according to teh requirement.
• Integrated data from pharmaceutical domain to generate teh reports.
• Involved in building teh database and created stored procedures, triggers to maintain teh referential Integrity, functions, view to handle business logic and functionality of various modules.
• Involved in post deployment Production support activities
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes
• Users provide teh source data in flat files and loading into stage tables using ETL process.
• Developed standard mappings and mapplets using various transformations like expression, aggregator, joiner, router, sql and lookups.
• Developed scripts using python in Linux environment to invoke PMCMD commands.
• Involved in production supportactivities along with development.
• Involved in preparing teh LLD (low level design document).
• Involved in data profiling and data quality activities.

Environment: Informatica 9.1, informatica scheduler, Teradata 14, SQL Assistant, Oracle 10g/11i, UNIX Shell script, TOAD Quest software,BODS, Sybase