Datastage Lead Resume Milwaukee,Wisconsin - Hire IT People

SUMMARY

Close to 9 years of extensive experience in IT with expertise in Software Analysis, Design and Development.
9 years of extensive ETL tool experienceinIBM InfoSphere DataStage9.x/8.x/7.x( Enterprise Edition, Parallel Extender) DataStage Designer, DataStage Director.
Good knowledge in Data Warehousing concepts with emphasis on ETL and Software Lifecycle.
Experience in stages related to hadoop like Big Data File Stage.
Good knowledge on hadoop HDFS and MapReduce.
Proficient in Data Warehousing techniques for data cleansing, SCD and Surrogate Key Generation.
Proficient in UNIX Shell scripting for automating files and scheduling batch jobs.
Experience in unit testing, system integration testing and maintenance.
Experience in developing complex parallel jobs, sequences and routines.
Experience in handling variety of sources/RDBMS such as Legacy Systems/ Complex Flat Files/Delimited Files/Teradata/Oracle/SAP Databases for extraction and loading.
Experience in unit testing, system integration testing and maintenance
Experience in writing complex SQL queries, PL SQL, Stored Procedures, Triggers and Debugging
Experience in tuning and troubleshooting parallel jobs with focus on partitioning strategies to address the production issues and performance enhancement
Certified in Datastage IBM 000 - 421, Teradata Foundation Level V2R5,ISTQB
Proven ability to take up challenging roles, perform in highly visible positions, work under pressure to meet deadlines and produce strong sustainable results.

TECHNICAL SKILLS

Etl Tools: IBM Web Sphere DataStage 9.1/8.7/8.5/7.5 EE,Quality Stage

Databases: Teradata,Oracle

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

Other Tools: IBM Infosphere Change Data Capture,Quality center, Control - M, Cognos, JIRA, Putty, IBM Rational Team Concert,CVS

PROFESSIONAL EXPERIENCE

Confidential

Datastage Lead

Responsibilities:

Designed DataStage jobs to capture data changes in oracle tables using CDC transaction stage.
Developed CDC subscriptions to replicate source and target systems.
Integration of Data from PMM application to downstream.
Created ETL coding and naming standards document.
Experience in hadoop flies stages of datastage to load data to the target hadoop system.
Experience in leading/managing a team of up to 10 members consisting of Development/Support.

Confidential

Datastage Developer

Responsibilities:

Developed DataStage jobs in Designer to extract data from the sources like Flat Files, EBCDIC Files Cleanse it; transform it by applying rules to cretae target files.
Review developers ETL code, database objects like one time inserts,Unit test document before migrating the code into QA and production environment.
Created Unix scripts to perform process control activities.
Worked on shared containers to apply common logic to multiple jobs.
Performing time to time analysis of performance of jobs and making performance tuning when required.
Working with DataStage Administrator to create/modify/delete projects and cleanup projects
Used Rational Team Concert (RTC) to maintain versions of code.

Confidential, Milwaukee,Wisconsin

DataStage Developer

Responsibilities:

Designed and unit tested Datastage jobs using SAP ABAP plug-in stage to load data from SAP tables into EDW stating tables.
Designed and developed Master controlling sequencer jobs using the DataStage Job Sequencer.
Created ETL design document and Source to Target mapping document
Derived low - level specs from the high-level specs for developers
Created design documents and unit test cases with test results documents.
Worked with DBA team to solve table space, index creation issues
Performed trouble shooting, maintenance and performance tuning of DataStage jobs and SQL queries.

Confidential

DataStage Developer

Responsibilities:

Responsible for understanding the Confidential communication Domain.
Developed DataStage 7.5/8.7 jobs in Designer to extract data from the sources like Flat Files, Delimited Files,Cleanse it; transform it by applying business rules and load (Initial/Incremental) into target DWH/Teradata.
Defined the business logic into the DataStage jobs as well as loading the data in Teradata.
Performed trouble shooting, maintenance and performance tuning of DataStage jobs and SQL queries
Experience with performance tuning and good knowledge of parallelism
DevelopedBTEQscripts to generae surrogate keys and load them to intermediate tables.
Implemented performance-tuning techniques along various stages of the ETL process
Extensively used Teradata Load Utilities such as Teradata BTEQ,Fast Load, MultiLoad for parallel loading
Good Experience with Control M for scheduling daily and monthly ETL jobs.
Designed and coded for reusable components and Error Handling.
Created Unix shell scripts to implement process control system.