SUMMARY:

• 9 years of experience in business Intelligence as a Senior ETL Informatica PowerCenter /Informatica IDQ developer & database developer.
• Extensively used Informatica PowerCenter Informatica Data Quality (IDQ) 9.6/9.1, Informatica Data Explorer (IDE) as an ETL tool for extracting, transforming, loading and cleansing data from various source data inputs to various targets, in batch and real time.
• Followed Agile methodology, Scrum process.
• Strong experience in relational databases - Oracle, DB2, Teradata, Netezza and SQL Server.
• Experience with Cloud technologies - Salesforce, Workday.
• Experience in integrating data from flat files - fixed width, delimited, XML, WSDL, Web Services by using various transformations available in Informatica such as - Source qualifier, XML parser, Web services consumer transformations.
• Extensively used Informatica data masking transformation to mask NPI data (SSN, birth date, account number etc) in Dev, QA environments.
• Used various Informatica Powercenter and Data quality transformations such as - source qualifier, aggregator, update strategy, expression, joiner, lookup, router, sorter, filter, web services consumer transformation, XML Parser, labeler, parser, address validator, match, comparison, consolidation, standardizer, merge to perform various data loading and cleansing activities.
• Complete understanding of regular matching, fuzzy logic and dedupe limitations on IDQ suite.
• Complete knowledge of using XML, MQ series as the source and target.
• Extensively used data masking transformation for masking / scrubbing various sensitive fields such as social security number, credit card number, agreement numbers etc.
• Integrated Informatica data quality mappings with Informatica powercenter.
• Complete understanding of Informatica MDM (Sipherian MDM) including landing tables, staging tables, base objects, match, merge and unmerge process.
• Created various profiles using Informatica Data Explorer (IDE) & IDQ, from existing sources and shared those profiles with business analysts for their analysis on defining business strategies in terms of activities such as assigning matching scores for different criteria etc.
• Used various performance techniques in Informatica such as - partitioning, tuning at source/target/ transformation, usage of persistent cache, replacing transformations that use cache wherever possible.
• Created complex mapplets to be shared among team members.
• Extensive experience in developing various tasks, workflows, worklets, mapplets and mappings.
• Designed and enabled Informatica workflows as Web Services using Web Service as the source & target and exposed them for real-time processing.
• Authorized to work in the US for any employer

TECHNICAL SKILLS:

Architecture: EDW (Enterprise Data Warehousing), BIRA (Business Intelligence Reference Architecture), FDW (Federated Data Warehousing)

Business Systems: Investment Products, Insurance, Enterprise Claims Management Systems, Banking products.

Methodologies/Data: Modeling Tools Data Mart, Dimensional, Snow Flake, Star Schema, ERWIN

Databases: Teradata Oracle 11g /11i/10g, DB 2 10.1 / 9.7/ 9.5/ 9.1, Netezza, SQL Server 2012 / 2008.

Data Warehousing: Informatica PowerCenter IDQ 9.6/9.5, IDE 9.Business Objects XIR3, Qlikview 11.2

Scripting Languages: Unix Shell Script

PROFESSIONAL EXPERIENCE:

Senior Informatica Powercenter & IDQ Developer

Confidential, Saint Paul, MN

Responsibilities:

• Performed the roles of Senior ETL Informatica and Data Quality (IDQ) developer on a data warehouse initiative and was responsible for requirements gathering, preparing mapping document, architecting end to end ETL flow, building complex ETL procedures, developing strategy to move existing data feeds into the Data Warehouse (DW), perform data cleansing activities using various IDQ transformations.
• Collaborated with data architects, BI architects and data modelling teams during data modelling sessions.
• Extensive experience in building high level documents depicting various sources, transformations and targets.
• Extensively used Informatica transformations - Source qualifier, expression, joiner, filter, router, update strategy, union, sorter, aggregator and normalizer transformations to extract, transform and load the data from different sources into DB2, Oracle, Teradata, Netezza and SQL Server targets.
• Extensively used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
• Extensively used ETL Informatica to integrate data feed from different 3rd party source systems - Salesforce and TouchPoint.
• Used Standardizer, Labeler, Parser, Address Validator, Match, Merge, Consolidation transformations.
• Worked on performance tuning of Informatica and IDQ mappings.
• Created Informatica workflows and IDQ mappings for - Batch and Real Time.
• Converted and published Informatica workflows as Web Services using Web Service Source & Target & web service provider capabilities of Informatica.
• Invoked several 3rd party web services using Web Services Consumer transformation.
• Used HTTP transformation to invoke REST web service POST method to upload attachment to a 3rd party application for loading the data.
• Used Informatica data masking transformation to mask NPI data (SSN, Date of birth etc) in Dev & QA environments and used default and custom dictionaries in the masking process.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.
• Worked on a POC to use Informatica powerexchange for cloud connector to access Workday cloud connector and read/load data into Workday application.
• Worked closely with MDM team to identify the data requirements for their landing tables and designed IDQ process accordingly.
• Extensively used XML, XSD / schema files as source files, parsed incoming SOAP messages using XML parser transformation, created XML files using XML generator transformation.
• Worked extensively with Oracle external loader - SQL loader -to move the data from flat files into Oracle tables.
• Worked extensively with Teradata utilities - Fastload, Multiload, Tpump and Teradata Parallel Transporter (TPT) to load huge amounts of data from flat files into Teradata database.
• Created BTEQ scripts to invoke various load utilities, transform the data and query against Teradata database.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQLAssistant and Query man.
• 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.
• Excellent Experience with different indexes (PI, SI, JI, AJIs, PPI (MLPPI, SLPPI)) and Collect Statistics, wrote Teradata Macros and used various Teradata analytic functions.
• Knowledge on Teradata Manager, TDWM, PMON, DBQL, extensively used SQL Analyser and wrote complex SQL Queries using joins, sub queries and correlated sub queries.
• Generated explain plans to identify bottlenecks, path of the query, cost of the query, broadcasting in partitioned database, indexes that are getting picked.
• Extensively used OLAP queries - Lead, Lag, First Value, Last Value to analyze and tag rows for type-2 processing.
• Generated explain plans for performance tuning of queries and identifying the bottlenecks for long running queries, worked with DBA to fix the issues.
• Extensively used PowerExchange for Mainframe to read data from mainframe / VSAM/ COBOL files and load into Oracle tables.
• Extensively used PowerExchange for Salesforce to read data from relational sources (Oracle) and load into Salesforce objects.
• Used Netezza Bulk writer to load huge amounts of data into Netezza database.
• Extensive experience in querying Salesforce objects using workbench.
• Extensively used JIRA & ServiceNow for creating requests for access, production migrations, component migrations & production related service requests.
• Used Jenkins to automate packaging and deployment of various ETL, Unix components.
• Scheduled jobs using Control-M manager, Autosys.
• Owned the defects from production as well as from system testing and worked on the solutions.
• Created Procedure Document for Implementation procedures for every release for all the UNIX, Informatica Objects and if any catch-up process needed to be done.
• Provided on-call support for the newly implemented components and existing production environments and made sure that the SLA has been met.

Financial Advisor and Financial Institution

Confidential, Lake Mary, FL

Responsibilities:

• Created the Design for Extraction process from legacy systems using combined techniques of Data Replication and Change Data Capture.
• Extensively used Informatica web services Consumer transformation to invoke 3rd party web services on Billing, Payments.
• Enabled Informatica workflows as web service to be invoked and used by different client systems.
• Created test Java programs to test the Informatica web services and Try - it option on Web Service Hub.
• Used Informatica Data Quality transformations to parse the "Financial Advisor" and "Financial Institution" information from Salesforce and Touchpoint systems and perform various activities such as standardization, labeling, parsing, address validation, address suggestion, matching and consolidation to identify redundant and duplicate information and achieve MASTER record.
• Extensively used Informatica Data Quality transformations - Labeler, Parser, Standardizer, Match, Association, Consolidation, Merge, Address Validator, Case Converter, and Classifier.
• Created highly optimized ETL processes to move the data from legacy systems, DB2 and flat files into Oracle database.
• Invoked SOAP & REST web services using URL from HTTP transformation.
• Used POST and GET methods to upload and download attachments from web services using HTTP transformation.
• Extensively used Informatica DVO (Data Validation Option) for data comparison between source and target tables, data validation after workflow completion.
• Used Informatica DVO to create table pairs, test rules, SQL views options to create various data validation scenario's and used RunTests command to execute the table pairs and send out emails with the status of data validation.
• Extensively used Data masking transformation to use default and custom dictionaries to mask the non-production data.
• Scheduled Informatica & Unix jobs using Control-M.
• Extensively used Informatica DVO for unit testing in Dev environment.
• Involved in performance tuning of SQL queries & Informatica mappings.
• Knowledge on banking products, equities and bonds.

Environment: Informatica Powercenter 9.6, Informatica Data Quality (IDQ) 9.6, Informatica Data Explorer (IDE) 9.6, Informatica MDM 9.6, Data Masking, Informatica PowerExchange for Mainframes, Informatica DVO, SQL Server 2008, Oracle 11i, Teradata 12, Fastload, MQ series, HTTP, REST web services, Multiload, Tpump, Teradata Parallel Transporter (TPT), Netezza, Bulk writer, AIX-UNIX, Korn, T-SQL, COBOL, KORN, Shell script, Autosys, JIL Scripts, Rapid-SQL, TWS, Toad, SQL Loader, Load, PL/SQL, PVCS, ServiceNow, Visio, Rumba (Mainframes).

Senior Informatica Powercenter & IDQ developer

Confidential, Lake Mary, FL

Responsibilities:

• Involved in functional design reviews and lead technical design reviews.
• Extensively used ETL Informatica to integrate data feed from different 3rd party source systems - Claims, billing, payments.
• Used Informatica Data Quality transformations to parse individual consumer information from various vendors such as Acxiom, Alliant to identify the true source of policy holder's origination and assign credits accordingly by performing various activities such as standardization, labeling, parsing, address validation, address suggestion, matching and consolidation to identify redundant and duplicate information and achieve MASTER record.
• Extensively used Informatica Data Quality transformations - Labeler, Parser, Standardizer, Match, Association, Consolidation, Merge, Address Validator, Case Converter, and Classifier.
• Extensively used in-built reference data such as - token sets, reference tables and regular expressions and created new set of reference tables to identify the noise data and standardization of input data.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.
• Created various data quality mappings in Informatica Data Quality tool and imported them into Informatica powercenter as mappings, mapplets.
• Used Informatica Data Masking to mask sensitive data in Dev, QA environments.
• Scheduled jobs using Autosys, TWS.
• Extensive knowledge on defect tracking tools - TRAC, RMS as version control management tool.
• Used Informatica powerexchange to connect to Netezza and loaded huge amounts of data using Bulk writer external loader.
• Provided on-call support for the newly implemented components and existing production environments and made sure that the SLA has been met.

Environment: Informatica Power Center 9.6, Informatica Data Quality (IDQ) 9.6, Informatica Data Explorer (IDE) 9.6, ILM TDM, Netezza, Bulk Writer, Teradata 13, Oracle 11i. DB2 10.1, SQL Server 2012, SQL Developer, SQL Loader, Fastload, Multiload, Tpump, Fastexport, Teradata Parallel Transporter (TPT), Teradata SQL assistant, BTEQ, T-SQL, PL/SQL, RMS, Linux, AIX, Toad, Winsql, Putty, UltraEdit, Data Masking, PowerExchange for mainframes, MQ Series, PowerExchange for Salesforce, XML, UC4, Control-M, Rally, Enterprise Manager, Autosys, JIL Scripts, Jenkins, JIRA, Unix shell scripting, XML Spy.

Informatica Developer

Confidential, Herndon, VA

Responsibilities:

• Responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders.
• Responsible for maintaining repository backups and their restorations.
• Responsible for migrations from Development repository to the QA and Prod repositories.
• Bench Mark testing of Hardware and Informatica Power Center mappings to calculate the load times for batch processing and tuning the mappings.
• Installed and Configured Informatica Power Center on Client and Server Machines and Configure Informatica Server and Registered Servers.
• Install and configure Power Exchange for Oracle and SQL server.
• Implemented Type II Slowly Changing Dimension methodology for accessing the full history of customers.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, dynamic Lookup, Filter, Update Strategy, and Router transformations.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Worked with the DBA to improve Informatica session performance and query performance by collecting statistics and defining relevant indexes on target tables.
• Created Data Flow Mappings to extract data from source system and Loading to staging area.
• Analyzed the Source data and developed the code to extract the data and implemented in the informatica.
• Extensively worked on Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Worked on various tasks like Session, E - Mail task and Command task.
• Used mapplets, parameters and variables in mappings as per the requirement.
• Used versioning and shared folders for better control on Informatica jobs among the team and across different projects.
• Worked on slowly changing dimension Type2.
• Involved in performance tuning of the process at mapping, session, source level and at target level.
• Support Production job failures and resolve the issue in timely manner.
• Troubleshoot the Productions failure and provide root cause analysis.
• Worked on emergency code fixes to Production.
• Involved in testing by using Informatica workflow manager and monitor, etc. and extensive testing on log files to detect errors.
• Tested different data load databases by comparing source and target table counts and tested

Environment: Informatica Powercenter 9.1/8.6, Informatica PowerExchange for Mainframes, Oracle 10i, DB2 8.6, AIX-UNIX, Korn, Shell script, DB2 Ingest, Toad, SQL Loader, Load, PL/SQL, PVCS, Visio