SUMMARY

• Around 8+ years of professional IT experience in Systems Design, Development, Testing, Integration, Documentation, and Implementation of large/complex projects for reputed industries.
• ETL Developer experience working on Data warehousing and Business Intelligence applications using ETL tools with Oracle, DB2, MS SQL server andTeradatadatabases on windows and UNIX platforms.
• Experience in Application Design, Data Extraction, Data Acquisition, Data Mining, Development, Implementations and Testing of Data warehousing and Database business systems.
• Expertise in performance tuning of SQL and ETL code and writing efficient and complex queries on huge volumes of data.
• Expert in designing and developing Unix Shell Scripts for automation of ETL Processes, Error handling and auditing.
• Good knowledge in Data Modeling using data Modelers, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files - fixed width and delimited files, Oracle, SQL Server, XML files, Applications andTeradata.
• Expert level experience in Data Integration and Data Warehousing using ETL tool Informatica Power Center, Power Exchange, Power Mart, Power Analyzer and Power Connect.
• Profound Experience in Project Environment setup such as Installation, configuration and Administration of Informatica products Client/Server environment.
• Strong experience in developing mappings and worklets using transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Joiner, Update Strategy, Java Transformations and Re-usable transformations.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.
• Design and developed Semantic views based on business needs.
• Refreshed the data by using fastexport and fastload utilities.
• Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
• Designed ETL architecture, created data flow diagrams, process flow diagrams, and high level ETL design.
• 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 but also provide a good data lineage.
• Developed Informatica mappings with Pushdown Optimization (PDO) to load data from Staging to the EDW layer.
• Designed and developed ETL job orchestration framework, CDC framework and Data Quality framework.
• Coded complex scripts for theTeradataUtilities and fine-tuned the queries to enhance performance.
• Expertise in creatingdatabases, users, tables, triggers,macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Extensively worked with Teradata utilities likeTeradataSQL Assistant, BTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, TeradataSQL Assistantand Query man.
• Experience in PL/SQL Programming (Stored procedures, Triggers, Packages).
• Working experience inAgile Methodologyand the SCRUM process using tools like JIRA.
• Well versed with all stages ofSoftware Development Life Cycle (SDLC)i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.

TECHNICAL SKILLS

Operating Systems: UNIX, LINUX, Windows

ETL Tools: Informatica PowerCenter 8.X/9.5.1, PowerMart 6.X/7.X, PowerExchange(PowerConnect )8.X

Teradata Tools: Teradata ViewPoint, Teradata Manager, Performance Monitor, Teradata SQL Assistant, BTEQ, Teradata Administrator, Teradata Dynamic Workload Manager, Data Mover, Unity Director, TSET, Priority Scheduler, Teradata Index Wizard, Teradata Statistics Wizard, Teradata Visual Explain, MultiLoad, FastLoad, FastExport, Informatica, Tpump, SQL*Plus, Peregrine ServiceCenter, ITSM(Information Technology Service Management).

Database: Oracle 8i/9i/10g/11i, Teradata 13.10/14, DB2 V9, MS-SQL Server 2000/2005/2008

Load utilities: Informatica, TPT, Fastload, Fastexport, Multiload, Tpump, Bteq

Tools: JIRA, Erwin, Sharepoint, MS Vizio, HP Service Manager, Tivoli, Job Tracker, Business Objects, Content Manager, Citrix, Quality Center, Remedy, DocDirect,and Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Columbus-OH

Sr Informatica/Teradata Developer

Responsibilities:

• Analyzing the requirements and making functional specification by discussing with business user groups and translate the Business Requirements and documented source-to-target mappings and ETL specifications.
• Solid experience in performance tuning on Teradata SQL Queries and Informatica mappings
• Worked on Teradata SQL Assistant, Teradata administrator, Teradata view point and BTEQ scripts.
• Experience in migrations of project's application interfaces.
• Implemented PL/SQL queries, triggers and Stored Procedures as per the design and development related requirements of the project.
• Handling the File transfer through SFTP Scripts, which are running through Informatica and also having some Unix Shell Scripts used to send mails to Clients whenever there is success or failure depending upon the Business requirements to the Customers.
• Extensively used the Teradata utilities like BTEQ scripts, MLOAD and FLOAD scripts to load the huge volume of data.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.
• Designed ETL processes for optimal performance.
• Design and developed Semantic views based on business needs.
• Experience in the Business Intelligence field covering expertise of looking at designing semantic layers in Teradata
• Experiencein the field of Data Modelling and Semantic design of complex data models
• Worked on moving the code from DEV to QA to PROD and performed complete Unit Testing, Integration Testing, user Acceptance Testing for the three environments while moving the code.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse.
• Created Parameter files to pass database connections, parameter entries for source and target.
• Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables.
• Worked on Informatica Advanced concepts & also Implementation ofInformatica Push Down Optimization technology
• Exclusively used Informatica optimization techniques like push down optimization and pipeline partitioning.
• Implemented Target Load Plan and Pre Session and Post Session Scripts.
• Created test cases and test scripts to validate data.
• Review the detail level design and ensure that the IT standards are followed.
• Created complex Informatica mappings, re-usable transformations and prepared various mappings to load the data into different stages like landing, staging and target tables.
• Worked with cross-functional teams to resolve the issues.
• Used the debugger in Informatica to test the mapping and fix the mappings.
• Worked on various lookup caches like static, dynamic and persistent.
• Developed Informatica mappings with Pushdown Optimization (PDO) to load data from Staging to the EDW layer.
• Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy for designing and Optimizing.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Involved in the defect analysis for UAT environment along with users to understand the data and to make any modifications to code.
• Performed root cause analysis and resolved complex issues.
• Ability to design EDW and Semantic layer for BI.
• Created SQL Queries to validate the data in both source and target databases.
• Prepared the recovery process in case of workflow failure due to database issues or network issues.
• Conduct a thorough code review and ensure that the outcome is in line with the objective and all the processes and standards are followed.

Environment: Teradata 14/13.10, Teradata SQL Assistance, Teradata Utilities, Mload, Fastload, FastExport, BTEQ, Informatica Power Center 9.5/9.1, Power Exchange 9.0.1, Windows, UNIX.

Confidential, IL

Sr. Informatica/Teradata Developer

Responsibilities:

• Coding all the Teradata SQL part of the project.
• Refresh data across environments from Informatica mappings.
• Applied slowly changing dimension type 2 effectively to handle the delta Loads.
• Worked on Teradata SQL Assistant, Teradata administrator, Teradata viewpoint and BTEQ scripts.
• Experience in migrations of project's application interfaces.
• Implemented PL/SQL queries, triggers and Stored Procedures as per the design and development related requirements of the project.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Extensively used the Teradata utilities like BTEQ scripts, MLOAD and FLOAD scripts to load the huge volume of data.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Teradata and Delimited Flat files.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error-handling document to maintain the error handling process.
• Automated the Informatica jobs using UNIX shell scripting.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Refresh data across environments.
• Analyzing the Asset Management Subject Area.

Environment: Teradata 13, Teradata SQL Assistance, Teradata Utilities, Mload, Fastload, FastExport, BTEQ, PMON, Informatica PowerCenter 9.1.

Confidential, IL

Sr. Informatica/Teradata Developer

Responsibilities:

• Involved in Full Life Cycle development for building a data warehouse.
• Worked with team members to design and develop customization for Siebel Analytics ETL Mappings in variable environment for Siebel Marketing and Call Center applications.
• Involved in gathering of business scope and technical requirements and written technical specifications.
• Extracted client information data and history from DB2 into flat files, transformed and loaded into Teradata database.
• Worked with the MULTILOAD utility of Teradata database for better performance.
• Worked with Teradata BTEQ to run the scripts in batch mode.
• Wrote Functions and Stored procedures in Teradata Database.
• Created Teradata security macros to create, modify and remove users and Grant/Revoke their access privileges.
• Gathered business requirements from users and groups to create Base views and secref (security ) views as per their roles.
• Extensively used BTEQ, Query Man and WinDDI for database creation, moving space between databases altering spool space and user creation and management in Teradata.
• Error handling and support of existing applications for failed reloads using Teradata MLOAD, BTEQ and Fast Load.
• Load balancing of ETL processes, database performance tuning and Capacity monitoring.
• Optimization and tuning of SQL's for fixing Teradata Spool issues.
• Written UNIX Scripts for event automation and input file validations.
• Worked with Informatica Workflow Manager to create scheduled workflows.
• Extensively worked on Informatica Workflow Manager, Workflow Monitor, Designer and Repository Manager.
• Designed Complex Mappings, used lookup (Connected and Unconnected), Update Strategy and Filter transformations for loading data.
• Did Unit Testing and make sure the code matches with the design.

Environment: Teradata V2R12, Teradata SQL Assistance, Teradata Utilities, Mload, Fastload, FastExport, BTEQ, PMON, Informatica PowerCenter 8.6.1.

Confidential - Manhattan, NY

ETL/Teradata Developer

Responsibilities:

• Analysis and Understanding the ETL and Reporting requirements based on the design document
• Participated in Daily meeting with Business Units to resolve any issues/concerns.
• Created mappings in Informatica to in corporate the business requirements.
• Used Teradata Mload and FastLoad utilities through Informatica external loader.
• 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.
• Extensively used ETL to load data from wide range of source such as flat files, oracle.
• Used Event wait task to create dependencies between workflows.
• Developed and Implemented different transformation techniques for identifying slowly changing Dimensions as per technical specifications.
• Extensively wrote the SQLs based on the given scenarios and created queries for testing and validation of the mapping.
• Wrote BTEQ scripts in UNIX to grab the Load Id and generate the Parameter file.

Environment: Informatica Power Center 8.6/8.5, LINUX, BTEQ, Teradata SQL Assistant, Mload, UNIX, Fastload, FastExport

Confidential - Madison, WI

ETL/Informatica Developer

Responsibilities:

• Gathered business requirements from business users and prepared functional specifications for various interfaces and Data Migrations.
• Developed ETL jobs to load data into XML files from Oracle database.
• Developed various mapping to migrate the data from ADMIN/LIMS to Darwin.
• Used Integration Manager to load data from XML files into Darwin system.
• Extensively worked on developing and modification of ETL Mappings using various Transformations like Source Qualifiers, Expression, Lookup, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Router transformations in Informatica Designer
• Extensively worked on creating Workflows for various Interfaces and Data Migrations
• Developed UNIX shell scripts to execute interfaces and data migration mappings.
• Scheduled workflows using UNIX command tasks to automate the entire process of fetching the source file from a different path and ftp it onto the server.
• Involved in creation of target tables in Oracle and Informatica mappings and workflows and executing them through UNIX Shell Scripts.
• Worked with heterogeneous sources from various channels like Sybase, Oracle, Flat files.
• Developed FTP scripts to move files across different servers.
• Files, XML Files and Excel files to target Oracle Data Warehouse.
• Loading the OLTP data into the Warehouse OLAP and built the Re-usable.
• Created various UNIX Shell Scripts for scheduling, data cleansing and loading process.
• Used pmcmd command in the UNIX shell scripts.
• Involved in Testing of Interfaces and Data Migrations.

ENVIRONMENT: PowerCenter 8.6, Integration Manager, Oracle11g, SQL, PL/SQL, Unix Shell Scripts (Korn), Windows XP, TOAD 8.5, MQ series, ClearCase Explorer, Documentum.

Confidential

Teradata Developer

Responsibilities:

• Loading business data into Teradata data warehouse.
• Involved in Performance Tuning of Queries.
• Involved in the development scripts for data loading through Fast Export, Fast Load, Multi Load, BTEQ utilities.
• Created Procedures to load data from view into tables and executed it using BTEQ Session.
• Developed BTEQ scripts to add the logic to get the related data from the source database.
• Communication with Architect and principal programmers to get the clarifications on transformation rules.
• Worked closely with the Teradata DBA and the Source DB teams to get the clarifications in optimizing SQL scripts.

Environment: Windows, Teradata V2R3, Teradata SQL Assistant, Microsoft Excel, and Teradata Utilities.

Confidential

Informatica Developer

Responsibilities:

• Extracting data from sources like Oracle and Flat Files. And transforming them using the business logic and loading the data to the target warehouses.
• Analyzing Source Database Objects as per the warehouse Database requirements.
• Designed mapping Requirement Diagrams based on Source and Target Databases.
• Developed mappings as per the Requirement, Using the Transformations such as Source Qualifier, Aggregator, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc.,
• Handled Multiple Database Connectivity including oracle, SQL Server, MS Acess, XML Files, Text Files etc.
• Developed User defined Transformation and Mapplets for Reusability of code.
• Improved Performance of mappings by using transformation in proper sequences and using multiple pipelines and using caches.
• Extensively used Dynamic and Static Lookup to improve the performance of mapping rather than Joiner Transformations.
• Dimensional modeling techniques using Star and Galaxy Schema Modeling.
• Tested Mappings using Debugger and Workflow Manager using Test Scripts for Accuracy of Data as well as for Performance.
• Involved in unit test.

Environment: Windows 2003 Server, Informatica7.1, Oracle 9i, Flat Files.