SUMMARY

• Over 8 years of IT experience in Software Analysis, Design, Development and Testing of business applications for Internet, Insurance, Financial, Retail and Telecom applications
• Experience in development and testing of ETL process using Informatica Power center.
• Expertise in developing complex transformations, mappings, mapplets, different tasks, worklets, workflows using Informatica.
• Expertise in performing source system analysis, data transformation and loading.
• Experience in working with different databases like Oracle, Teradata, DB2 and SQL Server etc.
• Experience with Extraction, Transformation and Loading (ETL) of data from various data sources like Flat files, XML, COBOL, web applications and relational tables etc.
• Experience in integration of various data sources like Oracle, Mainframe DB2, SQL server, Teradata, Sybase, flat files, COBOL files, AWS S3, MongoDB, JSON files, XML files and web applications.
• Experience with performance tuning of ETL mappings and optimizing the SQL overrides to improve ETL job performance. Experience in Performance tuning of targets, sources, mappings, and sessions.
• Implementing Incremental/delta loads, slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Developed ETL mappings to load data into Dimensions, Facts and Aggregate tables using Informatica ETL tool.
• Used global parameters, variables in mappings/sessions and specified the values in parameter files.
• Experience in working with Parameter files, Mapping parameters, Mapping Variables, Error handling, target load order, constraint-based loading, unconnected Lookups, session partitions, dynamic lookup caches, file lists.
• Used Informatica HTTP transformation and Curl commands in scripts to read data from the HTTP server using GET method or write data to the HTTP server using POST methods along with authorization details, required parameters, content type (JSON for Rest API) and body format provided to URL.
• For web applications requests used different methods like GET/POST/PUT/DELETE.
• GET method to read or retrieve requested data from web server. POST method to insert requested data to webserver, PUT method to update existing data on web server and DELETE method to delete requested data on web server.
• Analyze the documents for given web application to know about how we can read and write data to their server.
• Used POSTMAN tool to know how the requests/response will work for these.
• Experience with MongoDB to store data in JSON format. (collections,documents,objects,arrays etc.)
• Experience in creating TDD, source to target mapping documents, developing/unit test of ETL mappings and fixing the issues during QA.
• Experience with writing DDL, DML, DCL (grant/revoke) and TCL (commit/rollback) stmts.
• Experience with writing Oracle PL/SQL Stored Procedures/Functions/Packages and involved in SQL Query Optimization using hints, indexes, partitioning tables etc.
• Conducts database testing for data verification and data validation using SQL to meet the Business requirements.
• Experience with writing UNIX commands and writing shell scripts.
• Provide Production support for Data Warehouse load processes.
• Experience with multi-dimensional models like Star schema, Snowflake schema.
• Experience in creating reports using Actuate reporting tools.
• Knowledge on creation of logical and physical data models using Erwin.
• Knowledge on Informatica Developer and Informatica Cloud.
• Involved in working with project Managers on estimates, timelines, and resource plan and on time deliverables.
• Interfaced with analysts to understand high-level requirements and expectations.
• Involved in review meetings
• Experience in managing offshore teams for developing and testing of various projects.
• Involved in preparing daily status reports, defects reports and signoffs during development and testing.
• Experience in creating Test Plan, Test strategy, Test Cases, Test Scripts (SQL), Defect/Test reports using Quality center and test data for different scenarios.
• Experience with different testing like Smoke, Integration, Functional, System, Regression and UAT, White box testing of Informatica ETL mappings and OBIEE Reports
• Categorized bugs based on the severity and priority wise and interfaced with team to resolve them during testing phase
• Involved in scheduling meetings and coordinate with project team during development and testing phases
• Familiar with migration of Informatica objects from Development to QA.
• Knowledge on writing java code.
• Good organizational skills, fast learner, strong analytical and problem solving skills, good time management skills and ability to work independently, team work and goal oriented.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center, Teradata Utilities

Databases: Oracle, SQL Server, MS Access, Sybase, Teradata, DB2

Data Modeling Tools: Erwin, Star Schema, Snowflake Schema

Cloud technologies: AWS

Query Tools: SQL developer, SQL Assistant, TOAD, DB visualizer

OLAP/Reporting Tools: Actuate reports

No SQL DB: MongoDB

Languages: UNIX/LINUX/DOS Scripting, C, C++, Java and PL/SQL, Python

GUI/Dev Tools: Visual Basic, PowerBuilder, WinSCP, Postman

Schedulers: Informatica scheduler, Maestro, Control-M, Autosys, Tivoli

Testing Tools: Test Director 8.0/7.6, Quality Center 9.0, PVCS Tracker, Toad, SQL developer, Informatica, Actuate, UNIX, Rally

Internet Technologies: JSON, HTML, XML, UML, VBScript, ASP, and IIS

Protocols: FTP, TCP/IP, Connect Direct

Operating Systems: UNIX, Linux, Windows

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Informatica ETL Developer

Responsibilities:

• Worked with Business Analysts to understand business requirements.
• Data Extraction, Transformation and Loading using Informatica Power Center.
• Developed mappings, mapplets, worklets, workflows and scheduled jobs using Informatica.
• Used different transformations like Sorter, Aggregator, Router, Normalizer, sequence, Union, Ranker, Update Strategy, Lookup, Stored Procedure, Source, Target, Transaction Control, XML, HTTP transformations etc.
• Responsible for enhancing existing mappings and creating new mappings.
• Developed various mappings for extracting data from various sources involving flat files, Oracle, XML files.
• Developed mappings to implement type1, type2, type3 slowly changing dimensions.
• Developed mappings to load Facts and Aggregate tables.
• Developed ETL code for Incremental/delta loads.
• Used different tasks include Session, Command, Decision, Email, Event-Wait etc.
• Created Mapping Parameters and Mapping Variables to use globally.
• Used parameter files to specify the values.
• Used debugger to test the mappings.
• Developed the Test scripts and performed data validation includes counts check, duplicates check, data structure and requirements validation from source to target.
• Validated type1, type2 logic for slowly changing dimensions and validated data in Fact and aggregate tables based on business, functional and technical requirements.
• Wrote SQL queries against the target database to validate the load results.
• Verified the ETL workflows performance during the data loads.
• Performed smoke, functional, system, integration, regression, and performance testing and ensured that the results are accurate before moving to PROD.
• Involved in required test data creation for different test scenarios.
• Involved in fixing the defects during QA based on the severity and priority.
• Created stored procedures for removing the indexes before the data is loaded, rebuilt the indexes after the load has been completed, to truncate the tables, to analyze tables etc
• Tuning of Informatica mappings and sessions to improve the jobs performance.
• Involved in working with project Managers on estimates, timelines and on time deliverables.
• Involved in review meetings
• Involved in scheduling meetings and coordinating with the project team during development and testing phases.
• Involved in Testing, Debugging, Validation and Performance tuning of data warehouse.

Environment: InformaticaPowerCenter,Oracle,PL/SQL,SQLServer,DB2,Flatfiles,Unix,Python,, XML, Erwin, Jira, WinSCP, Putty

Confidential, Atlanta, GA

Informatica ETL Developer

Responsibilities:

• Worked with Business Analysts to understand business requirements.
• Analyze the documents for given web applications to know about how we can read and write data to their server.
• Example: Facebook, Google, Trust pilot and Amazon. Used POSTMAN tool to know how the requests/response will work for these web applications.
• Data Extraction, Transformation and Loading using Informatica Power Center.
• Developed mappings, mapplets, worklets, workflows and scheduled jobs using Informatica.
• Used Informatica HTTP transformation and Curl commands in scripts to read data from the HTTP server using GET method or write data to the HTTP server using POST methods along with authorization details, required parameters, content type (JSON for Rest API) and body format provided to URL.
• For web applications requests used different methods like GET/POST/PUT/DELETE.
• GET method to read or retrieve requested data from web server. POST method to insert requested data to webserver, PUT method to update existing data on web server and DELETE method to delete requested data on web server.
• Experience with MongoDB to store data in JSON format. (collections, documents, objects, arrays etc.)

Environment: InformaticaPowerCenter,Oracle,PL/SQL,SQLServer,DB2,Flatfiles, Unix,Python,AWS,MongoDB,JSON,XML,Erwin,Jira,WinSCP, Putty, Postman

Confidential, Atlanta, GA

Informatica ETL Developer

Responsibilities:

• Worked with Business Analysts to understand business requirements.
• Data Extraction, Transformation and Loading using Informatica Power Center
• Developed mappings, mapplets, workflows and scheduled jobs using Informatica.
• Developing and testing of ETL mappings.
• Wrote Unix commands and Sql queries.
• Improved performance of the jobs using various performance tuning techniques.
• Involved in fixing the defects during QA. worked on Actuate reports

Environment: Informatica Power Center 9.6/10.1.1,Informatica developer, HP Quality Center, Unix, WinSCP, Putty, Actuate, XML, MS Excel, Oracle, PL/SQL, SQL Server,DB2, Flat files, Windows NT, Erwin,Jira

Confidential, Atlanta, GA

Informatica ETL Developer

Responsibilities:

• Worked with Business Analysts to understand business requirements.
• Data Extraction, Transformation and Loading using Informatica Power Center
• Developed mappings, mapplets, workflows and scheduled jobs using Informatica.
• Developing and testing of ETL mappings.
• Wrote Unix commands and Sql queries.
• Improved performance of the jobs using various performance tuning techniques.
• Involved in fixing the defects during QA.

Environment: Informatica Power Center 9.1/9.6, HP Quality Center, Unix, WinSCP, Putty, OBIEE, ETL, XML, MS Excel, Oracle, PL/SQL, SQL Server, Flat files, Windows NT, Erwin

Confidential, Atlanta,GA

ETL Developer

Responsibilities:

• Understanding the mapping specification and analyzing data according to the business requirements.
• Interfaced with analysts to understand high-level requirements and expectations.
• Extraction, Transformation and loading data from source to target system using Teradata utilities.
• Developed Bteq scripts to transform the data as per business/technical specifications.
• Used volatile, global temporary tables and parameters in code.
• Used the utilities of Teradata - BTEQ, Multi-Load to load data into the Teradata Target database
• Used the Fast Export utility of Teradata to run the Extracts (Extracting the data from tables and writing to flat files).
• Specified the indexes and collected statistics on columns and tables to improve the job performance.
• Tested the SQL queries using Teradata SQL Assistant as part of the ETL process.
• Prepared unit test cases and verified the results like successful job runs, count check, duplicates and requirements validation to make sure results are accurate before moving code to QA.
• Verified the job performance during the data loads by checking the log files.
• Involved in required test data creation for different test scenarios
• Fixed the defects during QA.

Environment: Teradata13,Bteq,Mload,Fload,SQLAssistant/query man Unix, WinSCP, Putty, SVN, Business Objects,Rally,Erwin, ETL, XML, MS Excel, Flat files, Windows.

Confidential, Atlanta, GA

Informatica ETL QA LEAD

Responsibilities:

• Involved in working with project Managers on estimates, timelines, and resource plan and on time deliverables.
• Interfaced with analysts to understand high-level requirements and expectations.
• Involved in review meetings
• Experience in managing offshore teams for developing and testing various projects.
• Involved in scheduling meetings and coordinating with the project team during development and testing phases.
• Responsible for testing of existing mappings and new mappings.
• Involved in testing of type1, type2, type3 slowly changing dimension, Facts and Aggregate tables..
• Verified ETL code for full and Incremental/delta loads.
• Developed the Test scripts and performed data validation includes counts check, duplicates check, data structure and requirements validation from source to target.
• Involved in required test data creation for different test scenarios.
• Involved in Testing, Debugging, Validation and Performance tuning of data warehouse.

Environment: Informatica Power Center 8.6/9.1, HP Quality Center, Unix, WinSCP, Putty, OBIEE, ETL, XML, MS Excel, Oracle 10g, PL/SQL, SQL Server, Flat files, Windows NT 4.0, Erwin 4.5

Confidential, Madison, WI

Informatica Developer

Responsibilities:

• Worked closely with Business Analyst and Business users to understand business needs.
• Data Extraction, Transformation and Loading using Informatica Power Center and Teradata utilities.
• Developed complex transformations, mappings, mapplets, workflows and scheduled informatica jobs
• Developed Bteq scripts to transform the data as per business/technical specifications. Used volatile, global temporary tables and parameters in script.
• Designed various mappings for extracting data from various sources involving flat files, Oracle, Sybase, SqlServer, IBM DB2, XML files.
• Developed pre-session and post-session sql and stored procedures.
• Created stored procedures for removing the indexes before the data is loaded, rebuilt the indexes after the load has been completed, to truncate the tables, to analyze tables.
• Tuning of Informatica mappings and sessions to improve the jobs performance.
• Created Mapping Parameters and Mapping Variables to use globally.
• Used parameter files to specify the values.
• Used debugger to test the mappings.
• Developed the Test Scripts and performed the Unit Tests on the ETL mappings.
• Written test cases for data validation on source and target side.
• Wrote Unix scripts.
• Used TOAD front-end tools to issue SQL commands matching the business requirements to Oracle RDBMS.
• Worked with HP Quality Center to interact with teams during testing.
• Used Autosys to schedule informatica jobs on unix box and monitored the results
• Used different tasks include Session, Command, Decision, Email, Event-Wait etc.

Environment: Informatica Power center 8.1/8.5, Oracle9i/10g, SQL, PL/SQL,ToadErwin 4.x,QualityCenter,Autosys,Windows NT, AIX 5.1,Siebel,PVCS,XML,Unix ShellScripting, VisualSourceSafe,MicrosoftVisio,BusinessObjects,Teradata,DB2,SQL Server