DataStage Developer Job Description
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:
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:
Desired experience for datastage developer includes:
DataStage Developer Examples
DataStage Developer Job Description
- 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
- 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
DataStage Developer Job Description
- 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
- 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
DataStage Developer Job Description
- 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
- 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
DataStage Developer Job Description
- 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
- 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
DataStage Developer Job Description
- 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
- 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