SUMMARY

• Overall 7 + years of experience in teh field of IT Industry.
• Experience in full life cycle of Software Engineering including design, implementation, testing, and maintenance and production support of Data Mart, Data Warehouse systems.
• Strong technical and development expertise in Informatica MDM, Informatica Power Center, SQL, Oracle,SSIS, Data stage, UNIX Shell Scripting and applied in manufacturing and telecom domain projects and also worked in Kimball and Agile SCRUM Development methodology wif smaller iterative releases.
• Thrives in challenging environments wif an aptitude for learning and applying new technologies. Key strengths are hard work, dedication and strong belief in teamwork.
• Has got teh opportunity to play multiple roles in my career so far in form of ‘Technical Lead’, ‘Sr. Informatica MDM consultant/Sr.Informatica developer/ /PL/SQL developer/Tester/Production Analyst’.
• Experience wif Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling, design techniques and data Modeling using Star/Snowflake Schema Design, Relational and Dimensional Data Modeling, Fact and Dimensional tables.
• Strong experience in understanding business Scope, Design, Development, Customization and Production Support of Informatica MDM 9.7.1,Informatica Power Center 9.6.x/8.6.x projects, UNIX, Oracle and SQL Server
• Strong experience in Installing and Configuring of various Informatica MDM components
• Data modeling, data mappings, data validations, data standardization, defining business rules for cleansing, matching, merging and maintaining data.
• Created and Configured Landing tables, Staging Tables, Base Objects, Hierarchies, Foreign Key Relationships, Lookups in teh Hub, Queries, Query Groups and Packages in MDM.
• Experienced wif hierarchy manager to develop hierarchies as per teh business needs.
• Created IDD application as per teh business needs by creating teh subject area and subject area groups.
• Extensively used Merge Manager and Data Manager for Managing Data.
• Worked on Repository manager for validation, promotion, importing and exporting teh ORS repositories to development, QA, pre - production and production environments.
• Hands on experience in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Data Validation and Data cleaning using User Exits in MDM Hub and in IDD.
• Developed database objects like Stored Procedures, Functions, Packages and Triggers, Ref Cursor, External TablesandCollections
• Extensive experience in design and creation of ETL mappings and Transformations using Informatica to move data from multiple sources into target using transformations like Source Qualifiers, Expressions, Aggregator, Lookups, Filters, Routers, Joiners etc.
• Extensively created mapplets, common functions, reusable transformations, look-ups for better usability.
• Experience in scheduling of ETL jobs using Autosys, Control-M.
• Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading.
• Successfully resolved issues during Integration testing of multiple projects, single-handedly During teh time of resource-crunch
• Strong Leadership skills- involved in setting up and leading design, development and Production support teams.
• Has received appreciations from client for running teh projects efficiently, managing teh work independently, completing teh challenging tasks in time, and adhering to tough deadlines
• Ability to work TEMPeffectively and efficiently in a team and individual environments wif excellent interpersonal, technical and communication skills.
• Prepare business requirements documents and functional requirements documents to support teh design and development teams in their efforts.
• Responsible for unit and integration testing in readiness for UAT deployment
• Work wif teh change management team to ensure product documentation, including user guides, implementation guides and product information are maintained and up to date
• Communicate TEMPeffectively wif stakeholders to identify needs and evaluate alternative business solutions, deliver informative, well-organized presentations
• Responsible for post-go live application support and transition to support group Mentored junior analysts in their roles and development

TECHNICAL SKILLS

Data Warehousing: Data Warehousing Concepts

Methodologies: Software Development Life cycle (SDLC),Waterfall and Agile Methodology

ETL: Informatica MDM 9.7.1, Informatica Power Center 8.x/9.x

MSBI tools: SQL, SSIS

Scripting Tools: UNIX Shell Script

Database: Oracle 12c,11g,10g/9i,SQL Server 2005/2008/2012

Software: Autosys,Control-M

Version Manager: Visual SourceSafe, CVS, SVN

Tools: Toad, FileZilla, WinSCP, PL/SQL Developer, SQL developer and SSIS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica MDM Consultant/Lead

Responsibilities:

• Currently playing Sr.Informatica MDM Consultant/Lead in teh project where teh development was carried out along wif production support and maintenance
• Installed and configured MDM Hub Console, Hub Store, Hub server, Cleanse and Match Server, Resource Kit, Address Doctor applications by following Informatica Product Availability Matrix( PAM) document
• Created and Configured Landing tables, Staging Tables, Base Objects, Hierarchies, Foreign Key Relationships, Lookups in teh Hub, Queries, Query Groups and Packages in MDM.
• Determined relative trust and validation values of source data and decay in reliability.
• Identified Gloden Record(BVT) by analyzing teh data, cleansing teh data and merging duplicate records coming from different source systems.
• Defined teh Match and Merge Rules in teh MDM Hub by creating match path components, match strategy, match columns and rules.
• Analyzed teh source system for integrity issues to teh data resided in various source systems and defined teh same in Systems and Trust.
• Involved in implementing teh Landing Process of loading teh customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
• Worked on data cleansing and standardization using teh cleanse functions in Informatica MDM.
• Defined teh Trust and Validation rules and setting up teh match/merge rule sets to get teh right master records.
• Configuring Delta detection and raw retention period for teh Base Object.
• Execute Stage Jobs, Load Jobs, Match and Merge Jobs using teh Batch Viewer and Batch groups
• Using SoapUI user interface to communicate wif MDM HUB.
• Working on teh requirements for upgradation of MDM version from 9.7 to 10.1
• Used Informatica’ s features to implement Type I, II changes in slowly changing dimension tables and also developed complex mappings to facilitate daily, weekly and monthly loading of data.
• Created mappings using various Transformations like Source Qualifier, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy and Sequence Generator.
• Involved in data analysis and handling teh ad-hoc requests by interacting wif business analysts, clients and customers and resolve teh issues as part of production support.
• Responsible for performing teh impact analysis in case of new Change Requests from Business in terms of database change, ETL change and performance tuning.
• Helped business team in resolving some of teh critical issues in quick turnaround time.
• Interact wif teh clients on a regular basis to discuss day-to-day requirements, issues and matters.
• Leading a team of 8 offshore and 1 oniste

Confidential

Sr. Informatica Developer/MDM Consultant

Responsibilities:

• Played Sr.Informatica developer and MDM Consultant role in teh project
• Worked atconceptual/logical/physical data model level according to requirements.
• Created and Configured Landing tables, Staging Tables, Base Objects, Hierarchies, Foreign Key Relationships, Lookups in teh Hub, Queries, Query Groups and Packages in MDM.
• Extensively created graph functions and cleanse list for reusability of teh validations
• Created cleanse functions by using pre and user defined conditional statements and existing functions
• Created Mappings for Cleansing teh data and extensively used parameters, advanced mappings options in model workbench
• Defined teh Match and Merge Rules in teh MDM Hub by creating Match Path components, Match Strategy, Match columns and rules for maintaining Data Quality
• Defining teh key type(Fuzzy or Exact) based on teh column values which was provided by doing data profiling
• Extensively used lookups for maintaining referential integrity
• Created teh Batch groups for loading, matching and merging teh data
• Created ETL mappings and Transformations using Informatica to move data from multiple sources into target using transformations like Source Qualifiers, Expressions, Aggregator, Lookups, Filters, Routers, Joiners etc.
• Developed complex workflowsand used various tasks likeEmail, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Sessionin teh workflow manager.
• Worked wif heterogeneous source to Extracted data from Oracle database and flat files and loaded to a relational Oracle warehouse.
• Extensively worked on performance tuning at all levels of teh Data warehouse. Implemented performance tuning by using lookup caches, gathering stats, dropped indexes and re-created them after loading data to targets and increased teh commit interval.
• Extracted teh data from teh flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Implemented SFTP, FTP services to retrieve Flat Files from teh external sources, created UNIX shell scripts to connect external servers using SSH, SFTP and FTP process.
• Loaded data from multiple data files during teh same load session and also into multiple tables during teh same load session.
• Manipulate teh data before loading it using SQL *Loader, using SQL functions to increase teh performance of processing teh data
• Developedshell scriptsfor Daily and weekly Loads and scheduling them usingUnix Cronutility and Control M
• Performed Code and quality reviews on teh deliverables to deliver teh robust, reusable and defect free solutions wif high performance
• Migrated repository objects and scriptsfrom development environment to QA and to production environment

Confidential

Informatica Developer

Responsibilities:

• Played Informatica developer role in teh project
• Worked in analyzing teh current application code and developing teh mappings as per teh existing functionality in Datastage
• Designed and developed Informatica Mappings and Sessions based on existing functionalities and implemented new business rules to load data from source flat files and oracle tables to target tables
• Implemented complex mappings such as slowly Changing Dimensions Type 2 using Flag which is teh consolidation of three Datastage mappings
• Extensively worked wif Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Worked wif email, command tasks, Mapplets, Reusable Transformations and worklets.
• Used shortcuts to reuse objects wifout creating multiple objects in teh repository and inherit changes made to teh source automatically.
• Tuned mappings using Power Center-Designer and used teh best practices to provide maximum efficiency and performance.
• Developed Pre and Post SQL scripts to drop and/or create indexes on Target tables to optimize loading query speed.
• Performed Unit testing, system testing and regression testing
• Migrated repository objects and scriptsfrom development environment to QA and to production environment
• Responsible for managing and prioritizing teh releases and submitting teh deliverables wifin teh timeline.

Confidential

Informatica Developer

Responsibilities:

• Played Informatica developer role in teh project
• Worked on teh Detailed design documentation
• Installed and Configured Informatica Power Center client tools and connected wif each database in Data Ware house using repository server.
• Understanding teh existing system, business requirements and executing new change requests for enhancing teh existing system.
• Hands on experience in creating teh Views, Stored procedures,Functions and Packages
• Preparing ETL specifications for identifying sources, targets and data transformations.
• Exported and Imported mappings between different Informatica folders and also Repositories
• Developing CRON tabs to execute teh above Informatica extracts in an orderly manner.
• Make sure that all teh daily, monthly data loads are happened and should be available to business on time.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Developing and scheduling teh SSIS packages
• Providing end-to-end support for all teh activities that is being carried out in teh OPS monitoring process.

Confidential

Informatica Developer

Responsibilities:

• Played Informatica Developer role in teh project
• Has extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in teh Target.
• Involved in extracting teh data from teh Flat Files and Relational databases into staging area
• Developed ETL programs using Informatica to implement teh major feature related to maintaining Shipment and Delivery data of teh products in Supply chain Management system.
• Created UNIX shell scripts to run teh Informatica workflows and controlling teh ETL flow
• Performed unit testing for teh mappings and system testing to check data consistency wif adherence to teh data model defined.
• Tuned SQL queries to improve response time and managed teh job scheduling using Autosys
• Created teh mappings to Disable and Enable teh indexes so as to reduce teh overall time to load teh data into various target- Fact tables.
• Performed unit testing for teh mappings and system testing to check data consistency wif adherence to teh data model defined.
• Fixed teh invalid mappings and troubleshoot teh technical problems of teh database
• Monitored performance and changed performance requirements through application of Database tuning and performance optimization techniques

Confidential

Informatica Developer

Responsibilities:

• Played Informatica Developer role in teh project
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production
• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop teh mappings using needed Transformations in Informatica tool according to technical specifications
• Developed mappings/sessions for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup, Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored teh results using workflow monitor.
• Write Shell script running workflows in Unix environment.
• Optimizing performance tuning at source, target, mapping and session level
• Tuned SQL queries to improve response time.
• Wrote UNIX shell scripts to run SQL scripts daily.
• Worked closely wif DBA for proper backup and recovery plans.
• Monitored performance and changed performance requirements through application of Database tuning and performance optimization techniques