Post Job Free

Resume

Sign in

ETL Datastage Developer

Location:
Bellevue, WA
Posted:
May 23, 2018

Contact this candidate

Resume:

PADMAPRIYA A

***** ** **** *****

Email: ac5kk8@r.postjobfree.com

Bellevue, Washington-98005 Mobile: 425-***-****

Profile Summary

A technically competent professional with 4 years of Work- experience Development of DataStage jobs.

IBM Certified Solution Developer – InfoSphere DataStage v8.5

Extensive knowledge of the most advanced tools and applications aiding the execution of DataStage design and development functions.

Having experience on scheduling tool Autosys

As an ETL Developer designed and created ETL jobs for more processes to move data from source to reporting data.

Strong knowledge of data warehousing, data modelling and other concepts

Knowledge on SQL/PLSQL

Learning UNIX operations and have worked over in Agile/ Waterfall level Project Developments.

Educational Summary

Bachelor of Engineering from Anna University (2006-2010) with 82% Aggregate.

Professional Summary

4 Years of IT experience in designing, developing and documenting software

Applications using ETL_Datastage technologies.

Worked in DWH Framework.

Worked in ETL Technologies (ETL_Datastage).

Worked in Clearcase Tool.

Worked in Autosys Scheduler.

Work Summary

Worked as an Associate for Cognizant Technology Solutions.

Duration: Nov 2014 to April 2015

Worked as a System Engineer for IBM India Pvt Ltd.

Duration: May 2011 to Oct 2014

Technical Exposure

Operating Systems : Windows XP.

Programming Languages : C, C++, CORE JAVA

Database Servers : Netezza, DB2, Oracle 10g.

Tools : IBM.Datastage v 8.5, Autosys, Clearcase, FastTrack

PROJECT PROFILE-1

Project title : AETNA HEALTHY APPLICATIONS

Platform : ETL-Datastage.

Domain : Healthcare

Tools : ETL Datastage v 8.5.

Duration : Nov-2014 to April-2015

Brief Description:

A new web application, AHA, which is intended to be used on mobile devices, will interact with an application volume purchasing process to enable eligible members the ability to download applications to aid in a member's health and wellness. AHA will interact with the registered members via email to notify them of applications which are available for them to download. Members will be required to complete a Survey prior to redemption of the application.

Responsibilities:

Worked in Architecture and Design and Process flows.

Involved in every phase of the ETL process starting from Analysis to Implementation

Translated the Business requirements into ETL Parallel jobs that maximize object reuse, parallelism, and performance

Worked on different stages like Transformer, Join, Sort, Lookup, Filter, Aggregator, Funnel, Remove Duplicates, Difference, DB2 Connector, Dataset

Reduce Job dependency and Complexity to ensure future modifications.

Unit Testing.

Fix bugs as reported by testers/costumers.

Deployment.

PROJECT PROFILE-2

Project title : Bank of America-RDS-DI

Platform : ETL-Datastage.

Domain : Banking

Tools : IBM.Datastage v 8.5.

Duration : August-2012 to Oct-2014

Brief Description:

Bank of America is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. It is the second-largest bank holding company in the United States by assets. We are providing them Data Integration Services in our project.

Responsibilities:

Involved in the analysis of existing Mainframe process flow & preparing Low level & High level design documents.

Involved in every phase of the ETL process starting from Analysis to Implementation

Translated the Business requirements into ETL Parallel jobs that maximize object reuse, parallelism, and performance

Worked on different stages like Transformer, Join, Sort, Lookup, Filter, Aggregator, Funnel, Remove Duplicates, Difference, DB2 Connector, Dataset

Involved in Clearcase deployment

Worked on scheduling tool AUTOSYS by preparing JILS

PROJECT PROFILE-2

Project title : ACAPULCO BI.

Platform : ETL-Datastage.

Domain : Telecom

Tools : IBM.Datastage v 8.5.

Duration : July-2011 to August-2012

Brief Description:

The Project Acapulco has been initiated with a major aim of growth of revenue and market share of IUSACELL. The Business Intelligence Project has been undertaken to leverage the valuable information gathered by the business processes and help the Management and Executive committee to make the right business decisions to achieve business targets.

Responsibilities:

Implementing the logic using datastage parallel and sequential jobs which included several stages like database, dataset, pivot, funnel, filter, sequential file, lookup, External Source, transformer, join, Merge, Start & End loop, User Variables, Remove duplicates, DB2 connector, shared & local Container etc.

Implementing Multiple Instance Jobs

Preparing the test cases according to the analysis done for developing the datastage jobs.

Involved in the unit testing of the code on the Development server.

Involved in handling the issues while UAT of the code.

Handled the production implementation of the code.

Declaration:

I here by declare that the above details furnished are true to my knowledge and I have the relevant records to prove the same, I hope the above are suitable for your organization.

Place: (PADMAPRIYA.A)

Date:



Contact this candidate