SKILLS INVENTORY

• Extensive experience in Data warehousing and Informatica Power center.
• proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Worked Extensively on ETL process using SSIS package.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Developed scripts with windows power shell
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Involved in all the phases of SDLC.
• Excellent understanding and knowledge of NOSQL databases
• Proficient in ETL (Extract - Transform - Load) using SQL Server Integration Services (SSIS) and Informatica Power Center tool.
• Experience in integration of various data Sources such as Multiple Relational Databases (like Oracle, SQL Server), XML files, Flat files.
• Used AWS services to use Amazon cloud services for development and deployment using AWS EC2 and ECS.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Expertise in building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inman), Star and Snowflake schema design.
• Experience in Mapping Server/parallel Jobs in Data Stage to populate tables in Data warehouse and Data marts.
• Experience in dimensional and relational database design.
• Excellent knowledge in creating and managing Conceptual, Logical and Physical Data Models.
• Experience in Mapping Server/parallel Jobs in Data Stage to populate tables in Data warehouse and Data marts.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development Using Informatica Power Center(Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Developed complex mappings from varied transformation logics like Unconnected or connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update strategy, Mapplets, Worklets and more.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• Worked on Data Mapping, load process, and extract process.
• Good experience with Data Modeling Tools (MS Visio), Databases (SQL Server, Oracle), Documentation Tools (MS Office)
• Knowledge of complete software development life cycle including Requirement Analysis, Requirement Gathering, Cost Estimation, Project Management, Design, Development, Implementation and Testing.
• Having experience in installing Informatica Power center.
• Experience in Upgrading, Installing and Configuring Power Center 8.x/7.x/6.x to 9.x on Client/Server environment.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow

TECHNICAL SKILLS

Informatica Power: Center9.5/9.x/8.x/7.x/6.x/5.x (Source Analyzer, Repository Manager, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Warehouse Designer and Informatica Server), TALEND

Informatica: Data Quality 9.x/Informatica Data Explorer

Microsoft: Windows 8.1/8/7/Vista/XP/2000, UNIX XML, PERL Scripting, HTML, Web services

Oracle: 11g/10g/9i, SQL Server, MYSQL, SQL Plus, Oracle SQL developer, SQL, SQL Scripting, SSIS, PL/SQL, NOSQL, SSRS, Windows Power Shell, ETL data stage

MS Visio: , MS Word, Excel, PowerPoint

HADOOP: , HIVE, SQOOP, PIG, HBASE, BIGDATA AWS EC2 and ECS.

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential, Reston, VA

Responsibilities:

• Designed and Implemented the ETL Process using Informatica power center.
• Created Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Involved in Data Extraction from SQL, Oracle, Db2, Flat files and other sources using Informatica.
• Developed scripts with windows power shell
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Created various database objects like tables, views.
• Developed Mapping Server/parallel Jobs in Data Stage to populate tables in Data warehouse and Data marts.
• Developed Conceptual, Logical and Physical Data Models.
• Involved in development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Used Amazon AWS web services (Linux) as development and deployment environment.
• Prepared ETL flow of data from Staging to Data Mart.
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas.
• Created Informatica mappings to populate the data into dimension and fact tables.
• Created mappings from source systems to target systems. Implemented Join, Expression, Aggregate, Sort, Rank, Lookup, Update Strategy, Filter and Router Transformations in Mappings.
• Worked on Designer tool - Source Analyzer, warehouse designer, Mapping Designer & Mapplet Designer and Transformation Developer.
• Creating Reusable Transformations and Mapplets in a mapping.
• Involved in Creating tasks, Worklets, workflows and Schedule, Run, Monitor sessions by using workflow manager and workflow monitor.
• Worked on Erwin and UML Data modeling tools to create conceptual, logical and physical processes of the business in accordance to business regulations.
• Worked on moving mappings from Development to Test and from Test to Production environments. Designed and Implemented the ETL Process using Informatica power center.
• Involved in Data Extraction from SQL, Oracle, Db2, Flat files and other sources using Informatica.
• Prepared ETL flow of data from Staging to Data Mart.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas.
• Created Informatica mappings to populate the data into dimension and fact tables.
• Created mappings from source systems to target systems. Implemented Join, Expression, Aggregate, Sort, Rank, Lookup, Update Strategy, Filter and Router Transformations in Mappings.
• Worked on Designer tool - Source Analyzer, warehouse designer, Mapping Designer & Mapplet Designer and Transformation Developer.
• Creating Reusable Transformations and Mapplets in a mapping.
• Involved in Creating tasks, Worklets, workflows and Schedule, Run, Monitor sessions by using workflow manager and workflow monitor.
• Worked on Erwin and UML Data modeling tools to create conceptual, logical and physical processes of the business in accordance to business regulations.
• Worked on moving mappings from Development to Test and from Test to Production environments.
• Migrated Mappings, Sessions, and Workflows from Development to Test and then to Production environment.
• Used Informatica debugger to test the mappings and fix bugs.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
• Created and monitored sessions and batches to run the mappings.

Environment: Informatica Power Center 9.5, SQL Server 2012, Windows 7, Linux, Oracle 10g, DB2, Erwin/UML data modeling.

Informatica Developer

Confidential, GA

Responsibilities:

• Involved in OLTP system analysis
• Created Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Worked on Informatica tool - Source Analyzer, Target Designer, Power Center Designer, Mapping Designer, Mapplet Designer and Transformations.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Created various database objects like tables, views.
• Developed Mapping Server/parallel Jobs in Data Stage to populate tables in Data warehouse and Data marts.
• Developed Conceptual, Logical and Physical Data Models.
• Developed scripts with windows power shell
• Created sessions and batches to run the mappings and set the session parameters to improve the load performance Developed Mapplets, reusable transformations and creation of shortcuts.
• Created Informatica mappings to build business rules to load data Most of the transformations were used like the Source qualifier, Aggregators, lookups, Filters & Sequence Generators.
• Creating Jobs and Scheduling the Jobs based on target load Order.
• Involved in Unit Testing and tuning process for better performance.
• The ETL tool is an integral part of the data warehousing architecture that will be.
• Used to model and create target Warehouse, extract data from multiple data sources, transform the data to make it Accessible to business analysis, and loading target data marts.
• Designed Excel Sheets for each mapping of their Test Scenarios.
• Worked with production issues like bottlenecks, data validation and report errors.
• Developed UNIX shell scripts to scheduling Scripts by using scheduling tools.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.
• Created, scheduled, and monitored workflow sessions on the basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Involved in all the phases of SDLC.
• Participated in requirements gathering.
• Developed new Informatica mappings and workflows based on specifications.

Environment: Informatica Power Center 7.x, Oracle 9i, SQL*PLUS, SQL, UNIX, Flat files

Informatica Developer

Confidential, IL

Responsibilities:

• Develop Informatica Mappings, Sessions and Workflows and test them for their functionality.
• Created Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Created various database objects like tables, views.
• Developed Conceptual, Logical and Physical Data Models.
• Developed scripts with windows power shell
• Schedule the workflows using Informatica Scheduler.
• Do the detailed unit and integration testing.
• Monitoring the Daily ETL loads during the Testing Phases.
• Testing individual modules of the software against the Unit test cases.
• Doing System Integration testing of the software against System Integration Test Cases.
• Communication with the ERP source team in case of Invalid Data scenarios and other data issues.

Environment: Informatica Power Center 7.x, Oracle 9i, SQL*PLUS, SQL, UNIX, Flat files