SUMMARY

• Highly Motivated and Result Oriented IT Professional with eight plus years’ experience in Design, Development and Implementation of Data warehouses as an ETL Developer.
• Experience in designing and implementing ETL environments using ETL strategies as well as tools like Informatica Power Center 9.X/8.x.
• Experienced in the Analysis, Design, Development, Testing, and Implementation of business application systems for Financial, Telecom and Healthcare Sectors.
• Extensively worked with Client’s for gathering Requirements.
• Perform and participate in all aspects of the project lifecycle including, requirements definition, solution design, and development.
• Involved in full life cycle development of Data Warehousing.
• Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, XML, DB2 UDB, Oracle and SQL Server, Teradata.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, and Multi Load to export and load data to/from different source systems including flat files.
• Extensively worked on Informatica power center tools - Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensively worked on Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer.
• Strong Experience on Workflow Manager Tools - Task Developer, Worklet & Workflow Designer.
• Extensively worked in Design, Development, Testing and Production Environments.
• Hands on experience with Complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy and Re-Usable transformations.
• Experienced in Installation, Configuration of Informatica Power Center/Power Mart Client, Server.
• Extensive experience in Error Handling and problem fixing in Informatica.
• Experience with IDQ 9.6.0/9.1 Informatica Developer and Informatica Analyst.
• Involved in data analysis, cleansing, matching, exception handling, reporting and monitoring, parsing & standardization, address validation, creating score cards capabilities that manage data quality initiatives.
• Hands on experience with mappings from IDQ transformations like Address Validator, Match, Labeler, Parser and Standardizer.
• Experience in exporting the IDQ Mapplets from Informatica Developer to Power Center.
• Strong experience in Oracle, SQL Server, MS Access database programming using PL/SQL and standard built-in Oracle Packages.
• Experience in using SQL, PL/SQL Indexes, Functions, Procedures, Triggers and Cursors.
• Experience in using scheduling tools like UC4, Autosys.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.6.1/9.1/8.6/8.1 , Informatica Developer 9.6.1/9.1.

Operating Systems: UNIX, Windows.

Databases: Oracle 11g/10g/9i, SQL Server 2012/2010., Teradata14.0

DB & other tools: PL/SQL Developer, TOAD, SQL Server Management Studio 2012/2010.

Data Modeling: ER Model, Star-Schema Model, and Snowflake Model.

Languages: UNIX Shell Scripting, PL/SQL, SQl, .NET Framework.

Other Tools: MS Visio 2010, MS Power Point 2010

SDLC Methods: Water Fall Methodology, Agile Methodology

PROFESSIONAL EXPERIENCE

Confidential, Saint Paul, MN

Sr. Informatica and IDQ Developer

Responsibilities:

• The Confidential has developed an integrated warehouse that contain Information to aid in the collection of both individual and business taxes for the State of Minnesota.
• Receive source data (individual returns and business returns) from the other state departments and federal data from the IRS like DPS, DEED, DNR, IMF/IRTF, BMF/BRTF, HOMESTEAD, and EOAD etc.
• Created new mappings according to business rules to extract data from different sources, and used different transformations to transform data as required and loaded the data to the target databases.
• Extracted the data from different kind of sources like Flat Files, SQL, ORACLE, Teradata, and XML Files according to the requirements.
• UsedTeradata utilities Fast-Load, Multi-Load, and Tpump to load data.
• Worked on Teradata Multi-Load, Teradata Fast-Load utility to load data from Oracle and SQL Server to Teradata.
• Creation ofBTEQ, Fast export, MultiLoad, TPump, Fast loadscripts for extracting data from various production systems.
• Worked onTeradata Store proceduresand functions to conform the data and load it on the table.
• Worked in the conversion ofSQL serverfunctions into theTeradata Store procedurefor confirming the data.
• Deveoped Teradata BTEQ scriptsto implement the business logic
• Developed Bteq and Mload scriptsto load data from Oracle to Teradata
• Used Informatica Workflow Manager to create, schedule, execute and monitor Sessions, Worklets and Workflows.
• Modified the mappings according to the new changes and implemented the persistent cache in several mappings for better performance.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
• Involved in writing stored procedures and shell scripts for automating the execution of jobs in pre and post sessions to modify parameter files, prepare data sources.
• Identified the issues in sources, targets, mappings and sessions and tuned them to improve performance.
• Created and used reusable Mapplets and Worklets to reduce the redundancy.
• Performed data cleansing, parsing, validation techniques on the source data according to the business requirements.
• Created new IDQ Mappings, Mapplets, Workflows in Informatica Developer.
• Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ) 9.6.1 Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address Validation, Key Generator, Lookup, Decision etc Transformations and performed the unit testing for the accuracy of the data.
• Experience with Address Doctor MD files, AD license key, and AD50 file.
• Created scorecards to find the accuracy Like Zip code accuracy, county code accuracy etc.

Environment: Informatica Power Center 9.6.1/9.1, Informatica Developer 9.6.1/9.1SQL Server 2012/2008, Oracle10g, Teradata, UNIX.

Confidential, Chicago, IL

Sr. Informatica Developer

Responsibilities:

• Involved in Design Part of the Project by Creating FSD & Business mapping documents.
• Involved in gathering Business Requirements.
• Involved in Design, Development &Testing Phases.
• Prepared low level Source to Target mapping documents.
• Created/Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center 9.1/8.6.
• Extracting data from several source systems and loading data into Confidential database and also feeding data into some external systems.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer.
• Created reusable Transformations and Mapplets by using Lookup, Aggregator, Normalizer, Update strategy, expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respectively.
• Extracted data from various source systems likeOracle,SQL Serverand flat files as per the requirements.
• Performed bulk data load from multiple data source (ORACLE, legacy systems) to Teradata RDBMS using BTEQ, MultiLoad and Fast Load.
• Wrote BTEQ scriptsto run complex queries on theTeradata database.
• Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Created, optimized, reviewed, andexecutedTeradataSQL test queriesto validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Extensively worked with the data conversions, standardizing, correcting, error tracking and enhancing the data.
• Implemented the process for capturing incremental data from source systems and move the data warehouse area.
• Involved in performance tuning with Informatica and database.
• Writing Stored Procedures and Functions for processing business logic in the database.
• Involved in Shell Scripting.
• Created updated and maintained ETL technical documentation.
• Workflows scheduled by using Autosys Scheduler Tool.

Environment: Informatica Power Center 9.1/8.6, and Oracle10g, Teradata, AutosysWindows, UNIX.

Confidential, Boston, MA

Informatica Developer

Responsibilities:

• Analyzed the business requirements and suggested changes to the design accordingly.
• Created Informatica mappings with different transformations including Source Qualifier, Lookup, Filter, Expression, Aggregator, Look up Transformations and more.
• Creating work/shared folders, users, groups and managing permissions, privileges to groups and users using the Informatica Repository Manager and admin console.
• Worked efficiently with Designer tools including Source Analyzer, Target Designer, Mapping and Mapplet Designer, Transformations.
• Developed Mapplets, Mappings and configured Sessions.
• Created reusable Tansformations and Mapplets to use in multiple mappings.
• Tested Mappings and fixed bugs using Debugger.
• Involved in the creation of workflow and planning the schedule for this workflow.
• Performed scheduling techniques with ETL jobs using scheduling tools.
• Created PL/SQL Functions and Stored Procedures for the processing of data from Warehouse to Mart.
• Created PL/SQL procedures in Oracle 10g.
• Involved in setting up users through Supervisor and assigning privileges to these users to meet security requirements.
• Executed Scripts, Managed scheduled activities based on business requirements.
• Involved in the regression testing before migrating the code from UAT to Production.

Environment: Informatica 8.1.1, Oracle 10g, PL/SQL, UNIX

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouse.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, XML files, and loaded into data warehouse.
• Used Source Analyzer and Target 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.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
• Written Queries, procedures, created Indexes, primary keys and databases testing.
• Defects were tracked, reviewed and analysed.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Identified issues in sources, targets, mappings and sessions and tuned them to improve performance.
• Actively participated in database testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc.
• Used command line mode to embed pmcmd commands in to shell scripts and used pmcmd, pmrep commands in Interactive mode to access repository and workflows.

Environment: Informatica Power Center, Oracle9i, SQL, PL/SQL, MS Vision, Ms-Access