Client and Project: IBM Watson Health (DWH implementation in three State Projects), EY (Federal), Acentra Health(State Project) Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse. Design and implement all stages of data life cycle.  Maintain coding and naming standards. Provides updates to the management and the business to keep them informed of any system issues. Provides input to development project plans. Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema. Extract data from heterogeneous data sources with multiple databases like Oracle, SQL Server, Fixed Width and Delimited Flat Files and transformed into a harmonized data store under stringent business deadlines. Involved, Conducted, and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements. Develop scripts to automate the execution of ETL using shell scripts under Unix environment Providing routine process/operational control reports and/or Controls Dashboard support Help develop test cases and plans to complete the unit testing and support System testing.

 Interacted with business team to understand business needs and to gather requirements. Prepared requirements document to achieve business goals and to meet end user expectations. Created Mapping document from Source to stage and Stage to target mapping. Worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer, Transformation Developer. Designed Mappings by including the logic of restart. Created source and Target Definitions, Reusable transformations, mapplets and worklets. Created Mappings and used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Expression, Router, Joiner, Normalizer, Aggregator Sequence Generator and Address validator. Performed data quality analysis to validate the input data based on the cleansing rules. Used Parameter Files defining variable values for mapping parameters and variables. Created FTP scripts and Conversion scripts to convert data into flat files to be used for Informatica sessions. Involved in implementation of data profiling, creating score cards, creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency. Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures. Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Marts. Very strong knowledge of Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.