Job Summary

Datastage Developer

  • Location:
    Pleasanton , California
  • Category:
    Information Systems
  • Contract Type:
    Contract/Temporary
  • Job reference:
    US_EN_6_17195_57508168

**Please call Aparna Sreeraman at 415 228 4275 if you have any questions about the opportunity or email Aparna.sreeraman at modis.com**
Role: Data Integration Developer
Location: Pleasanton, CA
 
Technical Knowledge and Skills:
• Extensive hands-on experience in building ETL interfaces using Datastage version 9.1 and higher version to aggregate, cleanse and migrate data across enterprise-wide MDM, Big Data, and Data Warehousing systems using staged data processing techniques, patterns and best practices.  Working knowledge and experience on DataStage 11 is a plus.
• Strong experience in full life cycle management of capturing, versioning and migrating various Datastage ETL metadata including data mapping and other data integration artifacts (such as schedulers, scripts, etc.) across environments using vendor platforms such as Data Stage,  or other equivalent tools (including open source) by establishing standards, guidelines and best practices.
• Combined experience of advanced SQL and stored procedures (in DB2, SQL Server, and/or Oracle Database Platforms) with hands-on experience of designing solutions for optimal performance and handling other non-functional aspects of availability, reliability and security of DATASTAGE ETL Platform.
• Proficiency on working with Unix and Linux servers, jobs scheduling, as well as script languages such as C, shell script (sh), AWK, and sed.
• Experience with both normalized and dimensional data models, hands-on knowledge of other data integration techniques such as database replication, change data capture (CDC) etc. and familiarity of SOA and ESB technologies and patterns.
• Technical knowledge in predictive analytics architecture and in development and deployment of predictive models is a plus.
 
Demonstrable Skills:
• Strong analytical skills with the ability to analyze information identify and formulate solutions to problems. Provides more in-depth analysis with a high-level view of goals and end deliverables.
• Over 5 years of proven work experience in DataStage version 9.1 and 11. Over two years of DataStage version 11.0 is a plus.
• Over 3 years of proven work experience on scripting languages such as Perl, Shell, and Linux/Unix servers, files structure, and scheduling.
• Complete work within a reasonable time frame under the supervision of a manager or team lead.
 
Deliverables:
• Recommend the good practice on ETL process to extract data from disparate source transaction systems, transform and enrich the data, and load it into specific data models that are optimized for analysis and reporting.
• Facilitate the best-in-class data integration platform.
• Recommend and implement the plan for DataStage version upgrade from v. 9 10 v. 11.
• Recommend the training and mentoring plans for the transition of knowledge to current employees.
 


Apply Below

OR

Note: Required fields marked with an asterisk (*).

*
Greeting



*
*
*
*
*
*
Primary Number
*
*
Preferences
[Ctrl (Cmd Mac) + Click] to select multiple industries
Upload your resume
*
Terms of Use
*

Or

Upload your resume using

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.

Equal employment opportunity information:
EEO is the Law (poster) | EEO is the Law (poster supplement) | Reaffirmation of Affirmative Action Policy Statement