SUMMARY:

• Over 7+ years of IT experience in analysis, design, modeling, development, implementation and testing of Data Warehousing and Client/Server applications and also in locations like India and USA.
• Extensively worked on ETL developer using Informatica Master Data Management, Informatica Power Center (Source Analyzer, Warehouse designer, Mapping designer, Mapplet designer, Transformation developer) Repository manager, Workflow manager & Workflow monitor.
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources like Oracle, DB2, SQL Server, XML and Flat Files.
• Hands on experience in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL solution using Informatica Power Center Knowledge in ETL and Data warehousing with OLAP technology.
• Well versed in Data modeling concepts incorporating dimensional modeling (star and snowflake schema), logical and physical data modeling.
• Experience on Informatica designer tools - transformations, reusable transformations, mapping, and mapplets.
• Experience in RDBMS such as ORACLE 12c/11g/10g/9i/8i, MS SQL Server 2008/2005/2000, Teradata 12.0, DB2, SQL, T-SQL and PL/SQL.
• Good understanding and working experience in Logical and Physical data models that capture current/future state data elements and data flows using Erwin.
• Experience working in Oracle 9i/10g/11g with database objects like triggers, stored procedures, functions, packages, views, and indexes.
• Efficient in all the phases of System development life Cycle (SDLC) using different methodologies like Agile and Waterfall.
• Extensive experience in dealing with High Volume Data, Performance Tuning, Maintaining, Multiple Job. Developed efficient mappings for data extraction/transformation/loading (ETL) from different sources to a target data warehouse.
• Designed using Informatica Power Center in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, configuring the Informatica Server and scheduling the Workflows, sessions and Experience in writing daily batch jobs using UNIX shell scripts.
• Having exposure in UNIX, worked on CONTROL M and TWS to schedule the jobs.
• Implemented Performance Tuning Techniques and Error Handling at various levels such as sources, Target, mappings.
• Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon and surrogate key assignment and CDC (Change Data Capture) using Informatica.
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• The ability to adapt and learn new technologies and proficient in learning them quickly.
• Strong oral and written communication skills to maintain productive work relationships with management, clients, team members and other groups.

TECHNICAL SKILLS:

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

Operating System: UNIX, LINUX, Windows 7/vista/2000/2003

Virtualization Tools: VMware, VSphere, Vcenter server.

Databases: Oracle 11g/10g/9i, TOAD, DB2, Teradata V2R4, MS SQL Server 2012/2008/2005.

ETL Tools: Informatica Power Center 10.1.1/9.6.1/9.1/8.6

BI Tools: SAS, Congo’s, Tableau

Web Technologies: HTML, XML, CSS, Servlets, JDBC, JSP

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis

ETL Informatica Developer

Responsibilities:

• Involved in the Informatica server installation and setting up the environment.
• Analyze the data from different sources i.e. Oracle, SQL Server and Flat file and define Data Warehouse and ETL processes.
• Designed the Data Warehouse/ ETL process using Informatica Power Center to extract, transform and load data from multiple input sources like SQL Server and oracle to target oracle database.
• Involved in daily production server check list, SQL Backups, Disk Space, Job Failures, System Checks, checking performance statistics for all servers using monitoring tool and research and resolve any issues, checking connectivity.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created complex mappings using various transformations such as Rank, Joiner, Expression, Lookup (Connected/Unconnected), Aggregate, Filter, Update Strategy, Sequence Generator etc. to implement the user requirements.
• Used Informatica Power Exchange Passport tool to analyze COBOL /Mainframe source data for legacy systems.
• Used Informatica Power Center Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Implemented Type II Slowly Changing Dimensions Methodology to keep track of historical data. Prepared detail documentation on the developed Informatica Mappings/Transformations, and Informatica sessions.

Environment: Informatica Power Center 9.1, Informatica Power Exchange, Oracle 11g, Mainframes, SQL SEVER, TWS and UNIX.

Confidential, BOSTON, MA

ETL Developer

Responsibilities:

• Developed mappings using Informatica Power Center -Designer for data transformation as per the technical requirements.
• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Worked with ETL Developers in creating External Batches to execute mappings, Mapplets using Informatica workflow designer to integrate Shire’s data from varied sources like Oracle, DB2, flat files and SQL databases.
• Analyzed the system for the functionality required as per the requirements and created System Requirement Specification document (Functional Requirement Document).
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Normalizer, Union, and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Involved in the development of the conceptual, logical and physical data model of the star schema using ERWIN.
• Wrote complex Stored Procedures and triggers to capture updated and deleted data from OLTP systems.
• Extensively used ETL to load data from heterogeneous sources like flat files (Fixed Width and Delimited), Oracle tables, and DB2 tables to the data warehouse.
• Developed Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Worked on Informatica Test Data Management Data Masking Tool for data subset and data security.
• Developed various complex mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure and Sorter transformations.
• Developed PL/SQL procedures for processing business logic in the database and used them in the Stored Procedure Transformation.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for optimized performance.
• Created stored procedures to filter data based on audit requirements.
• Developed Cloud mappings to extract the data for different regions
• Fixed invalid mappings, tested stored procedures and functions, and performed unit testing of Informatica Sessions and Workflows.
• Prepared and documented unit test plans and resolved issues escalated from system testing.
• Used Teradata utilities like Fast Load, Multi load, Fast Export and BTEQ.
• Loaded data into Teradata data warehouse.
• Created Stored Procedures to generate batch processes.
• Collaborated with Project Manager, Tech Lead, Developers, QA teams and Business SMEs to ensure delivered solutions optimally support the achievement of business outcomes.
• Implemented various slowing changing mappings based on the related Star Schema data model.
• Created logical and physical data models using ERWIN.
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency.
• Worked on UNIX shell scripting and automation of ETL processes using scheduling tool Autosys.
• Used Incremental aggregation for CDC (Change Data Capture).
• Worked with BI teams in creating reports using BO and involved in developing report using BO and developed tabular matrix, parameterized chart reports.

Environment: Informatica Power Center 10 9.6.1/9.0.1, Oracle 11g,PL/SQL,Teradata 14.0, Flat files, Erwin 7.2, SQL Developer & Toad, Shell Scripting, Autosys.

Confidential, Pittsburgh, PA

Informatica Developer

Responsibilities:

• Involved in the Informatica server installation and setting up the environment.
• Analyze the data from different sources i.e. Oracle, SQL Server and Flat file and define Data Warehouse and ETL processes.
• Designed the Data Warehouse/ ETL process using Informatica Power Center to extract, transform and load data from multiple input sources like SQL Server and oracle to target oracle database.
• Involved in daily production server check list, SQL Backups, Disk Space, Job Failures, System Checks, checking performance statistics for all servers using monitoring tool and research and resolve any issues, checking connectivity.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created complex mappings using various transformations such as Rank, Joiner, Expression, Lookup (Connected/Unconnected), Aggregate, Filter, Update Strategy, Sequence Generator etc. to implement the user requirements.
• Used Informatica Power Exchange Passport tool to analyze COBOL /Mainframe source data for legacy systems.
• Used Informatica Power Center Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Implemented Type II Slowly Changing Dimensions Methodology to keep track of historical data. Prepared detail documentation on the developed Informatica Mappings/Transformations, and Informatica sessions.

Environment: Informatica Power Center 9.1, Informatica Power Exchange, Oracle 11g, SQL, MS SQL Server 2016/2012, PL/SQL, OBIEE and UNIX.

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Used ETL tools Informatica 9.1 to extract data from source systems, cleanse Transform, and Load data into XML and Flat files.
• Developed mappings using Power Center -Designer for data transformation as per the technical requirements.
• Designed mappings for different subject areas Patient demographics and order history.
• Extensively used Transformations like Router, Aggregator, Normalizer, Expression, Lookup, Update strategy and
• Sequence generator, Procedure.
• Used Update Strategy to insert and update for inserting and updating the audit tables.
• Worked extensively with Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading.
• Created mapping using Oracle sources.
• Used Reusable Transformations for different validations.
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Experience in setting up Active batches for running the workflows in batch processing.
• Extensively worked on UNIT TESTING and created different unit test case documents for different subject areas.
• Designed workflows that are used to run a set of maps together one after the other, the results such as the execution time, start time; end time and status are stored in a run time repository, which can be accessed by other users.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used debugger to test the mapping and fixed the bugs.
• Tuned and optimized mappings to reduce ETL run times thereby ensuring the mappings ran within the designated load window.
• Generated the Profiles for analyzing the source data and discussed with the business for populating the target columns.
• Co-ordinate with Business teams for any data related issues and updated the QA team with the mapping document.

Environment: Informatica Power Center, Oracle 10g, PL/SQL, UNIX, Windows 7, SQL developer, Active Batch.

Confidential

ETL Developer

Responsibilities:

• Responsible for design/development of relational databases for collecting data.
• Developed database objects like Stored Procedures, Functions, and Packages using PL/SQL
• Created Tables, Indexes, Views and improved database performance
• Analyze SQL statements, reorganize database objects and design indexes to improve query response time.
• Tuned stored procedures and triggers identified for better performance
• Involved tuning and applying the SQL statements and PL/SQL processes
• Experience with Data flow diagrams, Entity relation modeling and design techniques.
• Worked along with the DBA to resolve performance and tuning issues
• Gathered reporting requirements from business end users/clients

Environment: Oracle 10g/11g, PL/SQL, MS SQL Server, SQL Developer, Windows, Unix/Linux