Hi,
Hope you are doing good.
Please go through the below requirement and send me your updated resume
Position:
Datastage Developer
Location:
Kansas City, MO
Duration:
3 Years Project
VISA:
No Constraints
No
# Positions: 5
Interview mode: Video WebEx
1 junior level openings (0-3 years of experience)
3 mid level openings (4-7 years of experience)
1 senior level opening (10+ years of experience)
Technical
Environment: IBM Datastage 11.5, IBM DB2, SYBASE, SQL Server, IBM Data Studio,
Advanced Query Tool, Putty (Unix Shell Scripting), ASG – Zena for scheduling,
MS Visual Studio, ServiceNow
Qualifications:
Experience working with Datastage 11.5, experience working with both parallel
and server jobs. Experience with Unix scripting, SQL and job scheduling
tool. Prior healthcare experience desired.
Datastage
Developer Day to Day Responsibilities:
- Involved in gathering
requirements from the business users and design of object mappings based
on functional document.
- Develop the interfaces using
the ETL tool IBM Infosphere Data stage 11.5 with DB2 as Data Source/target
- Prepared the Technical
specification document for developing Data stage jobs.
- Developed shell scripts as per
the business logic.
- Reviewing the code, UAT with
Datastage Architect and getting signoff from Business System Analysts
- Developed DataStage jobs using
Lookup stage for Range Lookup.
- Created Job parameter sets for
reusing the parameters.
- Use Resource Estimation feature
of DataStage to implement ETL solutions with good performance.
- Update existing DataStage jobs
to accommodate changes requested by users.
- Deploy the interfaces to Test,
Stage and Prod and job monitoring
- Perform unit testing for jobs
and scripts to validate the data and prepare jobs checklists to validate
the user requirements.
- Working with CLAIMS and
MEMBERSHIP data. Processing member data to the data warehouse and
then processing claims data after mapping members to claims tables in
warehouse.
- Responsible for developing
various complex Datastage jobs both Parallel and Server jobs for
processing Claims, Membership and other data.
- Work to extract data from
various source databases like DB2, SYBASE, SQL Server and used various
complex transformation and load data into various target DBs.
- Working extensively with Flat
files (Fixed width and delimited), Web Service calls (SOAP and Rest), XML
files and Hashed files in server jobs.
- Design various sharable
components like Shared Containers, custom build routines and Transforms.
- Working in generating EOBs
(Explanation of benefits), one of its kind of complex process designed in
Datastage.
- Highly competent in working in
Unix scripts and implementing them in Datastage.
- Worked on enhancement of
Datastage framework in which every developer need to fit in their jobs and
which helped in easy debugging and let anybody follow the flow of data.
- Worked on all the SDLC phases
of the project in this team. Followed Agile methodology.
- Worked with SAP business
objects team and helped them in developing the reports and with cooking
data for them.
- Gathering Requirements, Estimation,
creating related documents in all SDLC project phases, creating data
model, development in IBM Data stage to populate DWH and DM, creating Unix
shell scripts, ensuring project deliverables for smooth rollout to
production environment, production support, Transition to support team are
some of the task I performed in this project.
- Worked on job scheduling using
Zena tool and designed various complex scheduling techniques, some of them
were custom build.
Regards,Ramesh,
HYR Global Source Inc | AN ERP Consulting Corp
Mail to:
r...@hyrglobalsource.comWork:
617-418-4173