Datastage Resume Samples
4.7
(92 votes) for
Datastage Resume Samples
The Guide To Resume Tailoring
Guide the recruiter to the conclusion that you are the best candidate for the datastage job. It’s actually very simple. Tailor your resume by picking relevant responsibilities from the examples below and then add your accomplishments. This way, you can position yourself in the best way to get hired.
Craft your perfect resume by picking job responsibilities written by professional recruiters
Pick from the thousands of curated job responsibilities used by the leading companies
Tailor your resume & cover letter with wording that best fits for each job you apply
Resume Builder
Create a Resume in Minutes with Professional Resume Templates
CHOOSE THE BEST TEMPLATE
- Choose from 15 Leading Templates. No need to think about design details.
USE PRE-WRITTEN BULLET POINTS
- Select from thousands of pre-written bullet points.
SAVE YOUR DOCUMENTS IN PDF FILES
- Instantly download in PDF format or share a custom link.
LL
L Luettgen
Lera
Luettgen
6769 Abshire Squares
Detroit
MI
+1 (555) 396 3495
6769 Abshire Squares
Detroit
MI
Phone
p
+1 (555) 396 3495
Experience
Experience
Philadelphia, PA
Datastage / ETL DBA
Philadelphia, PA
Langworth, Schultz and Abernathy
Philadelphia, PA
Datastage / ETL DBA
- Provide infrastructure operations, support and administration of the 8.5, 9.1 and 11.3 DataStage environments
- Support and troubleshoot production incidents/problems, optimizing performance
- Kill/assist release job locks, shared memory locks, hung processes, etc
- Post install Configuration, various data sources configuration for the plug-ins, connectors as well as ODBC configurations
- Stop/start services, monitor logs, setting up security, assigning roles, and project permissions, create/delete projects, create/modify environmental parameters, etc
- Document Runbooks for the installs, Disaster Recovery plans, etc
- Monitor the InfoSphere suite (Data Stage/Quality Stage/Information Analyzer) servers
Philadelphia, PA
Datastage Administrator
Philadelphia, PA
Sauer-Wintheiser
Philadelphia, PA
Datastage Administrator
- Provide technical expertise and development support for the ETL development team
- Assist and provide input to various teams on action plans for refreshes, loads, report performance and other data warehouse related issues
- Perform a lead role in the development, planning, preparation and ongoing disaster recovery readiness
- Responsible for performance metrics reporting. Contribute to establishing best practices
- Advanced working knowledge of environment, capacity and performance monitoring, system-level and application-level MDM administration activities
- Assist trouble shooting any problems or incidents that occur with the EIM software
- Reviewing and managing ILMT (IBM Licensing Management Tool) reporting
present
Boston, MA
Infosphere Datastage Administrator
Boston, MA
Schuppe Group
present
Boston, MA
Infosphere Datastage Administrator
present
- Stop / start services, monitor logs, create/delete projects, create/modify environmental parameters etc
- Evaluate system specifications, working parameters for hardware / software compatibility
- Comply with standards and guidelines related to the design, construction, testing and deployment activities within the Delivery Management environments
- Install IBM Information Server product suite, post configurations including configuring database native connectivity and ODBC connections and parallel database reads and writes
- Works with minimal guidance; seeks guidance on only the most complex tasks
- Create documentation for the installs, upgrades and regular maintenance
- Resolving ETL DataStage performance issues
Education
Education
Bachelor’s Degree in Computer Science
Bachelor’s Degree in Computer Science
San Diego State University
Bachelor’s Degree in Computer Science
Skills
Skills
- Capability build-out
- Performance Management and Employee Engagement/Development
- Experience in working with Vendors
- Experience in working in matrix operating model
- Managed team size of up to 15 members including Employee and Contractor
- 10+ yrs Relevant IT software experience in IBM IIS Datastage-System Engineering on Linix Platform
- Issues resolution and manage escalation
- Stakeholder reporting
- Presentation and reporting
15 Datastage resume templates
Read our complete resume writing guides
1
Datastage Extract, Transform, Load Developer Resume Examples & Samples
- At least 6 months experience in understanding of data warehouse processes
- At least 6 months experience in ETL Development
- At least 6 months experience in technical requirements definition and data mapping (source to target)
- At least 6 months experience in hands-on technology experience in Data Warehouse projects
- At least 6 months experience in hands-on developed project deliverables using formal/structured methodology
- At least 6 months experience in understanding of Datastage tools
2
Datastage Administrator Resume Examples & Samples
- Functions as administration support and insures availability and proper performance for shared platforms. Ensures that projects follow the prescribed development life cycle and meet quality standards
- Develops architectural plans supportive of the business objectives of the application area
- Maintain system reliability and availability by managing system updated and patches
- Participates in 24x7 production support on-call rotation
- Function as a technical expert in problem resolution for DataStage issues
- Other duties as required
3
Datastage Administrator Resume Examples & Samples
- Experience on Installation and Administration in IBM InfoSphere Suite (DataStage, Information Analyzer, QualityStage, Business Glossary)
- Experience on ETL Datastage Administration on windows and UNIX environment
- Experience of Code migration through Copy Folder / Export and Import of Objects/ Deployment groups Experience in the Meta data Management
- Configure security for the Users and User groups, providing resolution for the issues raised by the users, involved in
- Setup and support deployment of IBM Datastage V8.1/V8.5 on IBM-AIX environment
4
IIM ETL Datastage Ops Support Resume Examples & Samples
- Managing Macquarie's technology infrastructure
- Supporting, maintaining and enhancing existing business systems
- Delivering and deploying new systems, technologies and services
- Ensuring all technical hardware and software is provided to all users
- Operates the ITG helpdesk which provides IT support to all users
5
Solutions IT Designer / Datastage Resume Examples & Samples
- IBM Information Server (DataStage) hands on coding experience
- Knowledge of MQ
- Knowledge of Oracle 12C, Oracle RAC & DB2 for zOS
6
Datastage Application Developer Resume Examples & Samples
- 1) Development & Enhancement of new/existing functionality as per business requirements
- 2) Run Control of Daily Datastage job runs
- 3) Implementing solutions to fix the production job failures
- Candidate must be able to translate functional designs into technical designs and code
- Datamart - ETL development (Extract transformation and Load)
- UNIX and scripting, AIX and IBM InfoSphere DataStage knowledge
- Nice to have PLI Cobol knowlegde
7
Datastage Application Developer Resume Examples & Samples
- Hungarian: fluent
- Mainframe, MVS
- UNIX/AIX
- Team player and flexible in the daily work
- We work in an agile approach
- Eager to learn new and other technical skills
8
ETL Datastage Resume Examples & Samples
- 5-8 years of Strong ETL Design and development skills. Deep expertise on ETL architecture and solutions providing experience
- Good knowledge and experience in UNIX/LINUX scripting, Oracle SQL and AUTOSYS scheduling tool
- Quick learner and self starter who requires minimal supervision to excel in a dynamic environment
- Coordinate and Work closely with Technology Infrastructure Teams, Development & Testing Teams throughout the project life cycle
- Prior experience implementing process improvements in ETL applications
- Willingness to train/coach/mentor junior resources
- Knowledge in other ETL tools like Informatica, Ab Initio
- Exposure in Data modeling and designing
- Basic knowledge in Teradata
- Exposure to various platforms and technologies: Analytics, Hadoop, Java, .Net, SharePoint
9
Datastage ETL Developer Resume Examples & Samples
- Proven experience designing and building integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.)
- Performance tuning of end-to-end integration processes within Datastage sequencers or in the source/target database endpoints as needed
- Collaborate with ETL Team on solutions
- Strong problem solving, analytical and interpersonal skills
- RDMBS database skills, including complex SQL constructs and DDL generation
- Ability to communicate effectively orally and in writing, to design, develop, test, debug, and maintain application programs
- Must be able to work independently, while guiding and assisting other development team members as needed
- Determine optimal approach for obtaining data from diverse source systems
- Assist in the development process Create Datastage Jobs and Sequencers
- Create Shell Scripts for automation
- Co-ordinate Data Modeling of Sources and Targets
- Create Source to Target Mapping Specifications
- Conduct Unit Testing and create Unit Testing Results Documents
- Provide Support for QA/UA Testing
- Assist Migration of code to Production
- Provide Warranty Support
- 6+ years of experience - large global companies preferred
- 4+ years of ETL development experience using Datastage and Oracle 10g/11g and using Industry best practices
- Experience in any of Scheduling Tools - Tivoli, Autosys, Ctrl-M
- Assist in the development process - Create Datastage Jobs and Sequencers
- Excellent understanding of data warehousing concepts
- Ability to present technical concepts to senior level business stakeholders
- Knowledge of Teradata Database
- Knowledge of Teradata BTEQ scripts
- Knowledge of Teradata utilities such as TPump, fast load, fast export
- Experience in Oracle database programming using Partitioning, Materialized View and OLAP
- Experience with data warehouse designing, building, installing, configuring and supporting
10
Senior Solution Engineer, IBM Datastage ETL Resume Examples & Samples
- Responsible for supporting and leading delivery of development services
- Identifies key drivers of a defined problem and proposes solutions
- Identifies and solves problems using analysis, experience, and judgment
- Experience designing, building, unit testing and deployment of ETL jobs built using IBM DataStage 9.1
- Ability to pull client source data into data warehouse to create reports
- Exposure pulling data from multiple sources including: xml, web services, delimited flat files, and other data sources
- Experience translating functional ETL requirements into technical design documentation
- Very strong skills with dimensional modeling concepts and ability to write complex MS sequel queries in Microsoft SQL Server 2012/2014
11
Datastage Administrator Resume Examples & Samples
- Supports the installation, configuration, and maintenance of purchased applications or application frameworks
- Supports processes for installing, configuring, tuning, and maintaining application systems
- Participates in testing and installing new software releases, and application system upgrades
- Assists with monitoring and fine-tuning the application system to achieve optimum performance levels
- Maintains a comprehensive operating system hardware and software configuration database/library of all supporting documentation
- Assists with application system problem resolution by working with application developers, vendor, and internal infrastructure team members to troubleshoot
- Our current environment includes tools such as the IBM Information Server Suite, IBM Data Governance tools, and SAS, and will soon include both new geospatial (ESRI) and analytics tools
- At least 5 years of administration experience
- At least 5 years of DataStage experience
- Software distribution
- IT service change management
12
Datastage Applications Developer Resume Examples & Samples
- Analysis and trouble shooting of all ETL/Bi Reporting/workflow technology issues encountered by the multiple Optum business groups
- Analyze user requirements and procedures to improve existing systems
- Review computer system capabilities and work flow in order to determine appropriate upgrades and improvements
- Review, analyze, and modify programming systems including encoding, testing, debugging, and installing for a large-scale computer system
- Evaluate system specifications, input/output processes, and working parameters for hardware/software compatibility
- Provide expertise in software systems programming, operating software applications and overall operating systems
- Prepare root cause analysis documents, conduct code review, and test and tune the developed jobs. Duties are performed utilizing UNIX/LINUX /Wintel OS, UNIX/LINUX Scripting, Oracle/SQL, Teradata, PERL, Datastage Parallel Extender, Java, Tomcat server, Toad, SAS, MS SSIS/SSRS, Microstrategy and Serena workflow technologies
- · Submit and Monitor Health Plan Manager(HMA 2.0) dataloads
- Bachelor's Degree OR High School Diploma/GED with Datastage Parallel Extender experience
- 3+ years of Datastage Parallel Extender experience
- 3+ years of Oracle/SQL experience
- 3+ years of UNIX/Linux OS experience
- 3+ years of Windows OS experience
- 3+ years of Microsoft Office tools experience
- MicroStrategy experience
- Teradata experience
- PERL experience
- UNIX/Linux Scripting experience
- Tomcat Server; Toad; MS SSIS/SSRS; SQL Server management experience
- IT experience in the Health Care Information field
13
Datastage / ETL DBA Resume Examples & Samples
- This includes setting up and testing new installations of DataStage, QualityStage and Information analyzer
- Post install Configuration, various data sources configuration for the plug-ins, connectors as well as ODBC configurations
- Document Runbooks for the installs, Disaster Recovery plans, etc
- Stop/start services, monitor logs, setting up security, assigning roles, and project permissions, create/delete projects, create/modify environmental parameters, etc
- Monitor the InfoSphere suite (Data Stage/Quality Stage/Information Analyzer) servers
- Kill/assist release job locks, shared memory locks, hung processes, etc
- Apply fixes, patches and service packs as required. Ensure infrastructure and application stability through preventative maintenance, monitoring, troubleshooting, and implementing long term solutions
- Liaises with product vendors and technical specialists to resolve issues
- Provide technical expertise and development support for the ETL development team
- Good understanding of ETL Best Practices in design and implementation
- 2+ years of experience in installing and administering IBM Infosphere Information Server product suite
- Experience with relational databases (SQL Server, Teradata, DB2, and Oracle)
- Experience with SuSE Linux Knowledge of Information Server Architecture (SMP, MPP, different tiers, etc.)
- Knowledge of Linux and WebSphere Application Servers
- Familiarity with connecting DataStage with Hadoop
- Bachelor’s in Computer Science or related discipline
14
Datastage Lead Resume Examples & Samples
- Anticipates and resolves potential problems, handles escalations
- 8+ years of experience in Datastage
- Preferred experience in migration project from 8.5 to 11.5
- Would be advantage having knowledge on Big data
- Should have experience in leading a team
- Knowledge on Databases like Netezza, Oracle and DB2
- Good knowledge on UNIX shell scripting
- Have knowledge on Agile process
15
ETL Datastage Applications Developer Resume Examples & Samples
- A proactive approach to problem solving, taking ownership of issues and having the determination to follow things through
- The ability to present and absorb complex ideas quickly and accurately
- A self-confident and authoritative manner without being over bearing
- Minimum 8 years of hands on Application Development work experience throughout the entire project lifecycle
- Expertise in ETL tools - DataStage
- Strong focus on time-management, decision-making, and project delivery
- Strong communication skills with the ability to communicate technical information to non-technical teams and Lines of Business
16
Datastage Administrator Resume Examples & Samples
- Maintain and support Enterprise Information Management (EIM) ETL environments
- Plan and coordinate the testing of software upgrades and patches
- Manage continual operations of the ETL application infrastructure
- Coordinate data refresh activities with the database administrators for all EIM databases
- Help development teams maintain Control-M schedules and interface with the operations staff
- Monitor performance of all tiers in all environments utilizing operating system utilities as well as InfoSphere Information Server Operations Console
- Provide support for user requests
- Assist trouble shooting any problems or incidents that occur with the EIM software
- Support all MDM environment issues via Incidents and Problem Management tickets
- Assist and provide input to various teams on action plans for refreshes, loads, report performance and other data warehouse related issues
- Responsible for ETL code migrations into the Production environment
- Responsible for configuration and tuning of production and lower-level environments, capacity & stability monitoring for all ETL environments (dev/test/QA and prod)
- Responsible for performance metrics reporting. Contribute to establishing best practices
- Establish regular maintenance procedure in all ETL environments
- Establish and maintain user access for all ETL environments
- Coordinating with product vendors and technical specialist engineers to resolve product issues/bugs/reoccurring issues
- Requires a Bachelor's degree in Computer Science, Information Technology or a related field
- 6+ years of ETL development experience preferably with IBM InfoSphere Information Server, ETL software administration, performing environment, capacity and performance monitoring, MDM patches maintenance/installs or other directly related experience
- A combination of education and experience may meet job requirements
- Experience employing advanced knowledge as a generalist or specialist of ETL administration, MDM patch maintenance/installs in all environments
- Advanced working knowledge of environment, capacity and performance monitoring, system-level and application-level MDM administration activities
- Ability to resolve product issues/bugs/reoccurring issues
- Ability to support all MDM environment issues
- Excellent customer relationship, presentation and communication skills, both verbal and written
- Excellent analysis and problem resolution skills
- Strong project management, organizational and time management skills
- Ability to develop resolutions to complex problems that require the frequent use of creativity
17
SQL Server / Datastage Resume Examples & Samples
- Strong Experience in Microsoft SQL Server 2008 R2 /2012
- Able to Write queries to perform data loads between environments using SSIS
- Good knowledge on RDBMS concepts, like data integrity, SQL Constraints and DB normalization concepts
- Experience in creating DB objects ( Stored Procedures, Functions ,Views and Triggers)
- Sound knowledge and working experience in Data Stage
- Bachelor"s Degree in Computer Scicence or Equivalent
18
Datastage Administrator Resume Examples & Samples
- Provide infrastructure operations, support and administration of the 8.5, 9.1 and 11.3 DataStage environments
- Engineer and Install/upgrade Information Server product suite
- Document Runbooks for the installs, Disaster Recovery plans etc
- Stop/start services, monitor logs, setting up Security, assigning roles, project permissions, Create/Delete projects, create/modify environmental parameters etc
- Kill/assist release job locks, shared memory locks, hung processes etc
- Apply fixes, patches and service packs as required
- Ensure infrastructure and application stability through preventative maintenance, monitoring, troubleshooting, and implementing long term solutions
- Capacity planning for new projects in the shared environment
- Support and troubleshoot production incidents/problems, optimizing performance
- Knowledge in the ETL concepts, OS, datawarehousing and underlying infrastructure
- Experience with relational databases (SQLServer, Teradata, DB2, and Oracle)
- Experience with SuSE Linux Knowledge of Information Server Architecture (SMP, MPP, different tiers etc.)
- Bachelors in Computer Science or related discipline
19
Datastage Administrator Resume Examples & Samples
- Day-to-day operational decisions
- Effective decision-making to support business and customers
- Strategic decision making responsibilities including design and implementation of a stable, secure, high performance infrastructure for the application/customer
- Design High Availability, Backup/Restore/Disaster Recovery, Clustered solutions that interact seamlessly with other homogenous and heterogeneous platforms using links, replication products and/or related technology
- 2+ years of DataStage administration experience
- 2+ years of experience in InfoSphere Information Server
- Certification in Data Integration, DataStage or related field from a reputed education provider (eg TDWI, IBM etc)
- Excellent leadership and interpersonal skills
- Ability to handle multiple tasks and projects simultaneously
- Exemplary organizational skills
- Ability to effectively lead and deliver multiple projects concurrently
20
Senior Datastage Software Engineer Resume Examples & Samples
- Perform all phases of the Software Development Life Cycle (SDLC) including requirements analysis, application design, code development, testing and deployment
- Design and code in IBM DataStage to implement product features in collaboration with business and IT stakeholders
- Implement business rules via IBM DataStage, stored procedures, middleware, or other technologies
- Work closely with architects and drive solutions
- Tuning ETL jobs and SQL queries for optimization
- Review ETL code and design, UNIX scripts, SQL developed by other team members as part of ETL code governance and provide feedback relative to best practices and improving performance
- Troubleshoot production support issues post - deployment and come up with solutions as required
- Participate in an Agile / Scrum methodology to deliver high - quality software releases on a periodic basis through Sprints
- Participate in components of development or maintenance standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases
- Work as part of a project team
- Mentor and guide other software engineers within the team
- Work with upstream and downstream applications to define dependencies, interfaces, data formats etc
- 7+ years of experience as an ETL developer of which at least 2 years as a senior ETL developer in IBM DataStage
- Hands - on experience with IBM Data Stage Version 11.x
- Hands - on experience in ORACLE database technologies
- Strong background in writing UNIX shell scripts and PERL scripts
- Proven experience in delivering software using an Agile / Scrum methodology
- Experience using an Agile management tool such as CA Agile Central
- Experience using Job scheduling software such as TWS
- Hands - on experience in writing and modifying stored procedures, DDL and DML statements in a relational database environment would be highly valued
- Experience working in an onsite / offshore model
- Proven experience across all phases of the SDLC
- Tuning of stored procedures in an ORACLE environment
- Experience using TWS
- CA Agile Central experience
- Experience in Production support activities
- Experience with HEDIS
- Strong verbal and written communication skills with the ability to communicate clearly and effectively to varying audiences
21
Senior Datastage Software Engineer Resume Examples & Samples
- Hands - on experience in writing, modifying stored procedures, DDL and DML statements in a relational database environment
- Experience working in an onsite / offshore model with offshore teams
- Experience using CA Agile Central
22
Datastage Architect Resume Examples & Samples
- Data Governance
- Business Intelligence
- Transition - Sales to Delivery Transition Technical Support
- 8+ years of Business Intelligence experience
- 2-3 years of Architecture experience
- 8+ years of Data Warehousing experience - Any toolsets
- 2+ years of Data Architecture enterprise initiative experience
- Full comprehension of SQL, cardinality, levels of granularity, normalized vs de-normalized, handling of slowly changing dimensions, auditing, database and tool optimization techniques and other such data architecture best practices is required
- Knowledge and experience in the development & deployment of master data solutions and data warehouse data architecture for large data volumes and complex reporting solutions
23
Senior Datastage ETL Developer Resume Examples & Samples
- Minimum of 2 years of IBM Datastage experience required
- Minimum of 4-6+ years experience in systems analysis and application program development, or an equivalent combination of education and work experience
- Understand the business and functional requirements that apply to the applications supporting a sub-domain or domain as well as their relevant interfaces
24
ETL Datastage Lead Developer Resume Examples & Samples
- Hands-on leadership for complex ETL delivery initiatives for data warehouses and related applications using industry standard toolsets
- Experience with IBM DataStage version 7.5 or 8.x in a development environment
- Experience with Informatica Powercenter 8.X would be added advantage
- Should know Oracle PL/SQL and AIX/UNIX, Schedulers, SQL
- Should have good communication skills
- Should be proficient in using advanced features like datasets, RCP, partitioning, handling large volume of data, parallel extenders, Data transformation, external loaders, performance tuning etc
- Should understand DWH concepts, schemas, Slowly Changing Dimensions, Facts and Dimensions and implementation of the same
25
IBM Infosphere Datastage ETL Developer Resume Examples & Samples
- Full support for IBM's InfoSphere DataStage applications including end-user support, release/upgrade management and testing and user training
- Ensure accuracy and integrity of data and applications through analysis, coding, documentation and problem resolution
- Review business problems and design appropriate solutions using various ETL toolsets
- Design source to target mappings to populate defined staging environments and business analytics warehouse
- Develop gap analysis between current state and desired to-be state from a data perspective
- Analyze and translate requirements and change requests into technical specifications
- Performance tuning and optimization of ETL
- Unit testing of data and ETL processes
- Ensure all system control processes are followed and compliant with corporate Sarbanes-Oxley control and change management procedures
26
Senior Datastage ETL Developer Resume Examples & Samples
- Engage with Internal clients to clearly define business requirements
- Perform complex data analysis to support research requests by the client
- Create technical specifications, unit test plans, dataflow diagrams and logical data models
- Follow quality assurance guidelines including the documentation, review and approval of all project related artifacts
- Lead developer for the planning, completion and coordination of work activity for projects involving multiple resources
- Research, evaluate, identify alternative approaches, recommend, design and code efficient and effective solutions for challenging problems ranging from small to large work efforts for low to moderate complexity problems
- Comply with standards and guidelines related to the design, construction, testing and deployment activities within the Delivery Management environments
- Support, train and mentor fellow analysts and developers
- Improve operational processes
- Function well within a matrix organization (e.g. - supporting multiple leaders)
- Bachelor's degree in computer science, business or other relevant degree; OR equivalent experience of 5 years minimum in one or more aspects of information systems development
- 7+ years of Data/Technical analysis experience
- 5+ years of IBM Infosphere DataStage ETL tool (version 7.5.2 or greater)
- 5+ years of experience with SQL on relational databases, preferably Oracle, DB2
- 5+ years of UNIX or Linux development experience
- Location: Minnetonka, MN
- Experience working with a virtual team environment over multiple locations, including off-shore
- Effective communications with all levels of internal staff, including issue resolution, negotiation of project related priorities, and completion dates
- An understanding of a variety of modeling and/or diagramming techniques, with the ability to create process flow diagrams and the ability read data flow and entity relationship models
- Tivoli (TWS) or equivalent job scheduling tool experience
- Ability to create detailed technical design and mapping specifications
- Knowledge of Hadoop and Java
27
ETL IBM Datastage Coder Resume Examples & Samples
- ETL IBM DataStage Coding
- Code and test highly complex ETL processing the support of data warehouses and/ or operational data stores
- Work closely with project management, analysts, data modelers and the existing ETL design and developers to understand project requirements and contribute to the project solution
- 2+ years IBM DataStage 11.5 (especially experience porting from older versions of DataStage to 11.5)
- 2+ years unit and functional testing and debugging
- 4+ years of hands on experience with UNIX/LINUX scripting
- Teradata, SQL, Oracle, MS SQL Server
28
Datastage Consultant Resume Examples & Samples
- At least 5 years of experience working with IBM DataStage
- Ability to design DataStage and SSIS packages to extract, transform, and load (ETL) data from internal/external systems
- Must have advanced SQL knowledge and the ability to write complex/advanced queries
- Experience with designing and building ETL solutions
- Experience with DB2 database development
- Experience with Unix scripting
- Experience with Mainframe is a plus
29
Senior Developer Datastage Resume Examples & Samples
- Sr Developer – DataStage
- Interpret written business requirements, functional requirements and technical specification documents to design and develop technical solutions that meet business needs
- Must have very good understanding and expertise to Design, Develop and Deliver ETL and Data Integration solutions using IBM Data Stage 11x working on all stages of SDLC
- 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 etc
- Knowledge of Best Practices in DataStage
- Contribute to design review meetings with other members of Application Development
- Participate in an Agile/Scrum methodology to deliver high-quality software releases on a periodic basis through Sprints
- Serves as initial point of escalation for all processing and operational issues
- 8-10 years of experience as an ETL developer of which at least 4+ years as a Senior ETL developer in IBM DataStage
- Strong hands-on experience with IBM Data Stage Version 11.x
- Strong knowledge of DW/BI Methodologies
- Strong hands-on experience in writing, modifying stored procedures, DDL and DML statements in a Oracle database environment
- Strong hands-on experience in writing UNIX shell scripts and PERL scripts
- Experience using Job scheduling software AutoSys
- Bachelor's degree in computer science or related discipline
30
Infosphere Datastage Administrator Resume Examples & Samples
- Engage with Internal clients to clearly define business requirements and assist in the design of ETL processes
- Troubleshoot client and operational issues quickly and comprehensively
- Demonstrate collaborative skills working within a project team of diverse skills and will bring communication skills including oral, written and presentation skills, creativity, and problem solving skills to a challenging environment
- Install IBM Information Server product suite, post configurations including configuring database native connectivity and ODBC connections and parallel database reads and writes
- Set up DataStage projects and configure information server security for users and roles
- Ensure infrastructure and application stability through preventative maintenance, troubleshooting and projects cleanup
- Create documentation for the installs, upgrades and regular maintenance
- Stop / start services, monitor logs, create/delete projects, create/modify environmental parameters etc
- Kill / assist release job locks, shared memory locks, hung processes etc
- Create and review PMRs, Apply fixes, patches and service packs as required by InfoSphere Information Server suite
- Evaluate system specifications, working parameters for hardware / software compatibility
- Work with infrastructure teams to identify and address systems problems
- Resolving ETL DataStage performance issues
- Assist in defining ETL standards, best practices and metrics
- Projects backup and recovery
- Perform regular systems maintenance and improvements as needed
- Responsible for analysis and improvement of system security
- Report project status timely and accurately from week-to-week
- Works with minimal guidance; seeks guidance on only the most complex tasks
- Be available for afterhours support and code releases
- Bachelor's degree in computer science, business or other relevant degree; OR equivalent experience of 5 years minimum in one or more aspects of information systems operations and maintenance
- 5+ years of experience in InfoSphere Information Server Suite administration experience
- 5+ years of experience in design and development of ETL solutions on DataStage version 8.7 and greater
- 5+ years of UNIX or Linux experience
- 5+ years of Data / Technical analysis experience
- 5+ years of experience with SQL on relational databases on one or more of the following: Oracle, DB2, SQL Server, MySQL
- Demonstrated experience in creating data and process flow diagrams
- Exposure to complex, cross-departmental projects involving multiple platforms
- Healthcare industry knowledge
- Experience with other ETL and EDI solutions such as IBM Sterling B2B Integrator, Ab Initio, or Talend
- Exposure to EDI 834, 835, 837
- Master's degree in computer science, business or other relevant degree
- Understanding of ASC X12 standards and HIPAA standard transaction code sets
31
Datastage / Mainframe Resume Examples & Samples
- 7+ years of relevant IT software experience (Production Support/Development SDLC lifecycle)
- 7+ years with Datastage, and with Mainframe and COBOL
- Strong database background on one or more of these databases: Vertica, Mainframe, DB2, Teradata, Cassandra, Oracle
- Experienced with Automation Tools, ex. Autosys, CtrlM Etc
- Experience with HP Vertica Database on Unix and Unix Shell Scripts is highly desired
- Prior banking/finance experience of working with globally distributed teams
- Able to contribute to Automation, System Analysis and Develop shared/common solutions
- Administered ETL tools like DataStage, Informatica etc
- Bachelor of Science/Engineering degree
- Exposure to these skills would be preferred – Information Governance Catalog, , JCL, CA7, BMC, Project Management, Easytrieve, MDM, cassandra, Teradata, C++, Basic Jav
32
Senior Datastage\etl Developer Resume Examples & Samples
- Designing\implementing the data flow between upstream systems and underlying reporting engines, including data staging and ETL
- Identifying and resolving scalability issues
- Define, prepare and implements data validation and unit testing to ensure data quality
33
Datastage ETL / DWH Developer Resume Examples & Samples
- ETL Development
- Implement data mappings
- Implement Physical Data Modelling
- Implement data analysis using SQL
- Define ETL scheduling task
- Maintain ETL verification processes in Data Warehouse environments
- ETL design and implementation (5+ years)
- Experience with Data Stage - must
- Source Target mapping (3+ years)
- Data/Attribute Mapping (2+ years)
- Teradata skills
34
ETL Datastage Resume Examples & Samples
- *MUST BE ABLE TO CONVERT TO FULL TIME***
- Configure and customize the chosen ETL tool for client installations
- Optimally leverage the ETL tool components for developing efficient solutions for data management, conversion, migration and integration. Develop overall design and determine division of labor across various architectural components (for example ETL tool vs. database)
- Deploy and customize Standard Architecture components
- Mentor client personnel. Train junior staff on the Integration Methodologies and related supplemental solutions
- Support development of task plans including schedule and effort estimation, under the guidance of an ETL architect
- Advanced ETL experience using either Informatica or Data Stage
- Strong individual contributor in complex Data Warehousing and Business Intelligence project implementations; leadership experience a plus
- Proven experience in working directly with business customers
- Data analysis skills - ability to dig in and understand complex models and business processes
- Strong UNIX shell scripting skills (primarily in COBOL, Perl)
- Data profiling experience
- Defining and implementing data integration architecture
- Strong ETL performance tuning skills. The ability to quickly and efficiently analyze and resolve performance issues within variety of operational environments
- Demonstrated ability to analyze data concerning production volumes, batch schedules, and i/o statistics
- ETL experience using either Informatica or Data Stage or an equivalent technology
35
IBM Datastage ETL Developer Resume Examples & Samples
- Extensive experience in IBM Datastage middleware development
- IBM Datastage – project specific configuration, packaging and deployment experience
- Hands on experience with IBM DS custom routine
- Experience in IBM InfoSphere DataStage 9.1 is an added advantage
- SQL Server ,Oracle and other database experience
- Good Analytical and problem solving skill
- Prior experience in data conversion and interface development
- Vendor data like Bloomberg knowledge is an added advantage
- Good team player is a must
- Understanding of ETL processes and Best Practices thereof
- Expert level knowledge and hands-on experience with IBM DataStage Server and Parallel Jobs
- Expert level knowledge and hands-on experience with MQ plug-ins and XML packages in DataStage
- Understanding of change management processes
- Understanding of Production Support (PS) processes
- Good and / or diverse understanding of IT infrastructure and other technologies
- Ability to deal with business users
36
IBM Datastage SME Resume Examples & Samples
- Implement and configure IBM Datastage software
- Knowledge of other ETL tools, Informatica is preferred
- Determine capacity constraints which could potentially arise with the addition of these new applications into the environment
- Outline security concerns which were introduced with these new products
- Support the integration of the tools within the network for proper functionality and support communication configuration between the tools and other required software for monitoring and testing
- Execute test cases and properly document the results
- Train operations personnel on the use and administration of the SAS tools
- Require experience with configuration, implementation, installation and the Datastage ETL tools
- A solid track record of accomplishments in systems design, deployment, troubleshooting, and tuning
- A minimum of 5 years of application instrumentation systems design, deployment and support experience is required
- Understanding of various Software products currently in use in customer environment including: Siteminder, Web Focus, Oracle, DB2 Connect, LDAP, Connect Direct and MQ Series
- Demonstration of initiative and results oriented with flexibility and tenacity, and the ability to continuously adjust priorities to reflect changing circumstances
- Strong diplomacy, assertiveness, influencing skills with commitment and ability to work in a dynamic cross-organizational team environment
- Strong dedication to provide quality customer service
- Effective problem-solving skills and inherent decision-making ability
- Ability to manage own projects including communications to customers as well as work as part of a larger team managed
37
Senior Lead-netezza & Datastage Resume Examples & Samples
- Hands-on architect providing technology guidance to the implementation team throughout the life cycle of a project
- Develop designs to support the functionality and documented protocols as specified in the solution architecture and developer stories
- Act as a technology advisor to the client and provide strategic guidance and thought leadership to arrive at roadmap definitions, optimal use of technology and ROI definitions
- Lead and manage resources at on-shore, off-shore from an architecture and technology perspective
- Ensure software developed is held to quality standards through code and design reviews
- In addition to billable engagements, contribute towards pre-sales activities and account strategy initiatives
- Relevant experience working in Netezza, Teradata or Exadata
- Strong experience in translating high level requirements into ETL deliverables
- Strong experience in hands on ETL development and troubleshooting
- Knowledge of DataStage Director for running and monitoring the jobs
- Ability to create DataStage sequences to run the batch jobs and Knowledge of best practices in DataStage and performance improvements
- Experience with dimensional data modelling principles (e.g. star and snowflake schemas, denormalised data structures)
- Experience with data profiling
- Highly developed conceptual, analytical, problem solving skills and systems and process thinking
38
Datastage Specialist Resume Examples & Samples
- A performance related bonus
- Car/allowance
- Generous pension contribution
- 30 Days leave plus bank holidays
- A flexible cash pot to spend on benefits
- Wider corporate benefits and perks
39
Software Engineer ETL Datastage Resume Examples & Samples
- Work on Datastage Design, Database: RDBMS- Terada or Oracle preferred
- Use Datastage Director for running and monitoring the jobs
- Import jobs and unlocking jobs, Deploying applications in to the production server and scheduling as per business requirements
- Work on production issues; root cause analysis and UAT defects
- Co-ordination & Status reporting to onsite & offshore teams
- Strong data base skills with Data warehousing,Design and development
- At least 2 years of experience with back end RDBMS and data modeling / database design(Terada or Oracle preferred)
- At least 2-4 years of hands on experience in Design, Development & Build activities in IBM Datastage( min v8.5; best is Datastage version 11.3 or 11.5) ETL Projects
- At least 2-4 years of experience in software development life cycle
- At least 2-4 years of experience in DW/BI related technologies and tools – MUST
- At least 2-3 years of experience in Project life cycle activities on DW/BI development and maintenance projects
- At least 1-2 years of experience in Design and Architecture review
- Knowledge of Best Practices in Datastage, Performance improvements, implementing CDC
- Strong understanding of scheduling tools such as Control- M, Tivoli etc
- Extensive Experience in Oracle SQL, PL/SQL
- Adherence to the company’s quality process and procedures
- Any Graduate or Master Degree
40
Senior Software Engineer ETL Datastage Resume Examples & Samples
- Develop & test Datastage ETL jobs and perform bug fixing
- Working on Datastage Design, Database: RDBMS- Terada or Oracle preferred
- Developing Datastage Parallel Extender jobs using different stages like Aggregator, Join, Merge, Lookup, Source dataset, External Filter, Row generator, Column Generator, Change Capture, Copy, Funnel, Short, Peek stages etc
- Using Datastage Director for running and monitoring the jobs
- Creating Datastage sequences to run the batch jobs
- Import jobs and unlocking jobs, deploying applications in to the production server and scheduling as per business requirements
- Provide expertise in determining the strategic technical direction and system architecture for initiatives
- At least 4 years of experience with back end RDBMS and data modeling / database design (Terada or Oracle preferred)
- At least 4 years of hands on experience in Design, Development & Build activities in IBM Datastage ( min v8.5; best is Datastage version 11.3 or 11.5) ETL Projects
- At least 4 years of experience in software development life cycle
- At least 4 years of experience in DW/BI related technologies and tools – MUST
- At least 3-4 years of experience in Project life cycle activities on DW/BI development and maintenance projects
- At least 2-3 years of experience in Design and Architecture review
- Knowledge of IBM Datastage Architecture, Stages/Transformations, Design, ETL flow, advanced SQLs
- Knowledge Best Practices in Datastage, Performance improvements, implementing CDC
- Understanding of Unix/Linux system, file systems, shell scripting
- Hands-on development experience, with a willingness to troubleshoot and solve complex problems
41
Datastage Specialist Resume Examples & Samples
- A minimum of 7 years’ experience in DataStage software implementation
- Demonstrated experience in design, development and testing interface solution, Strong technical background in DataStage
- Exposure to Agile, Integration with SAP
- A minimum of 7 years of experience in designing, development and testing
- SW development
42
Datastage Lead Resume Examples & Samples
- Experience in creating high level, detailed level estimates
- Ability to effectively present, defend solutions and respond to questions from executives, directors, managers, clients and customers
- Ability to work closely with customers in analyzing requirements
- Ability to work flexible hours
- Comfortable working independently, but has experience working in a team environment
- Can discern when escalation is needed
- 6+ years of Data Stage ETL experience
43
DNA Hil-technology Lead-datastage Resume Examples & Samples
- Bachelor’s degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education
- At least 4 years of experience with DW/BI & Datastage/Big Integrate ETL tool
- At least 2 years of hands on experience in Design, Development & Build activities in Datastage Projects - MUST
- At least 4 years of experience in Project life cycle activities on DW/BI development and maintenance projects
44
IBM Datastage Resume Examples & Samples
- Knowledge of other ETL tools, Informatica is preferable
- Outline security concerns which are introduced with these new products
- Support the integration of the tools within the network for proper functionality
- Support communication configuration between the tools and other required software for monitoring and testing
- Support application developers and continued tuning of the ETL infrastructure
- Assemble or develop application training and administration materials
- Ability to work effectively in a team, and with clients
- Understanding of various Software products currently in use in customer environment including: Siteminder, WebFocus, Oracle, DB2 Connect, LDAP, Connect Direct and MQ Series
- Strong analytical skills including the ability to quickly identify the cause of issues with the system or determine if other teams need to be included in resolving an issue
45
IBM Infosphere Datastage Specialist Resume Examples & Samples
- Minimum of 3 years of experience Assists with technical support of existing solutions and/or products. May install new products and assist in the migration to new releases or versions of products and provide related education. Area of expertise is usually related to a technology platform. In addition, a Technical Specialist may have programming skills and would be part of a project team
- 4 years of experience working with the Affordable Care Act
- 6 years of hands on experience with writing SQL procedures, triggers & packages and UNIX Shell scripts to schedule jobs and other maintenance tasks
- 4 years of experience with InfoSphere DataStage versions 9.1 or higher with overall DW Architecture and Best practices
- 6 years of experience in working with Data warehousing mainly with writing Source to target mappings (STMs), creating ETL maps, PL/SQL to load Target Dimension and Fact tables, Job scheduling, troubleshooting performance issues for large implementations 2+ Terabytes (TB)
- Professional IBM certifications including IBM Certified in XML Technologies and IBM Certified SOA Designer
- Completed or in progress certification- IBM Professional Certification Program- DataStage certification
- Master’s Degree in Information Technology or Computer Science
46
Datastage Consultant Málaga / Sevilla Resume Examples & Samples
- Programming in IBM DataStage tool with SQL knowledge
- Analyze for resolution of incidents
- Analysis and programming tasks
- Detailed technical documentation
- Perform both unitary and integrated tests
- Support for installation, configuration, acceptance tests and production start up. Collaborative teamwork
- Previous professional experience, at least 2 years worked, with technology Datastage
- Knowledge in DB2 databases
- Experience with querys optimization for performance improvements
- English medium high level
