SUMMARY

• Informatica ETL Consultant - IT Executive around 10 years of experience in all aspects of Information Technology management and Data Warehousing, specializing in providing client data solutions with comprehensive system analysis, database design and application development & experience. Equipped with strong qualifications in Analyzing, Profiling and building Balanced, Efficient and Optimized Data Warehouses and Data Marts. Highly structured and experienced with all phases of Data Warehouse SDLC enforcing standards and best practices in ETL developing and design
• Development: Worked on multiple and successful projects involving Data Extraction, Data Migration, Data Quality and Data Cleansing for various operational and transactional systems using ETL Informatica Power Center, Informatica Data Quality Developer. Involved in Onshore / Offshore models - effectively delegating tasks and coordinating diverse teams to accomplish project work and enhance productivity. Hands on Experience on writing the Unix shell scripts like wrapper, FTP, Validations and Achieving.
• Expertise: Informatica 10.0/9.6.1/9.5.1/9.1.0/8.6.1/8.5/8.1/7.1/ Power Exchange/RepositoryManager/Designer/WorkflowManger/Workflowmonitor/Oracle11g/10g/9i/SQLServer2005/2008/DB2/COBOLfile/XML/PeopleSoft/Netezza/Autosys/ControlM/Tivoli Workload Scheduler/ PL/SQL, C, SQL/IBM Db2/Amazon Red Shift Database
• Coding/Regression/Unit Testing/Integration Testing: Responsible for Analysis, Design, coding, testing, code review, debugging and implementing Extract, Transform, Load (ETL) mappings and workflows using Informatica. Developed test cases for validating data and reviewing QA test cases, Deep Unit & Integration Testing has been done in DEV and QA until the test case is passed. To Check Count Validation, Record Count Verification and reporting queries against source and target as an initial check and verifying initial loading of records on data warehouse and testing the rejected records that don’t fulfill transformation rules, Supporting UAT.
• Data Profiling: Data profiling has been done with understanding of business analysis and data analytics and Categorized data elements fordata profilingand mapping from source to target data environment.
• Data Analyst: Interpret data from primary and secondary sources using statistical techniques.
• Deployment: Deployment Groups has been created to do the code migration (Workflows). Conducted code reviews on weekly basis before Deploying into test and Production environment and Prepared migration document to move the mappings from development to testing and then to production repositories.
• Load Types: Implemented slowly changing dimensions of type 1 and type 2 to store history according to business requirements. Strong experience in OLTP/OLAP System Study, Analysis and E-R modeling, developing Schemas such as Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling using Erwin and ER Studio
• Performance tuning: Deep Experience in performance tuning of sources, mappings, targets and sessions. workflows, developedefficient Error Handlingmethods and implemented in development process
• ABC: Designed SOX Compliant Audit Balance and Control Mechanism to notify users and reporting the Audit results through automated Notifications.
• Production Support: Provided maintenance and support for report center by looking after errors in daily loads and played an active role in resolving them with in SLA and Coordinated with Informatica admin during Informatica production outage to bring back Informatica Integration services back on line to run workflows that have been interrupted or not run at all. Worked with Redshift support team during database choke and S3 bucket down due to space or other downtimes.
• Working on the outstanding Defects and IT service requests by coordinating with offshore and onsite team and working on inbound/outbound files and data from Vendors and downstream datafeed owners.
• Monitoring the daily loads in PROD and also the reconciliation failures in all subject areas and making sure of addressing all failures to respective Product heads and Business.

TECHNICAL SKILLS

Skills: Informatica PC,IICS CLOUD,PWX,MDM

Database: Oracle/SQL Server/Snowflake/AWS Redshift/Netezza

Interfaces: TOAD 11.6, SQL*Loader, MS SQL Server Management

Languages: PL/SQL, C, C++, SQL, Unix scripting

Scheduling Tools: Autosys, Control-M

Concepts: Data Warehousing, ETL and RDBMS

OS: Windows 2008/2007/2005/ NT/XP, UNIX, Linux

Tools: MSOffice-Word, Excel, Access, Visio, PowerPoint, SQL Loader, SQL Navigator, TOAD11.6 for Oracle 10g

PROFESSIONAL EXPERIENCE

Confidential, CA

ETL Consultant

Responsibilities:

• Understanding the business requirements and functional specifications of the module. •
• Responsible for information systems focusing on ETL/Database Architecture.•
• Working closelywith tech leads and product owners in terms of coordinating with project activities to meet project deliverables.•
• Interfacing with Client managers, Scrum masters, testing and development teams.•
• Design and implementation of ETL (Extract, Transform and Load) solutions.•
• Responsible for documenting all the mappings,mapplets in detail.•
• Build complex scripts to execute mappings and workflows.•
• Writing effective and efficient Structures Query Language (SQL) statements, common table expressions, window functions like rank,lag,lead rownum etc. to facilitate extraction of data from various source systems and loading it into reporting Datawarehouse (Snowflake).•
• Designing workflows, deployment & monitoring of master files data loading process in Reporting Datawarehouse(Snowflake) which also includes technical, business data validations upon successful data loads.•
• Responsible for creating reusable source, target definitions, resuable transformations in Informatica•
• Triggering Jobs, scheduling and monitoring them in Batch scheduling tool (Control -M).•Reviewing source systems and validate target systems.•
• Working on bugs and issues during development process, UAT and in productions environments.•
• Liaise with offshore teams to guide them on the design and development.•
• Provide Daily/Weekly status report during project phase to the client and Wipro Management.

Environment: Informatica Power Center 10x/Snowflake/IICS/GITHUB/Guidewire (Source system)/GW DataDictionary/Repository Manager 10/Workflow Manager/Unix/ Guide wire App/Data Modeling/Data Profiling/Scrum/ Control-M Scheduler

Confidential, CA

ETL Senior Dev

Responsibilities:

• Development: This project is to develop Data Marts for each Line of business and to completely integrate the business to AWS redshift cloud environment. This data warehouse is used to easily access the detailed data on a single platform using Informatica Power Center 10/MDM for extracting data from Various Sources systems Guidewire and Nextgen.
• Loaded about 2000 tables including Stage, Dimensions and Facts from different source systems into RC staging (Data Warehouses) for brand new projects using Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor) as ETL tool on Amazon Redshift and SQL Server Databases.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse/Developed and designed update and insert mappings with parameters and variables to support SQL override.
• Hands on experience in writing Unix Shell Scripts.
• Maintenance and Production Support: Handling maintenance and PROD support and ongoing support has been provided for production issues by looking after the errors in daily loads and played an active role in resolving them with in SLA.
• Coordinated with Informatica admin/Redshift Support during Informatica production/Redshift outage to bring back services online to run workflows to load the DWH in Cloud that have been interrupted or not run at all.

Environment: Informatica Power Center 10x/MDM/Repository Manager 10/Workflow Manager/ Power Exchange IDQ /Amazon Redshift/MS SQL Server 2014/XML Files/ Guide wire App/Data Modeling/Data Profiling/Scrum/ Tivoli Work Load Scheduler

Confidential, NJ

Software Engineer

Responsibilities:

• Development: Main objective of this project is to develop a Financial Data Hub and Claims Datamart to completely integrate and the business from Policy Center, Billing Center, Claim Center, to single environment called Report Center. This data warehouse is used to access easily the detailed data on a single platform using Informatica Power Center 10/MDM for extracting data from Various Sources systems and to generate Reports and to provide data feeds to Multiple vendors by generating Inbound and Outbound files.
• Loaded about 350 staging tables from different source systems into EDW and Legacy staging and loading data to 50 SCD type2 Dimensions and 30 facts with metrics in Data Warehouse for brand new projects using Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor) as ETL tool on Oracle, DB2 and SQL Server Databases.
• Extracted the data from the flat files and other RDBMS databases like Sql Server, Oracle into staging area and populated onto Data warehouse/Developed and designed update and insert mappings with parameters and variables to support SQL override.
• Hands on experience in writing Unix Shell Scripts.
• Complete hands of experience across all stages of Software Development Life Cycle (SDLC) including Business requirement analysis, Data mapping, build, unit testing, systems integration and user acceptance testing/Involved in building the ETL architecture and Source to Target mappings Regression and & Unit Testing: Conducted code reviews on weekly basis before Deploying into test and Production environment/Prepared migration document to move the mappings from development to testing and then to production repositories.
• Production Support: Ongoing support has been provided for production issues by looking after the errors in daily loads and played an active role in resolving them with in SLA.
• Coordinated with Informatica admins during Informatica production outage to bring back informatica Integration services back online to run workflows that have been interrupted or not run at all.

Environment: Informatica Power Center 10x/ Big Data/MDM/IDQ/Oracle Exadata/ Repository Manager 10/Workflow Manager/ Power Exchange IDQ /Sales Force/Oracle/MS SQL Server 2014/XML Files/ Guide wire App/Data Modeling/Data Profiling/Scrum/ web services

Confidential

ETL Informatica Technical Lead/Architect

Responsibilities:

• Development: Main objective of this project is to develop an Enterprise Data Warehouse to completely integrate the business to single environment. This data warehouse is used to access easily the detailed data on a single platform using Informatica Power Center 10/MDM/IDG/Big data for extracting data from Various Sources systems for creating Master data of RISK Items.
• Loaded about 2000 tables from different source systems into KPI staging (Data Warehouses) for brand new projects using Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor) as ETL tool on Oracle, DB2 and SQL Server Databases.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse/Developed and designed update and insert mappings with parameters and variables to support SQL override.
• Hands on experience in writing Unix Shell Scripts.
• Complete hands of experience across all stages of Software Development Life Cycle (SDLC) including Business requirement analysis, Data mapping, build, unit testing, systems integration and user acceptance testing/Involved in building the ETL architecture and Source to Target mappings Regression and & Unit Testing: Conducted code reviews on weekly basis before Deploying into test and Production environment/Prepared migration document to move the mappings from development to testing and then to production repositories.
• Production Support: Ongoing support has been provided for production issues by looking after the errors in daily loads and played an active role in resolving them with in SLA.
• Coordinated with Informatica admins during Informatica production outage to bring back informatica Integration services back on line to run workflows that have been interrupted or not run at all.

Environment: Informatica Power Center 10x/ Big Data/MDM/IDQ/Oracle Exadata/ Repository Manager 10/Workflow Manager/ Power Exchange IDQ /Sales Force/Oracle/MS SQL Server 2014/XML Files/ Guide wire App/Data Modeling/Data Profiling/Scrum/ web services

Confidential

ETL Informatica Developer

Responsibilities:

• Development Responsibilities for AIMS
• Developed multiple mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Router, Lookup, Sequence Generator, Filter, and Sorter.
• Extensively used ETL to transfer and extract data from source files (Flat files and VSAM main frames) and load the data into the target database for a New project Called REALMS
• Informatica Power center mappings for handling Sources using relational Connectors for loading the Data in databases.
• Attended meetings daily and got the business requirements & Updated maps, sessions and workflows as a part of ETL change.
• CDC Process: has been done for the comparison between the Source File Data and previous files
• Experienced in Business Requirements analysis, Application Design, Data Modeling, Coding, Development, Testing and implementation of business applications with ETL & RDBMS
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating Transformations.
• Created mappings that storeshistorical datawhich is further used for reporting
• Project# 2. Go to Market (GTM) - Cigna Pharmacy Management
• Design the system components for the extract/transform or conversion of data from source systems to the target application/Design system components which reconcile and audit the results of the extract/transform or conversion of data from source systems to the target application
• Construct the extract/transform, transfer and audit components of a data warehousing system or data conversion programs through the use of extract development tools or custom developed procedures
• Define and manage the data load procedures; facilitate the change data capture/In addition to developing new mappings / ETL jobs, also responsible for automation, monitoring and supporting mappings, and re-designing if required to make them run faster and more reliable
• Strong experience with Strong experience with business intelligence and data warehousing design principles and industry best practices /Deep understanding of relational database design concepts and SQL programming
• Enhancing the Shell scripts based on the requirements and writing new Linux/Unix shell scripts.
• Unit Testing: Developed test cases for validating data and Deep Unit & Integration Testing has been done in DEV and QA until the test case is passed. To Check Count Validation, Record Count Verification and reporting queries against source and target as an initial check
• Production Support: Provided maintenance and support by looking after errors in daily loads

Environment: Informatica Power Center (Designer9.x/8.x/7.x /Repository Manager 9.x/8.x/7.x Workflow Manager 9x/8x/7x)

Confidential

ETL Informatica Developer

Responsibilities:

• Development: Developed solutions in highly demanding environment and provide hands on guidance to other team members/Implemented an Informatica based ETL solutions fulfilling stringent performance requirements.
• Collaborated with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with product/Assess requirements for completeness and accuracy and determined if requirements are actionable for ETL team.

Environment: Informatica Power Center 9x /Oracle 10g/ Repository Manager 10/Workflow Manager/ Power Exchange /Sales Force/Oracle/MS SQL Server 2014/Data Modeling/Data Profiling/Scrum/ web services

Confidential

ETL Informatica Developer

Responsibilities:

• Rewards and Rebates Data Ware house (RRDW) is a conversion Project with an agenda of replacing flat file sources to Power exchange source (Mainframes) / Developed all data warehouse models and prepare reports for all Meta data integration into systems and draft all ETL scripts and prepare required reports for all end users.
• Design and implement all publication activities such as dashboards and maintain required system documentation according to IT applications and SDLC procedures and provide support to all activities and provide resolution.
• Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems and implement all data warehouse activities and prepare reports for same/ Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
• Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems / provided support to all ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.
• Design, build and deploy effective SSIS packages /Implement stored procedures and effectively query a database / Translate requirement from the business and analyst into technical code.

Environment: Informatica Power Center 9x /Oracle 10g/ Repository Manager 10/Workflow Manager/ Power Exchange