SUMMARY:

• Total 10 Years of IT experience in different tools and technologies like Informatica, Datastage, Teradata, Netezza, Unix, Oracle, PL/SQL, Autosys, Cronacle. Senior level experience in full life cycle (SDLC) Data Warehousing, Data Integration, and Business Intelligence as Sr. ETL/Informatica Developer, Data Warehouse Developer and Tester.
• Domain knowledge in functional areas like Retail, Healthcare and Banking.
• Knowledge of accounting concepts like General Ledger, balance sheets etc.
• Informatica 8.x certified Developer.
• Worked in the capacity of Business Requirements analysis, Data Mapping, Database design and designer (ETL & Reporting) of large data warehouses.
• Specializing in Design & Development of ETLs that load data from multiple sources (Oracle, Teradata, Netezza, DB2, Flat Files) into the Warehouse & Mart using Informatica, Datastage, SQL Loader; Design & Development of PL/SQL routines (Stored procedures, triggers, functions), SQL Queries, Teradata BTEQs and UNIX Shell scripts for data load & processing and testing.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage (Ver8.2/7), designing and developing jobs using DataStage Designer, Data Stage Manager, DataStage Director and DataStage Debugger.
• Scheduling of ETL workflows; Data Modeling (Logical & Physical) - using Erwin; Optimization of ETL routines; Workflow/Session level parameterization, Implementing partitioning and concurrency concepts in workflows for performance enhancements.
• Testing and Support during Implementation of ETL Mappings.
• Also having good hold on Oracle, Teradata and Netezza database appliance.
• Handling/Maintaining Quality and Process Related Aspects of a Project; Conducting Defect Prevention Meetings; Suggesting various Quality and Process improvement measures; Conducting Reviews; Maintaining Review Checklists/Issue Trackers and resolving issues with appropriate solutions.
• Used Quality Center for Testing Purposes.
• Worked as single point of contact for the Testing Team in case of ETL related issues. Mentoring members of the team. Technical Knowledge Transfer Sessions for the team on Informatica, Datastage, Teradata, Cronacle, Autosys.
• Facilitating Onsite-Offshore co-ordination and status meeting with the team. Task allocation and collecting status updates from the team to manage smooth completion of the task in hand.
• Experienced in Data Warehouse development with expertise in ETL Development, System Testing

TECHNICAL SKILLS

ETL Tools: Informatica 7.1,8.1,8.5,8.6,9.1Ab-Initio - GDE 3.0.4,3.0.6 DataStage 7.5,8.2,8.5

Reporting: Business Objects BOXI R3.1, Crystal Repots 2011

Database: Oracle 8i,9i,10g,11gNetezza 4.5,5.0DB2 V8, V9SQL Server 2000,2005,2008Teradata V2R6,12,13.10,14, 15

Scheduling Tool: Autosys 4.5.1, Redwood Cronacle 7.0.4

Languages: Visual Basic, SQL, PL/SQL, Java, J2EE,JSP, HTML, XML

Operating Systems: Windows 95/NT/2000, Windows XP, UNIX

ETL Tools: Informatica, AbInitio, DataStage

PROFESSIONAL EXPERIENCE:

Confidential, Fort Mill, SC

Lead Developer 

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Performed bulk data load from multiple data source (ORACLE, legacy systems) to TERADATA RDBMS using BTEQ, Multiload, TPT and FastLoad
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Responsible for Collect Statics on FACT tables
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations
• Designing, creating and tuning physical database objects (tables, views, indexes, PPI, UPI, NUPI, and USI) to support normalized and dimensional models. Maintain the referential integrity of the database.
• Created proper Primary Index taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Build tracking table to monitor the load status, loading steps and to monitor severity of errors.
• Helped BI Capabilities manage the complex inter-operations between shops and manage the cross functional demands with JIRA.
• Updating SLA reporting, customizable team queues/dashboards, real-time reporting and ownership notification in JIRA 5.2
• Involved in building Data marts, data structures, data storages, data warehouses, data archives, and data analysis.
• Wrote numerous BTEQ scripts to run complex queries on the Teradata database.
• Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process.
• Define the schema, staging tables, and landing table, configuring base object, foreign-key relationships.
• Writing teradata sql queries to join or any modifications in the table
• Involved in SASGRID Migration and also with configuring Queues/Policies in SASGRID environment, usage tracking, monitoring, alerts notification and load balancing.
• Involved in Teradata14 migration and streamlined the Teradata scripts, shell scripts migration and DDLs to accommodate teradata 14 reserved keywords.
• Developed UNIX shell scripts to run batch jobs in production.
• Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding the current system.
• Developed Teradata views and macros to accomplish the ETL work.

Environment Used: Teradata 15 Teradata SQL Assistant, Teradata Manager, Teradata view pointer, BTEQ, MLOAD, FLOAD, FASTEXPORT, Erwin Designer, UNIX, Korn Shell scripts

Lead Developer 

Responsibilities:

• Understanding of the business requirements and High level Design of systematic flow of the mapping and database tables. Created DLD document from the business requirements and implemented that in the design. Done Data Mapping as per the requirements.
• Detail level design and data flows creation for loading from Oracle, Teradata tables and flat files to staging database as per business logic and handling error scenarios for the same.
• Changes in design/coding with the frequent changes in business requirements.
• Data from Oracle, Teradata tables and flat files are segregated, fine-tuned and transformed using Informatica Mapping.
• Determination/Coding/Implementation of UNIX shell scripts for mapping execution and data validation and test automation.
• Analyzed and developed new codes to suggest new functionality and to support reusability.
• Development of Teradata BTEQs to Insert, Update, Delete the Target table data.
• Used Redwood Cronacle as the Scheduling tool. Developed the Cronacle Job Chains, Calling Scripts, Event Waits, and Locks. Scheduled them at proper time and window to run the Informatica mappings and Teradata BTEQs.
• Developing unit test and integration test plan and test cases for different business scenarios.
• End to End Software development including coding of mappings, creating sessions and workflows, unit testing, system testing, regression testing and integration testing as well as analysis of errors occurred.
• Unit test planning and execution and UAT testing coordination. Zero defects at UAT.
• UNIX scripting for test automation.
• Detailed design of performance testing plan and resolving and closing the Change Requests as and when raised.
• Handling/Maintaining Quality and Process Related Aspects of the Project to attain CMM Level 5 for the Project.
• Prepared the Project related documents like: KM Entitlement Plan, BCP, RTO Calculation Doc, UPP Doc, Induction Manual, Inventory List, Project Deployment Doc, Performance Matrix for the Teradata BTEQs etc.
• Submitted Case Study Documents for upload in K-Bank.
• Provided Project Implementation Support at the time of successful go-live.
• Provided Warranty Support and provided the Complete Project KT to RTS (Production Support) Team to hand over the project successfully.

Environment Used: Informatica 8.6.1, Teradata, UNIX, Redwood Cronacle, SVN

 Sr. ETL Developer and Module Lead

Responsibilities:

• Understanding of the business requirements and High level Design of systematic flow of the mapping and database tables. Created DLD document from the business requirements and implemented that in the design.
• Detail level design and data flows creation for loading from DB2 tables and flat files to staging database as per business logic and handling error scenarios for the same.
• Changes in design/coding with the frequent changes in business requirements.
• Data from DB2 tables and flat files are segregated, fine-tuned and transformed using Informatica features like Filtration, Aggregation, Joiner, Sorter, Expression, Connected and Unconnected Lookups on DB2 tables, Router, Mapplets, Update Strategy and Source Qualifier.
• Developed Datastage Job Sequences/routines to transform the data as per the requirement.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage (Ver8.2/7), designing and developing jobs using DataStage Designer, Data Stage Manager, DataStage Director and DataStage Debugger.
• Experience in Mapping Server/parallel Jobs in DataStage to populate tables in Data warehouse and Data marts.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Determination/Implementation of reusable transformation components and Mapplets in different downloads and fine tuning of transformations to reduce the coding/testing effort for mapping; and UNIX scripts for mapping execution and data validation.
• Performance tuning of PLSQL/SQLs used in the mapping and reducing the execution time.
• Developing unit and integration test plan and test cases for different business scenarios.
• End to End Software development including coding of mappings, creating sessions and workflows, unit testing, system testing, regression testing and integration testing as well as analysis of errors occurred.
• Unit test planning and execution and UAT testing coordination.
• Detailed design of performance testing plan and automation for generation of data for performance testing.
• Scheduling ETL Jobs using Autosys.
• Handling/Maintaining Quality and Process Related Aspects of the Project to attain CMM Level 5 for the Project.

Environment Used: Informatica 8.1.1, Datastage 8.2, DB2, UNIX, Autosys tool

ETL Developer and Module Lead

Responsibilities:

• Designed & Developed LLD Document, ETL mappings that load data from source files (UNIX, Mainframes) using Informatica and PL/SQL routines (Stored procedures, triggers, functions) and UNIX shell scripts for data load & processing. Optimization of ETL routines.
• Analysis of data files to incorporate the appropriate changes in the source definitions in order to read data correctly.
• Testing and Support during Implementation of ETL Mappings. Loaded data in Production environment using the mappings and scripts.

Environment Used: Informatica 8.6, Netezza 4.5 Database Appliance, UNIX

ETL Developer and Module Lead

Responsibilities:

• Designed & Developed PL/SQL routines (Stored procedures, triggers, functions) and UNIX shell scripts and ETL mappings that load data from multiple sources (Oracle, Db2, Flat Files) using Informatica, SQL Loader.
• Testing and Support during Implementation of ETL Mappings.

Environment Used: Informatica 8.5.1, Netezza 4.5 Database Appliance, Oracle 9i, UNIX, SQL Server

Developer

Responsibilities:

• Designed and built ETL using Informatica. Extensive used Informatica transformations like Filter, Aggregator, Lookup, Expression, Update Strategy etc. Used Informatica tuning features. Created/scheduled workflow. Used Oracle as the backend database.
• Unit testing, deployment and Implementation.

Environment Used: Informatica 8.1, Oracle 9i, SQL Server

Developer

Responsibilities:

• Designed HTML, XML and JSP pages. Writing SQLs and PL/SQLs to fetch the required appropriate data.
• Unit testing and Implementation.

Environment Used: : J2EE, Oracle 9i, SQL Server

Developer

Responsibilities:

• Writing SQLs and PL/SQLs.
• Unit testing and Implementation.

Environment Used: Oracle 9i, SQL Server