We provide IT Staff Augmentation Services!

Etl Tester Resume

PROFESSIONAL SUMMARY:

  • 6+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing Solutions.
  • Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Knowledge in Full Life Cycle development of Data Warehousing.
  • Experience with dimensional modeling using star and snowflake schema.
  • Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
  • Strong with relational database design concepts and proficiency in SQL and PL/SQL.
  • Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data
  • Independently perform complex troubleshooting, root - cause analysis and solution development.
  • Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
  • Team player, Motivated, able to grasp things quickly with analytical and problem-solving skillsExcellent interpersonal and communication skills.

TECHNICAL SKILLS:

ETL tools: Informatica PowerCenter & ESP, IBM Cognos, Business Objects.

Databases: Oracle & SQL Server.

SQL Language: SQL & PL/SQL, Shell Script.

SDLC: Waterfall & Agile

Scheduling Tools: AUTOSYS & UNIX CRON.

Agile Tools: RTC.

Operating System: WINDOWS & UNIX.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Tester

Responsibilities:

  • Collaborate with Business Stakeholders define and understand the Business requirements and KPIs.
  • Perform the Data profiling on the Source and Target systems.
  • Prepare the Test Plan, Test cases documents.
  • Perform Manual testing/System Integration testing/Regression Testing/Functional Testing/Performance testing and capture the test results.
  • Create Test cases which ensure that the required Business transformations and loading the data as specified in the requirement/mapping documents.
  • Prepare the test data and test according to the requirements.
  • Execute the test cases, Raise/track the defects and provide the sign-off.
  • Collaborate and work with business analysts and data analysts to support their data warehousing and data analysis needs.
  • Perform the Business Testing checkouts on the Dev, UAT and Production region.
  • Clarify the requirement in the Backlog refinement sessions.
  • Actively participate in the Standup, Backlog refinements, Iteration Planning, Demo and Retro agile sessions.
  • Provide the Story Demo to Business Stakeholders and obtain their approval.
  • Support the Production Business Testing Checkouts and deployment.
  • Review team members test cases and results.

Technical Environment: Enterprise servicing Platform (ESP), Oracle 11g, Interactive Views (IV), RTC & Squirrel.

Confidential

ETL Developer/ Tester

Responsibilities:

  • Responsible for Business Analysis and Requirements Collection.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Parsed high-level design specification to simple ETL coding and mapping standards.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Developed mapping documents to outline data flow from sources to targets.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Created mapplets to use them in different mappings.
  • Developed mappings to load into staging tables and then to Dimensions and Facts.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Modified existing mappings for enhancements of new business requirements.
  • Wrote UNIX shell Scripts to automate the ETL process.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.
  • Collaborate with Business Stakeholders define and understand the Business requirements and KPIs.
  • Perform the Data profiling on the Source and Target systems.
  • Prepare the Test Plan, Test cases documents.
  • Perform Manual testing/System Integration testing/Regression Testing/Functional Testing/Performance testing and capture the test results.

Technical Environment: Informatica PowerCenter 9.6.x, Oracle 11g, OBIEE, Tableau, RTC & UNIX.

Confidential

ETL Developer

Responsibilities:

  • Involved in Business Users Meetings to understand their requirements.
  • Translate Business requirements into High level design/Low level Design documents.
  • Prepare the ETL Design and Source to Target mapping.
  • Designed, Developed Source Extraction, Transformation and Load mapping/Workflow.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
  • Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
  • Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
  • Define the Dependency and automate the ETL process through AUTOSYS.
  • Responsible to optimize the ETL/DB objects and fix the ETL, Reporting performance issues.
  • Prepare the Test cases and Performed unit testing, integration testing and system testing.
  • Responsible to deploy the code in the higher Environment with minimal impact to Business.
  • Independently performed the complex troubleshooting, root-cause analysis and fixed many issues.
  • Involved in enhancements and maintenance activities of the data warehouse including tuning, enhancement of existing code.
  • Created various recon reports for reconcile the data between source to target.
  • Maintain the Project Delivery and Issue logs up to date.
  • Participated in weekly status meetings and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Technical Environment: Informatica Power center 8x, Oracle, Cognos, SQL, TOAD, AUTOSYS & UNIX.

Hire Now