TEKsystems is partnering with multiple companies in both Missouri and Kansas that are looking for DataStage Developers and Lead DataStage Developers for multi-year contracts.

ETL and Data Integration
Unix scripting
Data Warehouse
SQL Server


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.

Processing member data to the data warehouse and then processing claims data after mapping members to claims tables in warehouse.

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.

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.

About TEKsystems:

We’re partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That’s the power of true partnership. TEKsystems is an Allegis Group company.

More Jobs: