SUMMARY

• An Informatica 8 Certified Professional with 12 + yearsof total IT experience in the Design,Analysis, Development, End to End Implementation in Data warehousing and Business Intelligence using Informatica 7,8,9,10x .
• Involved in Entire Project Architecture and Design .
• Strong Data Warehousing ETL experience of using Informatica 9.6/9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Involved in the performance tuning of Informatica mappings by using Informatica Push Down optimization (PDO), which provides the same performance impact as a BTEQ script.
• Extensively worked on Creating Views/View Optimization.
• Experience in integration of various data sources from Databases like Netezza,Oracle, SQL Server /2014, Teradata 14.10, DB2,SAP R3 and formats like flat-files and CSV files.
• Good experience in interacting with the Business Users, SME’s to gather requirements.
• Have good hands on Clear Case/SVN as a Configuration management tools, for maintaining the project related documents and their versioning system.
• Extensively worked on the documentation related to the work plans, Detailed Design Doc, High Level Design Doc, ETL Mapping documents, Unit Test cases and Approach documents.
• Have extensive hands on experience integrating SAP Source System (File & Stream Mode) with Informatica,Teradata
• Learned SAS and Dataflux Jobs to Convert to Informatica
• Ability to handleMultiple tasks,InitiativeandAdaptable.Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Good ability to quickly grasp and learn new concepts and technologies
• Strong communication skills (both verbal and written) and Interpersonal skills with the ability to interact with individuals and a strong team player.
• Actively participates in ETL resource hiring Process (Interview & Training)

TECHNICAL SKILLS

Data Warehousing/ ETL Tools: Informatica Power Center 10.x/9.x/8.x/7.x

Databases: Netezza,Teradata 13.1/14.1, Oracle 9i, Mainframe DB2, SQL Server 2005/2008/2014 , Ms Access

Utilities: Aginity,Bteq, Fast Export,Fload,Mload,Tpump, Teradata Viewpoint

Programming: SQL,PL/SQL,Teradata SQL, T SQL, Unix Shell Scripting,Python

Tools: Aginity, Clear Case, SVN,TOAD, Service Center,CITRIX,Quality Center,IRIS,Data Studio,Harvest,TFS

Environment: Windows 7/8/XP, UNIX

Scheduling tools: Autosys, WLM,Tidal Scheduler,Informatica Scheduler,TWS

IDEs: WinSCP, Putty

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr Informatica Developer

Responsibilities:

• Design and Develop ETL solutions integrating internal and external sources and thereby ensuring correct standards are met
• Create High Level Design and Low Level Design Docs
• Perform requirement analysis & Data Profiling
• Involved in coding, testing, implementing, debugging and documenting the complex ETL programs.
• Extract, Transform and Load (ETL) data from various sources into Data Warehouses and DataMarts using Informatica Power Center (Repository Manager, Designer, Workflow Manager,Workflow Monitor), SQL Server Database,ESP.
• Develop Stored Procedures and also build UNIX shell scripts as per the requirements.
• Performance tuning of long running of ETL Jobs
• Support applications and infrastructure of production integration environment, which includes performance tuning, troubleshooting and maintenance of integration platform.

Environment: Informatica Power Center 10.2, Sql Server 2014, Unix,ESP,Quality Center

Confidential, Charlotte, NC

Sr Informatica Developer

Responsibilities:

• Design and Develop ETL solutions integrating internal and external sources and there by ensuring correct standards are met
• Create High Level Design and Low Level Design Docs
• Perform requirement analysis & Data Profiling
• Involved in coding, testing, implementing, debugging and documenting the complex ETL programs.
• Is responsible for assisting the project manager by compiling information from the current systems, analyzing the program requirements and ensuring that it meets the specified time requirements
• Extract, Transform and Load (ETL) data from various sources into Data Warehouses and DataMarts using Informatica Power Center (Repository Manager, Designer, Workflow Manager,Workflow Monitor), SQL Server Database,Autosys.
• Develop Stored Procedures and also build UNIX shell scripts as per the requirements.
• Performance tuning of long running of ETL Jobs
• Support applications and infrastructure of production integration environment, which includes performance tuning, troubleshooting and maintenance of integration platform.

Environment: Informatica Power Center 9.6, Sql Server 2014, Unix,Autosys,Harvest,Clearcase,TFS

Confidential, Charlotte, NC

Sr Informatica Developer

Responsibilities:

• Data Analysis, Profiling & Requirement Analysis.
• Learned SAS DI to extract the logic from SAS and convert it to Informatica .
• Converted DataFlux Rules/Jobs into Informatica Jobs .
• Developed Informatica mappings to extract data from Various Sources to load in to Stage.Created various checks for data prior load
• Design, Develop, Test and Implement the jobs that extract, transform and load data into the Netezza
• Provided Support to applications and infrastructure of production integration environment, which includes performance tuning, troubleshooting and maintenance of integration platform.
• Created Multiple views & Redesigned existing Views to provide Better Performance.

Environment: Informatica Power Center 9.6, Netezza, Unix,Autosys,Dataflux

Confidential, Minneapolis, MN

Informatica Tech Lead

Responsibilities:

• Distributing Tasks to my team mates
• Help them in ETL Development, mentor them.
• Reviewing the Documents and ETLS, to ensure it adheres to all set of Parameters with in the Organisaton .
• Review of Test Cases
• Data Analysis, Profiling & Requirement Analysis.
• Design different Layers of Stages through Informatica
• Designed ETL architecture to Process volume of data and created High-level design, low-level design documents keeping data lineage as the first priority and performance the next. Participate in user meetings; gather Business requirements & specifications for the Data warehouse design.
• Developed Informatica mappings to extract data from Oracle,Sql Server 2008,DB2, Flat files, XML,PWX Sources to load in to Stage. Worked data mapping, data cleansing, program development for loads, and data verification of converted data to legacy data.
• Design, Develop, Test and Implement the jobs that extract, transform and load data into the Enterprise data warehouse
• Highly motivated with the ability to work effectively in teams as well as independently.

Environment: Informatica Power Center 9.6, DB2,Sql Server 2008,XML,PWX, Oracle 9, Unix Scripting, TWS

Confidential, New Brunswick, NJ

Informatica Tech Lead

Responsibilities:

• Distributing Tasks to my team mates
• Help them in ETL Development, mentor them.
• Reviewing the Documents and ETLS, to ensure it adheres to all set of Parameters with in the Organisaton .
• Review of Test Cases
• Design and develop large Enterprise Data Warehouse projects and data marts.
• Data Analysis, Profiling & Requirement Analysis.
• Designed ETL architecture to Process volume of data and created High-level design, low-level design documents keeping data lineage as the first priority and performance the next. Participate in user meetings; gather Business requirements & specifications for the Data warehouse design.
• Developed Informatica mappings to extract data from Oracle, Flat files, SAP R3 Sources to load in to Stage area using TPT (Teradata Parallel Transporter) utility. Worked data mapping, data cleansing, program development for loads, and data verification of converted data to legacy data.
• Design, Develop, Test and Implement the jobs that extract, transform and load data into the Enterprise data warehouse
• Developed Informatica mappings with Pushdown Optimization (PDO) to load data from Staging to the EDW layer.
• Generate Windows scripts to handle, transform and transfer files and also to execute commands. Apply Informatica & Teradata best practices during development with a strong focus on reusability and better performance.
• Produce clearly articulated functionality documentation in data integration.
• Experience in Integration of various data sources like Teradata, Oracle, DB2, SQL Server, Flat Files and XML files.
• Highly motivated with the ability to work effectively in teams as well as independently.
• Provided required support in Multiple (SIT, UAT, PROD) environments of the project.

Environment: Informatica Power Center 9.1/9.5, Teradata 14.10, SAP R3, Oracle 10G, Linux Batch Scripting, TIDAL Scheduling Tool, Teradata Viewpoint

Confidential, Santa Ana, CA

ETL Developer

Responsibilities:

• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.
• Involved in the creation of Informatica mappings to extracting data from Flat Files to load in to Stage area.
• Designed and Created validation and External loading scripts like MLOAD and FLOAD for Teradata warehouse using Informatica ETL tool.
• Involved in error handling, performance tuning of mappings, Testing of Informatica Sessions, and the Target Data.
• Experienced in loading data into Data Warehouse/Data Marts using Informatica, Teradata Multiload, Fast load and BTEQ utilities.
• Extensively worked on indexes in Teradata and Creation of proper Primary Index (PI) talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Designed ETL to collect stats on regular basis ( when the volume increases by 3 % more )
• Loading data by using the Teradata loader connection, writing Teradata utilities scripts (Fast load, Multiload) and working with loader logs. Scheduled workflows, BTEQ Scripts, UNIX shell scripts using WLM Scheduling tool.
• Dropped the Join Indexes before ETL load and re-built after the ETL load to enhance Performance more.

Environment: Informatica Power Center 9.1, Teradata 13.10, IBM DB2, WLM Scheduling Tool and Windows 7

Confidential, Richmond, VA

ETL Developer

Responsibilities:

• Involved with the Business analysts in requirements gathering, business analysis, discussed issues to be resolved and translated user input into Business specifications documents.
• Analyzed the change requests and did the impact analysis and effort estimation.
• Documented business requirements, Coordinated with offshore team to prepare flawless ETL specifications, Technical design documents.
• Data profiling to estimate the quality of the data.
• Designed the data model and worked with Data Architect to Publish the Data Model.
• Developed and modified Teradata BTEQ, FLOAD, UNIX shell scripts.
• Identifying indexes for Teradata Tables to improve the performance.
• Provided required support in Multiple (SIT, UAT,PROD) stages of the project.
• Set up the FTP to transfer files from DX server to Vendor server.
• Provided support for system integration testing, release testing and production

Environment: Informatica Power Center 8.6, Teradata 13.10,WLM, Clear Case, Quality Center

Confidential

ETL Developer

Responsibilities:

• Data Analysis & Detailed Requirements Gathering
• Preparing High Level Design, ETL processing document and Low level design.
• Developed ETL around the business logic and testing the same against the specific business rules.
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy.
• Handling Defects raised by End Users, Analyzing the Informatica bugs and fixing them in the Informatica mappings
• Daily Data load Monitoring: These Workflows were then scheduled to run at specific time intervals on the Client Production Repository and monitored regularly in Workflow Monitor.
• Coordinating with the onsite team for reviews, feedback and issue resolutions & Mentoring new team members.
• Creating project deployment process document for the release management team to release the code to production

Environment: Informatica Power Center 8.1,SSIS,Oracle 9i,SQL Server,Ms Access,Autosys, Quality Center