PROFESSIONAL SUMMARY:

• 5+ years of IT experience in the software development life cycle (SDLC) starting from collecting business specifications, user requirements, confirming the design decisions regarding data, process, interfaces, reviewing/audit the code and documenting, Implementation and Testing of ETL applications for Telecommunications industries using Data Extraction, Data Transformation, Data Loading and Data Analysis.
• Worked extensively on Data Warehouse applications using ETL Tools Datastage, PL/SQL, and UNIX Shell Scripts. Worked extensively in a complex, high - volume environment dealing terabytes of data.
• Proficient in Designing, Developing, Testing and Performance Tuning of ETL jobs in Datastage.
• Extensive experience in testing and reviewing of dimensional modeling (Star and Snow flake schemas) of data warehouse using Erwin.
• Worked in multiple responsibilities such as reviewing of ETL architecture, ETL design, and analysis and ETL technical specifications.
• Tested ETL applications in relational databases and flat files using Datastage and involved in the report generation of BI systems using Cognos and Tableau Reports.
• Tested UNIX shell scripts written for ETL Processes to schedule workflows on Tidal and Autosys.
• Hands-on experience of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Good experience of Quality Assurance methodologies like Waterfall, V-Model, Agile, Scrum.
• Experience in designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for manual, automated & bug tracking tools.
• Expert in different types of testing that includes Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance testing (UAT) & Involved in Load Testing, Performance Testing.
• Developed ETL and Database related frameworks for automation.
• Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases.
• Strong understanding of the principles of Data Warehousing using Fact and Dimension tables in Star schema and Snowflake schema
• Experience with the design of large-scale ETL solutions integrating multiple source systems DB2, SQL Server, Oracle and Teradata.
• Expertise in use of for writing test cases, test execution, defect management, defect tracking and Bug Reporting.
• Significantly contributed in performance tuning, which in turn it helps to improve the performance at workflow level, mapping level and session level of Datastage.
• Efficient in Interacting with Business Users, know their views in Preparing ETL Test Strategies.
• High end working experience in Agile/Scrum methodologies, technical discussion with client and communication using scrum calls daily for project analysis specs and testing aspects.

ETL Tools: Datastage 8.x/ 11.x

Test Management tool: HP ALM, Quality Center, TestLink

Defect Tracking Tool: Rational ClearQuest, JIRA

Operating Systems: Windows XP/7, Unix, Linux

Databases: Oracle 9i/10g, Vertica, SQL Server 2008, DB2, Teradata

Scripting Languages: SQL, PL/SQL, korn shell, Born shell, Python,Perl

Big Data Technologies: Hadoop MapReduce, Hive, Hbase, Pig

Scheduling Tools: Control-M, Tidal, CRON Tab, Apcon

Other Tools: Cognos, Tableau, Control-M, Toad for Oracle, SQL, PL/SQL Developer, Squirrel, Teradata SQL Assistant, Erwin, Putty, WinScp

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

ETL DataStage Developer

Responsibilities:

• Creating and running sessions and workflows required to load the data into oracle application from flat files and staging tables.
• Extracted data from different flat files, MS Excel, MS Access and transformed the data basd on user requirement using DataStage into target.
• Expertise in development of Oracle and ETL Conversion Data.
• Creating transformations like Router, Lookup, Expression, Sequence generator and Update strategy.
• Created reusable transformations and mapplets and used them in mappings.
• Expertise in data validation operations in middle of ETL processes.
• Involved in extraction of data using delimited and fixed width flat files, XML file sources, Json files
• Extensively Worked on Datastage such as Source Analyzer, Target/Warehouse Designer, Transformation
• Creating source to target mappings and developing the ETL mappings using Datastage.
• Analyzing the problems and providing optimum solutions to customers.
• Tuning the mappings to achieve better performance.
• Involved in performance tuning the SQLs to optimize the run time in mappings.

Environment: DataStage 8.7,11.3,11.5, Oracle 11g, SQL, PL/SQL, DB2, Unix, Flat Files and CSV files

Confidential, Silver Spring, MD

DataStage Developer

Responsibilities:

• Used IBM Web Sphere DataStage as an ETL tool to extract data from sources like DB2 and flat files and loaded to target tables.
• Creation of Transformations like lookup, Merge, Rank and Source Qualifier Transformations in Datastage Designer.
• Coded Oracle Procedures and Packages for the migration run.
• Coded Oracle Stored Procedures/packages to create and drop jobs using DBMS Scheduler.
• Developed DataStage Parallel jobs for Daily Policy project which involves maintaining data of all Policy holders for Cincinnati Financial Corporation.
• Communicated with business people and understand their needs and put them in a functional documentation and curve functional documents in to technical design documents.
• Extensively involved in various iterations for designing and developing the DataStage code.
• Developed data extractions, transformations and routines.
• Mapped the source and target Databases by studying the specifications and analyzing the required transforms.
• Analyzed the performance of the jobs and enhance the performance using the standard techniques & best practices
• Created Job Sequences and schedules for automation.
• Used DataStage to transform the data to multiple stages, and prepared documentation.
• Worked on writing routines to read parameters from hash file at runtime.
• Documented the Purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.

Environment: IBM Information server 9.1, 8.7(Administrator, Designer, Director), Oracle11g, Teradata, PL/SQL, SQL Loader, UNIX, Autosys, Windows 7. 

Confidential

ETL Developer

Responsibilities:

• Developed processes for extracting, cleansing, transforming, integrating and loading data into Oracle database using DataStage Designer.
• Designed and developed of DataStage Server and Parallel Jobs.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements
• Tuned DataStage jobs for better performance by creating common modules, RCP concepts
• Used DataStage Director for running the Jobs.
• Used the Manager to import, export jobs/routines.
• Preparation of Unit test cases
• Performed Unit testing
• Preparation of System test cases
• Performed System Testing

Environment: Datastage 7.5.2, Oracle 9i, SQL, Linux, Shell scripts, TOAD, Putty