PROFESSIONAL SUMMARY:

• 7 years of experience in Information Technology including Data Warehouse development using ETL Informatica Power Center across various Domains.
• Extensive experience in developing ETL mappings, scripts and data integration using Informatica Power Center 10.2HF 1/10.2/9.6.1 /9.5.1/9.1.1/8.6.1.
• Extensive Experienced in Develop, maintain, and support application, business glossary, business intelligence, data integration, data modeling, and database management resources in Metadata Manager
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in working with business analysts to identify and understand requirements in order to create Technical Design Documents.
• Experienced in data profiling and data analysis.
• Attended data model review sessions with Data Modeler.
• Expertise in understanding Business Model Identifying Dimensions and Facts.
• Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Experience in creating Reusable Transformations (Joiner, Sorter, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Aggregator, and Rank) for better usability.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Expertise in implementing Change Data Capture (CDC) & Slowly Changing Dimensions - SCD Type 1 & Type 2.
• Experience in integration of various data sources like Oracle, DB2, Sybase, My Sql, SQL Server and non-relational sources like flat files and XML into staging area.
• Experience with Teradata utilities Fast Load, Multi Load, BTEQ scripting, Fast Export, TPT and using SQL Assistant.
• Experience in doing Tuning of Teradata Queries using Explain plan.
• Experience with Teradata Indexes and usage.
• Experience in converting SSIS packages to Informatica.
• Extensively worked with Sql and Pl/Sql.
• Experience in doing performance Tuning of Data Base queries.
• Experience in UNIX environment, file transfers and job scheduling.
• Worked on Informatica Performance Tuning identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experienced in ETL Informatica & Database Upgrade Testing.
• Experience working in Agile methodology and ability to manage change effectively.
• Experience in driving the Projects Independently with minimal guidance.

TECHNICAL SUMMARY:

ETL Tools: Informatica Power Center 10.2HF 1/10.2/9.6.1 /9.5.1/9.1.1/8.6.1/8.1.1

Metadata Manager 10.2HF 1/10.2/9.6.1 : Informatica Analyst 10.2HF 1/10.2/9.6.1

Data Modeling: Dimensional Modeling, ER Modeling, Ralph Kimball Methodology, Bill Inman Methodology, Star, Snow-Flake, Fact Tables, Dimension Tables, Normalization and De Normalization.

Databases: Teradata 16.x/15.x/14/12, Oracle 12c/11g/10g/9i, MS SQL Server 2015/2008, DB2, Sybase, My Sql, Hadoop

Others: Toad, SQL Navigator, FACETS, Shell Scripting, Sql Assistant, Sql, Java, Hive QL, Perl

Environment: Windows, Linux, Unix

Job Scheduling: Autosys, Control M, Cron Job and Maestro

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Sr. Informatica Developer

Responsibilities:

• Experience in preparing the High Level Design Document and Low Level design documents for mapping.
• Strong skills in using Informatica Power Center client tools, Metadata Manager, Informatica Analyst, Administration and Maintenance of Adding users, assigning rights to users moving objects from folder to folder using Repository Manager.
• Developed the complex mappings using power center designer using advanced transformations SQL transformation, and update strategy transformations.
• Developed change data capture mappings for capturing the history data.
• Extensively used mapping variables and workflow variables to pass the mapping variables from one session to another session in a workflow.
• Extensively Worked on Data warehousing with Data Marts, ODS, Data Cleansing, ETL tool Informatica.
• Worked with heterogeneous data sources like Oracle, XML, Flat Files, VSAM, AS400, Teradata and Relational Databases.
• Proficient in using workflow tasks like Session, Control, Event wait, command tasks, Decision tasks, Email tasks, pre-sessions, post-sessions by using pre-SQL and Post-SQL.
• Extensively worked on Informatica Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer and Workflow Manager.
• Implemented Slowly Changing Dimensions Type-1, Type-2 approach for loading the target tables.
• Extensively used Teradata parallel transporter for load operator to load to staging tables and update operator to load to EDW tables.
• Experienced in Tableau reports analyzing and testing.
• Used IDQ and Analyst tool to do basic profiling join analysis the source objects to better understand the Keys and duplicates for better modeling purposes & helped analysts to write improved mapping documents & used Address Validator (Doctor) to fix errors in addresses & output envelope to a ready format.
• Involved in ETL Architecture and Data Modelling using ERWIN.
• Implemented Full Informatica Push down Optimization (PDO) (source & target) for better load performance.
• Extensively worked on Teradata tools and utilities (BTEQ, Fast load, Multi Load, Fast Export, and TPUMP).
• Strong knowledge in creating SET and Multiset tables, Macros, stored procedure, Index, Views and Data marts.
• Created complex SQL queries and excellent record in SQL query performance tuning.
• Have strong experience working in Windows and UNIX environment and developing Batch and PERL Scripts.
• Proficient in Developing, maintaining, and supporting linkage between Informatica Business Glossary and Metadata Manager Assets.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Validate completeness of data lineage between the point of data element creation (system of record) and the point where it is consumed by business users (trusted data source).
• Monitored periodic loads of Metadata Manager Resources to confirm successful load, indexing, and linking.
• Performed business requirements analysis for business rules and documents associated with population and extraction of metadata resources.
• Extensively experienced in developing Business Glossary, Scorecards, Profiles and business rules.
• Had experience in creating Data lineages and Security model in Metadata Manager.
• Providing ongoing support for metadata implementation, testing and integration
• Created estimates for all Metadata Manager Activities, including analysis, development, and testing, and communicate to project team.
• Devised improvements to current procedures and develop methods for increasing efficiency, accuracy, and performance of metadata solutions.

Environment: Informatica Power Center, Informatica Metadata Manager, Informatica Analyst, Informatica Data Quality 10.2HF 1/10.2/9.6.1 , Teradata 16.x/15.x, Oracle 12c, UNIX, WinScp, Putty.

Confidential, San Francisco, CA

Sr. ETL Informatica / Teradata Developer

Responsibilities:

• Worked with Business Analyst & Data Modelers in understanding the BRD - Business Requirement Document, Mapping Document and Data Model.
• Extracted data from different source systems - Oracle, DB2, My Sql, Flat Files and XML Files.
• Developed ETL programs using Informatica Power center 10.2/9.6.1 to implement the business requirements.
• Involved in enhancements and maintenance activities of the Enterprise Data Warehouse.
• Communicated with business customers to discuss the issues and requirements.
• Used most of the Transformations available in Informatica - Source Qualifier, Filter, Router, Lookup (Connected & Un Connected), Expression, Update Strategy, Transaction Control and Sequence Generator.
• Implemented Slowly Changing Dimensions - Type 1 & Type 2 to maintain the history in Dimension tables.
• Worked with Huge data sets to load Fact Tables.
• Implemented Change Data Capture (CDC) for handling delta loads.
• Involved in Informatica upgrade process and testing the whole existing Informatica flow in new upgrade environment.
• Experienced in doing performance Tuning of Informatica objects- Finding the bottle necks at source, Target and mapping level and eliminating the with tuning methods.
• Used Informatica file watch events to pole the FTP sites for the external files.
• Involved in Enhancing existing Production Informatica objects for change or additional requirements and pushing it back to production after successful QA testing.
• Expertise in using Teradata Utilities BTEQ, M-Load, F-Load, TPT and F-Export in combination with Informatica for better Load in to Teradata Ware House.
• Built several BTEQ to load data from Stage to Base after considering several performance techniques in Teradata sql.
• Involved in Teradata upgrade process from TD 14/TD 15.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Good knowledge about FACETS tool and Healthcare domain, Worked on the various modules like Subscriber/Member, Groups, Enrollment, Claims, Billing, Accounting, Provider, MTM and Utilization Management.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing dataflow, evaluating transformations.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks.
• Used Maestro & Cron Job to schedule jobs.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Worked with ETL Admin team for code migration activities and deployments.
• Worked with QA team for better understanding of code development.
• Implemented & followed organization level Informatica best Standards & Procedures.
• Involved in Solving Trouble tickets raised by Business users as part of application support team.

Environment: Informatica Power Center 10.2/9.6.1, Oracle 12c/11g, DB2, Teradata 15/14, Flat Files, XML, TOAD, Sql Assistant, Maestro, Cron Job, UNIX, Perl, Facets 4.7, Windows.

Confidential, Woodland Hills, CA

Sr. ETL Informatica / Teradata Developer

Responsibilities:

• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Responsible for Impact Analysis, upstream/downstream impacts.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Developed mappings to load Fact, Dimension tables (SCD Type 1 and SCD Type 2 dimensions) and Incremental loading and unit tested the mappings.
• Successfully upgraded Informatica 9.1 and to 9.5 and responsible for validating objects in new version of Informatica.
• Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
• Loaded data in to the Teradata tables using Teradata Utilities Bteq, Fast Load, Multi Load, and Fast Export, TPT.
• Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Experienced in analyzing the code written in Hive QL in Hadoop environment ETL and converted that in to Informatica.
• Integrated the data into centralized location. Used migration, redesign and Evaluation approaches.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Worked widely on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Teradata for optimal performance.
• Worked on data validation, key validation, balancing count and referential integrity in P&C Domain.
• Scheduled Informatica jobs and implementing dependencies if necessary using Autosys.
• Managed postproduction issues and delivered all assignments/projects within specified time lines.

Environment: Informatica Power Center 9.6/9.5.1, Oracle 11g, My Sql, Teradata 15.X, Flat Files, Hadoop, Hive QL, Erwin 4.1.2, Sql Assistant, Toad, Winscp, Putty, Autosys, Perl, UNIX.

Confidential, Dublin, OH

Sr.Informatica Developer

Responsibilities:

• Extraction, Transformation and Loading of the data using Informatica.
• Designed the target load process based on the requirements.
• Enhanced the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Undertook the Testing and debugging of Enhanced mappings.
• Created the ETL run book.
• Developed Mappings and Workflows to generate staging files.
• Developed Mappings and Workflows to load the data into Oracle tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, database connections using Workflow Manager
• Developed complex Informatica mappings and tuned them for better performance
• Created sessions and batches to move data at specific intervals & on demand using Server Manager
• Responsibilities included creating and scheduling the sessions
• Also, Recovering the failed Sessions and Batches.
• Involved in extracting the data from SQL Server, Oracle and Flat files and loaded to DB2.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance and Understanding the Functional Requirements.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level.
• Developing, Testing and debugging the mappings in Informatica. experienced in UNIX working environment
• Prepared the documents for test data loading.

Environment: Informatica 9.5.1, Oracle 11g, WINSCP, TOAD 10.6, Assembla, UNIX and Shell Scripting, PL/SQL

Confidential, Irvine, CA

Informatica Developer

Responsibilities:

• Involved in the complete Software Development Life Cycle (SDLC).
• Interacted with the end clients to provide the status updates on the project.
• Worked with business analysts for requirement gathering, business analysis and project- coordination.
• Worked to identify different source systems and performed data analysis to determine the best approach of procuring source data using Informatica Power Center.
• Created the DDL’s required for the data warehouse tables.
• Created the Source to target mapping specification document.
• Assigned the work to the developers based on the work estimates.
• Responsibilities also included peer reviews.
• Used slowly changing dimensions and developed the Summary Fact tables.
• Designed and developed UNIX scripts to load tables and also for scheduling the jobs.
• Used Assembla to track the bugs and issues raised.

Environment: Informatica Power center 8.6, SQL Server, Oracle, DB2, Flat File, UNIX shell scripts, Windows

Confidential

Informatica Developer

Responsibilities:

• Involved in Designing and creating mappings and Mapplets using Informatica Source Analyzer, Warehouse designer, Mapplets Designer & Transformation Designer.
• Used all Transformations such as Expressions, Filters, aggregators, Lookups, Routers, Normalize, and Sequence Generator etc. to load consistent data in to Oracle database.
• Converted from SQL/Procedures and SQL Loader scripts to Informatica mappings.
• Involved in testing the Informatica mappings and creating QA Test Plans.
• Created low level design document and unit test case documents.
• Created Unix shell scripts to invoke informatica workflows using pmcmd command.
• Trained Entry level trainees on Informatica basics and the project specific details.

Environment: Informatica Power Center 9.X/8.X, SQL, PL/SQL, SQL*Loader, Oracle 9i, UNIX.