DataStage Developer Job Description
Datastage developer
provides input to DBA in modifying existing database structures for different types of databases (IMS, DB2, Oracle, SQL etc.).
DataStage Developer Duties & Responsibilities
To write an effective datastage developer job description, begin by listing detailed duties, responsibilities and expectations. We have included datastage developer job description templates that you can modify and use.
Sample responsibilities for this position include:
No less than 5 years IT experience in Design ETL solutions and data conversion strategy and solutions for multiple disparate systems using Oracle and Informatica
Create end-to-end solution for ETL transformational jobs that involve writing Informatica workflows and mappings, and creating database Packages, procedures and functions
Develop, maintain, and enhance Informatica Mappings, Work-flows, and processes
Support proper functioning and performance tuning of Informatica platform
Translate business requirements into functional / technical specifications
Designing and coding Datastage packages
Prepare root cause analysis documents, conduct code review, and test and tune the developed jobs
Provide inputs to testing strategy, configuration, deployment, hardware/software requirement
€¢ Identify avenues to improve project delivery parameters (eg productivity, efficiency, process, security etc) by leveraging tools, automation
€¢ Understand various technical tools used in the project (third party homegrown) to improve efficiency , productivity
DataStage Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for DataStage Developer
List any licenses or certifications required by the position: IBM, IHS
Education for DataStage Developer
Typically a job would require a certain level of education.
Employers hiring for the datastage developer 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, Information Systems, Technical, Management, Mathematics
Skills for DataStage Developer
Desired skills for datastage developer include:
Application design & development
Relational databases principles and structures
SQL
…
Informatica
DB2 zOS
Database and development methodology
Oracle databases
Principles
Desired experience for datastage developer includes:
Full time available with the intention to work for a long term
Keep eye on new tools/technologies in evolving big data landscape
5-8 years of Strong ETL Design and development skills
Tomcat Server
Analyze functional/non functional requirements and seek clarifications for better understanding of requirements
Based on understanding of system upstream & downstream, provide feedback and inputs on gaps in requirements and technical feasibility of requirements
DataStage Developer Examples
1
DataStage Developer Job Description
Job Description Example
Our company is looking for a datastage developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for datastage developer
- Develop DataStage Sequencers and Parallel jobs using different stages like Aggregator, Join, Merge, Lookup, Source dataset, External Filter, Row generator, Column Generator, Change Capture, Copy, Funnel, Short, Peek stages
- Work with the end user to get data requirements, performing complex data mapping and developing/maintaining ETL programs to support FCB's enterprise data warehouse
- Provide timely resolution for integration-related production issues, including root cause analysis and follow the change management procedures and policies
- Develop and maintain an integration component catalog
- Be part of a fast-paced team providing leading IT solutions to local enterprise clients
- May serve project team roles, such as project lead, business systems analyst, or technical lead, for small to medium efforts or manage phases of medium to large efforts
- Develops and implements program/system test plans
- Manage both employees and consultants on multiple ETL projects
- Interact with stakeholders for requirement
- Assist on support and enhancements modules
Qualifications for datastage developer
- Strong Experience in Data Stage
- Hands on / Exposure in other IBM InfoSphere products
- Able to manage 2-3 technical resources
- Exposure to Hadoop preferred
- Exposure in data modeling area
- Strong BI experience
2
DataStage Developer Job Description
Job Description Example
Our innovative and growing company is hiring for a datastage developer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for datastage developer
- HealthCare knowledge highly desired
- Must be able to work well with other teams
- Coordinate with the Multiple Source teams for the Input Files
- Understanding of source-to-mapping logic
- Technical ETL SME, liaises with the Business Technology teams - Dev Ops, DBAs, Architecture, BT Operations and Data Governance towards maintaining robust, secure and auditable ETL Development process in line with the overall software development lifecycle (SDLC)
- Acts as a self-starter on projects and facilitate technical sessions to gather relevant input required to proceed with the next steps towards finalization and completion of design and development work
- Challenges status quo and mentors DataStage development staff in terms of efficient Design reusable Development best practices for assigned projects and minimizing unfavorable work variances
- Provides DataStage tool administration functions over user maintenance, tool version control compatibility management by working with various technology vendors - IBM, Salesforce, Teradata etc
- Collaborates in Project Requirements (Business, Functional) sessions, translate them into technical requirements using High Level Solution (HLS) and forecasts development effort (Level of Effort) using standard template
- Guides staff in writing, testing and implementing ETL jobs using the latest and the greatest features offered by the DataStage tool without compromising the job performance
Qualifications for datastage developer
- 4+ years experience in Advanced InfoSphere DataStage Design and Development
- 4+ years in J2EE, JDBC, Java, JSP, XML, SOAP, EJB and WebSphere Application Development
- 3+ years in DB2 UDB Administration and Support
- 2+ years Report Solution/Design experiences
- 1+ year ServiceNow reporting
- Experience in Mortgage Industry
3
DataStage Developer Job Description
Job Description Example
Our innovative and growing company is looking for a datastage developer. 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 developer
- Provides Root Cause Analysis (RCA) for assigned technical issues, participates in company's Reliability process and provide solid updates related to assigned issues
- Leads and delivers solutions for complex enhancements of code and business projects independently
- Handles production support activities related to tickets analysis and process monitoring as appropriate
- Abides by our client's general Policy Procedures and Business Technology specific policy procedures and lives up to our client's core values
- To design, build, program ETL procedures (DataStage/Unix)
- Highly technical role requiring critical thinking, hands on development, and attention to detail from analysis through implementation and post-production QA
- Responsible for analyzing data requirements and developing ETL for clinical systems
- Assists in the identification and resolution of inefficiencies in ETL designs
- Determines and implements solutions for ETL design problems
- Analyzes the impact of source system data design changes as they relate to existing ETL solutions and makes appropriate changes to existing ETL solutions
Qualifications for datastage developer
- 5-7 years in IT specifically regarding Data Warehousing, ETL and Operational Data Store initiatives
- Expertise in Extraction, Cleansing, Validating and Integrating of data from multiple systems
- Hands on experience in Transforming Business specific rules into functional Specs
- Experience with Data Quality and how controlstieinto Data Quality
- Strong understanding of differences in various data quality controls
- Experience in writing Shell Scripts to automate file manipulation and data loading procedures
4
DataStage Developer Job Description
Job Description Example
Our company is looking for a datastage developer. 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 developer
- Develop ETL datastage jobs, SQL scripts, UNIX scripts and scheduling jobs
- Performs analysis to prevent data redundancy across systems and employs data integration best practices
- Performs data profiling, understands source data, and designs ETL solutions to accommodate any nuances that may exist
- Works with implementation team to ensure smooth deployment of packages and ensures resolution of outstanding issues
- ETL development using IBM DataStage
- Interface with the business analyst to define technical requirements
- Provide Production Support to the Daily / Monthly datastage Jobs Processing Cycles
- Implements coding practices consistent with defined conventions
- Develops and executes comprehensive test plans for system implementations
- Provides valuable insights in development code reviews
Qualifications for datastage developer
- 6+ years of software development experience demonstrating depth of technical understanding within Java
- Experience Datastage 11.3 and 8.7 is a must
- Strong experience with UNIX and shell scripting
- Minimum 4 years of development experience in Datastage (Version V8.5 or higher) with experience in processing high volume jobs
- Mastery level on Datastage 8.7 server and parallel versions
- Write ETL Technical Specifications
5
DataStage Developer Job Description
Job Description Example
Our growing company is looking to fill the role of datastage developer. 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 developer
- Performs unit and comprehensive testing for overall quality assurance of functional and technical quality of deliverables
- Defines and updates system tables as needed
- Tracks the project status and communicates status to scrum team as appropriate
- Maintains project issues log to track ongoing items for review and resolution by project team
- Alerts scrum team about out-of-scope work in a timely manner
- Works with scrum team to identify project deliverables and meets established deadlines
- Assists in developing standardized work processes, tools, and methodologies that improve quality and profitability
- Create Dev artifacts (Unit test case and Technical design document)
- Formulates and defines system scope and objectives through research and fact-finding to design, develop, modify, or integrate complex information systems • Devises or modifies application systems and procedures to optimize functional requirements including capacity, operating time, response time, and form of desired results
- Knowledge and good understanding of Best Practices in Database and DataStage development BHC Regulatory Reporting
Qualifications for datastage developer
- Knowledge on ETL estimation
- Knowledge on Cognos reporting added advantage
- 6+ years of software development experience demonstrating depth of technical understanding within BI/ETL technologies
- 4+ years experience with Datastage
- 6+ months experience with ilog rules engine
- 1+ years experience with web services such as SOAP or RESTful