EXPERIENCE SUMMARY:

• Around 11 years of total IT experience in analysis, design, development and implementation of data warehouse, analytical systems and Master Data Management with emphasis on Data Integration using Informatica Power Center, SSIS, Informatica Developer Tool, Informatica Analyst tool, Teradata Tools & Utilities, Microsoft SQL Server, and Oracle and automation using Tidal, Autosys Scheduling Tool /Informatica Scheduling following ELT/ETL Methodologies
• Data Integration experience includes the design and development of ETL to and from OLTP databases, Data Warehouses, Data Marts and MDM Databases.
• Hands on experience in Master Data Management using Informatica MDM Tool.
• Hands on experience in ETL Development using Informatica Power Center, SSIS, OWB.
• Hands on experience in Data Modeling for OLTP, ODS, OLAP and MDM systems
• Hands on experience in EDW solutions on Teradata, Oracle & SQL server
• Good knowledge & Hands on experience in big data eco - system Hadoop, Map/Reduce, Hive, Impala, Pig, Flume,Kafka,Sqoop, HBase(No SQL Database), Oozie, Hue, Spark etc.,
• Experience in building EDW solutions using Hadoop Ecosystem Tools
• Hands- on experience in Erwin Data Modeler, Teradata Oracle and SQL Server.
• Experience in handling XML, JSON data sources
• Experience in Extraction, Transformation and loading (ETL) of data from various sources into Data Marts and Data Warehouses using Informatica Power Center Tools (Designer, Workflow manager, Workflow Monitor and Repository Manager).
• Vast experience in developing complex mappings using Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Normalizer, Sequence Generator and Lookup Transformations.
• Experience in the integration of various data sources such as Oracle, Teradata, SQL Server and Flat files.
• Hands on experience in design and configuration of landing tables, staging tables, ODS, base objects, hierarchies, foreign-key relationships, lookups
• Experience in Data profiling using Informatica Analyst Tool as part of Discovery of source data.
• Experience in Exporting IDQ mappings to Informatica Power center.
• Experience in Informatica Cloud mappings using various transformations like Expression, Lookup, Filter, aggregator and update strategy transformation.
• Experience in migrating the code from one environment to another environment.
• Extensively used Teradata Tools like Teradata SQL assistant, Teradata Administrator and utilities MLoad, Bteq, FastExport and FastLoad, TPT to for loading multiple tables as part of batch processing and maintaining data warehouse.
• Thorough knowledge in Teradata Architecture.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning.
• Proficient in Writing SQL Scripting and PL SQL Programming.
• Proficient in UNIX/Linux Commands and shell scripting.
• Hands on experience on Tidal and Autosys Scheduler Tool.
• Experience in SCD’s Type 1 & Type 2. Worked on Normalizing/De normalizing Database.
• Worked in a variety of Business domains which includes Life Sciences and Health Care.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions in Informatica.
• Worked on Informatica Data Quality (IDQ 9.6.1/9.5.1 ) tool.
• Extensively worked on Informatica Push down optimization for better ETL performance.
• Worked with business to help estimate, and propose solutions for any improvements in the systems or for business needs.
• Experience in Erwin Data Modelling Tool to create Conceptual/Logical/Physical Data Model and follow best practices for naming conventions.
• Experience in designing High Level design documents (HDD) and Low Level Design documents (LLD) for data warehouse development projects complimented with Data Flow diagrams using Visio for each subject area.
• Connected salesforce.com using Informatica Developer Tool and exposed data as web service as part of Data virtualization POC for CITRIX client as part of proposal work.
• Worked on Proposal and provided a solution to Miami Children’s Hospital for their business needs sending report to one of the top Magazines and provided solution to Miami Children’s hospital for their needs by Designing ETL for processing Survey questions & answers data and helped ETL team to complete development and Production.
• Installed, Configured core Informatica MDM 9.6.1 (Master Data Management) Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD. Installed ORS schema.
• Hands on experience in AWS EC2, AWS S3, and AWS Redshift as part of prototype internal project work.
• Coordinated with testing team in developing Test Plans, Creating and Executing Test Cases.

TECHNICAL SKILLS:

Domain: Life Sciences, Healthcare, Pharmaceutical, Sales, Insurance, Supply Chain

MDM Tools: Informatica MDM Multidomain v9.6.1,v9.5.1

ETL Tools: Informatica Power Center v10.1, v9.6.1, v9.6, v9.5,v8.6,v8.5,v8.1

Data Quality: Informatica Data Quality v 9.6.1/9.5.1 /9.1

Data Modelers: CA Erwin Data Modeler v9.6, Microsoft Visio v2010

RDBMS: Teradata v15.0/v14/v13.1/v12, Oracle 11g,10g,9i, SQL Server v2012,v2008,v2003

Database: SQL, PL/SQL

Programming: Unix/Linux Shell scripting, C,C++,JAVA

DB Client Tools: Oracle SQL Plus, Toad for Oracle, Teradata SQL Assistant, SQL Server Management Studio, SQL Workbench, Oracle SQL developer, DB visualizer Pro

Web App Servers: RedHat JBoss v6.1.0

Cloud Technologies: Amazon (EC2, S3),Informatica Cloud

Big Data Technologies: Cloudera Hadoop, HDFS, Map Reduce, Apache Hive, Impala, Pig, Sqoop, Oozie, HBase,Flume,Hue,Kafka

WORK EXPERIENCE:

Confidential

On-site Technical Lead

Responsibilities:

• Mainly participated in application support activities like service request accomplishment and incident resolution
• Worked with business user on incidents/service requests.
• Worked and Managed Service now (tool) service tickets raised by User.
• Worked on Teradata TPT errors in Operations,
• Handled technical and functional call across the enhancement and Build teams.
• Providing valuable suggestion for service improvement not only on technical but also on Process wise.
• Changed Logical/Physical Data model for enhancements from user.
• Worked on data anomalies, code issues and fixed them.
• Impact assessment for any source system changes or enhancements on ongoing operations
• Used Cloudera Hadoop big data ecosystem, HDFS, Hive, impala, hue for GS/GO EDL project development and also incorporated JSON Files as config files and automated using Unix shell scripts
• Exported data out of EDL to EDW on demand using Sqoop and vice-versa.
• Involved in loading data from source system to HDFS as part of Enterprise data lake (EDL) using Scoop scripts.
• Load data to Hive and write hive queries on demand.
• Review existing scripts for Loading EDL layer as part of solving tickets.
• Involve with user understanding issue, troubleshooting issues and answering the question or issues raised as part of service Tickets.
• Involved in Code Migration from Dev to QA to PROD Environments.
• Worked with Offshore and help team understanding issues and troubleshooting tickets.
• Write script for loading data in HDFS and consume the hive tables.
• Provide valuable suggestion in performance tuning for ongoing production loads.
• Worked with different team on Teradata Space management as our environment was shared between different teams.
• Lead offshore team on production loads and help team troubleshoot production failures.
• Reverse engineer code as part of troubleshooting issues.
• Worked with stakeholders/users on Data release to users while avoiding escalation and make sure service on data delivery on time is met.
• Worked on Tableau data refresh to release the data to end users.
• Analyze the ETL code from source to Tableau to identify where the issues exist.
• Worked on Production critical issues and solved several incidents and release the data metrics to user without escalation
• Handled multiple user requests in efficient way and provided quick work around to close the requests.
• Manage the ticket priority by discussing with different users and aligned users on the same.
• Manage the critical incidents by having a quick call with users, understand issue and provide the resolution within no time to avoid escalation from users on data issues.
• Collaborated with various technical teams and business users for Development, QA, UAT and Production Support.
• Authored / Maintained technical documentation such as HLA documents, Technical LLD documents, release notes for migration etc.

Technology &Tools: Informatica Power Center v10.2,v10.1,v9.6.1, Oracle Database v12c, Teradata v13.1,Linux 3.0.101, Hadoop 2.6.0-cdh5.11.2,Tidal

Confidential

Data Architect/Senior Developer

Responsibilities:

• Involved in analyzing business requirement and source system data analysis.
• Worked on Teradata Utilities like Fast Load, Multi Load, and Fast Export etc.,
• Leveraged high level and detailed level technical design documents.
• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
• Addressed in daily meetings with team for ETL job failures and discussed about the issues and resolution.
• Handled technical and functional call across the teams.
• Written complex SQL Scripts for adhoc user request
• Worked on Logical/Physical Data model changes for upstream changes to in corporate in our system.
• Worked on data anomalies and fixed them.
• Involved in Impact assessment for any source system changes and incorporated changes in our system based on business needs.
• Created procedures for validation of File as the file gets error out due to bad data in file and called the procedure using VBA in excel macro
• Responsible for the Extraction, Transformation and Loading (ETL) Architecture & Standards implementation.
• Worked in all phases of Data Integration from heterogeneous sources, legacy systems to DW.
• Exposed the Nsite data using views to Front end application and corresponding views to Reports
• Involved in Design Review, code review, test review, and gave valuable suggestions for performance tuning to developers.
• Worked on Big data ecosystem Hadoop on HDFS, HIVE, PIG, Hue, spark etc. for large volume of data as ETL was slow in processing huge data for some of the data and complemented entire solution by ETL Tool for reporting needs.
• Installed and configured Flume, Hive, Pig, Sqoop, HBase, and Spark on the Cloudera Hadoop cluster.
• Worked on managing and reviewing Hadoop log files.
• Involved in loading data from UNIX file system to HDFS.
• Created Hive tables, loaded data and written hive queries on adhoc basis when required.
• Worked on support & troubleshooting existing legacy SSIS production load failures.
• Involved in Code Migration across various Environments.

Technology &Tools: Informatica Power Center v9.6.1, Teradata Database v15.1, MS-SQL Server v2102, Hadoop 2.6.0

Confidential

ETL Lead/Architect

Responsibilities:

• Created Technical Specification Documents and Solution Design Documents to outline the implementation plans for the requirements.
• Modified Data Mapping Documents - Field mapping from the Source system data sources to the staging database and the data store then the target database.
• Performed data profiling using Informatica Analyst tool as part of Discovery of data
• Developed Mappings in IDQ and Exported IDQ mappings to Informatica Power center.
• Worked on MLoad, Bteq, FastExport and FastLoad etc.,
• UNIX shell script development for automating ETL processes.
• Worked on Designing PPI (Primary Partition indexes), Aggregate Join Index as part of Performance Tuning.
• Worked on effort estimate for enhancement project & individual effort and lead offshore on development.
• Created procedures and packages using PL SQL and reviewed the existing PLSQL for troubleshooting.
• Created Unit Test Case Documents as part of Testing ETL code.
• Worked on Modifying Logical/Physical Data Model for enhancement project using Erwin.
• Followed Best practices for naming conventions, Load Process and Deployments.
• Troubleshoot several data & Code issues in ETL to support live reports.
• Worked on supporting existing SSIS jobs and solved several issues and refreshed SSAS cubes to verify fix.
• Provided production support by fixing any ETL Job failures and worked on the data for integrity.
• Owned the Production Deployment Activity of ETL components and Database Activities.
• Installed and configured Hadoop ecosystem like, HDFS, Pig, Hive & Spark etc.,
• Importing and exporting data into HDFS and Hive using Sqoop for large volume of data where ETL Informatica was slow.
• Worked on Spark and created RDD’s on Input Files and transformed RDD data to create another RDD.
• Transferred data from/to HDFS to/from Local and written Hive queries on data.
• Transformed data using pig scripts

Technology &Tools: Informatica Powercenter 9.6.1, Informatica IDQ 9.6.1, Microsoft SQL Server, PL/SQL, Oracle, Teradata 14, SSIS, SSAS Erwin, Hadoop 2.6.0

Confidential

ETL Architect/Senior ETL Developer

Responsibilities:

• Design & Developed Informatica mappings, transformations and workflows to populate necessary tables.
• Implemented ETL Data Extracts, Data Load Logic, Mapping, Work Flows, stored procedure.
• Design Star-schema for loading tables for reporting Layer.
• Optimizing Informatica mappings, sessions and workflows.
• Identify opportunities for process/cost optimization, process redesign and development of new process.
• Worked on Optimal Design of Teradata Tables using Compression, proper selection of Indexes etc.,
• Participated in data discovery, data profiling and requirement analysis around master data management activities for the Customer, Product, and Sales Force Alignment domains.
• Participated in project planning sessions with clients, business analysts, and team members to analyze / estimate development requirements /efforts and make appropriate recommendations.
• Defined, configured and optimized various MDM processes including landing, staging, base objects, foreign-key relationships, lookups, query groups, queries/custom queries, cleanse functions, batch groups and packages using Informatica MDM Hub console.
• Create, update and maintain project documents including business requirements, functional and non-functional requirements, functional design, data mapping, etc.
• Worked on Address doctor installation and configuration and used Address validator transformation.
• Worked on Exporting IDQ mappings to Informatica and created workflow in Powercenter.
• Analyzed & did profile of the Data from the current Source systems and identify Data Quality rules for cleansing and standardization
• Created the rules and profiled the source table's data using IDQ.
• Generation and maintaining of IDQ workflows for defined rules.
• Created references tables, workflows and deployed workflows as applications on Data integration service for further execution of workflow and monitored the Workflow executions and reviewed the session log for troubleshooting.
• Worked on Sorter, Filter, Expression, Consolidation, Match, Key Generator, Labeler and Address validator transformations.
• Worked on Data Profiling, Data Cleansing, Data Standardization, Data De-Duplication using Informatica Data Quality
• Worked on Informatica CDC mappings using Powercenter and later converted them to Informatica Power exchange CDC.
• Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development
• Involved in gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Involved in implementing the Land Process of loading the customer data set into Informatica MDM from various source systems.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Configured Address Doctor which can cleanse address Data and enhanced by making some modifications during installation
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Worked on Field Matchings Bigram distance, Edit distance, Hamming distance and Jaro algorithms and Identity matching as part of Match rule configuration.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Worked on using Shell script for Filecheck and Files validation in Informatica mapping with trigger file.
• Modify Existing Data Logical & Physical Model for small enhancements.
• Design & Develop vehicle VIN validation Technique and tested the logic.
• Worked on converting PL/SQL code to Informatica
• Worked on UNIX shell script development for automation ETL processes explicitly succeeding workflow when it’s stopped.

Technology &Tools: Informatica 9.6.1, Informatica Power exchange 9.6.1, Informatica MDM 9.6.1, Informatica IDQ 9.6.1, Microsoft SQL Server 2008, Teradata 14, PL/SQL, UNIX, Erwin

Confidential

ETL Architect/Senior ETL Developer

Responsibilities:

• Own, develop and nurture the overall logical & physical Data warehouse/Data-mart data model and data architectures using ERWIN
• Meeting with business user and did the Data validation.
• Conducted performance tuning of Informatica jobs and SQL queries.
• Worked on Integration of various data sources with Multiple Relational Databases like Oracle, Teradata, Sql Server and used Teradata Utilities like Fast Load, Multi Load, and Fast Export.
• Worked on query tuning to improve the performance by optimizing high volume tables in Teradata and also used Teradata Viewpoint to view queries running for long time and find bottlenecks in queries.
• Extensively worked on Informatica Client Tools like Repository Manager, Power Center Designer, Workflow Manager and Workflow Monitor.
• Experience in requirement gathering, analysis, design, development, testing, debugging, deployment, documentation and production support.
• Extracted data from various heterogeneous sources like Oracle10g, Flat files and Teradata.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Filter, Expression, Router, Sorter, Normalizer, Joiner, Lookup, Update Strategy, Union, Aggregator, Sequence Generator and Transactional Control transformations.
• Worked on exposing data via Web services as WSDL and using SOAP to consume the data
• Created Sessions, Tasks and Workflows using Workflow Manager.
• Implemented Full Pushdown optimization for CDC Sessions.
• Worked on XML sources and targets and used XML transformation.
• Followed Informatica recommended naming standards and the best practices for ETL development.
• Debugged the procedures and packages using TOAD and SQL Developer.
• Implemented SCD Type 2 Slowly Changing Dimension Mappings using Lookup and Update Strategy transformations.
• Used debugger to monitor the data movement for troubleshooting issues in the transformations.
• Extensively used parameter files, mapping variables, mapping parameters and session parameters.
• Developed mappings in IDQ developer tool using Expression, Key generator, Match, Merge and Association Consolidation, Standardizer and Labeler transformations.
• Involved in installation & Configuration of Informatica MDM Hub server, cleanse Server, resource kit in Development
• Analyzed/Data Profile the source system for data confidence using IDQ and defined the same in Systems and Trust.
• Defined the Landing Objects Base objects, staging tables, relationships, queries, packages and query groups.
• Developed Power center mappings for Landing tables in MDM.
• Worked on Match rules and reviewed infrastructure tables of staging and base objects for effective configuration.
• Tested the configuration for Base objects for proper evaluation of Master records.
• Understand and worked on Field Matchings Bigram distance, Edit distance, Hamming distance and Identity matching.
• Involved in implementing Stage process by creating mappings using various cleanse functions to load the data into Stage tables.
• Worked with Data Steward for Manual merge or consolidation of golden records.
• Extensively used tools of MLoad, Bteq, FastExport and FastLoad to design and develop dataflow paths for loading transforming and maintaining data warehouse.
• Thorough knowledge in Teradata Architecture.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning

Technology &Tools: Informatica Powercenter/IDQ/MDM 9.5.1, Microsoft SQL Server, PL/SQL, Teradata 13.1/14.1, Teradata Viewpoint.

Confidential

Senior ETL Developer

Responsibilities:

• Identified and mapped the business requirements (functional and technical) with the business users, which acted as a base for the project initiation and implementation.
• Gathered the requirements from users.
• Developed complex mappings and worked on data profiling and analyzing existing system.
• Worked on performance tuning of jobs and on query tuning to improve the performance by optimizing high volume tables in Oracle.
• Developed advanced Informatica mappings, transformations and workflows to populate necessary tables.
• Optimized the mappings, sessions and workflows.
• Connected to various source types like DB2, Flat files and Oracle to fetch data and load Oracle table.
• Responsible for scheduling the Informatica batch jobs through Informatica Scheduler and UNIX scripts.
• Wrote complex SQL queries and PL/SQL
• Informatica Metadata repository was created using the Repository Manager as a hub for interaction between the various tools. Security and user management, repository backup was also done using the same tool.
• Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner and Update Strategy.
• Involved Working on Functional testing, Integration System testing, Regression testing, And User Acceptance Testing.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Extensively used un-connected Look-Ups for minimizing the run time and add to the performance of the server, while making sure to avoid duplicates of data from other source systems.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Extensively used tools of MLoad, Bteq, FastExport and FastLoad to design and develop dataflow paths for loading transforming and maintaining data warehouse.
• Thorough knowledge in Teradata Architecture.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts, test matrix and test cases for manual and automated testing.

Technology &Tools: Informatica Power Center 9.1, Teradata 13.1, Oracle 10g,PL/SQL,TOAD, Winscp, putty, UNIX

Confidential

ETL Lead/Senior Developer

Responsibilities:

• Interacted with functional teams to understand the procurement process & requirements.
• Gathered requirements and work on analysis, design development and documentation for any enhancements.
• Designed, developed, tested and coordinated with offshore team for any enhancements.
• Worked on exporting data to flat files using Teradata FEXPORT.
• Worked on query optimization (explain plans, collect statistics, primary and secondary indexes).
• Built tables, views, UPI, NUPI, USI and NUSI.
• Interpreted long running queries using explain plan.
• Wrote several Teradata BTEQ scripts to implement the business logic.
• Worked with the Teradata SQL Assistant to interface with the Teradata.
• Involved in query tuning to improve the performance by optimizing high volume tables in Teradata using join indexes, secondary indexes, partition primary indexes, table compression, collecting stats etc.
• Participated in performance tuning for ETL process at source, target, Informatica mappings and sessions, and at database level for optimum performance.
• Coordinated the project tasks with the team and ensured that the projects were completed on time.
• Worked on Teradata utilities TPT, FLoad, MLoad, for loading tables, BTEQ and fast export exporting data from table.
• Worked on SQL queries and PL/SQL.

Technology &Tools: Informatica Powercenter 8.6 Teradata 13.1, PL/SQL, Linux, WinSCP, Putty, Autosys.