SUMMARY

• Over 7+ years of experience in IT filed with specialization in Data Warehousing, ETL (Data Stage) and BI Reporting.
• Excellent working experience in various domains like Banking, Telecommunication and Health care.
• Experience in complete Software Development Life Cycle (SDLC) (Requirement Analysis, Design and Development, Testing), Agile Methodologies.
• Strong experience in Data Architecture, Data Modeling, Data Analysis, Decision Support System (DSS) and GUI applications.
• Strong data modeling experience using Star/Snowflake schema, Re - engineering, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling.
• Proficiency in using Erwin tool for creating physical and logical data modeling.
• Experience in ETL and integration of various data sources like Oracle, Teradata and SQL Server.
• Experience in OLAP, OLTP Systems.
• Having solid experience with Data stage tool for Design and Development of Data Stage jobs.
• Design and developed Parallel Jobs of DataStage 8.1/9.1/11.3/11.5.
• Performed Debugging, Troubleshooting, Monitoring and Performance Tuning for Data Stage Jobs (server and parallel).
• Expertise in developing standard and re-usable jobs.
• Created a different Data Stage job using various stages like Transformer, Aggregator, Join, Merge Lookup, Filter, Funnel, copy, Modify, Remove Duplicates, Surrogate key, Change Capture, etc.
• Worked with Teradata Load utilities like TPT (Multi Load, Fast Load, TPump and Fast Export).
• Designed complex Mappings and have expertise in performance tuning and slowly changing Dimension Tables and Fact tables.
• Worked with DBA for performance tuning of SQL Queries.
• Experience in usage of Tivoli (Workload scheduler), Control M and AutoSys job Scheduling.
• Created Technical Documents and Business Requirement Documents and Report Design Documents for Document Library.
• Excellent in communication, presentation and interpersonal skills.
• Keep tracking development status and monitor day to day activities.

TECHNICAL SKILLS

ETL Tools: IBM Information Server 11.X, 9.1, 8.X DataStage.

Operating Systems: Windows, UNIX/Linux.

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Database: Oracle12G/10g/9i, Teradata version 14.10, 15.10, MS SQL Server.

Data Modeling Tools: Microsoft Visio.

Methodologies: Agile (Scrum), Waterfall.

Scheduling Tools: Autosys, TWS.

Version control: SVN, GitHub

CI/CD Tool: Jenkin

PROFESSIONAL EXPERIENCE

Confidential, NC

Sr. ETL/Data Stage Developer

Environment: IBM Information Server 11.7, MS SQL server, Autosys (Scheduler), GitHub (version control), HP Quality Center.

Responsibilities:

• Strong experience in Data Warehousing, Data Modeling, Data Analysis, Decision Support System (DSS) and GUI applications.
• Worked on complete life cycle of Design, Development, maintenance and documenting conversion process.
• Good understanding of Test-driven development, Software Development Life Cycle (SDLC) methodologies like Agile and Scrum.
• Designed and tested the DataStage jobs for extract, transform and load.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
• Extensively worked with DataStage Active and Passive Stages for Data Staging and Data Transformation
• Worked extensively on different types of stages like Sequential file, ODBC, Connectors, Aggregator, Transformer, Filter, Merge, Join, Lookup, Sort, and Containers (Server, Parallel) for developing jobs.
• Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Developed complex store procedures using input/output parameters, cursors, views, triggers and complex queries using temp tables and joins.
• Used Data Stage Director to validate schedule run and monitor the Data Stage jobs.
• Created SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Developed SQL triggers and master tables for automatic creation of primary keys.
• Creation of database objects like tables, views, materialized views, procedures and packages.
• Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks.
• Developed code fixes and enhancements for inclusion in future code releases and patches.
• Worked on Ad-hoc request tickets raised on a daily basis on service now.
• Migrating the code using GitHub and Jenkin.
• Daily monitoring production jobs.

Confidential, WA

ETL DataStage Developer

Environment: IBM Information Server 11.3/11.5 (EE edition), Teradata SQL Assistant 16, Tivoli Workload Scheduler, Putty, GitHub (version control), Note pad++, MS office, HPQC.

Responsibilities:

• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements & Design.
• Worked on migration of Data Stage jobs form Infosphere Information Server Version 9.1 to Infosphere Information Server Version 11.5.
• Used Data Stage as a ETL tool to extract data from source system and load the data into the target Database
• Designed the mappings between sources (external files and databases) to Operational staging targets.
• Analyzing & Designing, worked on changed requests as per clients and projects technical specification needs.
• Extensively involved in the data migration team to build the Re-usable DataStage job templates, common parameter sets, common DataStage job containers, analyzing with info analyzer 11.3, SQL extract procedures and common re-usable Shell Scripts.
• Widely used with Join, Look up and Merge Stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Tuned DataStage jobs for better performance by creating DataStage Hash files for Staging the data and Lookups.
• Developed complex store procedures using input/output parameters, cursors, views, triggers and complex queries using temp tables and joins.
• Used Quality Stage to coordinate the delivery, consistency, removing data anomalies and spelling errors of the source information.
• Extensively used slowly changing dimension Type 2 approach to maintain history in database.
• Created multiple layer report providing a comprehensive and detail report with Drill through facility.
• Used Parallel Extender for Parallel Processing for improving performance when extracting the data from the sources.
• Worked with Metadata Definitions, Import and Export of DataStage jobs using Data stage Manager.
• Providing the logical data model design, generating database, resolving technical issues, and loading data into multiple instances.

Confidential, CT

ETL Developer

Environment: IBM Information Server 11.3, Teradata, Unix, WinSCP, HP Quality Center, TWS.

Responsibilities:

• Designed and tested the DataStage jobs for extract, transform and load.
• Extensively involved in the data migration team to build the Re-usable DataStage job templates, common parameter sets, common DataStage job containers, analyzing with info analyzer 11.3, SQL extract procedures and common re-usable Shell Scripts.
• Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Data analysis, Data modeling concepts, Database design and Data migration using Quality stage.
• Implemented Aggregate, Filter, Join, Lookup, Rank and Update Strategy Transformations.
• Created ETL code as per UHG standard and best practices.
• Assessed the Teradata environment for implementation of the ETL solutions.
• Used Star Schema and Normalization data modeling techniques for warehousing of data.
• Extensively worked with DataStage 11.3V - Designer and Director to load data from source extract files to the warehouse.
• Used Quality Stage to coordinate the delivery, consistency, removing data anomalies and spelling errors of the source information.
• Created DataStage jobs to load data from sequential files, CSV, Flat files, oracle and DB2.
• Developed various jobs using Aggregator, Sequential File stages.
• Used Fast Load, Multi Load Scripts to load data into Teradata from Flat files.
• Worked towards optimal performance when using Stages like LOOKUP, JOIN and MERGE.
• Worked with Metadata Definitions, Import and Export of DataStage jobs using DataStage Tools Functionality.
• Created Parameters and Parameter Sets where necessary.
• Tuned DataStage jobs for better performance by creating DataStage Hash files for Staging the data and Lookups.
• Scheduled the server jobs using DataStage Director, which are controlled by DataStage engine and for monitoring and performance statistics of each stage using IBM Quality Stage 11.3.

Confidential 

Database Analyst

Environment: Oracle 11g, UNIX, putty, DataStage 8.1, AutoSys, HP Quality Center.

Responsibilities:

• Analyze the existing complex data loading procedure of the Application and identify the jobs need to be modified.
• Develop new jobs.
• Prepare Technical Specification Documents.
• Populate data from a different source.
• Coding for jobs and create reports for the end user.
• Transform the field as user requirement.
• Creating and Maintaining Traceability Matrix for the Test Plan/Test Specification (vs) Requirements.
• Implement project in production.
• After going live did also some change request and ISJR for some of the Intermediate Requirements to fulfil some more requirements and preparing technical and test document.
• Investigate Testing environment and fix bugs if any.
• Built DataStage jobs to read files from multiple tables using Oracle Connector Stage Created Sequencers with Exception Handling and Restarting Logics.