SUMMARY

• Over 11+ years of experience in Data Warehouse Applications with over 8+ years of ETL Application development, Integration of data and 3+ years of experience in manual testing on Data Warehousing applications, BI reports.
• Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Experience with dimensional modeling using star schema and snowflake models.
• Experience in High Level Design, Low level Design.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Have experience in working with both 3NF and dimensional models for data warehouse and good understanding of OLAP/OLTP systems.
• Experience in Data Integration from PeopleSoft, Oracle EBS, Salesforce-CRM systems using Informatica cloud and using Informatica Power Center (9.x/8.x)/DataStage.
• Experience in working on databases - Oracle 11g, 10g, Teradata V12 and DB2 V9.
• Highly proficient in performance tuning at ETL and at database level.
• Expertise in creating mappings, session, workflows in Informatica PC. Extensively used different transformations, parameters, variables to attain required logic.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and indexes in Teradata database.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Experienced in Data Analysis, Profiling.
• Experienced in using UNIX commands and in creating new/modifying UNIX Shell scripts for file processing, data validations and Job executions.
• Expertise in scheduling Informatica jobs using Informatica, $U, Autosys and Control-M.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
• Built the Physical Data Objects and developed various mapping, mapplets/rules using the Informatica MDM based on requirements to profile, validate and cleanse the data.
• Good knowledge on Agile Methodology and the scrum process.
• Basic experience with HDFS, HIVE and SQOOP.
• Basic experience in python.
• Clear understanding of business process.
• Experience in leading a team, onboarding new resources, consolidate access requirements, project requirements, get approvals when required, maintain code versions, review code and coding standards, initiate production deployments, track work status and communicate weekly status to all the stakeholder.

TECHNICAL SKILLS

ETL: Informatica PowerCenter, DataStage, Informatica MDM, Informatica IDQIntegration Salesforce.com, Oracle EBS

Databases: Teradata, Oracle, MySQL, DB2

Scheduling Tools: Control-M, Dollar-U, Autosys

Reporting/Analytics: Tableau, Business Objects, OBIEE

Version Control Tools: PVCS, Kintana, SharePoint, Perforce, Mercury Quality Center, Git

Programming: PL/SQL, Unix Scripts

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

Application Developer

Responsibilities:

• Worked closely with the Users to understand the requirement.
• Used Informatica Power Center to bring data from University CAP DB to Warehouse.
• Created PL/SQL Procedures to breakdown arrays of authors/citations/publications from JSON.
• Maintained “AS-IS” and “AS-WAS” data conditions.
• Created Summary tables and materialized views (with Business rules) to support report requirements.
• Developed and implemented Error Handling Strategies.
• Developed Restart ability strategy for all the workflows.
• Conducted Unit tests and documented test results.
• Maintain code migration checklist.
• Scheduled the Workflows and Procedures using Informatica Scheduler.

Confidential

Data Integration Specialist

Responsibilities:

• Worked closely with the Users to understand the requirement and perform Gap Analysis.
• Integrated data from Teradata, Oracle EBS, Salesforce and SQL Server source systems.
• Used Informatica Cloud to write data to Salesforce objects and sync to the Stage. Used Force Explorer to validate data on Salesforce.
• Developed and implemented Error Handling Strategies.
• Created Informatica workflows and scheduled them through Informatica Scheduler.
• Developed Restart-ability strategy for all the workflows.
• Maintained code in Perforce and used the same to migrate from one environment to another.

Confidential

ETL Specialist

Responsibilities:

• Worked closely with the Users to understand the requirement and perform Gap Analysis.
• Analyzed the system specifications related to the Datastage ETL and related applications to ensure they appropriately address the business requirements
• Evaluated the impact of proposed changes on existing ETL applications, processes and configurations
• Scheduled Informatica jobs using Control-M scheduler.
• Responsible for moving code from one environment to another. DEV to TEST and then to PROD
• Ensured the stable operation of ETL processes in the production environment and smooth transition.

Confidential

Consultant

Responsibilities:

• Creation of BTEQ, Fast export, Multiload, TPump, Fast load scripts for extracting data from various source systems.
• Profile Integrated Data from different source systems and performed Data Quality Audit using Informatica DQ(IDQ).
• Define and maintained metadata, data sources and set up Validation Rules.
• Create Fastexport scripts to export data from Oracle to Teradata.
• Created views based on user and/or reporting requirements and enhance performance.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Optimized various complex SQL queries for better performance.
• Used Teradata SQL queries to join tables, cleanse data and apply filter conditions.
• Provide design for CDC implementation for real time data solutions.
• Conduct training sessions with business and development stakeholders on data model and data validations performed.
• Updated RPD that consist of physical layer, business model / layers with aggregates, dimensions and Dimension hierarchies, presentation layer with catalogs & folders using Oracle BI Administration tool.
• Built interactive dashboardsin OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Performed environment migrations between the Development, Quality Assurance, and Production environments.
• Responsible for Unit Testing, Integration Testing of the RPD.

Confidential

Senior ETL Tester

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status.
• Worked with the Development team for process improvement and release planning.
• Analyzed the requirements, created and executed the test cases.
• Worked with the Development team for process improvement and release planning.
• Created the SQL Queries and stored procedures for quality assurance and analysis.
• Performed backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts, compared the expected results with the actual outcome and recorded the results.
• Tested the BO reports.
• Performed database testing to verify backend database transactions.
• Wrote complex queries in Teradata SQL assistant to analyze the data.
• Coordinated user acceptance testing activities for business groups and IT.
• Involved in communication between UAT team members, business leaders, and IT.
• Participated in application release planning and status sessions.
• Modified and executed test scripts for web based environment-using Quality Center.

Confidential

Senior Informatica Developer

Responsibilities:

• Understand the design and develop the application, analyze and estimate the impact of changes in design during development.
• Created the several mappings to extract the data from fixed width and delimited flat files from DB2.
• Create mappings which involve various business rules to populate the data from Stage1 to Stage2 and from Stage 2 to EDW.
• Created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.
• Worked on loading techniques like SCD's and incremental loading for extraction, transformation and loading of the data.
• Worked extensively with various passive transformations inInformaticaPowerCenterlike Expression Transformation, Sequence Generator and Lookup Transformation.
• Extensively used SQL override in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join and Master Outer Join in the Joiner Transformation.
• Created connected and unconnected Lookup transformation to get the related values.
• Responsible for performance tuning of Sources, Targets, Mappings and SQL queries in the Transformations.
• Experienced in writing PL/SQL Stored Procedures.
• Unit testing of the code
• Involved in code reviews to ensure that organizational and client standards are maintained in code and document unit test results
• Coordinate with the testing team in addressing the defects and resolved on time.

Confidential

Senior Software Engineer

Responsibilities:

• Test Scoping, Test strategy preparation
• Development of test cases/scripts, Test script reviews, Test case execution, Bug identification, tracking and closure
• Developed unit test cases and prepared test data for testing.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• As a QATester, performed both functionality and back end testing.
• Developed SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Worked with Production environment to resolve several data issues.
• Used SQL queries and custom programs to perform data validation.
• Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
• Coordination with offshore team
• Daily test status reporting and metrics, UAT coordination.

Confidential

Software Engineer

Responsibilities:

• Worked with Business analysts for requirements gathering, business analysis and designing of the data warehouse.
• Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin.
• Understand the design and develop the application, analyze and estimate the impact of changes in design during development.
• Created the several mappings to extract the data from fixed width and delimited flat files and load into DB2.
• Create mappings which involve various business rules to populate the data from Stage1 to Stage2 and from Stage 2 to EDW.
• Created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.
• Worked on loading techniques like SCD's and incremental loading for extraction, transformation and loading of the data.
• Worked extensively with various passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator and Lookup Transformation.
• Extensively used SQL override in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join and Master Outer Join in the Joiner Transformation.
• Created connected and unconnected Lookup transformation to get the related values.
• Responsible for performance tuning of Sources, Targets, Mappings and SQL queries in the Transformations.
• Experienced in writing PL/SQL Stored Procedures.
• Schedule the Informatica code using Control-M.
• Unit test the developed code.
• Involved in code reviews to ensure that organizational and client standards are maintained in code and document unit test results.
• Coordinate with the testing team in addressing the defects and resolved on time.
• Provide the required documentation and extend production support for the application.