SUMMARY

• 8+ years of experience in Data Warehouse Business Intelligence domain with projects involving Informatica and ETL tools.
• Extensive experience working with Data Warehouses and Data Marts using Informatica Power Center 10.2/10.1, 9.6/9.1, 8.6 (Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor), Informatica Data Quality 9.6, Informatica Power Exchange 9.6 and Informatica Cloud IICS.
• Responsible for interacting with different Business Partners, Vendors & Customers to identify information needs and business requirements.
• Knowledge in designing Star and Snowflake data model.
• Extensive knowledge in designing functional and detailed design documents for data warehouse development.
• Experience in writing UNIX Shell scripts.
• Experience in writing Stored Procedures and Functions (PL/SQL and T - SQL).
• Performance tuning of Sql using SQLplan, SQL hints, partitioning, indexes and join types.
• Working knowledge of a variety of Relational DBMS products, with experience in designing and programming for relational databases, including Confidential, SQL Server, Confidential, DB2.
• Working knowledge on MDM implementation.
• Confidential utilities like Tpump, FastLoad, MLoad and BTEQ.
• Knowledge on Informatica Power Exchange, Informatica Data Quality and, Informatica Icloud IICS
• XML source and target instance and object definitions.
• Extensive experience in using various Informatica Designer features like Source Analyzer, Target Designer, Mapping Designer,Transformation Developer, Mapplet and Worklet,
• Experience working on performance tuning in Informatica using Informatica partitioning and Push down optimization extensively.
• Experience in creating various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router, XML, Stored procedure, SQL, Transaction Control in Informatica Power Center.
• Around 1 year of experience with Change Data Capture using Informatica PowerExchange.
• 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 modeling.
• Extensive knowledge in handling Slowly Changing Dimensions (SCD) Type 1/2/3.
• Experience working with different OLAP BI Reporting tools like Business Objects, Cognos.
• Skilled in developing Test Plans, Creating and Executing Test Cases.
• Followed effectively industry standards of HIPAA layouts.
• Experience working with SDLC, SCRUM, Waterfall and Agile methodologies.
• Reliable, responsible, hardworking and good team player.

TECHNICAL SKILLS:

• ETL Informatica Power Center 10.2/10.1, 9.6.1/9.5.1/9.1.1/8.6, Informatica Data Quality 9.5.1, informatica Power Exchange 9.6.1, Informatica Icloud IICS
• Databases Scheduling tools Confidential 11g/10g/9i/8i, MS SQL Server 2016/2014/2008/2005, DB2, Confidential v 15/13, Mainframe, SQL*Loader Informatica Scheduler, CA7, Control M, Tivoli
• Environment Windows 95/98/2000/NT/2003/XP/7, UNIX, MS-DOS, SQL*Plus.
• Web Technologies Java, HTML, DHTML.
• Scripting Language XML, CSS, Java Script.
• Languages SQL, PL/SQL, C, C++, UNIX Shell, Perl scripting.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Informatica Developer

Responsibilities:

• The objective of the project was to design and develop a new data ware house which will replace the current Enterprise Data Warehouse. The ETL Process involved extraction and migration of the data from DB2,SQL server, Confidential, sales force and Flat files, implementing the business logic and populating the data into the target Sql Server. This project consists of various stages - staging, Ods, Hub, dimensional and fact.
• Extensively used Informatica Client tools - PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Developed complex dimensional and fact mappings using Informatica PowerCenter tool using various performance tuning concepts like partitioning and Push Down Optimization.
• Extracting data from flat files (structured and Unstructured), Excel files,DB2,sql server, Confidential and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Working with various sources such as Flat files, Relational database, MPP System, XML and Salesforce as part of Informatica Mappings.
• Experience working with EDI Standard files like 834, 835, 837's and HL7.
• Good Understanding about practitioner, Member, provider, patient, claim systems.
• Exposure working with Open Enrollment, Benefits and maintenance Enrollment, Payment claim information, Facets and Epic System.
• Designed and developed Technical and Business Data Quality rules in IDQ (Informatica Developer) and created the Score Card to present it to the Business users for a trending analysis (Informatica Analyst).
• Developed unix shell scripts to manage file handling process.
• Analyze the data based on requirements and wrote down techno functional documents and
• Built logical data objects (LDO) and developed various mappings, Mapplet/rules using Informatica data quality (IDQ) based on requirements to profile, validate and cleanse the data.
• Created sessions, tasks, workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Extracting data from Confidential, Sql Server, Db2 and performed Delta mechanism (Incremental loading using mapping variables, mapping parameters, last successful load time concepts. Used SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA).
• Experience developing and supporting complex DW transformations
• Excellent understanding of Star Schema Data Models; Type 1 and Type 2 Dimensions.
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading.
• Extracted data from various heterogeneous sources like Confidential, SQL Server, XML,XSD’s,Flat Files, Confidential .
• Used Debugger to fix the defects/ errors and data issues.
• Knowledge in designing and developing Data marts, Data warehouse using multi-dimensional Models such as Snow Flake Schema and Star Schema while implementing Decision Support Systems, OLTP and OLAP systems. Experience in FACT & Dimensions tables (SCD), Physical & logical data modeling with normalization process.
• Expertise in using both connected and unconnected Lookup Transformations.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD using static/dynamic lookup.
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Developed workflow dependency in Informatica using event wait task, command wait and control task.
• Changed the Informatica sessions to point to Confidential TPT connections using Stream, Update and Load operators.

Environment: Informatica Power Center 10.2/10.1/9.6.1, Informatica Data Quality (IDQ), UDB DB2, MS SQL Server 2014/2012, T-SQL, PL/SQL, OBIEE 10.1.3.x, Unix, SalesForce, Erwin, Unix, Toad, Confidential V15.

Confidential, Farmington Hills, MI

Sr. Informatica Developer

Responsibilities:

• Analyzed and thoroughly studied various data sources and different development environments within the organization.
• Extensively worked on extracting the data from various flat files (fixed width, delimited), applying the business logic and then loading them to the Confidential databases.
• Extensively worked with Source qualifier, Filter, Joiner, Expression, Lookups, Aggregator, Router, Sequence Generator, and Update Strategy.
• Used various Informatica transformations in the development of complex mappings.
• Extracted data from different heterogeneous source systems applied business logic using transformations and loaded to the target systems using Informatica power center.
• Worked closely with business for requirement gathering and to understand the project needs.
• Interacted with environmental team and data architects in design and implementation data models.
• Designed and developed complex mappings to load the Historical, Weekly and Daily files to Confidential database.
• Extensively worked on data conversion and data cleansing.
• Created different move-it jobs to have inbound/outbound transition of files between EDW and different vendors.
• Developed UNIX shell scripting, created command task, and email task for providing the pre-session post-session requirements for various Informatica jobs.
• Provide database coding to support business applications using T-SQL.
• Used Powerexchange for Confidential for db2 database
• Worked on automation of Informatica job flow using autosys boxes/jobs.
• Extensively worked on basic SQL queries such as creating altering Tables, Indexes, Views also worked with PL/SQL stored procedures. Queried various tables to get resultant datasets as per the business requirements.
• Prepared ETL mapping documents explaining complete mapping logic.
• Prepared unit test document and performed unit testing, regression testing.
• Provided QA/UAT support while code promotion and worked with QA’s to resolve any defects if found.
• Worked with different teams as Release Management, DBA, and UNIX team for smooth code promotions.

Environment: Informatica PowerCenter 9.5.1/8.6.1, Confidential 11g, Sql Server 2008/2005, Flat Files, MS Excel 2010, MS Visual Studio 2010, UNIX, WinSCP, MS Access, Autosys.

Confidential, Sacramento, CA

Senior ETL/Informatica Developer

Responsibilities:

• Studied the design of the data warehouse model using Star Schema.
• Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
• Involved in the designing of ETL process using Informatica in order to populate the BI Data Mart using the Flat Files, SQL server to Confidential and Confidential databases.
• Extracted data from sources like SQL server, and Fixed width and Delimited Flat files. Transformed the data according to the business requirement and then Loaded into Confidential and Confidential databases.
• Designed and developed complex mappings to load the Historical and Weekly data from the Legacy Systems to Confidential database.
• Created Reusable Transformations and Mapplets, used them in Mappings to develop the business logic for transforming source data into target.
• Enrich the transaction and load the enriched transactions into Transaction Enrichment Database (TED).
• Implemented Type II Slowly Changing Dimension methodology for accessing the full history of customers.
• Used XSLT for transforming the XML files in implementing the front-end templating system.
• Involved in designing the transformations using XML Source Qualifier in extracting the data from various XML files and loading them onto the Confidential Databases.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, dynamic Lookup, Filter, Update Strategy, and Router transformations.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Wrote PL/SQL statement and stored procedures in Confidential for extracting as well as writing data.
• Created and Monitored Workflows to run Session tasks using Informatica Server.
• Worked on Confidential and its utilities - tpump, fastload through Informatica. Also created complex Confidential Macros.

Environment: Informatica Power Center 9.1.1/8.6.1, Confidential 11g/10g, Confidential Database 13.10, XML, XSL (XSLT and XPath), SQL Server 2008, Flat files.

Confidential, Irving, TX

ETL Consultant

Responsibilities:

• Imported various Sources, Targets, and developed Transformations using Informatica Power Center Designer.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations.
• Created Mapplets using Mapplet Designer.
• Used Type2 mapping to update a slowly changing dimension table to keep full history.
• Captured source file/table definitions, target data, and data mart table definitions.
• Create and maintain metadata and ETL documentation that support business roles and detailed source to target data mappings.
• Involved in designing and extracting the transformations containing the XML Source Qualifier.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Testing and validation of the developed Informatica mappings.
• Monitored sessions using Informatica Server Manager.
• Applied performance-tuning logic to optimize session performance.
• Wrote PL/SQL Packages, procedures, functions in Confidential for business rules conformity.
• Utilized SQL loader, export/import utilities for data load and transformation.
• Developed PL/SQL stored procedures for source pre load and target pre load to verify the existence of tables.
• Worked with different databases such as Confidential and Flat files and used Informatica to extract data.
• Involved in Unit Testing, Integration, and User Acceptance Testing of Mappings.
• Worked with Senior Developer in Documenting the ER Diagrams, Logical and Physical models, business process diagrams and process flow diagrams.
• Environment: Informatica Power center 8.1, Toad, Confidential 9i/8i, Erwin 4.1, SQL Plus, UNIX, Windows 2003, SQL*Loader.
• :
• Masters in Engineering Management, Information Systems,
• Indiana Institute of Technology, Indiana USA(2009)
• Bachelors in 200