PROFILE

• 9 years of experience in software applications analysis, design and development, Testing, Maintenance and Enhancement in datawarehousing, DataIntegration.
• 9 years of strong DataWarehousing experience in BusinessRequirementAnalysis, Design, Development, Testing, Implementations, Loading, Maintenance and Enhancements of Datawarehouse and ODSsystems using Informatica PowerCenter 9.x/8.x/7.x/6.x, Oracle 11g/10g/9i, DB2, SQL, PL/SQL and well versed with Data Warehousing Architecture, Technology, Operational DataStore and DimensionalDataModeling.
• 2 years of experience in designing and implementation of real-time Data warehouse using InformaticaPowerExchange 9.1/8.6.
• Extensive knowledge with DimensionalDatamodeling, StarSchema/SnowflakesSchema, Fact and Dimension tables.
• Heavily interacted with the SourceSystemowners and businessusers to gatherrequirements, designtables, standardizeinterfaces for receiving data from multipleoperationalsources, coming up with loadstrategies of loadingstaging area and datawarehouse.
• Worked extensively with FlatFiles, DB2Relationalsourcedata, and Workflow and SchedulingJobdesign, resolvingproductionissues.
• Used features like pre-session/post-session commands/SQL, fine-tuned databases, mappings, and sessions to get optimalperformance.
• Implemented slowlychangingdimensions Type1, Type2 and Type3 , slowly growing targets, and simple pass through mapping's using Power Center.
• Experience in UNIXshellscripting, Application Monitoring using UNIXShellScripting.
• Extensive experience with relational databases Oracle 10g/11g, DB2, SQL Server, Teradata, Greenplum, Amazon AWS Redshift .
• Worked in Agile methodology, have experience on Rally, Basecamp.
• Experience in developing TestStrategy, Testplan, Testcases, UseCase, Testscripts.
• Possess excellent interaction, communication and problemsolving abilities.
• Strong experience in offshore and onsitecoordination.

WORK EXPERIENCE

Confidential

Contribution:

• Developed Pl/SQL Stored procedures, functions, views, triggers and package asperbusinessrequirement.
• Created reusable component like User Defined function UDF , Mapplet, transformation, tasks and worklets.
• Workedextensivelyon tuning Informaticacodebyvarioustechniques. Customized source qualifier queries, tuned transformationslike lookup, aggregate, sorter, joiner etcby multiple approaches.
• Workedon session tuning by customizing the memory setting, error login and partitioning and incremental aggregation.
• Database development and ETL process in Oracle11g and Greenplum using PSQL, SQL, PERL and UNIXscripting.
• Reported metrics on requirements, defects and testing for senior management.
• Migrated data from Oracle legacy to Greenplum platforms using off-hours and weekends to complete data exports and loads to target environments.
• Created of ETL mappings using Informatica PowerCenter to move information from multiple sources into a common target area such as Data Marts and Data Warehouse.
• Developed ELT mappings to reduce load times for large data sets
• Involved in performance tuning and created optimal partitioning on GP target table.
• Involved in the creation of Greenplum functions and views for the customer use.
• Actively involved with Greenplum DBAs for loading of GP data along with query performances and standard metric processes.
• Used Greenplum utilities like GPFDIST and GPLOAD.

Confidential

Contribution:

• Designed and developed Informatica code to extract, convert and load data for the application as per the business requirements.
• Worked closely with business analysts to gather functional specifications and turn them into technical specifications
• Reported project status and financials to business management, raising risks and issues and obtaining input and approval for mitigation strategies required, therefore, keeping projects on schedule.
• Worked with different source systems like XML, flat file and relational tables.
• Worked on Informatica transformations including but not limited to XML, normalizer and union to facilitate business requirement.
• Worked on defects and implemented change requests as and when assigned.
• Workedas onsite offshore coordinator andinvolvedinworkdistributionand code review ofjuniordevelopers.

Confidential

Contribution:

• Developed Detailed Design documents based on business requirements.
• Developed DSS tasks to extract the data
• Developed and implemented B2B plugin using Informatica DT studio for Informatica Cloud to overcome XML Connector limitations.
• Designed and developed Amazon Redshift databases.
• Developed PowerShell scripting to automate the file transfers.
• Developed Task Flows.
• Developed and implemented, Complex DSS tasks with mapplets.
• Worked with XML, Red Shift, Flat file connectors

Confidential

Contribution:

• Developed Detailed Design documents based on businessrequirements.
• Designed and developed Informaticacode to extract, convert and load data for the application as per the business requirements.
• Involved in the fulldevelopmentlifecycle from Requirements gathering through Design, Build, QA, Deployment and Support using InformaticaPowerCenter.
• 24x7 production support for jobsrunning in the productionenvironment.
• Involved in debugging the failedmappings identify the rootcause and developingerror-handling methods.
• Resolved Source system data issues by performingDataprofiling and providingworkaroundtechniques.
• Worked closely with businessanalysts to gather functional specifications and turn them into technical specifications.
• Worked with Direct and IndirectFlatFiles.
• Identified long runningjobs and implementedvariousperformancetuning techniques to mitigate the bottlenecks.
• Worked with DBA's to tune long running SQLqueries.
• Designed and developedcomplexInformaticamappings including slowlychangingdimension Type 1, Type2 .
• Used UNIX commands in sessions to handlemultipletarget files into one, clean unused Target or errorfiles and remove specialcharacters from Flatfiles.
• Developed reusabletransformations and Mappletstransformations.
• Designed, developed and executed RunControljobs.
• Worked with different sourceand target systems like XML, flatfile and relationaltables.
• Facilitated codereviews as a Leaddeveloper, to ensurecodequality.
• Worked on Informaticatransformations including but not limited to SQL, XML, SFDClookup and StoredProcedure to facilitate the business requirements.
• Used Variables and Parameters in Mappings, Workflows and Sessions.
• Created post-session and pre-sessionshellscripts and mail-notifications. Used various session tasks like Eventwait, Timer, Decision and Control.
• Created labels, deployment groups and worked on migrating the code between different environments using deploymentgroups.
• Develop and maintain the bestpractices and guidelines throughout dataWarehousepractice in the organization.
• Coordinated with the offshore team to make sure tables were loadedappropriately.
• Triagedissues worked on defects and implemented changerequests as and when assigned.
• Coordinate with the GFAapplicationteam in modifying the existingInformaticaETL code as per the new business requirements.
• Followed agile methodology and used TFS for creating userstories, taskand timeestimation.

Confidential

Contribution

• Developed HighLevelTechnicalDesignspecification and Low-levelspecifications based on businessrequirements.
• Developed robustInformaticamappings and fine-tunedthem to process millions of input records with estimatedthroughput as per the business requirements.
• Involved in the full development lifecycle from Requirement gathering through Design, Build, QA, Deployment and Support using Informatica Power Center.
• Workedcloselywith business analysts together functional specifications andturn them into technical specifications.
• Developed reusabletransformations and mapplets.
• Developed stored procedures to run as part of pre/post load process.
• Involved in debugging the failedmappings and developing error-handling methods.
• Created mappings mapplets for data cleansing in Informatica developer and used in Power Center.
• Used Variablesand Parameters in Mappings, Workflows and Sessions.
• Extracted data from COBOLcopybooks to the Oracle staging environment also performed data cleansing prior to data staging using PowerExchange.
• Triaged issues worked on defects and implemented change requests across the project life cycle.
• Responsible for four types of performance tuning MappingLevel, SessionLevel, SourceLevel, and Targetlevel.
• Coordinate with the application team in modifying the existing Informatica ETL code as per the new business requirements.