PROFESSIONAL SUMMARY:

• Around 12+ years of experience in Data Engineering projects, multiple projects on Data Quality Management, Data profiling & Transformation, Dynamic Rule Application, Data Migration & Master Data Management.
• Extensive Design, Development, Testing and Implementation of various applications in OLTP, Client/Server OLAP environment using BI tools in Healthcare, Retail, Marketing, Insurance and Pharmaceutical industries
• Experience in BI, ETL data integration developing in ETL Mappings, Mapplets, Workflows, Worklets and scripts using Informatica Power Center/Power exchange 9.x/8.x/7.x, S 9.6/10, Informatica MDM
• Expertise in software development, maintenance, testing and troubleshooting on data quality, data integration and Oracle database environment, Repository Access, Integration Services. experience in the configuration of MDM Hub which includes Data modeling, Data mappings, Data validation, Match and Merge rules, Tokenization, Hierarchy Manager, customizing/configuring Informatica Data Director.
• Informatica B2B Data Exchange, Designing and developing B2B transformations for EDI and other formats using Informatica B2B Data Transformer.
• Working closely with Architects, Lead and Project Manager for the applications assessment to all the Data Masking Team on Proxy server and proving support on the databases and applications.
• Good Knowledge on applying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformation and loading into targets.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Expertise in Change Data Capture (CDC), ODS (real - time data), Meta Data Management (MDM), Incremental Extracts, Slowly Growing Targets.
• Expertise in tuning the DW environment including Oracle SQL query tuning, Database tuning and in Informatica Power Center to identify bottlenecks, tune and remove bottlenecks.
• Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica Power Center and IDQ.
• Expertise in developing ETL processes using Informatica, including ETL control tables, error logging, auditing, data quality, data conversion, etc.
• Expertise in analyzing and understanding the business requirements and designing the applications based on it.
• Strong knowledge of Normal Forms, Star Schema and Snow Flake Schema.
• Expertise in Developing PL/SQL Packages, Stored Procedures, Functions and Triggers.
• Expertise in UNIX / LINUX Shell Scripting.
• Expert-level mastery in designing and developing Complex Mappings to extract data from diverse sources including RDBMS Tables, Flat Files and Legacy System Files.
• Excellent Communication, Analytical skills and Interpersonal skills. Exceptional ability to learn new concepts.
• Skilled at accessing client needs, working in a group, suggesting ideas that enhance Efficiency and Maximize Performance,
• Implementing Cutting-edge Technology Solutions and Training/Supporting end users.
• An excellent team player with Good interpersonal skills, commitment, result oriented, Multitasking, Hard working with Analytical skills.

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 10.1, 9.5.1/9.1/8.6.1/8.1 (Repository manager, Designer, Workflow manager, Workflow monitor), IDQ (Informatica data quality), Data cleansing, Master Data Management (MDM)

Database: Oracle10g/11g, SQL Server2008/2013, TERADATA,DB2, Netezza, Sybase ASE

Languages: PHP, C++, C#, SQL, PL/SQL, HTML, Unix/Linux Shell Scripting

BI Tools: Tableau (Desktop & Server), Micro Strategy 9.0.1, 9.3,OBIEE 10g/11g,Power BI

Other Tools: SQL Server 2013 BI Tools (SSIS, SSAS, SSRS),Toad

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Sr. Informatica Consultant

Responsibilities:

• Responsible for Technical Design Document and Detail mapping document. Analyzing and understanding functional requirements.
• Extracting data from different sources and loading into SAP HANA database.
• Developed different transformation processes to load data from source to target using various transformations.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Used Aggregator, Expression, connected lookup, Un connected lookup, Router, Update strategy transformation to create the mapping
• Created different source definitions to extract data from XML and flat files and relational tables using informatica power center.
• Used XML editor to create personalized views and validated them.
• Listed the bad records in the spread sheet or the business people for manual correction by exporting the bad records table from analyst tool to model repository.
• Created the reference tables both manually and from existing values in the Analyst tool and exported it to Model repository usage.
• Reviewed the source data information using the analyst tool for IDQ
• Responsible for best practices like name conventions, Performance tuning, and Error Handling.
• Responsible for performance Tuning at the source level, Target level, mapping level and Session level.
• Developed the UNIX shell script to generate the Inventory sync excel report for end user data validation.
• Create effective test data and unit test cases for reporting system to ensure the successful execution of the data loading processes.
• Created and scheduled jobs based sessions, on demand, run on time and run only once using workflow manager.
• Created sql scripts to verify test cases from source to target database oracle.
• Used Tidal Job scheduler in creating and scheduling the job’s run timings.

Environment: Informatica Power Center 9.6 and 10.1, Informatica Power Exchange, Informatica IDQ v.10, SAP HANA, Oracle 11g, SQL Server, Neteeza, MFT, Tidal, Unix Scripting

Confidential, New York

Sr. Informatica Consultant

Responsibilities:

• Responsible for technical development and support of Data Governance and Data Analytics solutions utilizing Informatica suite of products: Informatica Data Quality (IDQ), Master Data Management (MDM) as well as Power Center ETL.
• Produced detailed MDM design specifications consistent with the high-level MDM design specifications.
• Implemented Enterprise Data Hub solution on Informatica BDM and Amazon Redshift platform with staging in S3 raw buckets.
• Experience in Informatica B2B Data Exchange using Unstructured, Structured Data sets.
• Used Unstructured Data like PDF files, Spreadsheets, Word documents, legacy formats, and print streams option to get normalized data using B2B Data Exchange of Informatica.
• Designed ETL processes utilizing Dynamic Mappings for mass ingestion of data comprised of up to several hundred tables/files to load into raw and refine zones. Dynamically applied data standardization, datatype conversion and cleansing rules.
• Designed end to end application process flow for Informatica Master Data Management solution, including inbound/outbound data integration (ETL), maintenance/tuning of match rules and exceptions. Executed initial data load and incremental updates, worked with infrastructure and DBA teams to maintain multiple environments.
• Design, document and configure the Informatica MDM Hub to support loading, cleansing of data.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Collaborated with business and technical teams to gather requirements around data quality rules, proposed rules optimization, designed and developed these rules in IDQ. Implemented data profiling, created score cards, reference tables and documented DQ metrics like accuracy, completeness, duplication, validity and consistency.
• Developed extensions and customizations to the services (SIF) tier of Informatica MDM Hub
• Designed data quality specific ETL jobs including Address standardization and validation, emails, names parsing and phone cleanups. Migrated and integrated IDQ mapplets into Power Center batch processes.
• Designed and developed end-to-end ETL batch automation.

Environment: Informatica BDM 10.1.1 U2, Informatica Power Center 9.6 and 10.1, Informatica Power Exchange, Informatica B2B, Informatica MDM v.10, IDQ v.10, Oracle 11g, SQL Server, Big Data Hadoop, HDFS, HBase, Hive, Amazon EC2, AWS Redhsift, HP ALM.

Confidential, Plano, TX

Sr. Informatica Consultant

Responsibilities:

• Providing guidance in design, development, and implementation of ETL solutions in support of the corporate wide initiative to reduce complexity.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing.
• Worked on exception handling mappings for Data quality, Data Profiling, Data cleansing and data validation by using IDQ
• Developed MDM solution meeting technical specifications and business requirements
• Participated in MDM design reviews, including database code design reviews
• Established and promoted ETL Development Standards and Best Practices. Worked with ETL administration team and Infrastructure team on implementing standards and improving release management procedures.
• Documented and communicated technical architecture and ETL solution approaches. Developed processes design and Standard Operational Procedures (SOP) artifacts.
• Work closely with the Business Analyst resources in creating the code for data migration into Data Management Systems.
• Provided technical support to development team in resolving test defects.
• As part of Leads group responsible for build coordination and operational support of various development environments.
• Implemented ETL scheduling through CTRL M enterprise job scheduling tool. Implemented scheduling standards. Resolved tool technical issues and deficiencies.
• Scheduling and supporting MDM HUB database weekly backups.
• Conducted code reviews, promoted ETL best practices, mentored junior developers and conducted technical interviews.
• Involved in Error handling and auditing in ETL Processes.
• Responsible for utilizing technological analysis and design principles to formulate detailed application plans and processes in order to implement clients' requests for new or modified functionalities.
• Responsible for weekly status updates showing the progress of the ETL process.
• Documented Process Flow for mappings and sessions.
• Created Run and wrapper Scripts to call set of Informatica workflows and shell scripts to insert the records in ETL control table.

Environment: Informatica PowerCenter 9.6 on Windows platform, Informatica IDQ, Informatica MDM, SQL Server Management Studio 2012, Erwin, Windows PowerShell Scripting, Visual Studio 2013, MS TFS, Agile, XML/XSD, JAMS, SharePoint, VISIO, HPQC.

Confidential

Sr. Informatica MDM Developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Extracting data from different sources and loading into target database such as flat files, Relational and XML.
• Extraction, transformation and loading were performed using Informatica PowerCenter to build
• The data warehouse
• Extensively used Informatica Designer to create and manipulate source and target definitions,
• Mappings, mapplets, transformations, re-usable transformations.
• Worked on data cleansing and standardization using the cleanse functions using IDQ and implemented in Informatica MDM.
• Defined Match rules in Match and Merge settings of the base tables by creating Match Path Components, Match Columns and Rule sets.
• Performed match/merge and ran match rules to check the effectiveness of MDM on data
• Worked on various transformations such as Aggregator, Normalizer, Upgrade strategy, Router, sorter, source
• Qualifier, Filter, Expression, Lookup, Sequence Generator and Joiner.
• Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
• Used Pipeline partitioning to improve Session performance
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL
• Procedures for performing different database tasks
• Made extensive use of UNIX Shell scripting, setting UNIX corn jobs, maintaining user profiles, archiving log files etc.
• Around 1TB of data into target, by scheduling the sessions.
• Sessions and batches were created using Server Manager to load the data into the target tables.
• Performed Unit Testing and validated the data.
• Created partitions through the session wizard in the server manager to increase the performance.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.

Environment: Informatica Power Center 9.1,Informatica IDQ, Informatica MDM, Oracle 10g, PL/SQL, Sql Server 2005 and Windows 2000, UNIX

Confidential

Informatica MDM Developer

• Interacted with Business Users and Managers in gathering business requirements.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively used Teradata utilities like Fast load, Multi-load to load data into target database.
• Excellent knowledge on ETL tools such as Informatica MDM load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM on data.
• Extensively worked on Power Center Client Tools like Power center Designer, Workflow Manager, and Workflow Monitor, IDQ
• Extensively worked on Power Center 8.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregation, Update Strategy, lookup, Rank and Filter.
• Created Parameter files and validation scripts.
• Created used custom Mload Scripts from command task.
• Created Process Control and Metadata for informatica jobs.
• Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager.
• Involved in providing 24/7 production support to solve critical issues.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Extensively worked with various systems like Oracle, Teradata, MS Access, Flat files, XML and SQL Server.
• Assisted with peer code reviews and testing of development team's T-SQL code.
• Performed Unit testing and Data validation testing using Validation scripts.
• Proven Accountability including professional documentation and weekly status report.

Environment: Informatica Power Center 9, Informatica IDQ, Informatica MDM, Oracle 11g, SAP BW Flat Files, Teradata R12, BTEQ, UNIX, Win XP, SQL * Plus, PL/SQL, Transact-SQL

Confidential, North America

Informatica Developer

Responsibilities

• Involved in requirements gathering, functional/technical specification, Designing and development of end-to-end ETL process
• Extracting data from different sources and loading into target database such as flat files, Relational and XML.
• Developed different transformation processes to load data from source to target using various transformations
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Used Aggregator, Expression, connected lookup, Un connected lookup, Router, Update strategy transformation to create the mapping
• Used mapping parameter to customize the mapping
• Scheduling the session tasks, command task comprising of different mappings
• Used Session Partitions, dynamic cache memory, and Index cache to improve the performance of Informatica server.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Performed unit test cases for different Target Instance
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

Environment: Informatica Power Center 7.1/8.1, Oracle 9i, PL/SQL, TOAD and Windows 2000, Shell Scripts, Autosys

Confidential

Informatica Developer/Data Analyst

Responsibilities:

• Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created and scheduled Worklets. Setup workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
• Developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer and Server Manager.
• Extensively used almost all of the transformations of Informatica including lookups, Stored Procedures, Update Strategy.
• Developed sessions using Informatica Server Manager.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables and Bitmap Indexes.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.

Environment: Informatica Power Center 6.1, Oracle 9i, PL/SQL and Windows 2000, UNIX