EXPERIENCE SUMMARY:

• Over 7 years of experience in IT industry with expertise in experience in ETL processes
• Ensuring process compliance and process improvements in teh projects
• Meeting with teh customer, gather Business Requirements and document these requirements in teh form of functional requirements specification and technical requirement specification
• Captured business requirements through a range of analysis techniques (data flow diagrams, gap analysis, work & process flow diagrams)
• Expertise in documenting BRD, FRD and use cases in compliance with teh industry standard formats.
• Meeting user and gathering requirements in teh form of mapping changes, managing entire project s subversion (SVN) and share point sites etc.
• Obtaining agreement on business analysis deliverables and ensuring dat they meet all teh requirements of teh business users and tracking these across multiple teams.
• Good amount of experience in writing complex PL/SQL queries including joins.
• Experience in working on Product backlog review, sprint backlog
• Good experience in Process management and KPI
• Understanding of data lineage methods and techniques
• Good experience in working on PII data and data masking transformation in Informatica.
• Preparing test plans and test cases to ensure TEMPeffective quality assurance testing and a fully functional application
• Preparing test summary reports
• Good experience in all phases of Software Development Lifecycle (SDLC) such as development, testing, migrating and production support
• Experience on working with Business Intelligence
• Remarkable experience in designing ETL processes and developing source to target mappings
• Proven experience in utilizing databases like Teradata, SQL
• Analyzing requirements and providing work effort estimates
• Creating design specification and operational documents
• Developing test cases and planning to complete unit testing
• Expertise in deriving Test Scenarios and Documenting Test Cases in ALM
• Exhaustive experience in SDLC, specialization in design and development of ETL solutions
• Supporting production and maintain applications
• Expertise in developing, testing and deploying ETL solutions
• Good amount of experience working in Data Masking projects performing Data masking through Informatica
• Profound noledge about Data Masking transformation in Informatica and Data Masking in general
• Designing and developing various complex mappings to move data from multiple sources into common target area such as Data Marts and Data Warehouses using Lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator and Update Strategy from varied transformation logics in Informatica
• Performing Unit Testing/ SIT Testing and prepared testing documents are per teh Client requirement
• Strong experience in Enterprise Data Warehouse environment with Informatica and Teradata combination and extensive work with Slowly Changing Dimensions (SCD)
• Expertise in developing user guides, manuals, checklists, guidelines and other documents for teh end users
• Good exposure in writing client deliverables such as User Manuals and SDLC documents
• Designed and prepared Project Profiles and Project Plans for projects related to different domains
• Certified in Integrated Project Management Systems (IPMS) for Project Leaders
• Trained in integrated Quality Management Systems (IQMS)
• Company internal in Hadoop

TECHNICAL SKILLS:

ETL Tools: Informatica 9.6.1/9.5.1, Maven

Programs: MS Word, PowerPoint, Excel

Database: Teradata 14/13/12

Reporting Tools: Business Objects, HP ALM, Control - M, Unix, Selenium

Languages: PL/SQL, SQL, Java/J2EE

Operating System: Windows

PROFESSIONAL EXPERIENCE:

ETL TESTER

Confidential

Responsibilities:

• Teh daily activities involve regular meetings with teh CVS personnel to gather requirements, review designs, discuss and dissolve technical issues and change requests.
• Obtaining agreement on business analysis deliverables and ensuring dat they meet all teh requirements of teh business users and tracking these across multiple teams.
• Understand requirements from functional requirement documents to prepare test plans and test cases for various life cycles of testing.
• Perform Functional, Smoke, Integration, System, Back - end and User Acceptance testing.
• Prepare architecture and functional requirement documents.
• Write technical design document and unit test plan so as to ensure proper testing.
• Prepare test plans and test cases to ensure TEMPeffective quality assurance testing and a fully functional application.
• Generating Test scripts using any Automation Tool like LoadRunner or RPT
• Deriving Test Scenarios and Documenting Test Cases in ALM.
• Involved in preparing regression test cases and application landscape.
• Manage multiple projects and schedule teh timeline for testing process.
• Write complex PL/SQL testing queries for User Acceptance Testing.
• Involvement in Selenium Environment setup for Test Automation
• Provide support to various testing groups on test data setup for new functionality, existing functionality and triaging test environment issues in various phases of testing (System, Integration, User Acceptance)
• Delivering projects with complexity at scale, meeting business goals and objectives working with cross- functional teams using technologies Java/J2EE.
• Propose adoption of new fast track models of SDLC like Structured Iterative, Agile, Extreme Programming
• Grouping Test cases and generating detailed Test reports using TestNG
• Follow-up with customers on satisfaction of analysis, if a defect is raised tan follow it till teh closure of teh defect and ensure proper route for it close, monitor or slotting for future release.
• Prepare and share Daily & Weekly status report with Client personnel.

Confidential

System Engineer

Responsibilities:

• Highly skilled in analyzing business requirements and converting business requirements into code
• Extensive noledge of creating Business requirement and Technical documents
• Seasoned in all phases of Software Development Lifecycle (SDLC) such as development, testing, migrating, administrating and production support
• Preparing test plans and test cases to ensure TEMPeffective quality assurance testing and a fully functional application
• Performing application testing as well as front end testing
• Preparing test summary report
• Defect Reporting using Test Management Tool ALM
• Imported various Application sources, created Targets and Transformations using Informatica PowerCenter
• 9.6.1. Designer (Source Analyzer, Transformation Developer, Mapplet Designer and Mapping Designer).
• Developed masking routines using Informatica mappings using different masking rules and Data Masking transformation
• Developed various complex mapping using multiple sources and targets in different databases, flat files and loading them into Teradata
• Formatting and Technical Review of all teh Client Deliverables in order to ensure dat teh quality of teh documents is not compromised
• Strictly adhering to teh Client provided templates (if any), else preparing and providing templates to teh projects in order to ensure consistency in formatting and writing styles
• Face to face discussions with various Project Owners and team members about teh quality of teh documents prepared by teh corresponding team members. Causal Analysis was carried out particularly for teh teams dat received a low Customer Satisfaction Index (CSI) in terms of documentation.
• Regular connects with Project Owners in order to gather requirements for sessions on developing certain documents
• Conducted soft skills sessions on TEMPEffective Email Writing, TEMPEffective Technical Writing, TEMPEffective Client Communication and other similar topics dat ca help teh team members improve their verbal and written communication skills
• Ensuring timely feedback from teh Client as well as Project Owners upon teh improvements made and working upon it
• Demonstration of strong communication and analytical skills during teh project in order to ensure on time and successful project delivery
• Worked both individually and collaboratively, usually under no supervision
• Proven experience under changing environments with changing priorities and under alarming deadlines
• Received Best Faculty for conducting Client Communication for teh team members; recognized for making teh soft skills sessions interactive and learning at teh same time

ETL Lead

Confidential

Responsibilities:

• Ensuring process compliance and process improvements
• Supporting customer audits and interfacing with customer at all levels as per teh requirement
• Creation and maintenance of project Documents and other metrics
• Clarifying/raising queries for technical questions from teh team
• Planning technical s to teh new members in teh project
• Working closely with Development and Design team in order to understand Business Requirements
• Documented Business Requirements and assessed changes required to existing processes and procedures
• Performed Debugger testing and Unit testing for Informatica mappings
• Wrote Teradata queries to unit test Data Masking applications
• Carrying out data masking activities by triggering jobs in Informatica and monitoring these jobs
• Analyzing teh job failure issues and reporting to teh onsite team
• Identifying and analyzing teh issue if a particular workflow failed and looking for teh possible workarounds
• Suggesting solutions for teh failed jobs to teh onsite team and working with them for troubleshooting
• Preparing several documents like Performance Data sheet for teh jobs triggered reporting their status (succeeded/ failed) and other statistics related to teh onsite team
• Maintaining several documents related to PMR and audit of teh project
• Developing Project Profile for teh project
• Setting up meetings with onsite team to understand Client expectations
• Defect Reporting using Test Management Tool, Quality Center
• Perform functional testing, system testing, system integration testing, smoke testing, regression testing and user acceptance testing.
• Coordinating with project management to provide testing status and convey risk on time if any
• Responsible to log defects, track defects till closer in Quality Center and Team Track.
• Responsible to provide Daily Status Report and Weekly Status Report to project management
• Analyzing Unit Test results and Plan for testing accordingly
• Responsible to conduct Unit Test Exit/IT Entrance and IT Exit/ST Entrance meeting to present Integration (IT) and System Testing (ST) Plan
• Collaborated with QA team in building Master Project Plan and End - to-End scenarios

ETL Tester

Confidential

Responsibilities:

• Working closely with Development and Design team in order to understand Business Requirements and gather these requirements in teh form of BRD and create mapping document.
• Documented Business Requirements and assessed changes required to existing processes and procedures
• Preparing mapping documents on teh basis of any changes in mappings as suggested by Client
• Good understanding on applying rules of Data Masking transformation using Informatica PowerCenter and loading teh data into targets
• Worked on various sources like Flat Files, Teradata and SQL Server
• Worked on complex transformations like Data Masking Transformation, Lookup Transformation, and Expression Transformation etc.
• Responsible for capturing Unit and Integrated test results
• Responsible for updating QC with proper update for teh raised ticket
• Created programs, study guides and user manuals for new team members for easy understanding of teh projects
• Maintained materials and update documents after each release
• Planned, wrote and edited operational and instructional manuals for various applications
• Documented engineering processes and specifications for software development lifecycle and releases
• Prepared reports on testing metrics, such as test plan, test case execution, defects status and statistic.
• Escalate issues, risk and impacts and provide a mitigation plan for testing strategy, quality, timeline, scope and/or resources.
• Performed black - box testing, functional testing, integration testing, GUI testing, system testing, performance testing, smoke testing, and regression testing
• Involved extensively in User Acceptance Testing (UAT) to ensure application meets teh business users expectation and managed teh defect tracking lifecycle - tracking, managing, and solving all defects

ETL Tester

Confidential

Responsibilities:

• Attended requirement gathering sessions to understand customer needs and prepared workflow diagram for teh technical team understanding.
• Documented Business Requirements and assessed changes required to existing processes and procedures
• Translated Business Requirements into Data Warehouse design
• Good understanding on applying rules of Data Masking transformation using Informatica PowerCenter and loading teh data into targets
• Worked on various sources like Flat Files, Teradata and SQL Server
• Worked on complex transformations like Data Masking Transformation, Lookup Transformation, and Expression Transformation etc.
• Responsible for capturing Unit and Integrated test results
• Responsible for updating QC with proper update for teh raised ticket
• Created reusable transformations, mapplets, worklets using Transformation Developer, Mapplet Designer and Worklet Designer
• Handled Post - production issues and delivered all assignments/ projects within specified timelines
• Maintaining several documents related to PMR and audit of teh project
• Developing Project Profile and Project Plan for teh project
• Organized, edited and maintained technical records and files according to set standards for order, clarity, conciseness, style and terminology
• Deliver TEMPeffective and efficient testing solutions by meeting key project milestones and overall project deliverable n time, and adhering to development and quality standards.

Production Support Executive

Confidential

Responsibilities:

• Working closely with Development and Design teams to understand Business Requirements
• Performed major role in designing and masking teh data
• Imported various Application sources, created Targets and Transformations using Informatica PowerCenter
• 9.6.1. Designer (Source Analyzer, Transformation Developer, Mapplet Designer and Mapping Designer).
• Developed masking routines using Informatica mappings using different masking rules and Data Masking transformation
• Created mappings, sessions, workflows and worklets in informatica
• Used Expression, Connected/Unconnected Lookup, Router and Data Masking transformations to create mappings
• Performed Debugger testing and Unit testing for Informatica mappings
• Developed and scheduled Workflows using Task Developer, Worklet Designer and Workflow Designer in Workflow Manager and monitored teh workflows in Workflow Monitor
• Wrote Teradata queries to unit test Data Masking applications
• Carrying out data masking activities by triggering jobs in Informatica and monitoring these jobs
• Analyzing teh job failure issues and reporting to teh onsite team
• Identifying and analyzing teh issue if a particular workflow failed and looking for teh possible workarounds
• Suggesting solutions for teh failed jobs to teh onsite team and working with them for troubleshooting
• Preparing several documents like Performance Data sheet for teh jobs triggered reporting their status (succeeded/ failed) and other statistics related to teh onsite team
• Maintaining several documents related to PMR and audit of teh project
• Developing Project Profile for teh project
• Setting up meetings with onsite team to understand Client expectations
• Defect Reporting using Test Management Tool, Quality Center