We provide IT Staff Augmentation Services!

Etl Consultant Resume

Columbus, OH

SUMMARY:

  • Over 7 years of experience as an ETL consultant in Business Analysis, Design, Development and Production Support using industry accepted methodologies and procedures.
  • Highly motivated and goal - oriented individual with a strong background in SDLC Confidential Management and Resource Planning using AGILE methodologies.
  • 5 Years of experience in Health Care domain, 2 years of experience in Insurance domain
  • Experience in creating mappings, mapplets, reusable transformations, Sessions, Worklets and workflows using Designer, workflow manager, workflow monitor Using Informatica Power Center.
  • Extensive experience in Data Loading, Analysis, Design by using Various Technologies like Informatica Power Center 8.6, 9.x, 10.1 and Oracle, Teradata 15.0, DB2 in Data Warehousing, ensuring the deliverables within the time & cost parameters.
  • Developing ETL processes like Data Extraction, Transformations, and Loading using Informatica Power Center 8.6 & 9.x versions Designer, Workflow Manager and Workflow Monitor tools.
  • Strong hands on experience using Teradata utilities (SQL, Fast Load and MultiLoad), Teradata parallel support and Unix Shell scripting.
  • Experience in SQL, PLSQL queries and stored procedures. Having good experience in writing UNIX/Linux scripts.
  • Involved in various testing like unit testing and Responsible for performance Tuning and Error Handling of Informatica mapping.
  • Experienced in Teradata Parallel Transporter (TPT). Worked with different Teradata load operators.
  • Designing and developing Informatica mappings including slowly changing dimensions type 1 and 2.
  • Experienced in using advanced concepts of Informatica like push down optimization (PDO).
  • Experience in Informatica mapping specification documentation, tuning mappings to increase performance.
  • Experience in creating logical/physical Data Modelling in ERStudio. Hands on experience in creating Macros in ERStudio. Experience in HP Quality Center for logging defects and tracking defects.
  • Experience in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements, also good work experience in SQL, PL/SQL, UNIX
  • Experience in designing and implementing relational database model as per business needs.
  • Expertise in leading the policy migration and downstream Integration of Guidewire PolicyCenter and ClaimCenter projects to the legacy systems for multiple rollouts
  • Good knowledge of Transact-SQL (DDL, DML). Experience in Teradata utilities Fastload, Multiload, Fastexport
  • Knowledge in creating complex Bteq scripts. Experience in calling TPT connections inside Informatica mappings
  • Leadership quality in managing offshore and onsite people
  • Experience in Agile and Waterfall Confidential life cycle, experience in running daily stand ups
  • Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets.
  • Applied statistical methods and tools to solve business-related problems. Analyzing complex issues and distilling information down to key points and recommendations.

TECHNICAL SKILLS:

  • Informatica PowerCenter 10.1
  • HP Quality Center
  • Teradata 15.0, Oracle 10g, DB2
  • Toad 9.6, PLSQL
  • Guidewire PolicyCenter
  • ServiceNow/IT2B
  • ERStudio Data Modelling
  • Harvest, BuildForge
  • Unix Shell Scripting
  • ESP, CA7 Scheduler
  • Agile, Waterfall
  • Production Support
  • Onshore: Offshore Model
  • ETL Testing
PROFESSIONAL EXPERIENCE:

Confidential - Columbus, OH

Responsibilities:

  • Lead the offshore team and coordinated its activities with the onshore team.
  • Involved right from the analysis of requirements, converting the functional description to the technical workflow design, realization of the design into Teradata-Informatica mappings, code review and test cases review, coordinating with the onsite team, oversee the testing of the entire workflow including support once the production installation has been done
  • Design Data Architecture and Dimensional Data Modeling for new projects. Designed, developed, and tested the components using Informatica PowerCenter 9.6 all the way through Informatica PowerCenter 10.1
  • Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
  • Created Conceptual, Logical & Physical models, used ERStudio & VISIO for Dimensional Data Modeling.
  • Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
  • Demonstrated expertise utilizing ETL tools and Informatica ETL package design in RDBMS systems like Oracle, Sybase, Teradata etc.
  • Extracted data using BTEQ scripting which includes Fast Export and Multi Load utilities. Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
  • Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
  • Involved in the development of Informatica mappings and also performed tuning for better performance.
  • Setting up sessions to schedule the loads at required frequency using Power Center, Workflow manager, PMCMD and also using scheduling tools
  • Created Unit Test Cases for the ETL Informatica mapping validation
  • Performed extraction, transformation and loading of data from different sources like XML, FlatFiles, DB2 and Teradata in accordance with requirements and specifications.
  • Created complex Informatica mappings using Unconnected Lookup, Joiner, Rank, Source Qualifier, Sorter, Aggregator, dynamic Lookup and Router transformations to extract, transform and loaded data to ODS.
  • Implemented slowly changing dimensions (SCD) to maintain history data as per user requirement.
  • Handling of Error and its logging- Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, and used Informatica debugger to identify issues in mapping execution.
  • Involved in system testing, performance and System Integration testing stages of the project.
  • Ensuring the developed code as per the coding standard.
  • Had additional responsibility in ensuring quality, technical guidance, code review.
  • Importing Teradata source tables through informatica and loading Teradata targets through informatica
  • Verifying the source and target table DDLs are matching as per the mapping document and making necessary DDL change based on the requirements.
  • Checking the Indexes (PRIMARY, UNIQUE, SECONDARY) and properties (SET, MULTISET) of the table.
  • Mocking up source table data to test all the logics which was implemented through informatica coding.
  • Creating Source qualifier query and Lookup override queries based on the requirements.
  • Create staging tables and loading staging before data moves into target. Perform pre-post SQL to move data from stage to target.
  • Monitoring in Teradata View Point for skew while code is running. Checking Stats were collected for all the tables and index columns were used in the joins
  • Checking informatica load id has grant access to perform DDL/DML operations into Teradata tables. Handling the Error tables and UV tables in case of failures
  • Importing Oracle source tables through informatica and loading Oracle targets through informatica
  • Creating Source qualifier query and Lookup override queries based on the requirements.
  • Creating Oracle connection strings and give grant access to load oracle tables via informatica. Mocking up source table data to test all the logics which was implemented through informatica coding.
  • Post validation- taking backup of production tables to recover data in case of failures.
  • Calling Code tables through stored procedures. Daily status reporting to various stack holders of the project.
  • Had additional responsibility in ensuring quality, technical guidance, and code review. Ensuring the developed code as per the coding standard.
  • Involved with Clients in requirement gathering. Took additional responsibility in delivering on time. Often conducting daily scrum meetings while working for Agile Confidential cycle. Experience in lead role- managing people over offshore and onsite.

Technical Tools Used: Windows7, Informatica PowerCenter 10.1, Teradata 15.0, Oracle 10g, Toad 9.6, Putty, WinSCP, Harvest, ESP scheduler, Power Designer, Service Now.

Confidential- Eagan MN

Responsibilities:

  • Development and unit test of ETL mappings using Informatica PowerCenter, Informatica PowerExchange as per the Business Requirements.
  • Worked on Fast load and Multiload Teradata utilities to load staging data. Raising clarification and following it to closure.
  • Created Technical Design and UTC for the ETL Informatica mapping validation. Involved in Implementation, reviews and Unit Testing.
  • Responsible for debugging and performance tuning of targets, sources, mappings and sessions.
  • Optimized the mappings and implementing the complex business rules by creating re-usable transformations and Mapplets.
  • Involved in writing BTEQ, MLOAD and FLOAD scripts to load the data into Teradata tables.
  • Optimized the source queries to control the temporary space and added delay intervals depending upon the business requirement for performance
  • Used Informatica workflow manager for creating, running the Batches and Sessions and scheduling them to run at specified time.
  • Executed sessions, sequential and concurrent batches for proper execution of mappings and set up email delivery after execution.
  • Preparing Functional Specifications, System Architecture/Design, Implementation Strategy, Test Plan & Test Cases.
  • Implemented and documented all the best practices used for the data warehouse.
  • Handling of Error and its logging. Interaction with QA and BA team to resolve the issues. Have done ETL testing by loading the source data into temp tables through SQLs by preparing complex queries. Will log the defects into HP Quality Center and will track the existing defect’s status through QC.
  • Analysis of Specification document and mapping document. Raising clarification and following it to closure.
  • Created Technical Design and UTC for the ETL Informatica mapping validation. Involved in Implementation, reviews and Unit Testing.
  • Handling of Error and its logging. Imported source/target file data directly into Teradata tables through Fastload and Multiloads and used it for unit testing.
  • Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
  • Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
  • Worked on SQL tools like TOAD and SQL Developer to run SQL Queries and validate the data.
  • Scheduled Informatica Jobs through Autosys scheduling tool.
  • Checking the performance of the Source Qualifier Query through explain
  • Interaction with QA and BA team to resolve the issues. Weekly status reporting to various stack holders of the project.
  • Had additional responsibility in ensuring quality, technical guidance, and code review. Ensuring the developed code as per the coding standard.
  • Involved with Clients in requirement gathering. Assigned work to offshore team on daily basis and made sure that the Confidential is delivered on time.
  • Took additional responsibility in delivering on time. Experience in lead role- managing people over offshore and onsite

Technical Tools Used: Informatica PowerCenter 9.5, Informatica Power Exchange 9.6.5, SQL Server 2008, Windows7, Oracle 10g, PL/SQL, ClearCase, TOAD, Putty, Build Forge, UNIX, Teradata 14, Erwin 7.5, ESP, WinSCP, IT2B, Service Now

Confidential - Eagan MN

Responsibilities:

  • Created Technical Design and UTC for the ETL Informatica mapping & Wherescape validation.
  • Involved in Implementation, reviews and Unit Testing.
  • Handling of Error and its logging.
  • Interaction with QA and BA team to resolve the issues.
  • Had additional responsibility in ensuring quality, technical guidance, code review.
  • Ensuring the developed code as per the coding standard.
  • Assigned work to offshore team on daily basis and made sure that the Confidential is delivered on time.
  • Took additional responsibility in delivering on time.
  • Designed the jobs with so many dependencies without any issues.
  • Involved in setting up the MoveIt process and job schedule.
  • Involved in post-production support and resolving the incident during this phase.

Environment: Operating System: Windows 7, Tools: Informatica 9.5 and PowerDesigner, Databases: Teradata, Automation Tool: CA7.

Confidential - Eagan MN

Responsibilities:

  • Involved in analyzing the existing process for product specific and design for enhancements.
  • Analysis of Specification document and mapping document.
  • Raising clarification and following it to closure.
  • Created Technical Design and UTC for the Informatica code.
  • Involved in Implementation, reviews and Unit Testing.
  • Handling of Error and its logging.
  • Weekly status reporting to various stack holders of the project.
  • Had additional responsibility in ensuring quality, technical guidance, code review.
  • Ensuring the developed code as per the coding standard.
  • Involved in post-production support and resolving the incident during this phase.
  • Ensuring the developed code as per the coding standard.
  • Automated the code by running the code based upon the line of business.
  • Automated the process of the running the Packages using automation tool and the powershell script to invoke the jobs.
  • Involved in post-production support and resolving the incident during this phase.

Environment: Operating System: Windows 7, Tools: Informatica 9.5, Databases: Teradata, Automation Tool: CA7.

Confidential

Responsibilities:

  • Designed, developed and tested the components using Informatica 9.1/Informatica 9.5 on Teradata Database.
  • Validating the XML files using the Altova XMLspy.
  • Modelling the tables according to the XML files with the necessary surrogate keys to join them using PowerDesigner.
  • Designed and developed standards for the Informatica development team.
  • Involved in analysis of the defects and ensured the defects are fixed with expected results.
  • Involved in creation and testing of all the mappings in the datawarehouse.
  • Extensively used informatica client tools-Designer, Workflow Manager and Workflow Monitor.
  • Involved in preparation of unit test case and captured Unit test Results.
  • Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
  • Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc.
  • Tested the Workflow and involved in writing SQL Queries for ETL Validating the data transformed, Ensured that all expected data is loaded.
  • Worked with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
  • 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.
  • Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
  • 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.
  • Creating tasks, sessions, events, timers etc in the workflow manager and monitoring them in the workflow monitor.
  • Involved in system testing, performance and System Integration testing stages of the project.

Environment: Operating System: Windows 7, Tools: Informatica 9.1/Informatica 9.5, Altova XMLspy, Databases: Teradata.

Confidential

Responsibilities:

  • Designed, developed, and tested the components using Informatica 9.1/Informatica 9.5 on Teradata database.
  • Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager.
  • Involved in the analysis of source to target mapping provided by data analysts.
  • Created complex Informatica mappings using Unconnected Lookup, Joiner, Rank, Source Qualifier, Sorter, Aggregator, dynamic Lookup and Router transformations to extract, transform and loaded data to ODS.
  • Created integrated workflow per subject area keeping the dependency within the subject area.
  • Wrote Unit Test cases and executed test scripts successfully.
  • Involved in performance tuning of Informatica code using standard Informatica tuning steps.
  • Involved in code Reviews as per ETL/Informatica standards and best practices.
  • Generated 12 Reports related to Medical Claims, Pharmacy, Member, Provider and Revenue Claims etc.

Environment: Operating System: Windows 7, Tools: Informatica 9.1/Informatica 9.5, Databases: Teradata, Scheduler: CA7.

Hire Now