Job Order #3090

Email this Job to a Friend
Posted Date: 5/16/2019
Job Category:
Position Title: Int/Snr DataStage Developer
Salary Range:
Location: Toronto, Ontario, Canada
Desired Skills:

• Design, develop and implement moderate to complex data transformation processes using DataStage that will migrate data from the existing data warehouse, and other enterprise data sources.
• Author technical documents (ETL Architecture, ETL Standards, ETL Design Specifications, ETL Work Flow, System Architecture)
• Work with the Architect to develop solutions to technical issues and design issues
• Follow established SDLC processes as well as enterprise policies and guidelines for software development
• Develop SQL scripts and stored procedures to augment the ETL process
• Develop Unix scripts to support the ETL processes
• Work closely with the business systems analyst to develop the source to target data mappings
• Play a lead role in the development of the ETL design document and transformation rules
• Conduct user interviews to validate the transformation rules.
• Play a lead role in the development of the design/technical specifications for the DataStage configuration.
• Work with the ETL Architect to provide input into technical issues and design solutions
• Participate in design and code walk-throughs
• Prepare run-books and ETL operations manuals for support personnel
• Design the ETL workflow processes
• Prepare and schedule the ETL workflow’s, using scripting where necessary
• Evaluate the data quality and provide written feedback to the client
• Assist in project sizing, resource estimates, scope and requirements for a variety of projects.
• Prepare and execute test cases for unit and system integration testing.
• Assist in designing logical and physical dimensional datamart models
• Develop and execute the implementation plan
• Performance tuning of ETL mapping and load processes, as required
• Troubleshoot code issues and provide timely resolution

• Identify and capture business accepted definitions for data models
• Design and develop the logical models for subject areas
• Integrate request from various business units and determine overlaps and impact to other business areas
• Interface with business and technical people in order to understand and integrate business needs from various business units, interpret those into technical design within the logical and physical data model
• Examine and enforce opportunities to provide data reuse
• Understand the logical and physical data model and be able to determine impact, design, and implementation scheduling
• Helps influence data policies on the management and usage of data

• 5-7 years’ experience as a DataStage Developer
• Experience designing, building, and implementing moderate to complex DataStage solutions
• Extensive knowledge of general warehousing theories and OLAP reporting
• Extensive knowledge of Ralph Kimball and Bill Inmon design theories
• Strong knowledge of dimensional and relational data modeling techniques
• Working knowledge of the UNIX operating system.
• Extensive experience developing complex SQL queries
• Experience with Unix shell scripting
• Experience with ERWin or another data modeling tool an asset
• Strong knowledge of dimensional modeling techniques
• experience with testing tools (ie: Test Director)
• experience with testing strategies and concepts
• DataStage certification an asset
• Ability to work with minimal direction and supervision
• Demonstrated ability to ‘get the job done’, take the initiative, and be an integral member of your team
• Excellent interpersonal, facilitation, presentation and communication skills
• The ability to communicate complex information and issues to all levels of an organization

• 5+ years’ experience data modeling
• Extensive experience with conceptual, logical, and physical data modeling
• Extensive experience with entity relationship design and modeling skills in an OLTP environment
• Strong experience with ERWin or a similar modeling tool

Share this job: