PROFESSIONAL SUMMARY:

• Around 7 years in the information technology and wide range of experience in Software development, Project management, Data Integration, Master Data Management(MDM) andInformatica Data Quality(IDQ).
• Strong Data warehousing experience using Informatica Power Center 10.1/ 9.6/9.0/8.6/8.0/7 (Source Analyzer, Repository Manager, Mapping Designer, Mapplets, Transformations, Workflow Manager, Task Developer),IDQ 10.1/9.5, Power Connect for ETL, OLTP, OLAP, Data Mining, scheduling tool.Worked with heterogeneous source systems like flat files, RDBMS, DWH, parameterizing variables.
• Involved in driving complex discussions with business analyst and systems architect to determine the solution.
• Worked on deployment document preparation and assistance to deployment team while migration.
• Converted the business rules into technical specifications for ETL process for populating Fact and Dimension table of data warehouse.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Data modelling knowledge in Dimensional Data modeling, Star Schema, Snow - Flake Schema, FACT and Dimensions tables, Physical and logical data modeling and De-normalization techniques.
• Created mappings for various sources like DB2, Oracle, and flat files to load and integrate details to warehouse.
• Scheduled jobs and automated the workload using the Autosys Job Scheduler, Control-M Job Scheduler and Informatica Scheduler.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Created IDQ mappings to make data standardized and validated.
• Expertise in Data Warehousing with variety of Data manipulating skills like Data Migration, Data Modeling, Data Profiling, Data Cleansing and Data Validation.
• Worked in a production support role of processing daily, weekly and monthly loads in datastage based upon the business requirements.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling
• Scheduled the ETL jobs daily. Weekly and monthly based on the business requirement in Autosys.
• Experience in integration of Heterogeneous data sources like Oracle, SQL Server 2005/2008, DB2,XML Files, Flat Files into staging area as well as from homogenous sources.
• Performed Unit testing for the mappings developed.
• Scheduled jobs and automated the workload using the Autosys Job Scheduler, Control-M Job Scheduler and Informatica Scheduler.
• Experience in Dimensional Modeling (Erwin), Star / Snowflake Schema, Fact / Dimension Tables, Business Process Analysis, Production support, Data cleansing, Data analysis and Performance tuning of sources, targets, mappings sessions and SQL’s.
• Cleansed, labeled and fix data gaps with IDQ.
• Experienced in UNIX work environment, File Transfers, Job Scheduling and Error Handling.
• Scheduled sessions and batches on the Informatica server using Informatica Workflow manager.
• Performed application systems development tasks which include working with users to define system needs, analyzing, designing and developing applications to meet user needs.
• Provided technical support for very complex, highly critical mapping designs. Plan and coordinate tests, resolve production problems, identify opportunities to improve the performance.
• Tuned the Performance for ETL jobs by tuning the SQL used in Transformations and fine-tuning the database.
• Determined alternate solutions with risk analysis and identified opportunities to improve availability and advance business initiatives.
• Hands on experience in resolving the production issues in 24/7 environment.
• Worked on deploying the product in development environment and exposing the application to rigorous testing via functional, performance and user acceptance testing in test environments.
• Reviewed the code developed by co-team members.
• Experience with Sales, Retail, Financial and Banking Domains.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 10.2/9.6/9.5/9.0/8.6 , Informatica Analyst, OLAP, OLTPETL,$Universe, Informatica Data Quality 10.1/9.5,Data Cleansing, Data Profiling.

Tools: Informatica PowerCenter, Informatica MDM, Informatica Data Director(IDD), SAP Business Objects,Toad, $Universe,Putty, SQL Developer, Tableau,Qlikview,Tidal,SERVICE NOW

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005

Operating Systems: Linux, UNIX, Windows, Sun Solaris 2.x

Languages/Web: SQL, PL/SQL, UNIX,C

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Informatica Developer

Tools: Informatica 9.5.1, Toad, Informatica Data Quality,Autosys

Operating system : Windows XP/Win 7/Win 8, LINUX and UNIX

Database : SQL Server, Oracle

Languages: SQL/PLSQL

Responsibilities:

• Responsible for end to end Informatica ETL Process Design, like Requirements gathering, preparing Technical solution document, Detail Design, Unit Test Cases and Deployment.
• For Business meeting, conversion of business rules into technical specifications.
• Prepared High Level Estimate and the milestone for whole team.
• Extensively used ETL Informatica for the extraction, Transformation and Load of source data which was from Oracle, DB2 and Flat Files.
• Extensively worked with Performance Tuning at the mapping level and session level.
• Responsible for mentoring Developers and Code Review of Informatica Mappings developed by other developers.
• Worked on Informatica Power Center Tools like Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensively used Source Qualifier Transformation and used most of its features like filter, sorter and SQL Override.
• Extensively used various Informatica active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Lookup Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation and Aggregator Transformation.
• Developed Cognos framework and reports out of LODS.
• Responsible for best practices like Informatica naming conventions, Performance Tuning and Error Handling.
• Developed Reusable Transformations and Reusable Mapplets.
• Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV Environment.
• Responsible for Unit Testing and Integration testing of mappings and workflows.
• Create & schedule the Job using Tidal Scheduler.

Confidential, Minneapolis, MN

Informatica Developer

Tools: Informatica 9.5.1, Toad, Informatica Data Quality,Autosys

Operating system : Windows XP/Win 7/Win 8, LINUX and UNIX

Database : SQL Server, Oracle

Languages: SQL/PLSQL

Responsibilities:

• Extracting the data from the Relational Databases, Flat files using ETL process.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.
• Developed UNIX shell scripts to scheduling Scripts by using scheduling tools.
• Thorough Validation on source data and the load in the dimension and fact tables.
• Developed new Informatica mappings and workflows based on specifications.
• Extensively used XML transformation to generate target XML files.
• Involved in Using Parameters, Variables, for doing incremental loads and CDC.
• Created mappings to load different sources sent by IMS and CDC (Flat files, Oracle tables) to Target Oracle database.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Implemented Type 2 Slowly Changing Dimensions to maintain the historical data in sales Data mart as per the business requirements.
• Worked on development of metric dashboards via Tableau data at varying levels of complexity.
• Created IDQ mappings to make data standardized and validated.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Cleansed, labeled and fix data gaps with IDQ.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Building mappings, workflows in a cost effective manner.
• Worked on all phases of data warehouse development life-cycle, ETL design and implementation, and support of new and existing applications.
• Involved in analyzing business requirements and translating requirements into functional and technical design specifications
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Captured data error records corrected and loaded into target system.
• Implemented efficient and effective performance tuning procedures.

Confidential , New Jersey

Informatica Developer

Tools: Informatica10.1/9.5.1,InformaticaDataQuality10.1/9.5,Toad,Autosys,InformaticaMDM, Informatica Data Director(IDD),Tableau

Operating system: Windows XP/Win 7/Win 8, LINUX and UNIX.

Database: Oracle 9i, Oracle 10g,Teradata

Responsibilities:

• As an ETL Tech lead, lead the ETL development for enhancements in Data warehouse.
• Gathering requirements from the Data Modelers and understanding the design from the technical analysis provided.
• Analyzing the technical documentation and concluding the design of the ETL loads.
• Extracting the data from the Relational Databases, Flat files using ETL process.
• Developing the ETL mappings according to the loads for Stage and Reporting.
• Worked on data profiling & various data quality rules development using Informatica Data Quality.
• Building mappings, workflows in a cost effective manner.
• Worked on all phases of data warehouse development life-cycle, ETL design and implementation, and support of new and existing applications.
• Designed, Developed and implemented Informatica Developer Mappings for data cleansing using Address validator,Labeler, Association, Parser, Expression, Filter, Router, Lookup transformations etc.
• Imported mapplets and mappings from Informatica developer (IDQ) to Power Center.
• Created generic rules in Informatica developer as per the business.
• Worked with IDQ toolkit, Analysis, data cleansing, data matching, data conversion, reporting and monitoring capabilities.
• Involved in analyzing business requirements and translating requirements into functional and technical design specifications.
• Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Used Debugger in Informatica Power Center Designer to check the errors in mapping.
• Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.
• Worked on data cleansing and standardization using Cleanse Adapter’s in Informatica MDM.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Support true ad hoc query by having predictable and consistent query performance for all queries and no requirement for known query workloads or precomputation of aggregates or summaries using tableau.
• Captured data error records corrected and loaded into target system.
• Implemented efficient and effective performance tuning procedures.
• Used Address validator transformation in IDQ and passed the partial address and populated the full address in the target table.
• Resolving performance issues by understanding the bottles necks at various levels and tuning them for better performance.
• Resolving productions issues for any scheduled jobs failures and reporting issues to the concerned teams.
• Documenting the Cut over plans, Design documents and Run books for the Production support teams.

Confidential

Informatica Developer

Responsibilities:

• Gathered Business requirements from concerned users and analyzed the Functional Requirement Documents (FRD) and drafted the Technical Specifications based on the Informatica ETL standards and also conducted Impact and feasibility analysis.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of data in the data warehouse.
• Created various Informatica jobs using transformations such as Source Qualifier, Normalizer, Union, Expression, Filter, Connected Lookup, Unconnected Lookup, Update Strategy, Sorter, Aggregator, Router, and Sequence Generator etc.
• Used Informatica Debugger for debugging mappings.
• Well versed in loading the Data into different targets from source systems like Flat files, Oracle, DB2 and loaded into Oracle and Flat files.
• Designed Reusable Transformations using the Transformation Developer & created Mapping Parameters and Variables.
• Extracting data from set of flat files through Direct or Indirect file methods.
• Created various Informatica tasks such as Sessions, Email, Decision, Control, Command, Timer, Assignment, Event Wait and Event Raise.
• Developed Error Logging and Error Handling methodologies.
• Implemented Global Parameter file to centralized all the parameters and variables for the Database connections, file paths etc.
• Tuned Informatica mappings for better performance using various strategies based upon the analysis done.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Created UNIX Shell scripts to create wrapper scripts to run the workflows and ftp the target files to Mainframes server.
• Installed Informatica PowerCenter 9.1 and configured in Development, QA and Production.
• Created deployment groups for deploying the mapping from one environment to another.
• Responsible for Release migration in between different environments.
• Provided 24/7 On-Call support to resolve the Informatica related issues on Production system and used to support ETL Applications.