SUMMARY

• Over 7 Plus years of IT experience in Software Development, with specialization in Data Warehousing using Informatica and Oracle based Client server computing.
• Experience in all activities related to the development, implementation, testing and Production support of ETL processes for large - scale data warehouses using Informatica Power Center.
• Thorough knowledge of Data warehouse concepts with complete hands-on experience in conceptualizing designing, building, testing and building Enterprise Data warehouse from multiple source systems using Informatica Power Center
• Experienced in OLTP/OLAP system study, analysis and ER modeling. Hands on experience in handling data from various source systems such as Flat Files, XML Source, Oracle, MS SQL Server, IBM DB2, Teradata and Excel Files.
• Having good expertise in migrating various Informatica power center mappings and sessions from one version to another.
• Experience in Teradata load performing using the utilities FASTLOAD, MULTILOAD, TPUMP, TPT and BTEQ scripts.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations. Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings.
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle, SQL Server and MS Access, Sybase.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL ServerSSIS.
• Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.
• Experience in creating jobs, SQL Mail Agent, Alerts and scheduleSSISPackages.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages toSSIS, Package Migration Wizard, and Storage Management.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2008/2005 (SSRS).
• Highly skilled in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables,
• Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports usingSSRS.
• Good experience in creating and using Stored Procedures, Functions, Triggers, Views and packages in Oracle database.
• Having brief practical knowledge on POWER EXCHANGE NAVIGATOIR, POWER EXCHANGE.
• Extensively involved in data migration to data conversion using Sql server as source and target is dynamics, so in this process extensively involved in creating time stamps between source and target by using power exchange change data capture (CDC). Have good experience on Monitoring and Scheduling of Jobs using UNIX Shell Script and BTEQ Scripts.
• Extensive Shell scripting experience for scheduling, Process Automation and periodic job scheduling.
• Expertise in slowly changing dimensions’ type 1 and type 2 to maintain the history of records.
• Experience in working with testing team to create test cases for unit and system testing.
• Experienced in Performance Tuning of sources, targets, mappings, transformations and sessions. Experienced in Database Partitioning and Informatica Partitioning.
• Experienced in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation. A quick learner with an aptitude for taking responsibilities.
• Excellent skills in understanding business needs and converting them into technical solutions.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.5/8.x/7.X/6.X (Repository Administration Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor)

Job Scheduling: Informatica Scheduler, Autosys,CDC,CMC

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2014/2012/2008/2008 R2/2005 and Teradata

Applications: MS Word, MS Excel, MS PowerPoint, MS Outlook

DB Tools: Oracle SQL developer, Toad, SQL* Loader

Operating systems: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr. Informatica Developer

Responsibilities:

• Involved in requirement gathering from the business users and converted them into mapping documentation.
• Designed the Mapping Technical Specifications on the basis of Functional Requirements.
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
• Developed ETL programs using Informatica to implement the business requirements, Using Agile Scrum Model.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Union, Rank, Sequence Generator, Update Strategy, Source Qualifier Transformations, Mapplets, Reusable Transformations and Data Recovery Process.
• Involved in error handling, debugging and troubleshooting sessions using the Session logs, Debugger and Workflow Monitor.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and unit tested the mappings.
• Extracted data from Flat files, DB2, Oracle, XML and Loaded into Teradata data warehouse.
• Wrote several Teradata BTEQ scripts to implement the business logic.
• Used Teradata Utilities (FASTLOAD, MULTILOAD, and FASTEXPORT) and queried the Target database for validation.
• Developed application views in Teradata and using expression and router transformations simplified the data.
• Developed the Informatica mappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, Excel files etc.
• Created Informatica mappings with modification on PL/SQL procedures/functions to build business rules to load data.
• Developing Informatica Mappings and Workflows to extract data and to load into Teradata staging area using Fast Load/Tpump utilities.
• Responsible for migration of Source and Target definitions, Mappings, Workflows, and Flat Files from development environment to the production environment.
• Involved in performance tuning of the Informatica sessions and workflows.
• Involved in enhancements and maintenance activities of the data warehouses concepts including tuning, modifying of stored procedures for code enhancements.
• Experience in creating complexSSISpackages using proper control and data flow elements.
• Worked on multiple transformations provided bySSISsuch as Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support.
• Created ETL metadata reports usingSSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Responsible for Data migration from SQL Server 2000, 2005 to SQL Server 2012 Databases.
• Applied conditional formatting inSSRSto highlight key areas in the report data Used Report Builder to do Ad-hoc Reporting.
• Implemented the Web Service, XML Service for data interaction between app and the DB2 server database.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively worked on Onsite and Offshore work model.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Developed and executed UNIX scripts to schedule loads, through wrapper shell scripts for calling Informatica workflows using PMCMD command Experience scheduling of ETL jobs using Crontab, Control-M.
• Extensively used Perl scriptsto edit the xml files and calculate line count according to the client\'s need.
• Writing Perl script to execute power mart command and also to load data from source xml’s to Staging tables, to purge data from tables, to purge files from respective paths.

Environment: Informatica Power Center, Teradata, Control M, Informatica Data Quality, PL/SQL, Oracle, SQL Server, DB2, Web Services and Windows, SSIS, SSRS.

Confidential, Keene, NH

Informatica Developer

Responsibilities:

• Involved in development phase meetings for Business Analysis and requirements gathering.
• Worked with users and developers on requirement issues and gap analysis.
• Developed and Implemented ETL processes using Informatica client tools - Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Developed Source to Target Mappings using Informatica Power Center Designer to load data from various source systems like Oracle and Flat files to the target tables.
• Designed and developed complex aggregate, join, look up transformation rules to generate consolidated (fact/summary) data.
• Involved in Change data capture process using Slowly Changing Dimensions.
• Involved in Optimizing and Performance tuning on targets, sources, mappings, and sessions to increase the efficiency of session.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Experienced introubleshootingTeradata scripts, fixing bugs and addressingproduction issues andperformance tuning
• Involved in the process of scheduling Workflows using Autosys.
• Involved in developing SQL Scripts for extraction and loading of data to data warehouse.
• Developed Test Cases for Unit Testing, and also involved in Integration, system, and performance testing levels.
• Create and maintain shell scripts for pre/post session operations.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• UsedSSISto populate data from various data sources, creating packages for different data loading operations for applications.
• Created Complex Stored Procedure, Triggers, and Cursors, Tables, Views and other T-SQL JOIN techniques
• Generated parameterized reports, sub reports, tabular reports usingSSRS.
• Created SQL Server Drill down, Drill through, Adhoc, Cross tab report usingSSRSto fit business requirements.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated reports usingSSRSwhich were send to different Primary Vendors, Clients, and managers.
• Developed UNIX shell scripts to automate the data transfer (FTP) process to and from the Source systems.
• Developed various Mapplets, Transformations and validated and fine-tuned the ETL logic coded into mappings.
• Involved in preparing detailed ETL design documents.
• Analyzed the business requirements provided by the business analysts and functional specifications provided by the data architect and created the impact analysis and the technical specifications documents for the mappings.
• Developed all the Shell scripts which is required for the Application.
• Analyze functional specifications and prepared Impact analysis document, ETL Spec, Technical design document and KT document.
• Re-designed ETL mappings to improve data quality.
• Analyzing tables and indexes for performance tuning.
• Developed Scripts for automation of workflow.
• Worked with various new and existing team members and tried to share my knowledge with them for prompt transition in the project without effect pace of deliverables.
• Fine Tuned and optimized Mappings for better performance and efficiency.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Provided Production support by running scheduled jobs, fixing session problems, fixing failed mappings etc.
• Involved in Unit and integration testing for the mappings.
• Creation of SSIS packages to Load data and SSRS Reports for Quality Dashboard reporting purpose.
• Involved with the Business analysts in requirements gathering, business analysis, testing, and project coordination.
• Created and Documented ETL Test Plans, Test Cases, Expected Results, Assumptions and Validations.

Environment: Informatica Power Center, Windows XP, UNIX, TOAD, AIX, SSIS, SSRS Autosys, Oracle, SQL.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Analysis and evaluation of the issues faced during development and facilitating speedy recovery.
• Review and analyze data mapping document to determine ETL program design.
• Use Informatica to develop ETL program to extract data warehouse File extract to be created will follow the instructions specified in the data mapping and file layout documentation.
• Extracted data from flat files and oracle database, applied business logic to load them in the central Oracle database.
• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center.
• Using Informatica did the Data Migration from various source systems (DB2 UDB, Siebel, SQL Server) to central oracle data base which is used to business users for easy access of the data.
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Creating BTEQ (Basic Teradata Query) scripts to generate Keys.
• Used BTEQ andSQL Assistant(Query man) front-endtools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Responsible for Unit Testing of Mappings and Workflows.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Built efficientSSISpackages for processing fact and dimension tables with complex transformations and type 1 and type 2 changes.
• Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse/OltpDB.
• Worked on migrating the Cognos reports to SSRS. Worked with different tasks inSSRSlike tables, charts, sub reports, List, Image and Textbox.
• Created drill through, drill down reports, parameterized reports. Deployed reports to Report server using SSRS.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing and also worked with QA teams regarding fixing bugs.
• Using Teradata to Set up file transfer connectivity to send the extract files to BAC ECRIS system for processing.
• Using the Power Exchange for Change Data capture (CDC) option to capture the data whenever the inserts, updates, and deletes underlying these events as soon as they occur and transfer in to multiple targets without intermediate queues or staging tables
• Used Control-M scheduler to automate the process of running sessions and workflows.

Environment: Informatica, Oracle, SQL, PL/SQL, DB2, SQL Server, XML, MS Access, Informatica Scheduler, Teradata, Windows, SSIS, SSRS Control M, UNIX-HP, Control M, CDC, Autosys, Tidal.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Involved in analyzing the data models of legacy implementations, identifying the sources for various dimensions and facts for different data marts according to star schema design patterns.
• Developed complex mapping using Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Update strategy.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Worked along with the QA Team and provided production support by monitoring the processes running daily.
• Defined Target Load Order Plan for loading data into Target Tables.
• Implemented slowly changing dimensions methodology and developed mappings to keep track of historical data
• Written SQL overrides in Source Qualifier and Lookups according to business requirements.
• Involved in troubleshooting the loading failure cases, including database problems.
• Responsible for Documentation of the Test cases, completed modules and the results of acceptance testing.

Environment: Informatica, Unix, SQL Developer, Oracle 10g and Windows.

Confidential

Informatica Developer

Responsibilities:

• Involved in the creation of the Technical design document on the basis of the Functional design document.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using Erwin.
• Wrote stored procedures in PL/SQL and UNIX Shell Scripts for automated execution of jobs.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse using Informatica mapping and complex transformations (Aggregator, Joiner, Lookup, Normalizer, Filter)
• Through explain plan, analyzed and modified indexes and modified queries with derived or temporary tables to improve the performance. Also utilized Teradata viewpoint.
• Worked with clients to demonstrate agile techniques for software development, explained and implemented unit testing, created coding standards.

Environment: Informatica Power Center, Power Exchange, Teradata, Erwin, Oracle, SQL, BTEQ, Power Connect, PL/SQL, UNIX, TOAD.