SUMMARY:

• Over 7+ years of progressive hands - on experience in analysis, ETL processes, design and development of enterprise level data warehouse architectures, enterprise level large databases, designing, coding, testing, and integrating ETL.
• Proficient in understanding and detailing the business requirements and had experience in interacting with business users to clarify requirements and translate the requirements into technical and user stories.
• Experience in Dimensional data modeling techniques, Slow Changing Dimensions (SCD), Software Development Life Cycle (SDLC) (Requirement Analysis, Design, Development & Testing), and Data warehouse concepts - Star Schema/Snowflake Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Experience in integration of various data sources like Oracle 12c,11g,10g, MS SQL Server, XML files, Teradata, Netezza, DB2, Flat files, Salesforce, Mainframe sources into staging area through ETL Process and loaded data into different target Enterprise level databases.
• Expertise in Master Data Management concepts, Methodologies, and ability to apply this knowledge in building MDM solutions
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server, and Cleanse Adapter in Windows.
• Expertise in developing large integrated complex mappings with standard transformations and complex transformations like SQL transformation, Java Transformation for calling API’s, Store-procedures, Flexible Target Key transformation (AI, BI modes) also developed complex re-usable chunk of mappings called Mapplets, and Worklets and re-usable and non-reusable transformations.
• Extensively worked on ETL Automation Testing using Ruby, done unit testing and acceptance testing through Automation and captured major and minor bugs during code development and delivered highly efficient Business deliverables.
• Hands on Experience in SQL, DB2 SQL, TSQL, PL/SQL code and done Perl scripting to validate the record counts in the xml’s, getting load event id to process, updating the status of events for the load event id and building informatica parameter file and executing the informatica workflows using Perl scripts.
• Also developed UNIX shell scripts to run batch jobs and Informatica workflows from Unix server and automated the entire ETL test ruby specs through Jenkins that is integrated with the docker, so units and acceptance will run on daily basis.
• Extensively worked on Informatica Data Quality (IDQ) projects and worked on Informatica Data Quality transformations like Address validator, Parser, Labeller, Match, Exception, Association, Standardizer and other significant transformations . As a Data Quality developer initiated the process of Data profiling by profiling different formats of data from different sources.
• Expertise in maintaining the different Versions of the code in GitHub and expertise in maintaining Project and Feature branches and hands on experience in deploying the code from Development server to Test Region or to Production server using Urban Code Deployment tool (UCD) .
• Designed complex Mappings and enhanced the performance by identifying the bottle necks in P erformance tuning at target level, source level, mapping and session level and worked with dba to identify the bottlenecks during the transaction commits and logs.
• Maintained best practice of writing tests first and developing code next a Test-Driven Development methodology TDD which is associated in writing Good Failing Tests first, Developing Code next, then Passing already written Failed Tests and finally Refactoring the code.
• Hands on experience working in UNIX, LINUX and Windows environments.
• With both On-site and Off-shore experience have developed skills in system analysis, troubleshooting, debugging, deployment, Team management, prioritizing tasks and customer handling.
• Domain knowledge experience on Health, Finance, Insurance, Telecom Domains.

TECHNICAL SKILLS:

Operating System: UNIX, Linux, Windows

Programming and Scripting: C, C++, Java, .Net, Perl Scripting, Shell Scripting, XSLT, PL/SQL, T-SQL.

Specialist Applications & Software: Informatica Power Center/ 10.1 10/9.6.1/9.5/9.1/8.6/8.1/7.1 , Informatica Power Exchange, Metadata Manager, Informatica Data Quality (IDQ), Informatica Data Explorer (IDE), MDM, SSIS, Salesforce, DataStage, etc.

Data Modeling (working knowledge): Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Physical, Logical Data Modeling, and ER Diagrams.

Databases tools: SQL Server Management Studio (2008), Oracle SQL Developer (3.0), Toad 11.6 (Oracle), Teradata, AQT v9 (Advanced query tool) (Oracle/Netezza), DB Artisan 9.0 (Sybase), SQL Browser (Oracle Sybase), Visio, ERWIN

Scheduling tools: Informatica Scheduler, CA Scheduler(Autosys), ESP, Maestro, Control-M.

Conversion/Transformation tools: Informatica Data Transformation, Oxygen XML Editor (ver.9, ver.10)

Software Development Methodology: Agile, Water fall.

Domain Expertise: Publishing, Insurance/Finance, HealthCare Others (working knowledge on some):

OBIEE RPD creation, OBIEE, ECM, Informatica Data Transformation XMAP, DAC, Rational Clear Case, WS-FTP Pro, DTD.

RDBMS: SQL, SQL*Plus, SQL*Loader, Oracle11g/10g/9i/8i, Teradata, IBM DB2, UDB 8.1/7.0, Sybase 12.5, Netezza v9, MS SQL Server 2000/2005/2008 , MS Access 7.0/2000.

PROFESSIONAL EXPERIENCE:

Confidential, Newark, DE

Sr. Informatica Developer/Application Developer

Responsibilities:

• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, Mapplets, reusable transformations, session tasks and Workflows.
• Performed extraction, transformation and loading of data from different sources like Flat Files, DB2 in accordance with requirements and specifications.
• Creating mappings and different kind of transformations like Source qualifier, Aggregators, lookups, Filters, Sequence, Stored Procedure, Java and Update strategy. Created and used Reusable Transformations and Mapplets to improve maintainability of the mappings.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Involved in extensive Performance Tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Designed and developed real-time Data Warehouse using CDC tool Informatica Power Exchange. Created and configured Power Exchange components like registration, data map, configured cfg file, connection setup and recovery.
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes.
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using workflow manager.
• Loaded data using FLOAD, MLOAD and Teradata Parallel Transport utility (TPT).
• Developed the queries using Teradata SQL Assistant.
• Creating tasks, sessions, events, timers etc in the workflow manager and monitoring them in the workflow monitor.
• Examined sessions, event, and error logs and analyzed for trouble shooting mappings and sessions.
• Performed Unit Testing and tuned the mappings for better performance.
• Migrated mappings, sessions, and workflows from Development to testing and then to Production environments.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the Shell scripts.
• Used Informatica IDQ to do data profiling of the source and check for the accuracy of data using dashboard.
• Developed UNIX shell scripts to create parameter files, and to executing Informatica workflows.
• Created Autosys JIL scripts, Parameter files and automated ETL process by scheduling the jobs using Autosys.

Environment: UNIX, Windows XP, CDB, LiveLink, Oracle 10g, ERP (Oracle apps), IDQ, Informatica Power Center 9.6.1, Toad, autosys, Business Objects.

Confidential, Miamisburg, OH

Sr. Informatica/ETL Developer

Responsibilities:

• Working as Snr. ETL developer to gather all requirements.
• Interacts with business users to understand the requirements.
• Create technical specification documents, STM documents, detailed ETL designs, Unit test plans, Deployment plans, Turn over documents etc.
• Involved in ETL architecture meetings and any new tool implementations.
• Used complex Informatica mappings to extract data from the source system to the Staging DB.
• Converted complex Oracle PL/SQL Packages to Informatica Mapping/Mapplets.
• Converted complex Transformation requirements to Informatica Transformations to transform the Source data to match the target data.
• Designed and build the wrapper script to call the Informatica workflow and session to migrate the data from one end to other end.
• Worked on the Macro s for building parameters, generating the source and inserting the Metadata.
• Implemented various performance tuning activities related to Informatica, Databases and UNIX for complex loads. Resolved several ETL performance issues there by cutting the run time from several hours to minutes.
• Designed and developed complex mappings to load the Historical and Weekly data from different source systems.
• Worked and responsible for running the Control M Jobs.
• Design document for mapping, which include details of field-to-field mapping between sources and target, Business (Transformation) Rules, Parameters, Processing flow and details of sessions, pre-dependencies, post-dependencies, and exception error processing methodology.
• Worked closely on the major defects in QA and UAT Environment.
• Created Data Flow Diagrams using Microsoft Visio to depict the flow of the Mappings.
• Used slowly changing dimensions.
• Coordinate with project management team and ensure accuracy on all deliverables and prepare summary reports.
• Monitored Data Quality, Informatica Data Quality (IDQ) routines in the Informatica mappings to standardize and cleanse the name, address, and contact information.
• Involved in reading data from XML/XSD, Flat files, COBOL/VSAM files.

Environment: Informatica Power Center 9.6.1, IDQ 8.6, DB2, Oracle 11g/10g, UNIX Shell scripting, Linux, OBIEE 11.7.0, Control M, Teradata 12.0, Notepad ++, DB Visualizer, Perl Scripting, XML Files, COBOL Files.

Confidential, Minneapolis, MN

Sr. ETL Developer / Analyst

Responsibilities:

• Worked with Business Analysts (BA) to analyze the Data Quality issue and find the root cause for the problem with the proper solution to fix the issue...
• Document the process that resolves the issue which involves analysis, design, construction and testing for Data quality issues
• Involved in doing the Data model changes and other changes in the Transformation logic in the existing Mappings according to the Business requirements for the Incremental Fixes
• Worked extensively with Informatica tools like Source Analyzer, Warehouse Designer, Transformation Developer, and Mapping Designer.
• Extensively used Informatica Data Explorer (IDE)&Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
• Created Informatica workflows and IDQ mappings for - Batch and Real Time.
• Extracted data from various heterogeneous sources like DB2, Sales force, Mainframes, Teradata, and Flat Files using Informatica Power center and loaded data in target database.
• Created and Configured Landing Tables, Staging Tables, Base Objects, Foreign key relationships, Queries, Query Groups etc. in MDM.
• Defined the Match and Merge Rules in MDM Hub by creating Match Strategy, Match columns and rules for maintaining Data Quality
• Extensively worked with different transformations such as Expression, Aggregator, Sorter, Joiner, Router, Filter, and Union in developing the mappings to migrate the data from source to target.
• Used connected and Unconnected Lookup transformations and Lookup Caches in looking the data from relational and Flat Files. Used Update Strategy transformation extensively with DD INSERT, DD UPDATE, DD REJECT, and DD DELETE.
• Extensively Implemented SCD TYPE 2 Mappings for CDC (Change data capture) in EDW.
• Involved in doing Unit Testing, Integration Testing, and Data Validation.
• Migration of Informatica maps extensively involved in migration from Dev to SIT and UAT to Production environment.
• Developed Unix script to sftp, archive, cleanse and process many flat files
• Created and ran Pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager
• Extensively worked in migrating the mappings, worklets and workflows within the repository from one folder to another folder as well as among the different repositories.
• Created Mapping parameters and Variables and written parameter files.
• Used SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, and Database Triggers).
• Worked on Scheduling Jobs and monitoring them through Control M and CA scheduler tool(Autosys).
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Worked with the SCM code management tool to move the code to Production
• Extensively worked with session logs and workflow logs in doing Error Handling and trouble shooting.

Environment: : Informatica Power Center 9.0.1, Erwin, Teradata, Tidal, SQL Assistance, DB2, XML, Oracle 9i/10g/11g, MQ Series, OBIEE 10.1.3.2, IDQ, MDM Toad and UNIX Shell Scripts.

Confidential, Pittsburgh, PA

Sr. Informatica Developer/IDQ/MDM

Responsibilities:

• Designing the dimensional model and data load process using SCD Type 2 for the quarterly membership reporting purposes.
• Derived the dimensions and facts for the given data and loaded them on a regular interval as per the business requirement.
• Generating the data feeds from analytical warehouse using required ETL logic to handle data transformations and business constraints while loading from source to target layout.
• Worked on Master Data Management (MDM), Hub Development, extract, transform, cleansing, loading the data onto the staging and base object tables
• Extracted data from multiple sources such as Oracle, XML, and Flat Files and loaded the transformed data into targets in Oracle, Flat Files.
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ
• Designing and coding the automated balancing process for the feeds that goes out from data warehouse.
• Implement the automated balancing and control process which will enable the control on the audit and balance and control for the ETL code.
• Hands on experience on HIPPA Transactions like 270, 271, 272, 273, 274, 275, 276, 277, 834, 835, 837 etc.
• Improving the database access performance by tuning the DB access methods like creating partitions, using SQL hints, and using proper indexes.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Created ETL mappings, sessions, workflows by extracting data from MDM system, FLASH DC & REM source systems.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Mapped client processes/databases/data sources/reporting software to HPE’s XIX X12 processing systems(BizTalk/Visual Studio/Oracle SQL/MS SQL/C#/.Net/WSDL/SOAP/Rest/API/XML/XSLT).
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations, and create mapplets that provides reusability in mappings.
• Analyzing the impact and required changes to in corporate the standards in the existing data warehousing design.
• Following the PDLC process to move the code across the environments though proper approvals and source control environments.
• Source control using SCM.

Environment: Informatica Power Center 9.0.1, Erwin 7.2/4.5, Business Objects XI, Unix Shell Scripting, XML, Oracle 11g/10g, DB2 8.0, IDQ, MDM, TOAD, MS Excel, Flat Files, SQL Server 2008/2005, PL/SQL, Windows NT 4.0

Confidential - Merck, Bangalore, IN

ETL Developer/Analyst

Responsibilities:

• Involved in the requirement definition and analysis support for Data warehouse efforts.
• Documented and translated user requirements into system solutions; developed implementation plan and schedule.
• Designed fact and dimension tables for Star Schema to develop the Data warehouse.
• Extracted the data from Teradata, SQL Server, Oracle, Files, and Access into Data warehouse.
• Created dimensions and facts in physical data model using ERWIN tool.
• Used Informatica Designer to create complex mappings using different transformations to move data to a Data Warehouse
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Look up, Aggregator, Stored Procedure, Update Strategy, Joiner, Filter.
• Scheduling the sessions to extract, transform and load data into warehouse database on Business requirements.
• Loaded the flat files data using Informatica to data warehouse
• Created Global Repository, Groups, Users assigned privileges Using Repository manager.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Server Manager.
• Handled common data warehousing problems like tracking dimension change using SCD type2 mapping.
• Used e-mail task for on success and on-failure notification.
• Used decision task for running different tasks in the same workflow.
• Assisted team member with their various Informatica needs.
• Developed and maintained technical documentation regarding the extract, transformation, and load process.
• Responsible for the development of system test plans, test case creation, monitoring progress of specific testing activities against plan, and successfully completing testing activities within the requisite project timeframes.

Environment: Informatica Power Center 8.1, Erwin, Oracle 9i, UNIX, Sybase, MS SQL Server Windows 2000

Confidential

Informatica Developer

Responsibilities:

• Involved in analysis, design, development, test data preparation, unit and integration testing, Preparation of Test cases and Test Results
• Coordinating with client, Business and ETL team on development
• Developed Batch jobs using extraction programs using COBOL, JCL, VSAM, Datasets, FTP to Load Informatica tables
• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing logic, and transformation as per the requirement and creating mappings and loading the data into BI database.
• Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process.
• Designing and developing ETL solutions in Informatica Power Center 8.1
• Designing ETL process and creation of ETL design and system design documents.
• Developing code to extract, transform, and load (ETL) data from inbound flat files and various databases into various outbound files using complex business logic.
• Most of the transformations were used like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy.
• Created automated shell scripts to transfer files among servers using FTP, SFTP protocols and download files.
• Developed Informatica mappings, enabling the ETL process for large volumes of data into target tables.
• Designed and developed process to handle high volumes of data and high volumes of data loading in each SLA.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Informatica scheduling tool.
• Ensured acceptable performance of the data warehouse processes by monitoring, researching and identifying the root causes of bottlenecks.
• Acted as a liaison between the application testing team and development team in order to make timely fixes.

Environment: Informatica Power Center 8.1, ETL, Business Objects, Oracle 10g/9i/8i, HP - Unix, PL/SQL.