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.