SUMMARY:

• Data Warehousing: Experience in development, design & support of ETL Methodology for data transformations using Informatica Power Center 9.1/8.x/7.x/6.x
• Informatica PowerConnect for Mainframe and AS/400 to connect to most major data sources.
• PowerConnect for SalesForce, SAP R/3 and MQseries to read the portal data XML files.
• Databases: Experience in handling various Data sources like DB2(9.x/8x), ORACLE (11/10/9g), SQL Server 2008/2003/2000, Teradata /1413/12, MS Access, Ms Excel
• Data Modeling: Extensive experience in Analyzing the Dimensional Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data.
• SDLC: Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Skilled in Extracting/Loading data by using various Teradata utilities like MultiLoad, FastLoad, BTEQ, TPump, FastExport and Teradata Parallel Transporter (TPT).
• Good knowledge and experience working with Agile and waterfall software methodologies
• Other: Knowledge of UNIX shell scripting (korn/bash/AWK/SED), job scheduling on multiple platforms. Excellent individual and team performer maintains high levels of communication with Business Analysts and end users to enable better team performance.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.x/8.x/8.x/7.x/6.x, Repository Server Administrator Console, Power Exchange

Database & Related: DB2 9/8, ORACLE9i/10g/11g, SQL Server 2000/03/08, Teradata 14/13/12

Data Modeling Tools: Erwin7.x, MS Visio

Operating Systems: AIX, Linux, UNIX, Windows Server 2003, Windows XP/NT

Languages: SQL, PL/SQL,XML,XSD,HTML

Applications: Teradata SQL Assistant, TOAD, SQL Loader, Microsoft Office, BTEQ, Performance Monitor (PMON), Teradata Viewpoint, Fast Load, Mload, Fast Export, TPUMP, BTEQ, Teradata Parallel Transporter (TPT)

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead

Responsibilities:

• Discussed the Business Plans and Canned reports with the business analysts
• Led a team of 5 ETL Developers (Offshore and Onshore) to Design and Develop ETL Specs for the requirement.
• Conducted meetings with the clients at various stages of the project and coordinated with the off - shore team on a daily basis
• Created a complete Logical and Physical Data Model under a Star Schema by Analyzing Dimensions and Measures from the reports.
• Extensively used Forward and Reverse Engineering Methods utilizing the available Data Dictionaries
• Involved in Migration of Current Surety Business Data using Informatica Power Center 9.0 from external sources
• Created HLD and LLD for ETL Implementation from Source to Stage and Stage to Dimensions and Facts
• Created Mappings for Staging and Archiving Data using Informatica Power Center 9.0 by the Truncate and Load Method.
• Used SCD Type-II to load Facts and Dimensions to the Data Mart
• Generated Dynamic Parameter File using Data Refresh Table to Implement the CDC Logic to load Incremental Data
• Created Error Table to capture Errors and Exceptions generated while loading Facts and Dimensions
• Created Load History Table to Track Loading of various mappings
• Devised Reconciliation processes through SQL queries on the Source and the Target
• Used different Transformations (Expression, Router, Lookup, Filter, Normalizer Source Qualifier etc).
• Worked on various workflow tasks: Command Tasks, Decision & Assignment Tasks etc. to schedule workflows.
• Worked closely with Business Objects Team and implemented the Universe Design from the Dimensional Model
• Extensively used PMCMD for various chronological jobs ( scheduling etc.)

Environment: Oracle10g client, ERWin 7.3., Unix, Informatica 9.0

Confidential, FlorhamPark,NJ

Sr. Informatica Developer

Responsibilities:

• Analyzed business process and gathered core business requirements.
• Interacted with business analysts and end users and identified the potential bottlenecks.
• Used Agile software development methodology.
• Used Rally for user stories and downloaded the mapping specs and requirement.
• Involved in Design & Development of the Business Warehouse model.
• Implemented Dimension Model (logical and physical data modeling) in the existing architecture using ERWin
• Designed ETL processes to populate the fact and dimension tables with staging table data.
• Used Informatica Power Center Designer to extract data from different data sources.
• Created Mappings and Mapplets to load data from source systems into data warehouse.
• Created Different Transformations such as Joiner, Look-up, Rank, Expressions, Aggregator and Sequence Generator to implement the business rules
• Identified & Implemented Slowly Changing Dimension methodology for accessing the full history of accounts and transaction information
• Worked on various workflow tasks command Tasks, Decision & Assignment tasks etc. to schedule workflows.
• Session Partitioning for concurrent loading of data in to the target tables to improve the performance.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Performed Incremental Aggregation to load incremental data into Aggregate tables.
• Created Workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Responsible for enhancing the systems by implementing Informatica standards and mapping, workflow standards.
• Migrated code using repository manager and used static and dynamic deployment group for the migration in QA and staging and production environment.
• Scheduling of jobs using Autosys
• Involved in creation, backup, restoring, and performance tuning of Repository

Environment: Informatica 9.0.1, Informatica Schedular, Cognos 8.1, SQL developer tool, Erwin7.3, Oracle10g,Windows server 2008 R2

Confidential

Sr. Informatica Consultant

Responsibilities:

• Prepared the mapping design document using the specifications gathered from the Business Analysis teams
• Took part in the data modeling for datamart(shoe - mart) and created logical and physical tables in Teradata environment.
• Used Erwin forward engineering and backward engineering to modify existing data model.
• Created the ETL logic document and dependency mapping sheet.
• Worked on Teradata utilities like fastload, multiload and FastExport.
• Developed Teradata and Informatica based ETL scripts/jobs to meet client requirements.
• Load data from various source flatfile,excel source, xml, ORACLE, etc to stage table.
• Extract data using Informatica Powerconnect for mainframe(VSAM,DB2,ADABAS files ETC)
• Read the MQseries source data from portal using powerconnect for MQseries.
• Used XML generator to read Mq data and loaded into target table.
• Created range in excel source to import data from excel file source.
• Generated dynamic flat file using Informatica power center using transaction control transformation.
• Using delimited flat file load target file and generate excel reporting.
• Using excel formulas generate sales revenue pie charts.(per location wise )
• Created DSN for excel source in powercenter designer and seesion level.
• Created workflows with concurrent and sequential sessions as per requirement using control and email tasks.
• Load data from staging area into Teradata data warehousing using Bteq, Mload, fastload, TPT utilites.
• Worked on query tuning.
• Validated the data for accurate load into target databases.
• Involved in development of SQL Queries.
• Involved in writing scripts to schedule the different workflows.
• Tested the scripts and queries according to the requirements.
• Meeting and discussions within the team and also with onsite counterpart

Environment: Informatica Powercenter 9.1, AIX 6.1,Informatica powerconnect for mainframe and MQseries, Teradata 13.0, Teradata Parallel Transporter, FastLoad, MLOAD, Fast Export, Tpump, RHEL 6.4, Solaris 10, Windows XP

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Interacted with Business Analysts to gather the business requirements
• Analyzed the ETL logic to create the Ordertrack Application
• Using Erwin Modified existing data model and created logical and physical data model per requirement.
• Created the High Level and the Low Level Design documents according to the requirements
• Created the ETL logic document and dependency mapping sheet.
• Attended the weekly meetings with the BA’s and Java Developers to update the status of the application design
• Interacted with the data modeler team and created the data models according to the requirements.
• Created objects in shared folder of development area in Informatica Power Center.
• Created Mappings to load data from various sources to stage area tables
• Developed mapping using fixed width flat file and delimited flat file.
• Using flat file created change data capture mappings.
• Developed the Informatica workflows/sessions to extract, transform and load the data into Target Tables.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
• Implemented the Type1 and Type 2 Mappings and process insert/update strategies to load stage tables
• Created Mapping variables in parameter files to perform ETL process
• Wrote Pre-SQL and post SQL queries in source qualifier to maintain the flag to insert and update data
• Wrote complex SQL queries and PL/SQL procedures to perform database operations according to business requirements.
• Implemented the delta loading to load data from staging area to Ordertrack environment with the timestamp variable and maintained the change source capture in Informatica
• Wrote the test cases and test data to test the created ETL mapping for each schema
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems. Prepared Test Data/Unit Testing /Integrated testing and generated reports and documented various test cases.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Wrote UNIX scripts to maintain the workflows and to email customers and session log files to the development team in case of failures.
• Document all ETL related work per company's methodology.

Environment: Informatica PowerCenter 8.6.1, ORACLE10g, TOAD, AIX 6.1, Windows XP Professional, RHEL 5.6

Confidential, warren, NJ

Informatica Developer

Responsibilities:

• Interacted with Business Analyst team and analyzed the requirements to translate into Technical Specifications.
• Involved with Business Analyst for dealing with different sources Excel,Flatfile XMl,SAP etc
• Pull data using Informatica 8.6 from Excel workbook.
• Created Dsn connection and import using import fromu database option in Informatica.
• Installed and configured power connect for SAPR/3 and read tables and import source data from leagacy systems.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• As per the requirement, performed Initial loading, monthly loading and weekly cleanup update processing.
• Wrote PRE and POST SQL commands in session properties to manage constraints that improved performance.
• Performed Pushdown Optimization to increase the read and write throughput
• Wrote complex SQL queries and PL/SQL procedures to perform database operations according to business requirements.
• Performed defect fixes in various environments to ensure the proper delivery of the developed jobs into the production environment.
• Document all ETL related work per company's methodology.
• Synchronize Workflows with touch files to ensure proper delivery of data from source to stage to repository to mart.
• Schedule the workflows and using Autosys
• Involved in system end to end testing and performance tuning.
• Prepared estimates and tracked each and every task and strictly adhered to the estimated deadlines.

Environment: Informatica PowerCenter 8.6,PowerConnect for SAPR/3, DB2 UDB 8.0, Autosys, UNIX

Confidential, Charlotte, NC

ETL Developer

Responsibilities:

• Gathered business and technical requirements for the project
• Participated in business/technical discussions to understand the report requirements which involve client’s technical team to help us understand existing design.
• Designed reporting environment (database) based on the reporting technical requirements.
• Developed technical design documents and mappings specifications to build Informatica Mappings to load data into target tables adhering to the business rules.
• Designed and developed Extract Transform and Load (ETL) and Data Integration (ETL) solutions for complex functional and technical requirements using Informatica Power Center and Power Exchange.
• Designed and developed CDC and Datamap using Power Exchange 9.1.
• Creating Power Exchange Registration and Customizing power Exchange connection property and creating restart token.
• Involved in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Slowly Changing Dimensions, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.
• Hands on experience with Complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy and many more..
• Involved in migration of objects in all phases (DEV, QA and PRD) of project.
• Maintain existing code and fix bugs

Environment: Informatica Power Center 9.0.1, Informatica Powerexchange 9, ORACLE 10g,sql server, Toad, DB2, UNIX Shell Scripting, Microsoft Office

Confidential, Iselin NJ

Informatica Developer

Responsibilities:

• Interacted with business analysts to gather the business requirements by attending regular meetings with the business community.
• Performed Informatica Administrator functions like created repository, Groups Users, Folders, giving permissions on the folders to the users, etc.
• Used Power exchange data movement and CDC to move bulk amount of data in various platforms
• Extensively used command line tool like pmcmd, pmrep & pmrepagent.
• Used Informatica user defined functions to reduce the code dependency.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performing ETL & database code migrations across environments.
• Prepared ETL detail design and unit testing document to outline the flow of data, for testing source/targets counts and field-to-field mappings.
• Provided production support by running the jobs and fixing the bugs.
• Upgraded repositories from 8.1 to 8.6 version of Informatica.
• Took backup of the repository at regular interval depending on the amount of work done.
• Aided in migrating the code across various environments.
• Worked on test cases and test plans.
• Documented the process for further maintenance and production support.

Environment: Informatica Power Center 8.6, Informatica PowerExchange8.6,Autosys, ORACLE10g, SQL, PLSQL, WinSCP, DB2 9.1

Confidential

Software Engineer

Responsibilities:

• Involved in analysis, solution and low level design.
• Imported the data to the database through SQL * Loader.
• Created PL/SQL packages, procedures and triggers to populate the data and calculate the values required for the report.
• Created shell scripts to run various jobs, and invoke PL/SQL procedures and java programs.
• Created programs in PL/SQL for making different kinds of reports (Excel, XML, and CSV) based on the local configuration file.
• Used Inbuilt Oracle packages (UTIL PACKAGE) for sending out the reports to the email addresses configured.

Environment: Oracle 8i, PL/SQL, SQL* Loader, Core Java, HTML, Red Hat Linux.