SUMMARY

• 8+ Years of IT experience as a Functional and Technical Software Engineer/Consultant in the development of Data Warehousing/ Data Marts and Reporting environments.
• Over 6+ years of strong IT consulting experience, with profound knowledge in analysis, design, development and maintenance of Business applications in Manufacturing, Retail, Finance and Health Care Business Domains.
• ETL - Data Warehousing experience using Informatica Power center Designer, Workflow Manager, Workflow Monitor, Repository Manager (9.x, 8.x, 7.x).
• Experience in all the phases of the Data warehouse life cycle involving Design, Development Testing and Migration of code using ETL tool Informatica.
• Strong understanding of the principles of Data Warehouse using Fact tables, Dimension tables, Star Schema modeling and Snowflake modeling with sound knowledge of database architecture for OLTP and OLAP applications.
• Participated in ETL requirements gathering meetings with tier-1 data analyst’s and suggested the designs in development point of view for building the ETL Specification document.
• Extracted data from Homogeneous and Heterogeneous sources and developing the mapping needs and to push the data as per ETL Specification document into Target Tables.
• Has good hands-on knowledge in configuring various transformations like Source Qualifier, Expression, Filter, Joiner, Aggregator, Router, Unconnected and Connected Lookups, Update Strategy, Sequence Generator, Stored Procedure.
• Comfortable in implementing the CDC (Change data capture) for the slowly changing dimensions of types SCD-Type1, SCD-Type2, SCD-Type3.Used effective Start-Date, End-Date, Version, Flagging to capture the change for the records.
• Created Stored Procedures for Target Preload TRUNCATE of data, Handled PRE-SQL and POST-SQL for targets. Implemented SQL Overrides at Source Qualifier and Lookups whenever needed. Created Reusable objects like Transformations (Expression, Stored Procedure, Filter, and Lookup-Unconnected), Mapplets, and Functions.
• Strong experience in designing the Design Documents for loading data into Data Warehouse and Data Mart tables.
• Have created session Parameters and Variables as best coding standards. Responsible for controlling the execution of workflow sessions using user defined values in parameter file.
• Have good knowledge in configuring various session properties like DTM Buffer size, Pre-SQL, Post-SQL, Stop on errors, Commit Type, Commit Interval, Pre-session commands, post session success command, post session failure command. Intimating the end users by On-success E-Mail and On-Failure Email notifications.
• Have good hands-on knowledge in using Erwin, Sybase Designer for designing Logical and Physical models, assigning the Physical model to required database. Programs to govern the Constraints and reverse engineering the changes. Splitting and merging the designs. Generating XML files.
• Proficient in writing SQL code for DML’s, DLL’s and DCL’s with good programming knowledge in creating PL/SQL Anonymous blocks, Packages, Stored Procedures, and Functions.
• Good in writing simple Unix Shell scripts for Moving Files from one directory to another, archiving the files. Checking for control files existence in a directory or not. Removing carriage returns before processing Flat files.
• Ability to work independently and work with teams having various backgrounds on complex issues and have strong verbal and written communication skills along with strong analytical and decision-making skills.

TECHNICAL SKILLS

ETL: Informatica 9.5.1/9.1.0/8.6.1/8.5/8.1/7.1/6.2 , BO Data Integrator

BI tools: Business Objects: BO XI-R2\6.5, Crystal Reports.

Database: Oracle 10g/11g, SQL Server 2005, Teradata v12/13/14, DB2.

Interfaces: TOAD, SQL*Loader, MS SQL Server Management Studio

Languages: PL/SQL, C, C++, Java, SQL, HTML, XML.

Environment: s: Windows 2000\NT\XP, UNIX, Linux

Concepts: RDBMS, Data Warehousing/ Data marts

Scheduling Tools: Informatica Scheduler, Autosys, ControlM

PROFESSIONAL EXPERIENCE

Confidential, Carmel, IN

Informatica Developer

Responsibilities:

• Involved in design, development and maintenance of data of customer specific data marts and sales history transactions for data mart using Informatica Power center 9.X and 8.X.
• Developed mappings to extract data from source tables (Which are residing on Oracle 11g and 10g Platform) populating data into staging environment and then loading data from staging into target Oracle Tables. Had business scenarios where I dealt with Flat files (Fixed width and delimited), Read data from flat files and loaded into Flat files.
• Due to complexity of business, there are scenarios where I fetch data from VIEWS and load the processed data into target RDBMS and Flat files.
• Worked on different types of transformations like Source Qualifier, Filter, Expression, Joiner union, aggregator, update strategy, lookup, stored procedure, sequence generator.
• Developed reusable Transformations, Mapplets for validating MD5 functionality to know whether a record is changed or not based on the business rules.
• Developed Complex mappings like Slowly Changing Dimensions Type 1, Slowly Changing Dimensions Type 2 (Version numbering, Timestamp) in the mapping designer to maintain Full history of transactions.
• Performance tuning of Informatica sessions for large data files by increasing DTM block size, data cache size, sequence buffer length and target based commit interval.
• Used stored procedures to truncate target data before the loads as per ETL specs document and also worked with parallel processing of data being fetched from the RDBMS.
• Worked on issues related to code migration and workflow failures in Development, Test/QA and production environments.
• Created RFC for the change that needed to be implemented in the existing mappings.
• Used debugger to troubleshoot logical errors.
• Involved in tuning of SQL Queries for SQL OVERRIDE in Source Qualifier, Lookups and sessions.
• Redesigned some of the mappings in the system to meet new functionality.
• Worked on different tasks in Workflows like session-events raise, event wait, Command tasks, e-mail, work-lets (to achieve looping for desired iterations), Assignment, Timer and scheduling of the workflow.
• Used in maintaining database activities for various schemas using SQL DML, DDL, and DCL.
• Wrote simple Unix Shell scripts for Moving Files from one directory to another, archiving the files. Checking for control files existence in a directory or not. Removing carriage returns before processing Flat files.
• Scheduled the workflows and created dependency run for the set of workflows using Tivoli workforce scheduler.

Environment: Informatica Power center 9.5.1, Oracle 11g, 10g, 9i, Teradata, Unix AIX Server, Erwin 7.3, SQL, and Toad 10.0.

Confidential, Troy Michigan, MI

Informatica Developer

Responsibilities:

• Coordinated in daily team meetings, technical code review meetings and interacted with business people for better technical solutions and proposed ETL strategy based on Agile Methodologies.
• Validated, debugged old Mappings tested Workflows & Sessions and figured out the better technical solutions. Identified the Bottlenecks in old/new Mappings and tuned them for better Performance.
• Developed various complex SCD Type1/Type2 Mappings to maintain the data history in different layers. Used Mapping & Sessions Variables/Parameters, Parameters files, Reusable Transformations Mapplets to maintain the life cycle development. Designed and coded of major change requests as per new requirements.
• Worked on Automation process of Sessions, Workflows, scheduled the Workflows, created Worklets and configured them according to business logics & requirements to load data from different Sources to Targets.
• Worked on Team Based development to migrate the codes from Dev to Test to Prod environment and wrote up the Team Based Development technical documents to smooth transfer of project.
• Prepared effective Unit, Integration and System test cases of Mappings for various stages to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading.
• Created Pre & Post-Sessions UNIX Scripts, Functions, Triggers and Stored Procedures to drop & recreate the indexes and to solve the complex calculations on data. Transformed and loaded of large sets of structured, semi-structured and unstructured data coming from different sources like CSV, Flat file MS-SQL, Oracle etc.
• Worked with Informatica Data Quality (IDQ) 9.5.1 Developer/Analyst Tools to remove the noises of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Address Validation, Key Generator, Lookup, Decision etc.
• Created Reference tables using IDQ Analyst tools. Used the Address Doctor Geo-coding table to validate the address and performed exception handling, reporting and monitoring the data.
• Built the Logical Data Objects (LDO) and developed various mapping, mapplets/rules using the Informatica Data Quality (IDQ) based on requirements to profile, validate and cleanse the data. Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ 9.5.1. for MDM.
• Worked on Web Services (WSDL) to extract data from different Web Links and created Mappings load the data into target tables. Used WSDL link to represent the data in MS-Word, MS-Excel in Ads-on menu.

Environment: Informatica Power Center 9.5.1, Power Exchange, ControlM, Cognos, Oracle 10g/11g, MS Access, MS SQL Server 2008, Sybase, IBM DB2, SQL PL/SQL, SQL*Plus, TOAD, Oracle Applications 11i, Erwin, Unix, Sun Solaris, Windows XP

Confidential, Richardson, Texas

ETL Developer

Responsibilities:

• Worked closely with business analyst and Data Warehouse architect to understand the source data and the need of the Warehouse.
• Extensively worked with Designer tools like Source Analyzer, Target designer, Mapping designer, mapplet designer, Transformation Developer.
• Created source and Target Definitions, Reusable transformations, mapplets and worklets.
• Created Mappings and extensively used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Expression, Router, Joiner, Normalizer, Aggregator and Sequence Generator, Web services Consumer.
• Developed Source to Staging and Staging to Dimension mappings.
• Developed Source to Staging and Staging to Fact mappings
• Used Workflow Manager to create sessions, worklets workflows.
• Extensively involved in tuning the mappings, sessions and the Source Qualifier query.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data
• Involved in migration of mappings and sessions from development repository to test and production repository.
• Involved in production support and done knowledge transfer to team members.
• Actively involved in Daily check in meetings to discuss on the production issues and resolved.

Environment: Informatica Power center 9.1 Oracle 11g, PL/SQL, Toad 9.5, Dynamic SQL, UNIX Shell Scripting, SharePoint, HIPAA, Embarcado, IIR, Web Services (WSDL), MDM, and MySQL.

Confidential, New York, NY

Informatica (ETL) /Oracle (SQL, PL/SQL) Developer

Responsibilities:

• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Understood the Business point of view to implement coding using Informatica power center designer
• Migrate historical data, which is one time and built migration process for ongoing data loads using Informatica power center designer.
• Developed mappings to extract data from various source systems like SQL Server, Flat files, XML and load into Data warehouse.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Involved in versioning the whole process and retiring the old records using the built-in's DD UPDATE, DD DELETE, and DD INSERT.
• Debugging invalid mappings using breakpoints, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Identified sources, targets, mappings and sessions and tuned them to improve performance.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis and Maintenance of the Data Marts
• Worked as a part of a production support team and provided 24 x 7 supports.

Environment: Informatica Power center 9.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), Power Exchange 9.1, Informatica developer (IDQ) 9.1, Oracle 12c/11g, PL/SQL, SQL, COGNOS, TOAD, LINUX, Shell scripts.

Confidential

ETL Developer

Responsibilities:

• Analysed the data coming from different sources and their relationships.
• Interacted with business community and gathered requirements based on changing needs.
• Analyzed the architecture for Data Warehouse - star schema/snowflake model.
• Developed mapplets and reusable transformations to prevent redundancy of transformation usage and maintainability.
• Created various documents such as Source System Analysis (SSA), ETL technical design documents, and test documents while maintaining Wachovia interim standards and SOX compliances.
• Monitor; troubleshoot batches and sessions for weekly and monthly extracts from various data sources across all platforms to the target database.
• Involved in writing UNIX shell scripting, for automation of ETL process using Autosys for running the Batches and Sessions and scheduling them to run at specified time.
• Coordinated with Offshore team in India.
• Responsible for unit testing of mappings developed.
• Provided production support by running the jobs and fixing the bugs.
• Developed and maintained ETL (Data Extract, Transformation and Loading) mappings to extract the Data from multiple source systems like Oracle, and Flat Files and load into Warehouse through STAGE and ODS
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager
• Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements
• Worked on UNIX machine to connect to the Oracle database and run PL/SQL scripts
• Tuned SQL queries for better performance
• Optimized the mappings by changing the logic to reduce run time
• Developed the mappings to extract the data on incremental load basis.
• Developed reusable transformations for Date Conversion.

Environment: Informatica Power Center 8.6.1 7.1, Oracle 10g 9i, MS SQL Server 7.0 2000, IBM DB2 400, Flat files, SQL, SQL*Loader, ERWin 3.5, Toad 7.0, Windows 2000, Unix Shell Scripting.