SUMMARY:

• 9 years of IT experience in Development, Test, administration & analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverable within committed deadlines.
• Having experience in interacting with the client in requirement gathering.
• Developed in Informatica, QlikView and Talend for Dashboards, Data Visualizations projects working on Tableau Engineer/ BI/Reporting platform to enable data access, analytic models, and data visualization.
• Having sound knowledge on OLTP, ODS and EDW data modeling (logical and physical design, and schema generation) using Erwin, ER/Studio and other tools for Teradata, Oracle, DB2/UDB and MS SQL Server models & repositories.
• Extensive experience in loading high volume data, requirements gathering, analysis, design, development, test and implementation.
• Strong Data Warehousing ETL experience of using Informatica 9.6/9.5/8.6.1/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Good knowledge in Teradata 14/13/12/V2R6.2/V2R5, Data Load/Unload utilities like BTEQ, FastLoad, MultiLoad, Tpump, FastExport.
• Proficient in analysis of user requirements and functional specifications.
• Exclusive experience in ETL process and ETL development.
• Strong Emphasis in reviewing End-to-End test requirements, assigning appropriate resources, and initiate the End-to-End planning process.
• Good understanding of the Software Development Life Cycle (SDLC).
• Excellent in interacting with developers at various levels and understanding technical specifications, documentation of the application to be tested.
• Involved in development of Informatica mappings with required transformations like Aggregator, Filter, Lookup, Sorter, Normalizer, Update strategy etc.
• Strong Knowledge on Power center Designer,Workflow Manager,Workflow Monitor.
• Creating sessions and Workflows using Informatica Workflow Manager.
• Used complex transformations like Lookup, Update Strategy, Sequence Generator and Stored Procedure while Developing Mapplets and Mappings using Informatica Designer Tool.
• Involved in Performance Tuning at mapping level and session level.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Strong hands on experience using Teradata utilities (FastExport, MultiLoad, FastLoad, Tpump, TPT, BTEQ and QueryMan).
• Having good knowledge in Autosys,ALM/QC and Clear Quest.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning.
• Proficient in Teradata database design (conceptual and physical), Query optimization, Performance Tuning.
• Having knowledge on Teradata Parallel Transporter Wizard.
• Extensive experience with managing, leading various complex data warehousing applications and installations, integrations, upgrades, maintenances of ETL, Datamart Siebel 7.0/2000/5.5 , Siebel Warehouse 6.3, Siebel EIM, OLAP, OLTP, Autosys, Control M, Sybase, BI, data cleansing, data profiling tools.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant and Query man.
• Expertise in writing large/complex queries using SQL.
• Strong knowledge on Ab Initio GDE ( 3.0/1.15/1.14/1.13 ), Co>Op (3.0/2.15/2.14/2.13/2.12/2.11 ).
• Good Knowledge in Dimensional Data modeling, Star/Snowflake schema design, Fact and Dimensional tables, Physical and Logical data modeling.
• Experience with business intelligence reporting tools using Business Objects, Cognos and Hyperion.
• Experience in supporting large databases, troubleshooting the problems.
• Experience in all phases of SDLC like system analysis, application design, development, testing and implementation of data warehouse and non-data warehouse projects.
• Excellent ability with competitive spirit in finding various approaches for problem solving and highly skillful, creative and innovative in developing efficient logic/code.
• Proficiency in prioritizing and multi-tasking to ensure that tasks are completed on time
• Good Communication and interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.6/9.5/8.6.1/8.1/7.1 , OBIA,AbInitio(GDE 3.0/1.15/1.14/1.13 ),Co-op (3.0/2.15/2.14/2.13/2.12/2.11 ) SSIS

Teradata Tools: BTEQ, Teradata SQL Assistant, Teradata Manager, PMON, Teradata Administrator, ARCMAIN.

DB Tools: SQL*Plus, SQL Loader, TOAD, OBIEE, BTEQ, Fast Load, Multiload, FastExport, SQL Assistant, Teradata Administrator, PMON, Teradata Manager, Microstrategy. Cognos, Microstrategy, BO

Databases: Teradata 14/13/12/V2R6.2/V2R5, Oracle 10g, DB2, MS-SQL Server 2000/2005/2008 , MS-Access, Oracle, Mainframe

Scheduling Tools: Autosys

Version Control Tools: Clear Case

Programming Languages: C, C++, Java, J2EE, Visual Basic, SQL, PL/SQL,Siebel,Python and UNIX Shell Scripting

Data Modelling /Methodologies: Logical/Physical/Dimensional, Star/Snowflake, ETL, OLAP, Complete Software Development Cycle. ERWIN 4.0

Operating Systems: Sun Solaris 2.6/2.7/2.8/8.0 , Linux, Windows, UNIX

EXPERIENCE:

Confidential, Boca Raton, FL

Sr Informatica Developer

Responsibilities:

• Created Mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Router, Joiner, etc.
• Understanding of Bussiness Requirement Documents, Data models & Architecture of project.
• Used BI and analytic tools, Business Objects, QlikView, Tableau, Netezza Agile, Waterfall, Scrum development methodology, Web Services, Hyperion, OBIEE, Informatica IDQ/Power Center.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager
• Understanding of Requirements Specification and analysis of source systems.
• Involved in Developing Mappings and Mapplets using Informatica Designer Tool.
• Used complex transformations like Lookup, Update Strategy, Sequence Generator and Stored Procedure while Developing Mapplets and Mappings using Informatica Designer Tool.
• Worked as a Tableau Engineer/ BI/Reporting platform to enable data access, analytic models, and visualization.
• Involved in Creating sessions and Workflows using Informatica Workflow Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Involved in Performance Tuning at mapping level and session level.
• Involved in Unit Testing and Preparing test cases.

Environment: Informatica Power Center, Oracle, OBIEE, Windows, UNIX, Tableau, Netezza, QlikView

Confidential, Reston, VA

Sr Informatica/Teradata Developer

Responsibilities:

• Worked with various Business users to gather reporting requirements and understand the intent of reports and attended meetings to provide updates on status of the projects.
• Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Developed complex Mappings, Mapplets and Reusable Transformations to facilitate daily loading of Data into Oracle.
• Responsible for coordinating with the upstream teams to get the data into system.
• Responsible for validating the ETL transformation logic.
• Analyzing and troubleshooting the issues that were found.
• Responsible for running autosys jobs.

Environment: Abinitio, Autosys, Informatica, Business Objects XI R3, ALM/Quality Center, Clear Quest, Clear Case, Oracle 9i/10g,Toad and Win XP.

Confidential, Cincinnati, OH

Sr Informatica/Teradata/ETL Developer

Responsibilities:

• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Developed complex Mappings, Mapplets and Reusable Transformations to facilitate daily loading of Data into Oracle.
• Performed Unit testing of the mappings developed.
• Created transformations and used Aggregator, Expression, Sequence Generator, Joiner, Filter, Router, Look up and Update Strategy transformations to model various standardized business processes.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Modified existing mappings for enhancements of new business requirements.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.Responsible for coordinating with the upstream teams to get the data into system.
• Loaded data into test databases by executing autosys box and validated the data.
• Created new Informatica mappings, sessions, Worklets and Workflows to in corporate the enhancements requirement.
• Giving KT to the new joiners and freshers in the team about project architecture, Loads and data issues.
• Responsible for validating the ETL transformation logic.
• Responisible for running autosys jobs.
• Helping to the team members in fixing the issues, developing the jobs and analyzing the code.
• Analyzing the data loads, identifying the dependency and changing the load sequence in busy schedules.
• Monitoring the daily, weekly and monthly data loads and fixing the load failures.
• Automated the jobs through scheduling using Built in informatica scheduler.
• Performance tuned and optimized various complex SQL queries.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements.

Environment: Informatica Power Center 8.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange,Teradata SQL Assistant, Windows NT,Autosys,UNIX,Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT.

Confidential, Atlanta, GA

Sr Informatica/Teradata/ETL Developer

Responsibilities:

• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Created Mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Router, Joiner, etc.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Migrated data with help of Teradata FastExport, Insert/ Select, flat files from one system to another.
• Involved in test data set up and data quality testing and Unit testing and Integration Testing.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Performance tuning, monitoring and index selection while using PMON, Teradata Dashboard, Statistics wizard and Index wizard and Teradata Visual Explain to see the flow of SQL queries in the form of Icons to make the join plans more effective and fast.
• Providing suggestions for best join plans while visualizing SQL queries with Visual Explain and Explain while recommending best Join Indexes such as Single table or multi table join indexes.
• Supporting jobs running in production for failure resolution with tracking failure reasons and providing best resolution in timely manner.
• Interaction with different teams for finding failure of jobs running in production systems and providing solution, restarting the jobs and making sure jobs complete in the specified time window.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica PowerCenter Designer 8.6/8.1, Informatica Repository Manager, Teradata, shell scripting, SQL Assistant, Cognos, Windows Vista, Erwin, Autosys.

Confidential, NJ

Sr Informatica Developer

Responsibilities:

• Worked with various Business users to gather reporting requirements and understand the intent of reports and attended meetings to provide updates on status of the projects.
• Understanding of Bussiness Requirement Documents, Data models & Architecture of project.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting. eveloped complex Mappings, Mapplets and Reusable Transformations to facilitate daily loading of Data into Oracle.
• Performed Unit testing of the mappings developed.
• Created transformations and used Aggregator, Expression, Sequence Generator, Joiner, Filter, Router, Look up and Update Strategy transformations to model various standardized business processes.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Modified existing mappings for enhancements of new business requirements.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica, Business Objects, Autosys, Oracle, Shell Scripts,OBIEE, HP unix, Windows XP, Erwin.

Confidential, Dearborn, MI

Sr Informatica/Teradata/ETL Developer

Responsibilities:

• Involved in understanding the Requirements of the End Users/Business Analysts and Developed Strategies for ETL processes.
• Configured the source and target database connections using .dbc files
• Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier,Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Developed reusable Mapplets and Transformations.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Created proper Teradata Primary Indexes taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
• Involved in performance tuning for Teradata SQL statements using Teradata Explain command.
• Tuning of Teradata SQL statements using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes.
• Prepared the testcase documents and other technical specification documents.

Environment: Informatica Power Center, Informatica Repository Manager,Teradata, Teradata SQL Assistant, Fast Load, BTEQ, MLOAD, Business Objects, Shell Scripts, HP unix, Windows XP.