Sr Datastage Deve l oper Resume

SUMMARY

Ov er 5.5 year s o f exp erienc e in the IT ind ustr y with spec ial iz ation in Data Wareh ou sin g and Busin ess In tellig ence. Vast experience in Analysis, design, development, testing and implementation of Business intelligence solutions using ETL Design. Curr ently w or kin g as Senior ET L De vel oper for Confidential C onsultanc y Ser vi ces.
Extensive development experience in Datastage, Uni x Shell Scri p tin g an d SQL.
Sound kno wledg e of pharmacy retail, supply chain management, contract pharmacy arrangement, health care, OPA regulations and reporting .
Strong knowledge of dataware housing concepts and data Modelling guidelines.
In - depth expertise in analysis, design, development and management of solutions to achieve business critical objectives.
Extensive experience with complex ETL implementations like external subroutines, external target stage, undefined structures, row level loops, nested execute command activity, Data profiling.
Specialized in tuning datastage and SQL workloads and perform optimization in existing workflows
Fair kno wledg e of Tableau 10.2.1, Business Objects XI and Informatica.
Experience in Datastage /AIX upgrade from 8.0 to 9.1 with minimal downtime and major issues.
Good verbal and written communication skills. Strong analytical abilities.
Solution-oriented with strong sense of responsibility.
Strong zeal to learn new technologies and improve technical skills.
Ability to effectively handle multiple initiatives at once in a calm and effective manner.
IBM Certified Solution Developer - InfoSphere DataStage v8.0 Certified
Have attended introductory course on Ab initio and Big data
Won on the sport award thrice.

PROFESSIONAL EXPERIENCE

Sr Datastage De ve l ope r

Confidential

Responsibilities:

Meet wi th bu sin ess us ers t o und erstand the busin ess p rocess and gather require ments.
Prepare Hig h Le vel D esig n Do cu men ts.
Rev i ew Data mapping, Desi gn Do cu men ts, T est Strate g y, Unit Test Case s, and Sys tem Te st Ca ses.
Wo rk with offsh ore tea m t o de vel op o ptim iz ed Data stage c ode.
Rev i ew Test Resul ts
Involved in migration from datastage 8.0 to Datastage 9.1
In vo l ved in pr oduction depl oy ment proc ess.
Ensu re c ode versi on c ontro l usi n g GIT
Ensu re docu men t v ersi on c ontrol usin g Sh arep oint.
Su bmit j obs f o r scheduli n g u sin g ESP sch edu ler.
Pro duc tion sup p ort
Providing functional, architectural and technical guidance to team members
Solving queries of business by applying analytical and functional skills.
Analysis and solving of complex application issues, data issues and environment issues.

Sr Datastage De ve l ope r

Confidential

Understand business requirements and prepare low level design documents.
Develop data stage code to achieve critical business objectives.
Prepare Test Strategy, Unit Test Cases, and System Test Cases.
Perform Unit Testing and System Testing.
Ensure document version control using Sharepoint.
Create jobs for scheduling using ESP scheduler.
Designing and implementation of code in most optimal way

TECHNICAL SKILLS

ETL Tools: Datastage 9.1, Datastage 8.5, Informatica, Tableau 10.2.1

DB Tools: Oracle SQL Developer, MySQL, SQL, PL/SQL

Languages: UNIX Shell Scripting

Platforms: UNIX, Linux, Windows

VISA STA TUS: Visa Type H1-B

Valid Until: Oct 6, 2017

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship