PROFESSIONAL SUMMARY:

• 8 years of IT experience wif expertise in analysis, design, development and implementation of Data warehouses, data marts, ODS and Decision Support Systems (DSS) using ETL tools wif RDBMS like Oracle,Teradata, MS SQL server, DB2, and Netezzadatabases on Windows and UNIX platforms.
• Hands on experience in Informatica PowerCenter10.2/9.x/8.x
• Expert in working and implementing Water Fall Model as well as Agile Methodology. Involved in delivery of multiple sprints in project. Also played role as scrum master.
• Strong experience wif Informatica tools using real - time CDC (change data capture) and MD5.
• Experience in integration of various data sources like Oracle, Teradata, Netezza, Mainframes, SQL server, Flat files.
• Very strong in Data Warehousing Concepts like Dimensions, De-normalization, SCD Type I, II and III, Facts, Surrogate keys, ODS, Staging area and cube.
• Realistic understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling.
• Expert in writing pseudo code,SQL queries and optimizing the queries in Oracle, SQL Server and Teradata. Good understanding of Views,Materailized View, Synonyms, Indexes, Partitioning, Database Joins, Stats and Optimization.
• Experience in developing very complex mappings, reusable transformations, sessions and workflows using Informatica ETL tool to extract data from various sources and load into targets.
• Experience in tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulk load.
• Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Reduced the execution time for huge volumes of data for a company merger project. Heavily created mapplets, user defined functions, reusable transformations, look-ups.
• Experience wif Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, Tpump SQL Assistant.
• Expertise in SQL and PL/SQL programming and also excellent in Views, Analytical Functions, Stored Procedures, Functions and Triggers.
• Technical expertise in designing technical processes by using Internal Modeling &working wif Analytical Teams to create design specifications; successfully defined &designed critical ETL processes, Extraction Logic, Job Control Audit Tables, Dynamic Generation of Session Parameter File, File Mover Process, etc.
• Ability to lead other ETL developers in solving complex scenarios and coordinated wif source systems owners wif day-to-day ETL progress monitoring.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 10.2/9.1/8.x, Informatica PowerExchange 10.2/9.1/8.x

Languages: C, C++, SQL, PL/SQL, HTML, XML, UNIX Shell Scripting

Methodology: Agile, Waterfall

Databases: Oracle 11g/10g, SQL Server 2012/2008/2005/2000 DB2, Teradata 14/V2R5, UDB DB2,Sybase

OS: Windows NT, 2003, 2007, UNIX, Linux

Modelling Tool: Erwin 9.1/7.2, MS Visio

Scheduling Tools: Control-m 8.x/10

Reporting: Tableau 9.2, Cognos 8.x/10

Others Tool: JIRA, Notepad++, Teradata SQL Assistant, Teradata view point MS office, T-SQL, TOAD, SQL Developer, XML Files, Control - M, ORACLE ERP, PUTTY, SharePoint, SVN, PL/SQL Developer, TOAD, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Informatica Developer

Responsibilities:

• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked extensively wif mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Developed mapping to load Fact and Dimension tables, for type 1 and type 2 dimensions and incremental loading and unit tested the mappings.
• Extracted data from a web service source, transform data using a web service, and load data into a web service target.
• Coordinate and develop all documents related to ETL design and development.
• Involved in designing the Data Mart models wif ERwin using Star schema methodology.
• Used repository manager to create repository, user’s groups and managed users by setting up privileges and profile.
• Responsible for debugging and performance tuning of targets, sources, mappings and sessions.
• Optimized the mappings and implementing the complex business rules by creating re-usable transformations and Mapplets.
• Involved in writing BTEQ, MLOAD and TPUMP scripts to load the data into Teradata tables.
• Optimized the source queries in order to control the temp space and added delay intervals depending upon the business requirement for performance.
• Used Informatica workflow manager for creating, running the Batches and Sessions and scheduling them to run Confidential specified time.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and set up email delivery after execution.
• Preparing Functional Specifications, System Architecture/Design, Implementation Strategy, Test Plan & Test Cases.
• Implemented and documented all the best practices used for the data warehouse.
• Improving the performance of the ETL by indexing and caching.
• Created Workflows, tasks, database connections, FTP connections using workflow manager.
• Responsible for identifying bugs in existing mappings by analyzing data flow, evaluating transformations and fixing bugs.
• Code walks through wif team members.
• Created UNIX shell scripting for automation of ETL processes.
• Used UNIX for check in’s and check outs of workflows and config files in to the Clearcase.
• Experience in monitoring and reporting issues for the Daily, weekly and Monthly processes. Also, work on resolving issues on priority basis and report it to management.

Environment: Informatica PowerCenter 10.2, Tableau 9.2, SQL Server 2008,Oracle 11g, PL/SQL, TOAD, Putty, Autosys Scheduler, UNIX, Teradata 15, Erwin 7.5, WinSCP

Confidential, Plano, TX

Sr. Informatica Developer

Responsibilities:

• Gathering requirements and implement them into source to target mappings.
• Experience in integration of data sources like SQL server and MS access and non-relational sources like flat files into staging area.
• Designing custom reports via SQL Reporting Services to align wif requests from internal account teams and external Clients.
• TEMPEffectively worked on Mapping Designer, Workflow Manager, and Workflow Monitor.
• Extensively used Sequence Generator in all mappings and fixed bugs / tickets raised in production for existing mappings in common folder for new files through versioning (Check in and Check out) on an urgency through support for QA in component unit testing and validation.
• Used shortcuts for sources, targets, transformations, mapplets, and sessions to reuse objects wifout creating multiple objects in the repository and inherit changes made to the source automatically.
• Applied slowly changing Dimensions Type I and Type II on business requirements.
• Extensively worked on performance tuning and also in isolating header and footer in single file.
• Working wif large amounts of data independently executing data analysis, utilizing appropriate tools and techniques (Interpreting results and presenting them to both internal and external client.
• Writing SQL queries to create end-user reports /Developing SQL Queries and stored procedures in support of ongoing work and application support.
• Used Cognos Transformer to build multidimensional cubes
• Designing and executing test scripts and test scenarios, reconciling data between multiple data sources and systems.
• Involved in requirement gathering, Design, testing, project coordination and migration.
• Project planning and scoping, facilitating meetings for project phases, deliverables, escalations and approval. Ensure adherence to SDLC and project plan.
• Worked on Multidimensional Models and created Reports in Report Studio using Cubes as a data source.
• TEMPEffectively understood session error logs and used debugger to test mapping and fixed bugs in DEV in following change procedures and validation.
• Raised change requests, analyzed and coordinated resolution of program flaws and fixed them in DEV and Pre-Production environments, during the subsequent runs and PROD.
• Precisely documented mappings to ETL Technical Specification document for all stages for future reference.
• Scheduled jobs for running daily, weekly and monthly loads through control-M for each workflow in a sequence wif command and event tasks.
• Created requirement specifications documents, user interface guides, and functional specification documents, ETL technical specifications document and test case.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator Update Strategy, Rank, Expression, lookups (connected and unconnected), Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Responsible for studying the existing data warehouse and also working on migrating existing PL/SQL packages, stored procedures, triggers and functions to Informatica Power Center.
• Fine-tuned ETL processes by considering mapping and session performance issues.
• Responsible for Creating workflows and Worklets. Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.
• Maintained the proper communication between other teams and client.

Environment: Informatica Power Center 9.2, SQL, PL/SQL, UNIX, Shell Scripting, SQL Server 2008, Sybase, Oracle 11g, DB2, Control-M, Cognos 8.4

Confidential, NY,US

ETL Informatica Developer

Responsibilities:

• Worked wif business analyst for requirement gathering, business analysis and testing and project- coordination using interviews, document analysis, business process descriptions, scenarios and workflow analysis.
• Created Technical Design Document or Minor Release Document (MRD) from business requirements document (BRD) or Functional Requirement Document (FRD) business analyst based on business objectives, facilitated joint sessions.
• Analyzed business and system requirements to identify system impacts.
• Created flow diagrams and charts.
• Created the Detail Technical Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, Database changes, shell scripts etc. and conducted meetings wif the business analysis, clients for the Approval of the process.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Handled versioning and dependencies in Informatica.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Translated the PL/SQL logic into Informatica mappings including Database packages, stored procedures and views.
• Involved in extensive performance tuning by determining bottlenecks Confidential various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Created UNIX scripts to read/write and ftp files from and to windows servers and UNIX.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test and supported the UAT for the client.
• Performing ETL and database code migrations across environments using deployment groups.
• Populating the business rules using mappings into the target tables.
• Involved in end-to-end system testing, performance and regression testing and data validations.
• Worked extensively on modifying and updating existing oracle code including object types, views, PL/SQL stored procedures and packages, functions and triggers based on business requirements.
• Worked in agile minor release cycles the designated database developer.
• Unit test and support QA and UAT testing for database changes.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production.
• Help support Data masking projects for DRD for all Dev, QA and UAT environments via Enterprise Data Obfuscation.
• Build creation, verification and deployment to QA and UAT using Transporter.
• Created batch scripts for automated database build deployment.

Environment: Informatica Power Center 8.6, SQL, PL/SQL, UNIX, Shell Scripting, Oracle 11g, Cognos 8.4

Confidential, Miami, FL

ETL Informatica Developer

Responsibilities:

• Translated requirements into business rules & made recommendations for innovative IT solutions.
• Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this data migration project.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked wif PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle database.
• UsedInformaticaas an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Worked onInformaticaPowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping Designer & Mapplets, and Transformations.
• Maintained Development, Test and Production Mappings, migration using Repository Manager. Involved in enhancements and Maintenance activities of the data warehouse.
• Performance tuning of the process Confidential the mapping level, session level, source level, and the target level.
• Used Teradata utilizes like FASTLOAD, MLOAD, and FASTEXPORT also wrote many BTEQ Script for loading data into target table.
• Implemented various new components like increasing the DTM Buffer Size, Database Estimation, Incremental Loading, Incremental aggregation, Validation Techniques, and load efficiency.
• Strong on Exception Handling Mappings for Data Quality, Data Cleansing and Data Validation.
• Worked wif SQL*Loader to load data from flat files obtained from various facilities.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Developed Parameter files for passing values to the mappings for each type of client
• Scheduled batch and sessions wifin Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Understanding the entire functionality and major algorithms of the project and adhering to the company testing process.

Environment: Informatica PowerCenter 8.6, SQL Server 2008, Teradata V2R5, Oracle 10g, Shell Scripts, Erwin 7.5, TOAD, UNIX, Cognos 9, SQL, PL/SQL, UNIX, Toad, SQL Developer, HP Quality Center

Confidential, Minneapolis, Minnesota, US

ETL Informatica Developer

Responsibilities:

• Designed and developed complex mappings using Mapping Designer to load data from various sources.
• Extensively created mapplets for reusable business rules.
• Used Pipeline partitioning and External Loader to improve Session performance, created indicator files for event driven sessions.
• Used the update strategy to TEMPeffectively load data from source to target.
• Used Teradata utility like BTEQ, FLOAD and MLOAD; scripts to load the data into Teradata tables.
• Created tasks, workflows and worklets using workflow manager.
• Used pmcmd to run workflows and Autosys to automate their schedules.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so dat they conform to the business needs.
• Handled Incremental loading using mapping variables and Implemented versioning of folders in the Informatica Designer tool.
• Used Parameter files to specify DB Connection parameters for sources.

Environment:Informatica PowerCenter 8.0, Oracle 11g, PL/SQL Developer, MySQL, RDS MySQL, Teradata V2R5, Putty, Control-M 8, Cognos 8.2.