SUMMARY:

• 9 years of Software Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Production support of Data Warehouse Applications.
• Experience in ETL/Informatica Power Center and Data Integration. Experience in developing ETL mappings using Informatica Power Center10.x/9.x/8.x.
• Strong understanding and hands - on programming/scripting experience skills - UNIX shell, Perl, and JavaScript
• Worked extensively in production support to support the ongoing projects.
• Experienced in software development life cycle and Relational Modeling, Dimensional Modeling and Modeling of Unstructured Data.
• Have clear understanding of Data Warehousing and BI concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP requirements. Solid understanding of OLAP concepts and challenges with large data sets.
• Strong experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected, Static and Dynamic lookups, SQL, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Extensively worked on Dimensional Modeling, Data Migration, Data Cleansing, and Data staging for operational sources using ETL and data mining features for data warehouses.
• Good understanding of relational database management systems like Oracle, DB2, SQL Server and worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
• Extensively created Mapplets, common functions, reusable transformations, look-ups for better usability.
• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.
• Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Experience in UNIX shell scripting, job scheduling and server communication.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Extensive database experience and good working experience in SQL Server, Oracle, DB2, Sybase, XML Files, Flat Files, MS Access.
• Excellent communication skills and result-oriented with minimum supervision, problem solving skills and team player.

TECHNICAL SKILLS:

ETL Tools and databases: Informatica 10.1/9.6/9.1, SSIS, Oracle, IBM-DB2, MS SQL Server

Data modeling & Other Tools: Erwin, Toad, SQL Developer, Crystal Reports, SQL Assistant

Programming Languages: SQL,PL/SQL, T-SQL, UNIX Shell Scripting

Job scheduling: Autosys,Control-M,Tivoli Scheduler

Environment: MS Windows 2012/2008/2005, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Michigan, MI

ETL/Informatica Developer

Responsibilities:

• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Developed mappings to load Fact, Dimension tables (SCD Type 1 and SCD Type 2 dimensions) and Incremental loading and unit tested the mappings.
• Successfully upgraded Informatica 9.1 and to 9.5 and responsible for validating objects in new version of Informatica.
• Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
• Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Integrated the data into centralized location. Used migration, redesign and Evaluation approaches.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Teradata for optimal performance.
• Scheduling Informatica jobs and implementing dependencies if necessary using Autosys.
• Managed postproduction issues and delivered all assignments/projects within specified time lines.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Interacted with business analysts and users to discuss the requirements for development.
• Experienced in using EDI/EDDI to transfer the files from one database to other database .

Environment:: Informatica Power Center 9.5.1/9.1.1, Oracle 11g, My SQL, Teradata, Flat Files, Erwin 4.1.2, SQL Assistant, Toad, Winscp, Putty, UNIX.

Confidential, Hartford, CT

ETL/Informatica Developer

Responsibilities:

• The gathering of and compiling of requirements for the project is very much a partnership between the user of the software and the developer.
• Worked with filter transformations and flat files to identify source and target bottlenecks
• Worked with various transformations including router transformation, update strategy, expression transformation, lookup transformation, sequence generator, aggregator transformation and sorter transformation
• Used Oracle to write SQL queries that create/alter/delete tables and to extract the necessary data
• Worked on Informatica Power Center tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer, Transformation Developer.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area and from staging area to target.
• Conducting effective testing approach, identifying, analyzing and prioritizing defects during UAT to ensure that the new software integration into company systems meets functional requirements, system compliance, and interface specifications is a must have.
• Provide day to day Data Warehouse support by debugging, maintaining, problem solving, data discrepancy resolutions and validation of procedures for schedule jobs or processes running in production Environment
• Build test cases for the ETL workflow design/ Database packages and components and test outputs and error handling.
• Build test cases for PL-SQL programming modules including functions, stored procedures, triggers, jobs and test outputs to deploy for final version.
• Build and maintain code migration scripts per release version from Development/Test and finally to Production environment.
• Performed Facets Data Analysis and data mapping between Facets Data elements and downstream system's requirements.
• In order to the calculations for HEDIS, the data from the PH source systems is loaded into cognizant HEDIS reporting, which calculates the rates of the various measures.
• Cognizant HEDIS reporting is a fully complicate his software from cognizant. a leading provider of healthcare data management, decision support, process automation and related information technology solutions that help governmental and commercial healthcare payers improve patient outcomes, increase customer satisfaction and reduce costs.

Environment: Informatica Power Center 10.1, Oracle 12C, UNIX, PL/SQL, TOAD, GIT, Bit Bucket, MJS, Winscp

Confidential, Michigan

ETL/Informatica Developer

Responsibilities:

• 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 developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Worked on Informatica Power Center tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Developed ETL processes to load data into HDFS using Informatica BDE from Oracle database.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Profiled the data using Informatica Data Explorer (IDE) and performed Proof of Concept for Informatica Data Quality (IDQ).
• Involved in performance tuning of Informatica code using standard informatica tuning steps.
• Helping the team in fixing the technical issues if any and Tuning of Database queries for better performance.
• Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target based commit interval.
• Worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer, Transformation Developer.
• Created Mappings and used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Expression, Router, Normalizer, Aggregator, Sequence Generator.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area and from staging area to target.
• Extensively created Re-usable Transformations and Mapplets to standardized Business logic.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Responsibilities include creating the sessions and scheduling the sessions.
• Translated Business specifications into PL/SQL code. Designed, Developed and fine-tuned Oracle Stored Procedures and triggers.
• Performed Facets Data Analysis and data mapping between Facets Data elements and downstream system's requirements.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Prepared SQL Queries to validate the data in both source and target databases.
• Designed and developed the ETL processes using Informatica to load data from Oracle, Flat files and XML files to target Oracle Data warehouse.
• Involved application source like EPIC, Clarity, Facets and unstructured files
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created control-M jobs and scheduled them.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Worked on creating the deployment groups for the code migration between the environments.

Environment: Informatica Power Center 10.1, Oracle 12C, UNIX, PL/SQL, Facets, SQL* PLUS, TOAD, MS Excel, Putty, Control-M

Confidential

Informatica Consultant

Responsibilities:

• Implementing the standards of creating Informatica Workflows/Mappings
• Implemented standards for naming Conventions Mapping Documents Technical Documents Migration form
• Extensive experience with End Users for understanding/analyzing the requirements
• Detailed Analysis of the Data provided by the respective source systems and filling in the gaps in the mapping specs
• Experience in designing the complete End to End Data Flow and designing the ETL jobs
• Worked on Source Analyzer Warehouse Designer Mapping Designer Mapp let Designer and Transformations Developer
• Responsible for Data Extraction and Transformation from disparate sources like Oracle, SQL Server, flat files and Loading to Oracle using Informatica Power Center
• Involved in designing of Informatica Mappings by translating the business requirements
• Involved in Performance Tuning and optimization of Informatica mappings and session
• Deploying the code across different environments. Performed Code Review with the team members
• Performance Tuning of Informatica /Data Base Code
• Created Unix Scripts for End to End process flow
• Created Technical Design Documents/Low Level Design Documents/Run Book for Basel II Project
• Used Rational Clear Quest for Raising Migration Requests
• Used HP Quality Center for Defect Tracking.

Environment: Informatica 8.1, Oracle 9i, SQL Server, Linux RHEL, UNIX Shell Programming, Windows NT.