SUMMARY

• Having 7 + years of experience in Design, Analysis and development of software applications.
• Around 5 years of experience with ETL Tool like Ascential Datastage and Database systems such as Oracle, SQL Server
• Around 3 years of experience with Talend Open Studio & Talend Enterprise platform for Data Management (V5.5.1, 5.6.1/5.6.2 )
• Having 1+ years of experience with Talend Admin Console (TAC)
• Good Knowledge on Datastage client components - Datastage Director, Datastage Manager, Datastage Designer.
• Developed efficient mappings for data extraction/transformation/loading (ETL) from different sources to a target data warehouse.
• Strong Knowledge on Data warehousing Basics and relational database management Systems and Dimensional modeling (Star schema and Snowflake schema).
• Implemented Slowly Changing Dimension phenomenon while building Data Warehouses.
• Implemented Error Logging, Error Recovery, and Performance Enhancement’s & created Audit Process (generic) for various Application teams.
• Deep understanding of OLTP, OLAP and data warehousing environment and tuning both kind of systems for peak performance.
• Worked in designing and developing the Logical and physical model using Data modeling tool (ERWIN)
• Experience in scheduling tools Autosys, Control M & Job Conductor (Talend Admin Console)
• Experience in working with parallel extender for splitting bulk data into subsets to distribute the data to all available processors to achieve best job performance.
• Good working noledge on utilizing various Teradata Tools and Utilities
• Written stored procedures to insert and clean data into the data warehouse tables, fired triggers upon completion of load to obtain the log of all the tables loaded with job name and load date.
• Worked on UNIX shell scripts using Kshell for the Scheduling sessions, automation of processes, pre and post session scripts.
• Ability to solve complex technical problems and has unique ability to understand long-term project development issues at all levels and interpersonal skills with strong desire to achieve specified goals within the given time frame.

TECHNICAL SKILLS

Languages: UNIX Shell Programming, SQL, PL/SQL

Operating Systems: UNIX, Windows

Database and Tools & Oracle Tools: Oracle 9i, 10g, SQL Server, SQL*Plus TOAD, Oracle SQL Developer, Teradata

ETL Tools: Talend Open Studio & Talend Enterprise Platform for Data management (V5.5.1, 5.6.1/5.6.2 )Scential Data Stage 8.1, 7.5.1, 7.5, 7.0.1, 7.0

Data Modeling Tools & Scheduling Tools: Erwin, Autosys, Control M

PROFESSIONAL EXPERIENCE

Confidential Richmond, VA

Talend Developer

Responsibilities:

• Developed complex ETL mappings for Stage, Dimensions, Facts and Data marts load
• Involved in Data Extraction for various Databases & Files using Talend
• Created Talend jobs using the dynamic schema feature.
• Has used Big Data components (Hive components) for extracting data from hive sources.
• Performance tuning - Using the tmap cache properties, Multi-threading and tParallelize components for better performance in case of huge source data. Tuning the SQL source queries to restrict unwanted data in ETL process.
• ELT components - Pushdown optimization technique. Moving the transformation logic to the database side instead of handling at talend side. Database tables are indexed properly and data is huge tan ELT method can provide to be much better option in terms of performance of the Job
• Has used AWS components(Amazon Web Services) - Downloading and uploading data files(with ETL) to AWS system using S3 components.
• Used more components in Talend and Few to be mentioned: tjava, toracle, txmlMap, tdelimited files, tlogrow, tlogback components etc. in many of my Jobs Design
• Worked on Joblets (reusable code) & Java routines in Talend
• Implemented Talend POC to Extract data from Salesforce API as an XML Object & .csv files and load data into SQL Server Database
• Implemented Error Logging, Error Recovery, and Performance Enhancement’s & created Audit Process (generic) for various Application teams.
• Experience in using Repository Manager for Migration of Source code from Lower to higher environments.
• Created Projects in TAC and Assign appropriate roles to Developers and integrated SVN (Subversion)
• Worked on Custom Component Design and used to has embedded in Talend Studio
• Used to be On call Support if the Project is deployed to further Phases
• Used Talend Admin Console Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis (Cron Trigger)

Environment: Talend Open Studio 5.5.1, Enterprise Platform for Data management (V5.5.1, 5.6.1/5.6.2 ), UNIX, Oracle, Microsoft SQL Server management Studio, WINDOWS XP

Confidential, St Louis, MO

Talend Admin/Developer

Responsibilities:

• Closely worked with Business Analysts to gather requirement’s and Worked with Data Architects to design Tables (TAC Tables, AMC Tables)
• Designed and Developed ETL process using Talend Open Studio (Data Integration) & Even Worked on Enterprise Latest Version’s
• In parallel to Development acted as an Talend Admin: Creating Projects/ Scheduling Jobs / Migration to Higher Environments & Version Upgrades
• Developed complex ETL mappings for Stage, Dimensions, Facts and Data marts load
• Involved in Data Extraction for various Databases & Files using Talend
• Extensively Used tmap component which does lookup & Joiner Functions
• Used more components in Talend and Few to be mentioned: tjava, toracle, txmlMap, tdelimited files, tlogrow, tlogback components etc. in many of my Jobs Design
• Worked on Joblets (reusable code) & Java routines in Talend
• Implemented Talend POC to Extract data from Salesforce API as an XML Object & .csv files and load data into SQL Server Database
• Mainly Involved in Performance Tuning of Existing Jobs and created Audit Process & Error Capturing methodology for various app teams.
• Hands of Experience on many components which are there in the palette to design Jobs & used Context Variables/Groups to Parameterize Talend Jobs.
• Implemented Error Logging, Error Recovery, and Performance Enhancement’s & created Audit Process (generic) for various Application teams.
• Experience in using Repository Manager for Migration of Source code from Lower to higher environments.
• Created Projects in TAC and Assign appropriate roles to Developers and integrated SVN (Subversion)
• Worked on Custom Component Design and used to has embedded in Talend Studio
• Used to be On call Support if the Project is deployed to further Phases
• Used Talend Admin Console Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis (Cron Trigger)

Environment: Talend Open Studio 5.5.1, Enterprise Platform for Data management (V5.5.1, 5.6.1/5.6.2 ), UNIX, Oracle, Microsoft SQL Server management Studio, WINDOWS XP

Confidential, Dallas, TX

Datastage Developer

Responsibilities:

• Involved with Business users and ETL Leads from different teams to implement ETL Frame Work using Datastage Server/Parallel combination of jobs.
• Extracted data from various sources like Oracle Database, Flat Files, and .CSV files and loaded to target warehouse.
• Implemented various strategies for Slowly Changing Dimensions using Datastage Server/Parallel jobs using the Frame Work approach.
• Designed jobs using different parallel job stages such as Join, Merge, Lookup, Filter, Data set, Lookup file Set, Remove Duplicates, Change Data Capture, Switch, Modify, and Aggregator.
• Involved in developing Datastage Designer Server and Parallel jobs for Extracting, Cleansing, Transforming, and Integrating/Loading Data into Corporate Data Warehouse (CDW).
• Developed Job Sequences for automating and scheduling the Datastage Jobs.
• Extensively designed, developed and implemented Parallel Extender jobs using Parallel Processing (Pipeline and partition) techniques to improve job performance while working with bulk data sources.
• Extensively used Datastage Director to Monitor and check the run statistics of the Jobs and to clear the job logs, job resources.
• Extensively used Datastage Manager to Export/import Datastage components.
• Involved in Unit Testing for the jobs.
• Created Shell scripts for scheduling the Datastage jobs using wrappers.
• Used configuration management tools like Rational Clear Case/Clear Quest for version control and migration.
• Involved in documenting the Frame Work Templates and the process of developing jobs using Templates.

Environment: Ascential Datastage 8.1/7.5.1 (Server/Parallel Extender), Oracle 10g, IBM DB2, SQL, PL/SQL, UNIX Shell Scripting, Windows NT/2000, Clear Case/Clear Quest, IBM AIX 5.2, Autosys.

Confidential, Chevy Chase, MD

Datastage Developer

Responsibilities:

• Involved in meetings to gather information and requirements from the clients.
• Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to Teradata data warehouse.
• Gathered information from different data warehouse systems and loaded into Database using Fast Load, Fast Export, Multi Load, Bteq and UNIX shell scripts.
• Used the Ascential Datastage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Worked in the areas of relational database logical design, physical design, and performance tuning of the RDBMS.
• Worked extensively on different types of stages like Sequential file, ODBC, Hashed File, Aggregator, Transformer, Merge, Join, Lookup and for developing jobs.
• Used Parallel Extender for parallel processing for improving performance when extracting the data from the sources.
• Create master controlling sequencer jobs using the Datastage Job Sequencer.
• TEMPEffectively used Datastage Manager to Import/Export projects from development server to production server.
• Written K shell Scripts for getting data from systems to Data Warehousing system.
• Extensively used ETL to load data from Oracle 10g, XML files and Complex Flat files.
• Responsible for trouble shooting, identifying and resolving data problems, Worked with analysts to determine data requirements and identify data sources, provide estimates for task duration.
• Created Fast Load, Fast Export, Multi Load, Tpump, BTEQ scripts for Target Database.
• Used the Datastage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
• Scheduled jobs dependencies using Control-M Scheduler.
• Implemented Unit, Functionality, and Performance on Mappings and created Testing Documents.
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.

Environment: Ascential Datastage 7.5.1 (Manager, Designer, Director), Teradata V2R6, Tools & Utilities (BTEQ, Fast Export, Multi Load, Fast load, TPUMP), PL/SQL, Oracle 10g, Windows 2000/NT, Unix, Control-M Scheduling.

Confidential

Data stage Developer

Responsibilities:

• Developed ETL jobs to load data from SQL Server, DB2 databases, flat files to Target warehouse.
• Datastage was used to transform a variety of financial transaction files from different product platforms into standardized data mart.
• Optimized SQL Queries for maximum performance.
• Used Datastage Designer to develop the jobs.
• Worked with stages like Sequential file, hash file, Transformer, Aggregator, Sort and others.
• Used Datastage Director to execute the jobs.
• Wrote SQL *Loader script to load Inventory data into custom tables.
• Worked with Datastage Manager to export/import Datastage components.
• Experienced in developing test plans for data warehouse solutions.

Environment: Ascential Datastage 7.0.1 (Director, Designer, Manager), PL/SQL, IBM DB2, SQL*Loader, SQL Server 2000, Windows NT.

Confidential

ETL Developer

Responsibilities:

• Involved in creating entity relational and dimensional relational data models using Data modeling tool Erwin.
• Designing the Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage.
• Mapping Data Items from Source Systems to the Target System.
• Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Worked on programs for scheduling Data loading and transformations using Data Stage from legacy system to Oracle 9i using SQL* Loader and PL/SQL.
• Designing and Developing PL/SQL Procedures, functions, and packages to create Summary tables.
• 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 an ad hoc or scheduled basis).
• Worked with Datastage Manager for importing metadata from jobs, new job Categories and creating new data elements.
• Developing Shell Scripts to automate file manipulation and data loading procedures.

Environment: Datastage 7.0 (Manager, Designer, Director), ERWIN, Oracle 9i, PL/SQL, SQL* Loader, SQL Server 2000, Windows NT 4.0, UNIX.