PROFESSIONAL SUMMARY:

• 8 years of IT experience in design, analysis, development, documentation, coding, and implementation including Databases, Data Warehouse, ETL Design, Oracle, SQL Server databases, Informatica MDM 10.x/9.x, Informatica Data Director, Informatica Power Center 10.x/9.x/8.x/7.x Informatica Data Quality.
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian).
• Experience in developing landing tables, staging tables, base object tables and providing the relationships between the tables based on the Data Model.
• Worked on informatica Data Director to implement Customer 360 - degree view for Business Users.
• Strong Data Warehouse experience in using Informatica Power Center client tools like Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Well expertise on Software Development Life Cycle including requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing.
• Design and implementation of Data Mart/Data warehouse using Informatica and developed transformations, mapping/mapplets, Sessions and workflows.
• Integrated various data sources like Oracle, flat files, XML and MS SQL Server into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in designing/developing complex mapping using transformations like Connected and Unconnected Lookup, Router, Filter, Expression, Aggregator, Normalizer, Joiner, Union and Update Strategy.
• Created and maintained Informatica users and privileges.
• Strong Knowledge on E-R modeling and Dimensional Data Modeling Methodologies like Star schema and Snowflake Schema used dimensional and multidimensional modeling.
• Experience in using Informatica Utilities like Pushdown Optimization, partition and implemented SCD (Slowly Changing Dimension) Type 1, Type 2, Type 3 methodologies.
• Extensive experience in conducting Requirement-gathering sessions, writing Business Requirement Document (BRD), Functional Requirement Document.
• Experience in using SQL, PL/SQL, SQL*Loader, SQL*Plus, Import/Export utilities.
• Worked wif Oracle Stored Procedures, Triggers, Indexes, DML, DDL, Database Links, Sequences.
• Worked on UNIX shell scripts used in scheduling Informatica pre/post session operations.
• Experience in API tools like Soap UI and Swagger Editor.
• Excellent communication and documentation skills using tools like Visio and PowerPoint.
• Has excellent analytical, problem solving & interpersonal skills and can work as a part of a team as well as independently.

TECHNICAL SKILLS:

ETL Tools: Informatica MDM (10.x/9.x), Informatica Power Center (10.1/9.x/8.x/7.1/6.x/5.x), Informatica Data Director, Snap logic.

Databases: Oracle 12c/11g/10g/9i, MS SQL Server 2008/2005/2000, DB2, MemSql, Postgres.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling.

Environments: UNIX, Windows 2000/XP/7, Windows server 2000/2003, HP-Unix, Linux

SQL, PL/SQL, T: SQL, Oracle, XML, UNIX, Visual basic, XML.

Tools & API: Toad, Visio, SQL developer, ERWIN, MS Office Suite, SOAP UI, PSwagger Editor.

PROFESSIONAL EXPERIENCE:

Informatica Developer

Confidential, Redmond,Washington

Roles &Responsibilities:

• Analyzed business requirements, following standard change control and configuration management practices and conforming to departmental application development standards and systems life cycle.
• Designed, developed, managed and monitored pipelines to process FTO and e-commerce data using Snaplogic Elastic Integration iPaaS.
• Design, development and implementation of new system components or fixes to resolve system defects.
• Participated in software design and programming reviews.
• Designed and built data models to conform wif our existing EDW architecture.
• Incorporated source code reuse wherever possible.
• Understanding data ETL concepts and best practices.
• Extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively worked on Onsite and Offshore work model.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Developed UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Sets up and executes component tests as well as tracks and documents system defects.
• Migrating the code to higher environments and handling it to QA team for SIT and UAT.
• Worked wif teams to deliver effective, high-value reporting solutions by leveraging an established delivery methodology.
• Performed data mining and analyzed to uncover trends and correlations to develop insights that can materially improve our decisions.

ENVIRONMENT: Informatica Power Center 10.4, Toad for Oracle 13.1, Unix Shell Scripts, Winscp, Windows XP.

ETL Developer

Confidential, Georgia,Atlanta

Roles &Responsibilities:

• Interactive collaboration wif business analysts and gatheird functional requirements and designed technical design documents for ETL process.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Operated Informatica Power Center to load data from different sources like flat files and Oracle, Teradata into the Oracle Data Warehouse.
• Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions).
• Hands On experience creating, converting oracle scripts (SQL, PL/SQL) to TERADATA scripts.
• Configure rules for power center operations team, no file monitoring, process not started, reject records and long running jobs.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Assisted the QC team in carrying out its QC process of testing the ETL components.
• Created pre-session and post-session shell scripts and email notifications.
• Involved in complete cycle from Extraction, Transformation and Loading of data using Informatica best practices.
• Involved in Data Quality checks by interacting wif the business analysts.
• Performing Unit Testing and tuned the mappings for the better performance.
• Maintained documentation of ETL processes to support knowledge transfer to other team members.
• Systemized in writing UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
• Developed ETL mappings, transformations using Informatica Power Center 9.6.
• Developed data Mappings between source systems and target system using Mapping Designer.
• Developed shared folder architecture wif reusable Mapplets and Transformations.
• Extensively worked wif the Debugger for handling the data errors in the mapping designer.
• Created events and various tasks in the workflows using workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Implemented pushdown, pipeline partition, persistence cache for better performance.
• Setting up Batches and sessions to schedule the loads at required frequency using Informatica workflow manager and external scheduler (Autosys).
• Applied Business rules that identify the relationships among the data using Informatica Data Quality.
• Developed Unit test cases and Unit test plans to verify the data loading process and Used UNIX scripts for automating processes .
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Taken part of Informatica administration. Migrated development mappings using Deployment groups as well as hot fixing them in production environment.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.

ENVIRONMENT: Informatica Power Center 9.6, Informatica IDQ 9.5, Power Exchange, Teradata, Data Quality Oracle12c, MS Access, UNIX Shell Scripts, Windows NT/2000/XP, SQL Server 2008, Netezza, DB2.

Informatica Developer

Confidential, Bellevue,Washington

Roles &Responsibilities:

• Drafting the requirements, implementing design and development of various components of ETL for various applications.
• Data extraction from oracle database and spreadsheets, CSV files and staged into a single place and applied business logic to load them in the central oracle database.
• Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Informatica Designer to create complex mappings from Business requirements.
• Designed and Developed IDQ mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
• Integration of various data sources like Oracle, SQL Server, Fixed Width & Delimited Flat Files, DB2.
• Involved in integration services SSIS creating packages that move data from a single data source to a destination wif no transformations.
• Involved in the Unit Testing and Integration testing of the workflows developed.
• Extensively worked wif Korn-Shell scripts for parsing and moving files and even for re-creating parameter files in post-session command tasks.
• Imported Source/Target Tables from the respective databases and created reusable transformations like Joiner, Routers, Lookups, Filter, Expression and Aggregator and created new mappings using Designer module of Informatica.
• Created different rules as mapplets, Logical Data Objects (LDO), workflows. Deployed the workflows as an application to run them. Tuned the mappings for better performance.
• Working wif database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed shell scripts for running batch jobs and scheduling them.
• Handling User Acceptance Test & System Integration Test apart from Unit Testing wif the halp of Quality Center as bug logging tool. Created & Documented Unit Test Plan (UTP) for the code.

ENVIRONMENT: Informatica Power Center 9.6, Informatica Multi Domain MDM 9.1, Informatica Data Quality (IDQ) 9.5, Oracle 11g, SQL Server, PL/SQL, Unix and WINSCP, SSIS.

Informatica Developer

Confidential

Roles &Responsibilities:

• Actively analyzed wif business analysts and data analysts to understand and analyze the requirement to come up wif robust design and solutions.
• Converted business requirements into highly efficient, reusable and scalable Informatica ETL processes.
• Utilized dimensional and star-schema modeling to come up wif new structures to support drill down.
• Created mapping documents to outline source-to-target mappings and explain business-driven transformation rules.
• Involved in standardization of Data like of changing a reference data set to a new standard.
• Dealt wif massive data profiling prior to data staging.
• Generated Technical Specification Documents and Solution Design Documents to outline the implementation plans for the requirements.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.5 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.
• Created Informatica components required to operate Data Quality (Power Center required)
• Designed best practices on Process Sequence, Dictionaries, Data Quality Lifecycles, Naming Convention, and Version Control.
• Developed scripts for creating tables, views, synonyms and materialized views in the data mart.
• Created PL/SQL programs like procedures, function, packages, and cursors to extract data from Target System.

ENVIRONMENT: Informatica Power Center 9.5, Oracle11g, Teradata, UNIX Shell Scripts.

ETL Analyst

Confidential

Roles & Responsibilities:

• Interacted wif business analysts and translate business requirements into technical specifications.
• Using Informatica Designer, developed mappings, which populated the data into the target.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas and the mapping designer to map the sources to the targets.
• Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks, shell scripts.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target-based commit interval.
• Extensively used aggregators, lookup, update strategy, router and joiner transformations.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Extensively used TOAD to analyze data and fix errors and develop.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion .

ENVIRONMENT: Informatica Power Center, Oracle 9i, PL/SQL, TOAD, UNIX, Control-M.