SUMMARY:

• Innovated, detail - oriented, and results-focused professional seeking a position to further enhance and utilize skills, knowledge, and abilities honed from hands-on experience in Software field. Informatica Developer with 6 years of IT experience in Business Analysis, Design, Data Modeling, Implementation and Testing of Applications using wide range of Technologies including Data Warehousing, Database and reporting systems backed by al background in Master of Information Science& Engineering. Knowledgeable of Software Development Life Cycle (SDLC) using Waterfall, Rational Unified Process (RUP), and Agile methodologies.
• Strong Experience in using Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, Erwin, FACT and Dimensions Tables.
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer, Sales force lookup and transformation using various Source Qualifier, Router, Filter, Rank, Aggregator, Joiner, Update Strategy etc.
• Experienced in creating mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica.
• Good understanding of ETL, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Enterprise Data Warehouse Concepts.
• Extensively worked on Informatica Designer Components-Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor
• Involved in writing UNIX shell scripts to run the sessions.
• Developed Teradata Fast load scripts for initial loads, Mload scripts for data loads and BTEQ scripts for developing post load processes.
• Worked on Sales Force Cloud while loading data through Informatica.
• Collecting statistics and tuning based on UPI, NUPI, USI, and NUSI.
• Hands on experience on Data Profiling/IDQ tool
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs
• Experienced in ETL processes, using Informatica and Teradata.
• Performance tuning the Teradata database using the Teradata Statistics Wizard, Index Wizard, and Visual Explain Plan.
• Good experience in Performance of Data warehouse by SQL tuning, Query optimizer and Indexing.

TECHNICAL SKILLS:

• Informatica Power Center 10.1,9.6,9.5,9.1,8.6/7.1/6.2 |Teradata SQL |PL/SQL | SQL Server
• Teradata (V2R4.x/5.x/6.x/12.0,14.0) Oracle 11g/10g/9i/8.x/7.x | Informix | Teradata SQL Assistant 
• BTEQ | Fast Load | Multiload | Fast Export | TPump | | UNIX Shell Scripting| IDQ | Sales Force | Microsoft Dynamics| Quality Center| JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Informatica Developer

Responsibilities:

• Worked with Technical Architect for understanding the Requirements and Client Mapping Documents.
• Created Technical Mapping documents for ETL Development.
• Using the Informatica Power Center, analyzed the source data to extract and transform the data from various systems by incorporating the business rules by using different objects and functions.
• Used Common Components Standards in developing the code using different Mapplets and Procedures to contribute and maintain best practices for data integration application development.
• Utilized various transformations like Expression, Update Strategy, Stored Procedures and Union to create mappings in the Informatica Designer.
• Developed Data Migration mappings which reads from Flat Files and Loads into Landing/Staging zone tables.
• Developed Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, and Connected and Unconnected lookups, Stored Procedure, Filters, Sequence, Router and Update Strategy
• Translated the business process into Mappings for building Data mart.
• Used the debugger in Informatica to test the mapping and fix the bugs.
• Performed unit testing and system testing for troubleshooting the mappings and workflows.
• Performed Code migrations from User folder to QA and Production Environments.
• Maintenance/Support of the application, trouble shooting and Enhancements.
• Used JIRA to Log Defects for connection issues and for migrating Code from DEV to QA and Production Environments.
• Implemented Performance tuning technique and Optimization of mappings for better performance and efficiency
• Provide remedial measures to the production issues or process failure.
• Troubleshoot problems by checking Sessions and Error Logs. Also used Debugger for complex problem troubleshooting. Maintained the transformation rules, target and stored definitions by using the Informatica repository manager.

Environment: Informatica Power Center 10.1, Quality Center, SQL Server, JIRA, Informix, Oracle 9i/10g/11g, Unix

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Involved in the entire SDLC (Software Development Life Cycle) process that includes Implementation, testing, deployment, documentation, and maintenance.
• Extracted data from Oracle database transformed and loaded into Teradata warehouse according to the business specifications
• Analyzed business process and developed ETL procedures to move data from source to target systems.
• Worked on Power Exchange Sources and flat files to load the data into Oracle Target tables.
• Involved in parameterizing the code in order to change the necessary parameter files in UNIX without disturbing the rest of the code.
• Using Informatica tool loaded the data into Salesforce application tables.
• Extensively used SQL for accessing and manipulating database systems
• Performed Data Profiling on various source systems like SQL Server, Oracle and Flat files.
• Involved in Power Center Change Data Capture (CDC) process to minimize the resources required for ETL processes that deals only with data changes and ensure data synchronicity.
• Hands on experience on Informatica Data Quality tool.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Involved in troubleshooting complex problems by checking sessions and error logs.
• 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.
• Implemented performance tuning techniques by identifying and resolving bottlenecks in SQL Queries, Sources, Targets, transformations, and mappings to improve performance.
• Hands of knowledge in creating Shell scripts for automation and execution of the workflows.
• Performed Unit Testing and System Integration Testing of Informatica Mappings and created Test cases.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Developed and created various Informatica Mappings and Sessions based on the client requirements and rules to obtain the data from the source files and the database tables to the target tables
• Raised change requests, analyzed, and coordinated resolution of program flaws in Prod and QA environment, migrated the fixed code in Dev and to QA, preproduction and production environments according to change request approval.
• Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.

Environment: Informatica Power Center 9.6, Teradata 14, Teradata SQL Assistant, Sales Force, Informix, Quality Center, SQL Server, Oracle 9i/10g/11g, Unix

Confidential, Rochester, NY

InformaticaDeveloper

Responsibilities:

• Involved in creating Informatica mappings in uploading the Data files into the Staging tables and then finally into Data Warehouse system.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target and Transformation objects.
• Extracted data from Flat files, AS400 sources and loaded into Oracle staging and target tables applying business rules as per the requirement
• Developed Complex mappings to feed Data warehouse & Data marts by extensively using Informatica Mappings, Mapplets, and Transformations like Lookup, Filter, Router, Expression, Aggregator, Joiner, Stored Procedure and Update Strategy
• Created Informatica mappings with PL/SQL Procedures / Functions/triggers to build business rules to load data
• Implemented SCD Type1 and SCD Type2 techniques to update slowly changing dimension tables
• Created different reusable tasks like email tasks to send email and command tasks to create, rename and delete files
• Scheduled and ran Workflows for Extraction, loading processes and monitored the Workflows using Workflow Monitor. Used the Informatica parameters files for defining various workflow variables, relational connections and mapping variables
• Performed manipulations using Informatica transformations like Filter, Update Strategy, Expression, Normalizer and Lookup (Connected and Un-Connected).
• Implemented Performance tuning technique and Optimization of mappings for better performance and efficiency
• Provide remedial measures to the production issues or process failure.
• Troubleshoot problems by checking Sessions and Error Logs. Also used Debugger for complex problem troubleshooting
• Modified /Created parameter files in development, test and production environments using UNIX
• Developed unit test scripts and test cases for unit testing and system testing
• Involved in production deployments of the projects.
• Involved in UAT along with users to understand the data and to make any modifications if suggested by the user.

Environment: Informatica Power Center 8.6.1, TOAD, Oracle 11g, UNIX, PL/SQL, SQL Server, Quality Center

Confidential

Teradata Developer

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Involved in the Extraction, Transformation and Loading source files from the data warehouse on Teradata.
• Used External Loaders like Multi Load, TPump and Fast Load to load data into Teradata database.
• Created sessions and workflows to run in parallel, sequentially, and nested.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Developed schedules to automate the update processes andInformaticasessions and batches
• Built and maintained SQL scripts and queries for data extraction and analysis using MS SQL Server Database.

Confidential

Informatica Developer- Intern

Responsibilities:

• Involved in preparation of technical specifications to develop Informatica ETL mappings to load data into various staging, Data warehousing and Data marts.
• Involved in Designing Logical and physical data models using Erwin following Star Schema methodology.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Analyzed the functional specifications provided by the data architect and created Technical Specification Documents and Detail Design Documents for all the mappings.
• Fine-tuned the SQL queries on SQL Assistant, analyzed the Explain Plains and came up with Cost Effective Solutions.
• Created mappings and mapplets using the transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, Filter, Sequence Generator, Update Strategy.