SUMMARY

• Around 7 Years of diverse experience in Agile as a Data Warehouse professional in Analysis, Design, and Implementation of Business Applications specialized in production support and ETL Testing.
• Worked closely with business to gather the requirements and perform business operations
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation,
• +and maintenance with timely delivery against aggressive deadlines.
• Extensively worked on ETL tools Informatica and created mappings, validated mappings and source and target tables.
• Analyze the production tickets/defects and document them, monitoring the informatica jobs and resolve any job failures.
• Have used Application life cycle (ALM) tool for Test management.
• Identified critical defects during data refresh and Data loads in Prod and Test environments.
• Created test cases in ALM and executed them, Able to generate test summary reports for signoff, performing statistical analysis using various tools.
• Validated CSV files, Flat files, Data extracts from source and target systems
• Performed data validation of source and target tables with SQL queries.
• Strong skills in Informatica Power center 8x/9x/10x (Designer, workflow manager, workflow monitor, Repository Manager, Informatica Developer and Admin Console)
• Expertise in creating, validating, testing, running, and scheduling sequential, and concurrent sessions using Workflow Manager
• Proficiency on all the Transformations like Lookup, Aggregator, Expression, Filter, Sequence Generator, Sorter, Rank, SQL, TCL, and Router transformations.
• Extensive experience in monitoring and troubleshooting production failures involving environmental issues.
• Analyzed session log files in case the session failed to resolve errors in mapping or session configurations
• Experience in implementing Incremental Loading Strategy using Mapping parameter
• Good noledge of data warehouse architecture, concepts, technologies, dimensional Star Schema, and Snowflakes Schema methodologies
• Good in using Debugger wizard to identify bottlenecks in mapping.
• Strong exposure to Database concepts and experience in Oracle11g/10g, DB visualizer
• Proficiency in PL/SQL and creation/modification of database objects like Synonyms, Group Functions, Single Row Functions, Views, Index, Set Operators.
• Exposure to Creation/modification of database objects like Tables, Packages, Procedures, Functions, views, Sequences.
• Experienced in writing SQL Queries for backend testing to validate Data integrity and consistency, identify data mismatch.
• Good Interpersonal skills, commitment, result oriented, hard working with quest and zeal to learn new technologies and undertake challenging tasks.
• Excellent client interaction and presentation skills and proven experience working independently and, in a team.
• Extensive Hands - on with informatica tool, experience in dataware house analysis by writing complex SQL queries to validate the source and target data loads.
• Translated business requirements into Technical Design Document having high level of ETL data flow with Source to Target mappings.
• Perform XML validations, flat file validations, CSV validations.
• Validated the accuracy of data while transforming, and Loading data from source to target using BTEQ, Fast Load, and Multiload Teradata utilities.
• Updated and maintained existing test Matrix and test cases based on code changes and enhancements.
• Hands on experience on various data quality transformations for data cleansing.
• Performed various testing activities like Unit Testing, Integration- System Testing, Regression, Performance and User Acceptance Testing.
• Looking for ETL Support analyst, Testing roles, across USA clients.
• Have completed and practiced Agile over 2 years.

TECHNICAL SKILLS

Test Management tools: Like JIRA, Hp ALM

Microsoft Azure tools: VSTS, Microsoft Azur

Testing Tools: Hp ALM life cycle management, JIRA

PROFESSIONAL EXPERIENCE

Confidential, AZ

ETL Tester

Responsibilities:

• Have performed Requirement analysis, technical process flow design diagrams in VISIO, creating more efficient data structures, data mapping for the project team according to the business requirements.
• Take ownership on gathering requirements and conceptualize various best possible design options along with testing
• Validated Ingenium, CDS, DCLM, LF70 GENACT Files For (Business Partner, Contract, TR FPG, TR FSCD) Daily files with file layout and compared to CST files.
• Used Power Query Editor for conversion files
• Used Unix to run the jobs
• Provide technical expertise and peer code reviews to other team members
• Worked on fulfillment of data warehouse project tasks including Data Extraction, Cleansing, Transforming and Loading.
• Created new Data mappings and updated old mappings according to changes in business logic.
• Working with transformations like lookup, Aggregator, Router, Expression and Joiner using Informatica
• Perform XML file validations, Flat file validations to identify any issues.
• Analyze the informatica all mappings according to the design document and mapping
• Involved in designing the mapping with multiple files loading using file repository
• Optimizing the mappings, sessions, and workflows to improve the load performance
• Involved in all phases of the software development life cycle.
• Coordination with dependent components across different vendors for the successful end to end delivery of the project.
• Assist in Quality Assurance process and customer issue resolution.

Environment: Unix, Shell scripting, Informatica, SQL

Confidential, VA

ETL Tester

Responsibilities:

• Help in creating more efficient data structures for the project team with a profile area dat releases higher quality code.
• Take ownership on gathering requirements and conceptualize various best possible design options along with testing
• Provide technical expertise and peer code reviews to other team members
• Worked on fulfillment of data warehouse project tasks including Data Extraction, Cleansing, Transforming and Loading.
• Created new mappings and updated old mappings according to changes in business logic.
• Working with transformations like lookup, Aggregator, Router, Expression and Joiner using Informatica
• Develop all mappings according to the design document and mapping
• Involved in designing the mapping with multiple files loading using file repository
• Optimizing the mappings, sessions, and workflows to improve the load performance
• Involved in all phases of the software development life cycle.
• Coordination with dependent components across different vendors for the successful end to end delivery of the project.
• Assist in Quality Assurance process and customer issue resolution

Environment: DB visualizer, Informatica, SQL, Excel, File comparison tools

Confidential

ETL Tester & support

Responsibilities:

• Help in creating a more efficient development team with a profile area dat releases higher quality code.
• Take ownership on gathering requirements and conceptualizing various best possible design options along with testing
• Provide technical expertise and peer code reviews to other team members
• Worked on fulfillment of data warehouse project tasks including Data Extraction, Cleansing, Transforming and Loading.
• Worked on Informatica parallel and serial flow batch mappings and commonly used components.
• Involved in all phases of the software development life cycle.
• Coordination with dependent components across different vendors for the successful end to end delivery of the project.
• Developed PL/SQL packages, procedures, triggers, functions, IndexesandCollections to implement business logic. Generated server-sidePL/SQL scriptsfordata manipulationand validation and materialized views for remote instances.
• Assist in Quality Assurance process and customer issue resolution
• Coordinate with the team.

Environment: Unix, Shell scripting, Informatica, SQL

Confidential

ETL Support Engineer

Responsibilities:

• Worked on fulfillment of data warehouse project tasks including Data Extraction, Cleansing, Transforming and Loading.
• Worked on Informatica mappings and commonly used components.
• Involved in all phases of the software development life cycle.
• Coordination with dependent components across different vendors for the successful end to end delivery of the project.
• Developed PL/SQL packages, procedures, triggers, functions, IndexesandCollections to implement business logic. Generated server-sidePL/SQL scriptsfordata manipulationand validation and materialized views for remote instances.
• Code Walk Through, Review and Testing
• Coordinate with the team.

Environment: Unix, Shell scripting, Informatica, SQL, PL/SQL.

Confidential

ETL Testing Analyst

Responsibilities:

• Participated in requirement gathering meetings with business stakeholders and documented detailed feature requirements.
• Translated business requirements into Technical Design Document having high level of ETL data flow with Source to Target mappings.
• Developed ETL data pipelines using Informatica PowerCenter client tools - PowerCenter designer, workflow manager, repository manager, workflow monitor.
• Proactively optimized performance of many existing mappings using partitioning, pushdown optimization, and incremental aggregation.
• Responsible for Extracting, Transforming, and Loading data from source to target using BTEQ, Fast Load, and Multiload Teradata utilities.
• Wrote complex and tuned SQL queries for data analysis and data validation.
• Delivered quality solutions by performing unit tests, system integration tests, user acceptance tests.
• Worked on production job failures, defects, new features, and enhancement requests.
• Followed agile methodology and used JIRA tool to plan, track and manage progress of story cards and track bugs and requests.
• Used GitHub for controlling code version.

Environment: Informatica PowerCenter 10.2.0, MDM, Teradata 15.0, Teradata SQL assistant, Unix, Shell scripts, PL/SQL, GitHub, JIRA, ESP scheduler, Confluence.