SUMMARY

• Around 6+ years of Software Life Cycle experience in System Analysis, Design, Development, and Implementation, Maintenance, and Production support of Data Warehouse Applications.
• Extensive experience in ETL/Informatica Power Center and data integration experience in developing ETL mappings and scripts using Informatica Power Center10.x/9.x/8.x/7.x, IDQ.
• Have clear understanding of Data Warehousing and BI concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Expertise in DWH technical architecture, design, business requirement definition and Data Modeling..
• Experience in data extraction from heterogeneous sources using Teradata. Informatica Power center.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges with large data sets.
• Strong experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected, Static and Dynamic lookups, Java, SQL, Stored Procedure, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Expertise in working with Teradata Stored Procedures, Oracle Stored Programs, Packages, Cursors, Triggers, Tables, Constraints, Views, Indexes, Sequence, and Synonyms in distributed environment.
• Extensively worked on Dimensional Modeling, Data Migration, Data Cleansing, and Data staging for operational sources using ETL and data mining features for data warehouses.
• Good understanding of relational database management systems like Oracle, DB2, SQL Server and worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
• Extensive experience in implementing projects using Agile(kanban) and waterfall methodologies
• Create project plan to carry out testing for implementation & upgrade of existing legacy system with Guidewire Policy Center & Guidewire Billing Center.
• Data load and exporting using Teradata utilities such as TPT, FLoad, MLoad, Fast Export and Tpump.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Extensively created Mapplets, common functions, reusable transformations, look-ups for better usability.
• Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Experience in UNIX shell scripting, job scheduling and server communication.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Extensive database experience and highly skilled in SQL Server, Oracle, DB2, Sybase, XML Files, Flat Files, MS Access.
• Excellent communication skills and result-oriented with minimum supervision, problem solving skills and team player.

TECHNICAL SKILLS

ETL Tools: Informatica 10.1/9.6/9.1/8.6.1/8.1 Source Analyzer, Mapping Designer, Workflow Monitor, Workflow Manager, Data Cleansing, Data Quality, Repository, Metadata, Data Mart, OLAP, OLTP, SQL Server SSIS.

Data modeling tools: Erwin

BI Tools: Cognos, Business Objects

Databases: Oracle 11g/10g/9i/8i, IBM-DB2, MSSQL Server

Other Tools: Toad, SQL Developer, Crystal Reports, SQL Assistant

Programming Languages: SQL, Java, PL/SQL, T-SQL, UNIX Shell Scripting

Job scheduling: Shell Scripting, Autosys, Tidal, Control-M

Environment: MS Windows 2012/2008/2005 , UNIX

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

ETL/Informatica Developer

Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Worked with DBA team on TDM process which is Data Acquisition TDM tool will help rapid development of ETL process which we can copy one or more tables from sql server or flat files to any TD core system.
• In the TDM Development tool which includes ABC metadata entries, creating tables/views Generation, Active batch development.
• Worked on Informatica Power Center tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Worked with Informatica IDQ to determine Data Quality issues and Remediation process for bad data.
• Involved in creating data models using Erwin.
• Worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer, Transformation Developer.
• Created Mappings and used transformations like Source Qualifier, Filter, Update Strategy , Lookup, Java, Expression, Router, Joiner, Normalizer, Aggregator, Sequence Generator and Address validator.
• Involved data governance, defined data modeling and model maintenance standard (enterprise-wide).
• Utilization of Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area ; staging area to target .
• Extensively created Re-Usable Transformations and Mapplets to standardized Business logic .
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created PL/SQL programs like procedures, function, packages, and cursors to extract data from Multiple Source Systems.
• Responsibilities include creating the sessions and scheduling the sessions.
• Translated Business specifications into PL/SQL code. Extensively used Explain Plan. Designed, Developed and fine-tuned Oracle Stored Procedures and triggers.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.
• Documented and presented the production/support documents for the components developed, when handling over the application to the product support team.

Environment: Informatica Power Center 10.1, Oracle 11g, IDQ, UNIX, PL/SQL, SQL* PLUS, TOAD, TERADATA 14.0, MS Excel, AcitveBatch V12 Console, Cognos, SQL server Management studio 2016.

Confidential, Memphis, TN

ETL/Informatica Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Developed rules and Mapplets that are commonly used in different mappings.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Created mappings in Informatica Data Quality (IDQ) using Parser, Standardizer and Address Validator Transformations
• Extensively used Teradata SQL Assistant to write different queries to understand the data in source tables.
• Participated in Kanban meetings held two days in a week to track the progress of the projects.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Extracted the data from oracle using sql scripts and loaded into teradata using fast/multi load and transformed according to business transformation rules to insert/update the data in data marts.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Working with Informatica Developer (IDQ) tool to ensure data quality to the consumers.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Used Address validator transformation for validating various customers address from various countries by using SOAP interface
• Worked on Data Quality checks for data feeds and performance tuning.
• Worked on data analysis to find the data duplication and existed data pattern using a data profiling tool, IDE.
• Monitoring the Data Quality, generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.
• Data if validated from third party before providing to the internal transformations should be checked for its accuracy (DQ).
• Used Address validator transformation for validating various customers address from various countries by using SOAP interface.
• Experience in scheduling of ETL jobs using Autosys, Tidal, Control-M.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.

Environment: Informatica Power Center 9.6, Oracle 11g, Autosys, IDQ, Cognos, AWS, UNIX, PL/SQL, IDQ, Teradata V 13.0, SQL* PLUS, TOAD, Teradata SQL Assistant, MS Excel.

Confidential

ETL/Informatica Developer

Responsibilities:

• Effective Communication with data architects, designers, application developers and senior management in order to collaborate on projects that involve multiple teams in a vitally time-sensitive environment.
• Effectively involved in allocation & review of various development activities / task with onshore counter apart.
• Maintain and Tune Teradata Production and Development systems
• Understanding the business logic behind every piece of code and documenting requirements in a reverse engineering fashion
• Optimized Query Performance, Session Performance and Reliability, did performance tuning of Informatica components for daily and monthly incremental loading tables.
• Designed ETL process to translate the business requirements into Mappings using Informatica Power Center - Source Analyzer, Warehouse designer, Mapping Designer, Workflow Manager/Monitor.
• Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Workflow Manager.
• Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ.
• Used Workflow Manager for creating validating, testing and running sequential batches.
• Involved in design, development and implementation of the Enterprise Data Warehouse (EDW) and Data Mart.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Experienced in working with Teradata ETL tools like Fast Load, Multi Load, Tpump and Fast Export.
• Extensively used Teradata system Priority Schedule in controlling the load of the system.
• Teradata Viewpoint is used to monitor the system performance when it is in load
• Used external tools like Name Parser and Address Cleansing for cleansing the data in source systems.
• Designed mappings using Source qualifier, Joiner, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy transformations and Mapplets load data into the target involving slowly changing dimensions.
• Used Workflow Manager for creating and maintaining the Sessions and Workflow Monitor to monitor workflows.
• Enhanced existing UNIX shell scripts as part of the ETL process to schedule tasks/sessions.
• Carried out unit and integration testing for Informatica mappings, sessions and workflows.
• Used Autosys as a scheduling tool for triggering jobs.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Experienced in Teradata Manager which is used to create Alerts, Monitor system.
• Using Perforce as a versioning tool for maintaining revision history for code.
• Documented and presented the production/support documents for the components developed when handing-over the application to the production support team.

Environment: Informatica Power Center, Teradata SQL Assistant 12.0, Teradata V12.0R2, AWS, Oracle10g/9i, MS SQL server 2005, Business Objects, Autosys, Toad 7.6, SQL, PL/SQL, Unix Shell Scripting, Windows.