PROFESIONAL SUMMARY:

• Over All 8 years of experience in Information Technology in Analysis, Design and Development of software applications. Expertise in development of Data warehousing solutions using Informatics Power Center 10.1/9.6/9.5.1 and Power Mart 7.1.1 /6.2, Power connects.
• Expertise in Implementation of Enterprise Data warehouses using Informatics Power Center 10.1/9.5/ and Power Mart 6.2.1 / 5.x, and Decision Stream
• Expertise in working with Oracle 12c/11g, SQL server 2014/ 2008, DB2, Sybase and Terawatt.
• Experience in the field of Data warehouse using ETL tools such as Informatics Power Center 9.6/8x/7x, Power Mart 9x/8x databases as DB2, Oracle, MS SQL Server and Terawatt. worked with Terawatt utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008/2014.
• Extensively worked on Informatics IDE/IDQ.
• Design and development of automated processes and/or workflows to integrate information from external sources to drive the creation and update of Facilities into ACBS system.
• Applied the rules and profiled the source and target table's data using IDQ.
• Proficient in warehouse designs based on Ralph Kimball and William Inman methodologies.
• Knowledge of full life cycle development in Data Warehousing.
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Expertise in implementing complex business rules using different transformations, mappings and applets.
• Working on SQL, PL SQL, Oracle packages procedures, functions, Triggers and Oracle database tuning
• Used Informatics Power Center to Extract, Transform and Load data into Netezza Data Warehouse from various sources like Oracle and flat files
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Terawatt SQL.
• Extensively worked with Stored Procedures, Triggers, Cursors, Indexes, Functions and SSIS Packages and even in data cleaning, data profiling using Informatics tools.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments and JavaScript environment.
• Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• Projects done based on the Informatics cloud, the Informatics designer cloud that consists of designing techniques and cloud data integration that is huge bulk of data is handled. The enterprise data integration which consists of power center and power exchange, the power center used is Informatics 9.5.1.

TECHNICAL SKILLS:

Data Warehouse Tools: Informatics Power Center 9.6/9.5/8.x/7.x, Data Stage, Informatics Power Analyzer/Power mart 9x, Informatics Data Quality 9.5 (IDQ)

Operating System: Windows XP/Vista 08/07, Unix, Linux, Confidential Mainframes, Putty, WinSCP

Databases: Oracle 11g/10g/9i, MySQL, SQL Server 08/05, Terawatt, MS Access

Reporting Tools: SAP BO, SSRS, SSAS,ACBS

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow - Flake, Modeling, Erwin.

Testing: UAT, Functional, ETL

Data Base Tools: Oracle SQL Developer, SQL Plus, SQL Loader, TOAD, Netezza 6.0/7.0, MS office, Microsoft Visio, OLTP/OLAP

Languages: SQL, PL/SQL, XML, Unix Shell Scripting, Cobol

Dimensional Data Modeling: Dimensional Data Modeling, Star & Snow Flake modeling, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, New York

ETL Application Software Engineer

Responsibilities:

• Developed mappings to extract data from SQL Server, Oracle, Terawatt, SFDC, SIEBEL, Flat files to load into Terawatt using the PowerCenter.
• Used Informatics Power Center 10.1,9x/8.6.1/8.5 and its all features extensively in migrating data from OLTP to Enterprise Data warehouse.
• Proficiency in HL7 on standards for interoperability of health information technology.
• Involved in analyzing and development of the Data warehouse .
• Wrote the shell scripts to monitor the health check of Hadoop daemon services and respond accordingly to any warning or failure conditions.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Extensively used Erwin for Logical and Physical data modeling and designed Star Schemas.
• Extracted data from different sources like Oracle, flat files, XML, DB2 and SQL Server loaded into DWH.
• Performed tuning and optimization of complex SQL queries using Terawatt Explain.
• Expert level knowledge of complex SQL using Terawatt functions, macros and stored procedures.
• Experience in upgrading from Informatics version 9.6 to 10.1.
• Supervise the installation of Datastage Software and established all the setups including data base connections, plug-in, configuration file setup, directory setups.
• Worked on multiple projects using Informatics developer tool IDQ of latest version 9.5.
• Performed feasibility study of the HL7-centric data model for the MVPS staging database.
• Creating and modifying existing SSIS package from Oracle database to SQL database
• 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.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Design, document and configure the Informatics MDM Hub to support loading, matching, merging, and publication of MDM data.
• Experience in Extraction, Transformation and Loading of data from different heterogeneous source Developed mappings/Reusable Objects/applets by using mapping designer, and applets designer, transformation developer in Informatics Power Center 10.1/9.6/8.6.1/8.5
• Used Informatics Power Center 8.6.1/8.5 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Involved in Plan, Document, and Develop and lead all Hadoop ETL development for the internal company data warehouse.
• Designed and Developed Datastage Jobs using Datastage Designer to Import and Export data from heterogeneous data sources Oracle, SQL server, Flat files .
• Worked on power exchange to create data maps, pull the data from mainframe, and transfer into staging area. Wrote numerous BTEQ scripts to run complex queries on the Terawatt database.
• Developed Complex transformations, Mapplets using Informatics to Extract, Transform and load (ETL) data into Data marts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
• Handled slowly changing dimensions (Type I, Type II and Type III) based on the business requirements.
• Parsing a document selectively, that is, retrieving selected data and ignoring the rest using HL7.
• Used Informatics Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Loaded Data from different sources using PL/SQL routines, UTL FILE, EXTERNAL TABLES to the oracle database tables.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse. Wrote PL/SQL stored procedures& triggers, cursors for implementing business rules and transformations.

Environment: Informatics Power Center 10x/9x/8.6.1/8.5 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Terawatt 13, Terawatt Manager, SQL Server 2012, DB2 8.1, XML, Autosys, Oracle 12c/10g, TOAD, SQL, PL/SQL, UNIX, Active

Confidential, Troy, NY

Informatics ETL/ Report Developer

Responsibilities:

• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplets designer in Informatics Power Center 9.6/9.5/9.1.
• Involved in Design and development of new data warehouse (Analytical Data Warehouse) for better Reporting and analysis.
• Involved in Data Modeling of the Oracle Database and Debugging Stored Procedures.
• Worked on developing Informatics Mappings, Mapplets, Sessions, Worklets and Workflows for data loads.
• 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. Using delimiters to define the source document structure for HL7 standards.
• Developed Mappings which loads the data in to Terawatt tables with SAP definitions as Sources.
• Analyzed complex ETL requirements/tasks and provided estimates/ETCs.
• Information is stored in table definitions in the repository and is entered using the Datastage import/export options.
• And extensively worked on IDQ admin tasks and worked as both IDQ Admin and IDQ developer.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Worked closely with client on planning & brainstorming to migrate the current RDBMS to Hadoop.
• Primary activities include data analysis identifying and implementing data quality rules in IDQ and finally linking rules to power center ETL process and delivery to other data consumers.
• Design the ETL process to source the data from source and load it into ODS tables
• Worked on UNIX and Oracle SQL Developer to develop queries and create procedures and Package Oracle.
• Worked with data warehouse staff to in corporate best practices from Informatics.
• Developed complex mappings and SCD type-II mappings in Informatics to load the data from various source to ODS tables. Hands on experience with data steward tools like data merge and hierarchy manager in MDM.
• Used Informatics to extract data from DB2, HL7, XML and Flat files to load the data into the Terawatt
• Created and modified Informatics Mappings and Workflows to load flat files to Oracle database.
• Data Loads to warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Worked with ETL Migration Team and Migrated Informatics folders from Dev to Test repository
• Profiled the data using Informatics Analyst tool to analyze source data (Departments, party and address) coming from Legacy systems and performed Data Quality Audit.
• Performed Unit testing, Integration testing, and coordinated with QA for UAT for code change and enhancement.
• Developed mappings in Informatics to stack the information from different sources into the Data Warehouse, utilizing distinctive changes like Source Qualifier, JAVA, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Worked with various IDQ transformations like Standardizer, Match, Association, Parser, Weighted Average, Comparison, Consolidation, Decision, and Expression.
• Building Data Warehouse/Data Marts using Ascential Datastage 7.5.2, 7.5.3 and Confidential Infosphere Datastage 8.1.0, 8.1.2 and 8.5 Versions.
• Working with Different Terawatt source systems to analyze data and load it into the Data warehouse.
• Performed reconciliation techniques to get huge health care counts.
• Experienced in running Hadoop streaming jobs to process terabytes of xml format data.
• Study and analyze source data systems in terms of business usage and data quality. Active involvement in data model design and MDM configuration proposal and data profiling.
• Worked on Informatics profiling for huge number of health care data.

Environment: Informatics Power Center 9.5/9.1, CDMA, ABC, Facets, Toad, Tidal, Terawatt, Fast load, Fast export, BTEQ, Unix, Informatics servers on Unix Putty, TOAD, MS VISIO, MS Office Suite, TDQ, Oracle, MVS, oracle 11g, SQL Server, Windows NT/2000.

Confidential, NC

Informatics ETL/ Report Developer

Responsibilities:

• Design and Development of ETL routines, using Informatics Power Center 9.5.1 Within the Informatics Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, connected and unconnected Lookups, and source filter usage in Source qualifiers and data flow management into multiple targets using Router was extensively done also designed and reported using power connect Informatics from external systems like SAP,DB2.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Involved in migration of Datastage projects and jobs from earlier versions to Confidential Info Sphere 8.0.1 version
• Preparation of technical specification for the development of Informatics Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards.
• Developed mappings using Informatics to load the data from sources such as Relational tables, Flat files, Oracle tables into the target Data warehouse.
• Define and build best practices regarding creating business rules within the Informatics MDM solution
• Experience with Vertica and Terawatt environments and its tool set
• Design and Developed pre-session, post-session tasks for the workflows.
• Implemented slowly changing dimensions methodology and developed mappings to keep track of historical data.
• Used the ACBS functional application.
• Extensively used Informatics Power Center Workflow manager to create sessions, workflows and batches to run with the logic implanted in the mappings.
• Expertise in Migration of objects from Oracle databases to Terawatt.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Created SSIS Reusable Packages to extract data from Multi formatted files, Excel, XML files into EDW Database.
• Used the Workflow manager to create workflows, Worklets and tasks.
• Developed Session Parameter files for the workflows.
• Used the Informatics command line utility pmcmd to start and schedule the workflows by setting a cronjobs and wrote Unix Shell scripts to create pre and post session commands.
• Code migration from development Repository to Test to Production Repository.
• Responsible for creating new users and folders for individual developers.
• Creating BTEQ (Basic Terawatt Query) scripts to generate Keys.
• Extracted the data from various Flat files and Loaded in Data warehouse Environment and written Unix Shell scripts to move the files across the Servers.
• Created export scripts using Terawatt Fast Export Utility.
• Worked on building ETL data flows that works natively on HADOOP and developed multiple Map Reduce jobs in Java for data cleaning and preprocessing
• Utilized the Informatics Data quality management suite (IDQ and IDE) to identify and merge customers and addresses.
• Developed complex Datastage jobs according to the business requirements / mapping documents.
• Daily Interactions with End-to-End(E2E) team for defining the project requirements, based on understanding of the business needs and help them in analysis sessions
• Used Pipeline partitioning to improve Session performance.
• Upgraded the Informatics Power Center version from V9.1.0 to V9.5.1
• Created configured and scheduled the sessions and Batches for different mappings using workflow manager and using UNIX scripts.

Environment: Informatics Power Center 9.1,Oracle 10g/9i, SQL, PL/SQL, SQL*Plus, Sybase, XML files, Sun Solaris 5.8, Windows 7/8, TOAD 7.0, PL/SQL Developer, Crystal Reports XI, MS Excel, Import Wizard, Central Management Console, Info View, True Task Scheduler, SQL Server Management Studio

Confidential, Chicago, IL

Informatics ETL/ Report Developer

Responsibilities:

• Interpreted logical and physical data model for business users to determine common data definitions and establish referential integrity of the system.
• Developed strategies for Incremental data extractions as well data migration to load into the Terawatt.
• Star Schema was used to design the warehouse.
• Experience in Business analysts and the DBA for requirements gathering, business analysis, designing and documentation of the data warehouse.
• Developed BTEQ scripts to load data to Terawatt and developed UNIX scripts to access Terawatt.
• Worked extensively on Source Analyzer, Mapping designer, Warehouse Designer.
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
• Extensively used almost all Transformations such as Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence Generator, and Rank.
• Had to create Datastage jobs instantly on demand for moving data from Sybase ASE (OLTP) to GreenPlum and Sybase IQ for testing purposes.
• Configured and used secured FTP by the Informatics Server to access source and target files.
• Schedule, Run and monitor sessions by using Informatica Server Manager .
• Developed Workflows with various Tasks and Parameter files.
• Expertise in using different tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event- Wait, Control).
• Used ETL for efficient mapping and transformation techniques and processed the data from various source to Terawatt target tables.
• Used Datastage Designer to develop parallel jobs to extract, cleanse, transform, integrate and load data into Data Warehouse.
• Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Server Administration (startup / shutdown, configuring the services) and system Maintenance (Log analysis, backups and archival).
• Migration of Informatics components from development to QA and Production Environment.

Environment: Informatica 8x/7x/5.2/6.2, ORACLE 8i/9i, UNIX, Windows NT 4.0, UNIX Shell Programming, PL/SQL, Business Objects 4.7, TOAD Quest Software, Business Objects XI R3.1/RI 2.0, Business View Manager,, MS Excel, Live Office.

Confidential, Bloomington NY

Informatics ETL

Responsibilities:

• Worked on Designing, Development and Testing of Workflows and Work lets according to Business Process Flow.
• Created mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created technical design specifications for data Extraction, Transformation and Loading (ETL).
• Extensively worked on Change Data Capture/Incremental loading of SCD Type I/II.
• Design the ETL process and schedule the stage and mart loads for the data mart.
• Worked on Informatics Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplets Designer and Transformation Developer for defining Source and Target, and coded the process from source system to data warehouse.
• Terawatt views have been developed against the departmental database and claims engine database to get the required data.
• Extensively used transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement business logic.
• Executed, scheduled workflows using Informatics Cloud tool to load data from Source to Target.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader Designed and developed mappings using Informatics Power Center
• Extensively created Re-usable Transformations and Mapplets to standardized Business logic.
• Extracted the data from various Flat files and Loaded in Data warehouse Environment and written Unix Shell scripts to move the files across the Servers.
• Used Informatics Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• ETL includes the selection criteria to extract data from source systems (Cloud), performing any necessary data transformations or derivations needed, data quality audits, and cleansing. Experience using the Informatics Web Services connector is critical.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Worked on building ETL data flows that works natively on HADOOP
• Used UNIX Shell Scripts to automate pre-session and post-session processes.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, Mapplets in Shared folder.
• Imported the IDQ address standardized mappings into Informatics Designer as a applets.
• Coordinated with testing team to make testing team understand Business and transformation rules that have been used throughout ETL process.

Environment: Informatics Power Center 9.6, Informatics IDQ 9.1, Oracle 11g, SQLServer2008, Confidential (DB2), MS Access, Windows XP, Toad, SQL developer.

Confidential

PL/SQL Developer

Responsibilities:

• Coordinate with the application development team working on Java to provide them with the necessary stored procedures and packages and insight into the data.
• Wrote PL/SQL procedures, packages, triggers. Involved in creation of databases, moved databases by creating control files, export/import, and complete backups.
• Created and maintained Oracle schema objects like Tables, Indexes, Sequences and Synonyms.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Designed Logical and Physical data, defined relationships, and implemented business rules as constraints for normalization.
• Wrote SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the intermediate tables.
• Involved in Data Migration and Data Transfer.
• Involved in writing complex SQL queries using Analytical functions in Oracle OLAP.
• Utilized Qwest tools (Toad 8.0, SQL Navigator) for database monitoring and tuning.
• Involved in ETL processes to load data from Flat files, XML, SQL Server, Access and Excel spreadsheets into the target Oracle database by applying business logic on transformation mapping for inserting and updating records when loaded.

Environment: SQL Server, TOAD 8.0, Packages, Triggers, Indexes, XML, Oracle, OLAP, Normalization, UNIX, Windows 7/8.1, UNIX Shell Programming.