SUMMARY

• Offering 11 years of rich experience as Technical & Functional experience in Data warehousing and Expert in Data Warehouse, ETL design & development, ETL Testing, OLAP design and development.
• Executed end to end Project Design, Development, Testing, Deployment and Support activities using DWH & BI.
• Extensive experience in Banking & Finance, Insurance, Telecom and Healthcare domains.
• 6+ years of Lead in Technical & Functional Lead experience in Decision Support Systems - Data warehousing implementing ETL using Informatica Power Center 9x/ 8x /7x /5x.
• Expert in Dimensional Data Modeling, Star/Snowflake Schema, FACT & Dimensions tables, Modeling Approaches, OLAP, Logical & Physical data modeling using ERWIN and Oracle Designer.
• Solid understanding of ETL design principles and good practical knowledge of performing ETL Design Processes.
• Good Exposure in Master Data Management architectures and MDM Hub configurations - Data modeling & Data Mappings, (Landing, staging and Base Objects), Data validation, Match and Merge rules.
• Experience in Informatica TDM for data masking and Informatica Transformation data Studio and atomization using DVO.
• Exposure in Informatica data explorer/Data Quality for Data Validation.
• Good Exposure in Hadoop and Cluster Administrations.
• Experienced understanding business functionality, Data Analysis, Data Migration, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis, Impact Analysis.
• Extensively worked on Power Center Mapping/Mapplet Designer, Transformation developer Warehouse Designer, Workflow/worklet Manager, Repository Manager and Workflow Monitor
• Well acquainted with performance related issues and techniques to improve the performance and Applied Performance Techniques to optimize SQL and Informatica (sources, targets, mapping and sessions to overcome the bottlenecks while loading/reading/transforming data)
• TSQL, Used BTEQ scripts, M Load for DML, Fastload to load bulk data and TPUMP for parallel processing.
• Responsible for Defining and implementing strategy for Enterprise Level Data Integration, Business Intelligence, Enterprise Reference Data and Data Quality Solutions across all divisions.
• Good experience in preparing documentation like HLD, Application Understanding document and LLD documents.
• Experience in integration of variousdata sources like Oracle, SQLserver, Db2, Salesforce.com (SFDC), SAP data sources, COBOL files, XML files, CSV files andFlat files into staging area.
• Expert in Oracle SQL and PL/SQL and good in UNIX scripting.
• Gathered key skills in concepts like Data warehousing, Data Modelling, ETL and Reporting.
• Experience in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Basic understanding of TSO and ISPF for interacting data from Data sets.
• Adroit in providing effective resolution to customer queries; improving relationships with the client by anticipating their future requirements, thereby ensuring a positive experience
• Strong abilities in software testing including creation of test scripts / cases, execution of testing procedures, Preparing test data for Unit Testing, SIT, UAT, Regression Testing.
• Being project lead, delivered qualitative projects on time by maintaining good relationship with the customers and team members.
• Excellent communication and inter-personal skills, quick adaptability, learning capability and good programming skills.
• Exceptional user facing skills and client relationship skills, ability to perform independently as well as in team player, ability to meet tight deadlines and work under pressure.
• Exposure with Talend functionalities like modeling, drag-and-drop job design, re-usability, Built in -in connectors for array functionality, Robust ETL functionality such as string manipulations, management of slowly changing dimensions, and automatic lookup handling, without code generation, Big query made easy loading data from huge clusters, Extensible - offers support for HDFS, HBase, Hive, Pig, Sqoop, HCatalog, Oozie and BigQuery and can be easily extended to support newer emerging big data technologies.

TECHNICAL SKILLS

• Informatica
• Power Center
• Power Exchange
• IDQ
• MDM
• TDM
• Oracle
• SQL Server
• DB2 Teradata
• DB2
• Sybase.
• Business Objects
• OBIEE
• Cognos.
• Control-M & Erwin.

PROFESSIONAL EXPERIENCE

Confidential | Delaware

Sr ETL Developer/Architect

Responsibilities:

• Involved in gathering the requirement and preparing Functional, Technical and Mapping Specification documents and Test cases for developments and enhancements, Analyze impact on Enterprise DWH
• Responsible for End to End deliverables from Design, Development, Testing and deployment from lower version till production environment.
• Prepare Detail Estimates and Planning. Estimation for new ETL Design/Development after analyzing the changes
• Worked on the Informatica Analyst tool for profiling the data and perform validations.
• Developed Re-usable Transformations, User defined Functions, mapplets, Mapping parameters, Mapping Variables, workflow variable, re-usable sessions and worklet in our frame work.
• Used various transformations like B2B, Lookup, SQL, VSAM Normalizer, java, Joiner, Aggregator, Expression, Router, Update strategy, Sequence generator and XML Generator Transformations in the mappings.
• Loading data from various data sources and legacy systems into Teradata warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Prepared and standard definitions for the COBOL copy book and work on COBOL sources.
• Responsible for MDM activities like IDD, HM and Match & Merge setup. Experience in setting up fuzzy and exact match rules and tuning
• Involved in troubleshooting any failures in Siperian batch processes.
• Responsible for creation of Informatica MDM Mappings, Cleanse Functions and Cleanse List..
• Responsible for setting up new ORS, Systems, Users Profiles, Lookups and Base Objects for a new database.
• Responsible for Data masking, Test data generation and protecting sensitive data for Dev regions using Informatica TDM.
• Responsible of creating universe and dashboards.
• Explored Informatica PowerExchange to read data from mainframe by enabling it to parse formats like VSAM, IMS and IDMS.
• Involved in Incremental loads after applying complex logics to achieve business solutions.
• Identified the problem areas where cost can be reduced reducing the efforts using ETL Code accelerator for till stage area.
• Extensively worked in troubleshooting skills in resolving errors and to address performance issues for ETL/SQL.
• Created Pre and Post Session Scripts for checking file validations/existence/count/archiving/versioning/files.
• Provided excellent customer service to the internal functional team by pro-actively following up with the issues on hand (through detailed emails and by setting up short meetings)
• Bugs found during “integration, user acceptance and regression testing” were analyzed (root cause analysis) beyond their obvious reason to extrapolate various errors that can occur in future.
• Executing/Maintaining daily/monthly ETL jobs that process customer Data and entries from the origin till Data warehouse/Data Mart load.
• Resources utilization for projects/applications in line with their skills for project executions.
• Defect Creation, Defect Tracking and Root Cause Analysis of the defects

Confidential | NY

Sr ETL Developer/Architect

Responsibilities:

• Prepared and walkthrough Functional Requirements Document and to Detailed Design Documents.
• Involved in impact analysis with the new trends in the DWH.
• Presented and got signoff from the users to load new set of SFDC application data into integration designs.
• Developed Re-usable Transformations, User defined Functions, mapplets, Mapping parameters, Mapping Variables, re-usable sessions and worklet.
• Responsible for initiation-> implementation->review to determine impacts of project
• Used various transformations like Lookup, SQL, VSAM Normalizer, java, Joiner, Aggregator, Expression, Router, Update strategy, Sequence generator and XML Generator Transformations in the mappings.
• Involved in Incremental loads after applying complex logics to achieve business solutions.
• Identified the problem areas where cost can be reduced reducing the efforts using ETL Code accelerator for till stage area.
• Extensively worked in troubleshooting skills in resolving errors and to address performance issues for ETL/SQL.
• Utilize in-depth knowledge of functional and Technical experience in Data warehousing and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer
• Assessing the ETL sizing for multiple projects/applications and assigned the resources for project executions.
• Responsible for MDM activities like IDD, HM and Match & Merge setup. Experience in setting up fuzzy and exact match rules and tuning
• Involved in troubleshooting any failures in Siperian batch processes.
• Responsible for creation of Informatica MDM Mappings, Cleanse Functions and Cleanse List..
• Responsible for setting up new ORS, Systems, Users Profiles, Lookups and Base Objects for a new database.
• Prepared Test Strategy, Test Plan, Risk assessment, Test Conditions, Test Data Characteristics document.
• Creating Scenarios, Test Scripts, Test Data, Peer Reviews of Test Deliverables; providing testing solutions to various enterprises by understanding business & IT strategy and then by aligning to them
• Scheduled test documents review meeting with Business and technical teams
• Coordinated with Business Teams for planning & execution of UAT Phase and gathering the business test data needs
• Worked on code enhancements and reviewed the test cases and test documents provided by team.
• Attended requirements gathering meetings during analyze phase and Involved in developments, documentation, Testing.
• Created Design, Lineage Diagrams and Prepared test plan & cases to perform data validation for various tables and files.
• Involved in production support, enhancements, and data testing for SFDC applications.
• Worked in full and incremental loads.
• Identified strategy to perform data validation for large volume.

Confidential | San Jose, CA

Tech Lead/Sr ETL Developer

Responsibilities:

• Involved in data validation during database up-gradation, Informatica up-gradation and system changes.
• Responsible for UNIX scripts changes to implement new change requests.
• Involved in end to end development as part of new change request.
• Involved on performance tuning of mappings and SQL queries.
• Prepared Documentation for all objects from the EDW.
• Involved in creating efficient Oracle SQL queries and Loading data from various data sources Teradata using BTEQ.
• Responsible to build dashboards, reports and analytics-based solutions.
• Coordinating with the customers for design clarifications and closing them.
• Supported Production activities like job monitoring, enhancements and resolving the production failures.
• Giving few innovative solutions / suggestions for any design changes based on business requirements.
• Attending requirements gathering meetings during analyze phase
• Prepared Test Strategy, Test Plan, Risk assessment, Test Conditions, Test Data Characteristics document for Testing Phase
• Scheduled test documents review meeting with Business and technical teams
• Reviewed the code, standards, test cases and test documents provided.

Confidential | San Jose, CA

ETL Tech Lead/Sr ETL Developer

Responsibilities:

• Drafted project documents which includes Mapping document, hand book, Test Script.
• Identifying the Root cause analysis and following up with source team to get done test data.
• Testing the different scenarios in the respective databases.
• Analyzing the root cause for the issue occurred while testing scenarios
• Continuous monitoring the running jobs in the $ U and resolving the issues such as aborts.
• Raising defects in QC and incidents remedy tool and continuous follow-up for the same.
• Conducted connectivity calls with partner network team and Confidential network team
• Worked closely with other teams for setting up the configurations and network set-ups for allowing the new infrastructure links with Confidential network

Confidential

Sr ETL Developer/Tester

• Gathered functional/technical information from the client in the transition tenure.
• Involved business new request and completed on time.
• Involved in Production support.
• Involved in change requests incidents solutions.
• Daily check outs and daily manual runs across all the regions like Dev, Qa, DR.
• Expert knowledge in utilizing BI tools to build dashboards, reports and analytics-based solutions
• Involved in generating the no of XML files using XML schema definition.
• Attended requirements gathering meetings during analyze phase
• Prepared Test Strategy, Test Plan, Risk assessment, Test Conditions, Test Data Characteristics document for Testing Phase
• Scheduled test documents review meeting with Business and technical teams
• Working in a fast-paced, constantly changing environment with an ability to work under pressure and tight deadlines; multi-task and prioritize projects

Confidential, Chicago, Illinois

Sr ETL Developer/Tester

Responsibilities:

• Involved in creation of estimations of project deliveries and High-level design documents.
• Involved in identifying business requirements and deliver the solutions
• Involved in stage tables, slowly changing Dimensions and Fact loading mappings.
• Implemented near real time business run workflows.
• Extensively used static and dynamic persistent caches and named cashes across Project.
• Created full load and incremental load workflows.
• Involved in migration from dev-Qa and Qa - Prod Environments.
• Involved in Performance tuning Techniques and SQL Optimizations.
• Involved in Unit test case preparation.
• Provided support to the Qa team to resolve issues at QAT and UAT phase.
• Coordinate extensively with the on-site ETL lead for design, deployment and testing activities.
• Involved in creating version, deployment groups and user folders.

Confidential

ETL Developer

Responsibilities:

• Involved in developing mapping to populate data from various systems like flat files, oracle to the single data warehouse.
• Involved in parameter files generation for all the staging mapping using Informatica.
• Involved in slowly changing Dimensions and Fact loading mappings.
• Scheduled workflows and file related jobs using Control-M tool.
• Extensively worked with SQL and Normalizer transformations.
• Developed and implemented data verification and testing methods for the data warehouse to ensure data accuracy.
• Involved in the tuning the mappings to achieve performance.
• Performed Data Reconciliation.
• Gained knowledge using ER-win tool.
• Involved in Unit test case preparation, Unit Testing and system integration testing

Confidential

ETL Developer

Responsibilities:

• Involved in creating and Maintaining Informatica technical specifications for application.
• Extensively worked in Designer and workflow manager.
• Worked with flat files sources and Oracle source and involved in code reviews.
• Increase productivity for reporting from facts.
• Created Reusable Objects, mapplets and worklet, and used all type of task types

Confidential

ETL Developer/Support

Responsibilities:

• Involved in stage mappings, sessions and workflows.
• Done Unit testing and Deployment activities.
• Involved in refreshing materialized views by running script and tracking logs information.
• Prepared the Unit Test Cases and executed them for defects resolved.
• Involved in Administrations like creating users, assigning privileges and deployment groups for migration