DataStage Job Description
Datastage
provides overall design principles and standards to guide development of all components using DataStage.
DataStage Duties & Responsibilities
To write an effective datastage job description, begin by listing detailed duties, responsibilities and expectations. We have included datastage job description templates that you can modify and use.
Sample responsibilities for this position include:
Plan and Lead ETL development projects including strategic Architecture, design, and implementation
Work in a data warehouse environment which includes data design, database architecture, metadata and repository creation
Analyze architecture blueprints and design plus build integration flows using the IIS Datastage platform
Oversee creation and approval of technical documentation including the Solution Definition document and Technical Design document
Provide expert level for ETL design, development, performance management and administration support
Supporting integration and tuning connections with data sources such as, Hortonworks, SalesForce, DB2, Oracle, SQL Server and Essbase
You will be challenged with design and develop new software applications
Work independently on complex processes and modules that may be used by programs, systems or in support of infrastructure component change management and coordinate with extended team to fix complex issues
Serve as a team member on 6 Sigma projects
Proficient in using “Remedy” incident management tool
DataStage Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for DataStage
List any licenses or certifications required by the position: IBM, IHS
Education for DataStage
Typically a job would require a certain level of education.
Employers hiring for the datastage job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Engineering, Business, Information Technology, Science, Technical, Information Systems, Mathematics, Graduate
Skills for DataStage
Desired skills for datastage include:
SQL
Relational databases principles and structures
Application design & development
Information Analyzer
Performance and tuning experience
Business Glossary
Metadata Workbench
Advanced SQLs
Data loading techniques using Datastage
Design
Desired experience for datastage includes:
Plan and Lead development projects including estimating work effort, understanding cross-project dependencies, resource planning, infrastructure planning
Prepare regular status reports, presentations of designs, and participate in architecture reviews
Experience with production support procedures and practices in a large data warehousing environment
Extensive knowledge of working in a demanding environment, responding to client requests, and working with inside and outside stakeholders
Knowledge of a scheduling tool, AutoSys would be of great benefit for this role
Ability to work with team members that are geographically separated
DataStage Examples
1
DataStage Job Description
Job Description Example
Our company is searching for experienced candidates for the position of datastage. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for datastage
- Serve as a Tech Lead on multiple, large integration and data publishing projects or as a project lead on smaller projects, ensuring consistent design and efficient data processing
- Design and develop innovative data solutions for demanding business situations
- Pocess good knowledge of PL/SQL / Stored Procedures , DB2
- Collaborate with enterprise architects and IT project managers to enhance existing business applications and facilitate solutions to meet business requirements
- Technically own and manage the process of ensuring timely build of the various elements of the solution
- Contribute to SDLC and QA teams to establish best practices implementation of methodologies and toolsets
- Function as a senior TSA/Development Lead on new initiatives (small to large of varying complexity)
- Review, research and analyze business and system needs, explore alternative options to recommend technology solutions and designs that meet sponsor needs and PLC deliverables including component reusability, data sharing and security
- Work on development and enhancement projects and follow and enforce development, architecture and infrastructure standards
- Support technical component upgrades for DataStage, Database, Application Servers
Qualifications for datastage
- Demonstrated understanding of source-to-mapping logic
- Demonstrated aptitude for troubleshooting technical issues
- At least 3 years experience in desarrollando con ETL DataStage
- Install/upgrade Information Server product suite on different tiers (Server and Client)
- Possess at least 4 years experience in a Support Analyst role
- Understand the varying demands across stakeholders, appreciation of operations support as a critical component of business delivery
2
DataStage Job Description
Job Description Example
Our innovative and growing company is looking for a datastage. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for datastage
- Review technical deliverables and guide developers to complete ETL application development tasks
- Work with upstream and downstream applications to define dependencies, interfaces, data formats
- Collection of requirements
- Participate in off hours production support on revolving basis
- Respond to scheduled and ad hoc requests for off hours resolution of production problems
- Designing ETL solutions with Auditing and Efficient error handling
- Responsible for the documentation and maintenance of new and existing Extract, Transform, and Load (ETL) processes within the Enterprise Data Warehouse
- Lead the Build, Testing and Implementation phases of assigned projects, with a diverse development team spread across multiple locations and time zones
- Perform process improvement and re-engineering with an understanding of technical data problems and solutions as they relate to the current and future business environment
- Participates in 24x7 production support rotation
Qualifications for datastage
- MDM (Master Data Management) experience will be an added advantage
- Data Specialist with experiencie mainly in ETL DataStage
- Experiencie mainly in ETL DataStage
- Experience with additional industry standard ETL tools (Pentaho, Informatica)
- Experience working with business stakeholders to define business KPIs, participating on client engagement activities such as project presentations and client workshops
- Document Runbooks for the installs, Disaster Recovery plans
3
DataStage Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of datastage. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for datastage
- Should able to articulate/communicate with onshore team as required
- Work on production issues
- Must have overall 3 to 5 years of IT experience in software development
- Hands on experience with Datastage/ETL over 3 years
- Hands on production suppport experience over 1 year
- Experience working with IBM financial data model
- Team leading experience maintaining SLAs and KPIs
- Develop, debug and unit test
- Meet SLAs and project metrics
- Be available for on call support and Shifts
Qualifications for datastage
- Stop/start services, monitor logs, setting up security, assigning roles, and project permissions, create/delete projects, create/modify environmental parameters
- Experience with SuSE Linux Knowledge of Information Server Architecture (SMP, MPP, different tiers)
- Experience handling multiple tasks and to work independently in a team, experienced in interacting with Business/Technology group
- Experience with Hadoop, Cloudera/Navigator, or any Big Data technologies will be a big plus
- Knowledge of Data Warehouse Architecture, Star Schema, Snow flake Schema, Fact tables and Dimensional tables
- Must have at least 1 year of technical working experience in the development & support of relational databases like DB2 10.1 and/or Oracle 11i
4
DataStage Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of datastage. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for datastage
- Creating quality documentations (Design, Unit test plans, Operations Guide)
- Must have experience in Agile and Scrum methodologies
- Regular tasks include supporting IT processes such as Application Monitoring, Incident Management, Problem Management, Request Management, and Security Management
- Resolve incidents, manage changes, and monitor change implementation in the production environment
- Manage strict security and control requirements for sensitive/confidential financial data across the portfolio, which includes support of ACR, SCRP, and MCRP input to business as necessary
- Collaborate closely with Operations Support staff and Application Development teams to work through the technical aspects of application support activities
- Analyze business requirements and prepares technical specification for various project processes and creates high-level and low-level ETL flow diagram in Visio and provide detailed level work estimates
- Coordinating activities with the functional and technical teams, working with the business partner and directing the development activities
- Has extensive knowledge using DataStage ETL tools (v8.x or 11.x) and various database platforms
- Prepare technical documentation and mapping documents (Excel/Word) for project processes into datamarts and various types of applications
Qualifications for datastage
- Must have at least 1 year of technical working experience with DataStage and QualityStage version 9.1 or higher
- Must have demonstrated exceptional written and verbal communication skills to ensure requirements are clearly, accurately and thoroughly documented and understood, either for system changes or process changes
- Possesses the vision and innovative approach to computer based solutions and ability to convey these ideas
- Must have hands-on technical working experience with UNIX/AIX korn shell scripting
- Working experience of IT platforms that support the banking/financial industry’s compliance or regulatory systems would be an asset
- Along with the Business Analyst, gather requirements (functional and nonfunctional) from customer
5
DataStage Job Description
Job Description Example
Our company is hiring for a datastage. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for datastage
- Developing the deployment plan and facilitating UAT and production code migrations
- Analyzing and interpreting business requirements/workflows
- Supporting project deployments
- Assisting others on issues, critical situations to meet project objectives
- Work with the end user to get data requirements, performing complex data mapping and developing/maintaining ETL programs to support enterprise data warehouse
- Designing and Developing DataStage ETL models, and working closely with the Data and Platform Architects to ensure designed BI solutions meet end user requirements
- Participate in Production Support (on-call rotation) for the BI Platform
- Legacy system support for Oracle Warehouse Builder jobs, Talend jobs and Business Objects reports
- Work closely with external partners and integration of data feeds into existing data models
- Identify current and emerging technologies that define BI Architecture *Best Practice.*
Qualifications for datastage
- 2-4 years of experience in writing database procedures, functions and fine-tuning SQL for performance optimization
- Analyze requirements for feasibility with regards to testing and implementation
- Provide inputs for requirements prioritization
- Debrief team on the requirements gathered and seek feedback
- Participate in client calls and seek clarifications if any
- Create and maintain requirements traceability matrix along with BA