PROFESSIONAL SUMMARY:

• Over 7+ years of IT expertise in Analysis, Design, Development, Implementation, Testing and Production Support for Data warehousing applications with good domain knowledge of healthcare and insurance.
• Good understanding with all phases of SDLC (System Development Life Cycle) including Planning, Analysis, Design, Implementation and Maintenance
• Experience in integration of various Operational Data Source (ODS) with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Experience in using ETL Informatica Power Center 9.5.1/9.0.1/8 . x/7.x and various types of RDBMS databases like Oracle, SQL Server, T - SQL, Integration Services (SSIS), Reporting Services (SSRS).
• Experience of real-time CDC (change data capture) design, development and implementation using Informatica Power Exchange 9.x/8. X/10. x.
• Extensive experience with ETL tool Informatica in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, and scheduling the Workflows and sessions.
• Good experience in Data Extraction, Transformation, Loading from data sources like Oracle 11g,10g,9i/8i, SQL Server2008R2/2008/2005, XML, Flat files, DTS and SSIS services.
• Strong knowledge on IDQ Mapping Designer, Mapplet Designer, Transformation developer Designer, Workflow Manager and Repository.
• Expert level Data Integration skills using Informatica Power Center to design, develop, implement, and optimize ETL mappings, transformations and workflows to move data from multiple sources including flat files, RDBMS tables, XML’s into Operational Data Store (ODS), Data Warehouse and Data Marts.
• Have experience with IDQ, MDM with knowledge on Big Data Edition Integration with Hadoop and HDFS.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Functions, Views, Indexes, Cursors, SQL joins and Dynamic SQL queries etc.
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Developed several Mappings, Mapplets and Reusable Transformations to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Extensively developed Complex mappings using various transformations such as Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union and more.
• Experience on data profiling & various data quality rules development using Informatica Data Quality (IDQ).
• Worked on IDQ tools for data profiling, data enrichment and standardization.
• Experience in development of mappings in IDQ to load the cleansed data into the target table using various IDQ transformations. Experience in data profiling and analyzing the scorecards to design the data model.
• Experience in migrating Informatica mappings/Workflows/sessions to Production Repository.

TECHNICAL SKILLS:

Relational Databases: MS SQL Server 2014/2012/2008 R2/2008, SQL Server Management Studio (SSMS), Oracle 11g/10g

Tools: SQL Server Management studio, Profiler, SSIS, SSRS, Visual Studio .Net. Informatica Power Center 9x/8.6.1/8.1

Languages: T-SQL, SQL, C#, ASP.Net, PL/SQL

Web Technologies: XML, XSL

Operating Systems: Windows 2007 Server, UNIX

Data Modeling Tools: ETL, Microsoft Office Suite.

ETL Technologies: SQL Server Integration Services (SSIS), Informatica Power Center 9.5.1/9.0.1/8 . 6.1/8.0.1/7.5/7.1, Control-M, IDQ, MDM, Autosys, SharePoint

PROFESSIONAL EXPERIENCE::

Confidential, Columbia, MD

ETL/Informatica developer

Responsibilities:

• Worked with business analysts to identify the appropriate data elements for required capabilities.
• Developed mappings in Informatica to load the data from source files using different transformations like Source Qualifier, Look up connected and unconnected, Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure, normalizer, Router and Mapplets.
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.
• Worked with client team while designing requirements document.
• Performed Data cleansing and data scrubbing on the source systems.
• Implemented transformations on the source systems as per requirements and loaded them into a Landing zone.
• Extensively used ETL Tool Informatica to load data from Flat Files to landing tables in Oracle server.
• Developed ETL mappings, transformations using Informatica PowerCenter 9.1/9.5.1 to load the data from landing tables to Dimension tables.
• Identified and eliminated duplicates in datasets thorough IDQ components
• Integrated Informatica Data Quality (IDQ) with Informatica PowerCenter and Created POC data quality mappings in Informatica Data Quality tool and imported them into Informatica power center as mappings, mapplets
• Implemented Slowly Changing Dimensions (SCD-2) for loading the dimension tables.
• Developed mappings to load the data into Fact Tables.
• IDQ is used for data cleansing, Tuning and profiling and Implemented reports, dashboards to display DQ results
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping
• Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Performed data profiling and analysis making use of Informatica Data Quality (IDQ).
• Performed in creating tasks in the workflow manager and exported IDQ mappings and executed them
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Filter, Joiner, Update Strategy.
• Created events and tasks in the work flows using workflow manager.
• Created sessions and arranged them in various workflows in the workflow manager.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.

Environment: IDQ, Informatica Power Center 9.5.1, Toad for oracle 11G,SQL Server Integration Services 2014/2012 (SSIS), SSRS 2014, SQL Server Management Studio, T-SQL, SQL Server 2014, Team Foundation Server, Informatica Power Center 10.x, Toad, Oracle SQL Developer.

Confidential, Baltimore, MD

ETL/SSRS Developer

Responsibilities:

• As part of SDLC process, created Software Requirements Specifications (SRS) Document and System Design Specifications (SDS) Document before Development phase.
• Designed and developed Informatica mappings to Extract, Transform and Load data into target tables.
• Worked with Memory cache for Static and Dynamic cache to enhance throughput of sessions containing Rank, Lookup, Joiner, Filter, Sorter, Normalizer and Aggregator transformations.
• Extensively used transformations of Informatica including Lookups, Router, Filter, Normalization, Union all, Update Strategy and others.
• Worked with Informatica Data Quality (IDQ) 9.1 for data cleansing, data matching and data conversion.
• Designed/Developed IDQ reusable mappings to match accounting data based on demographic information.
• Worked with IDQ on data quality for data cleansing, robust data, remove the unwanted data, correctness of data.
• Performed in creating tasks in the workflow manager and exported IDQ mappings and executed them.
• Worked on IDQ parsing, IDQ Standardization, matching, IDQ web services.
• Imported the mappings developed in data quality (IDQ) to Informatica designer.
• Worked on Informatica Analyst Tool IDQ, to get score cards report for data issues.
• Expertise in creating Packages using SQL Server Integration Services (SSIS).
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Developed mappings for Type 1, Type 2 Slowly Changing Dimension (SCD).
• Worked with Session Logs, Workflow Logs and Debugger for Error Handling and Troubleshooting in all environments.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Worked extensively in Unix Environment and Informatica to fix jobs.
• Involved in deployment of jobs to the production environment.
• Worked on configuring SFTP protocols in Unix Servers.

Environment: Informatica Power Center 9.5.1, Power Exchange, IDQ, SQL Server Integration Services 2014 (SSIS), SSRS 2014, SQL Server Management Studio, T-SQL, SQL Server 2014, Windows XP, Sub Version Server, Informatica Power Center 10.x, Toad, UNIX Shell Scripting, Oracle SQL Developer, SQL Server 2008 r2, CA7.

Confidential, Allentown, PA

ETL Informatica Developer

Responsibilities:

• Design ETL processes using Informatica tool to load data from Oracle source systems and Flat files into Oracle Target database
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files XML Files.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and from the relational database, which was Oracle 9i/10g.
• Extensively used Transformations like, Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Used Informatica Repository Manager to create Repositories and users and to give permissions to users.
• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into Frame Work Manager
• Extensively worked in the performance tuning of ETL mappings and sessions.
• Written PL/SQL stored Procedures and Functions for Stored Procedure Transformation.
• Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Extracted Data from Various sources by using Informatica. Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations.
• Extracted data from various sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules. Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement the ETL jobs using Informatica.
• Implemented slowly changing dimensions methodology and developed mappings to keep track of historical data.
• Written SQL overrides in Source Qualifier and Lookups according to business requirements.
• Configured and scheduled packages to be deployed out to a production environment using SQL server Table file configurations in SSIS.
• Proficient in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).

Environment: SQL Server 2008/2012 Enterprise Edition, BIDS, SSIS, SSRS, T-SQL ETL, VB.Net Informatica PowerCenter 8.6 & 9.1 (Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor), Oracle 10g/9g, TOAD, UNIX, PL/SQL

Confidential, Dallas, TX

SQL/SSIS/SSRS Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data

Environment: SQL Server 2008/2012 Enterprise Edition, BIDS, SSAS, SSIS, SSRS, T-SQL, MDX, ETL, VB.Net, ASP.Net, C#