SUMMARY

• Having 9+ years of IT experience as an ETL Developer working in Database/Data Warehousing Technology, analysis, designing, development and implementation of business systems in various environments.
• Involved in requirement gathering, design, development and implementation of data warehouse projects.
• Extensively used ETL methodologies for supporting Data Extraction, Transformation and Loading process, in a corporate - wide-ETL solution using Informatica Power Center.
• Extensively worked on developing Informatica Designer, Workflow manager and Workflow monitor for data loads.
• Extensive experience in using various Informatica Designer Tools such as Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer.
• Extensive experience in Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in E-commerce software, Utility, Pharmaceutical, Health Care, Insurance, Financial and Manufacturing industries.
• 8 years of experience in development and maintenance of SQL, PL/SQL, Stored procedures, functions, analytic functions, constraints, indexes and triggers.
• Knowledge onInformaticaData Quality (IDQ) implementing data quality solution across Member and Provider Domain.
• 8 years of experience in using different versions of Oracle database like 11g/10g/9i/8i.
• 6+ years of experience in UNIX Shell Scripting.
• Experience in creating batch scripts in DOS and Perl Scripting.
• Experience in ETL development process using Informatica for Data Warehousing, Data migration and Production support.
• Experience in both Waterfall and Agile SDLC methodologies.
• Sound noledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principals (Kimball/Inmon) - Star/Snowflake schema, SCD, Surrogate keys and Normalization/De-normalization.
• Data modeling experience in creating Conceptual, Logical and Physical Data Models using ERwin Data Modeler.
• Experience wif TOAD, SQL Developer database tools to query, test, modify, analyze data, create indexes, and compare data from different schemas.
• Extensive experience in developing Extracting, Transforming and Loading (ETL) and testing processes using Informatica PowerCenter and full life cycle implementation of data ware house.
• Worked on Slowly Changing Dimensions (SCD's) Types -1, 2 and 3 to keep track of historical data.
• Knowledge in Data Analyzer tools like Informatica Power Exchange (Power Connect) to capture the changed data.
• Proficiency in data warehousing techniques for data cleansing, surrogate key assignment and Change data capture (CDC).
• Experience in integration of various data sources like Oracle, DB2, Flat Files and XML Files into ODS and good noledge on Teradata 12.0/13.0, SQL Server 2000/2005/2008 and MS Access 2003/2007.
• Expertise in implementing complex business rules by creating re-usable transformations, Mapplets and Mappings.
• Hands on experience in MDM development.
• Involved in the designing of Landing, Staging and Base tables in Informatica MDM.
• Created MDM mapping and configured match and merge rules to integrate the data received from different sources.
• Optimized the Solution using various performance-tuning methods (SQL tuning, ETL tuning (i.e. optimal configuration of transformations, Targets, Sources, Mappings and Sessions), Database tuning using Indexes, partitioning, Materialized Views, Procedures and functions).
• Extensively used Autosys and Tidal for scheduling the UNIX shell scripts and Informatica workflows.
• Extensive noledge in all areas of Project Life Cycle Development.
• Strong analytical, verbal, written and interpersonal skills.
• Proactive in learning new technologies and updating my skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 8.x/ 7.x/6.x, PowerExchange, MDM.

Data Management and Integration: VLTrader V4.2.

Databases: Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008, Teradata 12.0/13.0, DB2 8.1.

Database Utilities: WinSQL, Toad, SQL*Loader, SQL Developer, SQL*PLUS, WinSCP.

Operating Systems: UNIX (Solaris 8/10), LINUX, Windows NT, 2000, XP, 2003, Win server 2008.

Languages: T-SQL, SQL, PL/SQL, C, C++.

Scheduling Tools: Tidal, Autosys, Crontab and Control-M.

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snowflake schemas, Fact and Dimension Tables, Software Development Life Cycle.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Informatica Developer

Responsibilities:

• Worked wif SME (Subject matter Expert) to understand and gather the business needs related to the data flow to implement data loading mappings.
• Analyze the business requirement and create ETL logic to extract data from flat files coming from Manufacturing at different geographic regions and load data in the data warehouse house.
• Prepared ETL Specifications and design documents to help develop mappings.
• Created Mappings for Historical and Incremental loads.
• Used Oracle 11g SQL, PL/SQL, Procedures, Functions and Complicated SQL queries using TOAD, SQL developer to truncate the data in the target tables before loading and tune the ETL Mappings to achieve the required Performance timing.
• Used Version Control to check in and checkout versions of objects.
• Tuned Source, Target, Mappings, Transformations and Sessions for better performance.
• Supporting daily loads and work wif business users to handle rejected data.
• Prepared and maintained mapping specification documentation.
• Use Debugger to test the mapping and fixed the bugs.
• Used Mapping Variables and Mapping Parameters to fulfill the business requirements.
• Performedincreating tasksinthe workflow manager and exportedIDQmappings and executed theminInformatica.
• Worked on staging the data into work tables, cleanse, and load it further downstream into dimensions using Type 1 and Type 2 logic and fact tables which constitute the data warehouse.
• Worked wif PMCMD to interact wif Informatica Server from command mode and execute the shells scripts.
• Project based on Agile SDLC methodology wif 2 weeks of software product release to the business users.
• Performedincreating tasksinthe workflow manager and exportedIDQmappings and executed theminInformatica.
• Take part in daily standup and scrum meetings to discuss the project lifecycle, progress and plan accordingly, which is the crux of Agile SDLC.
• Troubleshoot the QA defects and bug-fixes and SIT in a timely manner to make the 2 week release window possible.
• Provide post release/production support.

Environment: Informatica Power Center 9.5.1, Oracle Database 11g, PLSQL Developer, Linux 2.6.18, Unix Shell scripts.

Confidential, Los Angeles, CA

Sr. Informatica Software developer

Responsibilities:

• Extensively used Informatica Power Center for Extraction, Transformation and Loading process.
• Worked on Informatica tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Involved in Data Loading Sequence and Populated Data into Staging Area and Warehouse wif Business Rules.
• Designed and developed various Mappings and Mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data from SQL Server and load to Oracle database.
• Extracted the source definitions from various relational sources like Oracle, XML and Flat Files.
• Extensively used ETL to load Flat files, XML files, Oracle and legacy data as sources and Oracle, Flat files as targets.
• Created Sessions and managed the Workflows using various tasks like Command, Decision, Event wait, counter, Event raise, Email using Workflow Manager.
• Extensively used the Informatica Debugger for debugging the mappings.
• Created Mappings to load data using various transformations like Source Qualifier, Sorter, Lookup, Expression, Router, Joiner, Filter, Update Strategy and Aggregator transformations.
• Worked specifically wif the Normalizer Transformation by converting the incoming fixed-width files to COBOL workbooks and using the Normalizer transformation to normalize the data.
• Worked wif Lookup Dynamic caches and Sequence Generator cache.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings and also worked wif shortcuts for various informatica repository objects.
• Identified and eliminated duplicatesindatasets thoroughIDQcomponents.
• Used Teradata utilities like FastLoad, MultiLoad and Teradata SQL Assistant.
• Split the source file using shell script and parse it to make independent files and load onto Teradata.
• Load data files coming from external vendors onto Teradata EDW using mload and fload utilities.
• Workedinimplementation of Profiling, Score Card, Classifier models, Probabilistic models, Humantask and Exception record management as part ofIDQprocess.
• Worked wif Informatica Power Exchange to pull the changed data in the form of Condense files and load into Teradata tables using Tpump import.
• Created parameter files wif Global variables.
• Extensively worked wif Korn-Shell scripts for parsing and moving files and even for re-creating parameter files in post-session command tasks.
• Profile files and shell scripts were used for recreation of dynamic parameter files.
• Scheduling of Informatica workflows using Tidal Scheduler.
• Unit test and SIT performed on the Informatica mappings created.
• Migration of Informatica code from DEV to TEST environments in Informatica by creating deployment groups, folders, applying labels, creating queries in the Informatica Repository Manager.

Environment: Informatica PowerCenter 8.6.0/8.6.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), UNIX, Teradata13.0, Shell Scripts, Pipe-delimited, CSV, Fixed-width Flat Files, Tidal 5.3.1.

Confidential, Charlotte, NC

Informatica ETL developer

Responsibilities:

• Gathering of user requirements and source system analysis and establishing mapping between sources to target attributes.
• Used Informatica designer for developing various mappings.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator.
• Worked wif XML targets for the data coming from SQL server source.
• Query tuning and SQL Query override used in Source Qualifier transformation to pull historical data from database not earlier TEMPthan the given date i.e. the change data capture (CDC).
• Worked wif Expression, lookup, sequence generator, Normalizer, router transformations for cleansing and validation of data to load into XML and flat file targets.
• Worked wif re-usable sessions, decision task, control task and Email tasks.
• Parameterized the whole process by using the parameter file for the variables.
• Imported xsd file to create the xml target and create the Hierarchical Relationship And normalized views.
• Edited the views and created new views according to the business requirement.
• Designed and build a web services integration to download user activity data to flat files.
• Implemented the logic by using HTTP transformation to query the web server.
• Configure and setup a secure FTP connection to the vendor using the Informatica Managed File transfer software.
• Created complex Shell scripts for various set of actions dat would automate the process of executing the actions like validating the presence of indicator files.
• Encrypting and compressing the xml and flat files using PGP Compression algorithm like ZIP and PGP Encryption algorithms like TripleDES, Blowfish, AES-256 and CAST5 using MFT.
• Pushing the compressed and encrypted xml files and flat files generated to the external vendor using MFT.
• Involved in Unit testing and system integration testing (SIT) of the projects.
• Assist the team members wif the mappings developed as part of noledge transfer.

Environment: Informatica PowerCenter8.6.1/ 8.1.1, Windows Server 2008, MS-SQL Server 2005, Batch Scripting, Perl Scripting, XML Targets, Flat Files, MFT server (Managed File Transfer), VLTrader V4.2, Tidal 5.3.1.

Confidential, OH

Informatica Developer

Responsibilities:

• Designed the Source Definition, Target Definition and Transformation for building mappings using the Informatica designer tools.
• Involved in creating staging Tables, Indexes, Views.
• Analyze, design, build, test and implement change requests for certain areas in the production data warehouse as per the requirements.
• Proficient in writing SQL queries and creating PL/SQL stored procedures.
• Involved in Developing OLAP models like facts, measures and dimensions.
• Implemented change data capture (CDC) using Informatica PowerExchange to update tables in the oracle database.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings and also worked wif shortcuts.
• Implemented Type2 slowly changing dimensions (SCD).
• Worked on all aspects of Teradata loading and query tuning activities.
• Used Teradata utilities like FastLoad, MultiLoad, FastExport and BTEQ.
• Extracted data from Teradata source systems to a flat file.
• Created parameter files and scheduled workflows.
• Optimized mappings by performing Performance Tuning and Informatica best practices.
• Involved in Unit testing and system integration testing (SIT).
• Created mapping documentation and user guides for ETL processes as part of end user training.

Environment: Informatica PowerCenter 8.6, PowerExchange, Oracle 10g, Teradata 12.0, SQL, PL/SQL, ERwin, Toad 9.6, WinSCP, UNIX (Solaris 10), Autosys.

Confidential

Informatica developer

Responsibilities:

• Development, Testing, Implementation & Training ofusers.
• Prepared ETL Specifications and design documents to help develop mappings.
• Created mappings for Historical and Incremental Loads.
• Used Version Control to check in and checkout versions of objects.
• Tuned Source, Target, Mappings, Transformations and Sessions for better performance.
• Supporting daily loads and work wif business users to handle rejected data.
• Prepared and maintained mapping specification documentation.
• Use Debugger to test the mapping and fixed the bugs.
• Used Mapping Variables and Mapping Parameters to fulfill the business requirements.
• Implemented Type I and Type II slowly changing Dimension to maintain all historical information in Dimension Tables.
• Involved to prepare technical and functional specification.
• Performance analysis and tuning of SQL statements of projects.
• Imported data from different sources to Oracle tables using Oracle SQL*Loader
• Wrote Oracle PL/SQL, stored procedures and triggers to populate data.
• Involved in writing complex SQL statements for reports.
• Worked closely wif client to research and resolve user testing issues and bugs.

Environment: Informatica PowerCenter, UNIX, PL/SQL, TOAD, Oracle 8i, SQL, SQL*Loader