Datastage Resume Sample
Dustin Denesik
7831 Baumbach Keys,
Houston,
TX
+1 (555) 793 1702
Work Experience
Datastage Administrator
03/2016
-
PRESENT
Houston, TX
- Location is Vac - Hungary - traditional office - agile working space
- Language : Fluent English and Hungarian, verbally and in writing
- At the business area the person would be a member of our teams working on DataMart and ETL development focused on the ETL area
- Knowledge of UNIX/AIX and ETL (IBM InfoSphere Datastage) is required
- Contribute to IIS DataStage standards, policies and procedures
- Has thorough understanding of technical concepts required for specialized field and encourages and supports others to perform their jobs more effectively (e.g., provides advice, tools and/or resources)
- Engage in performance and optimization of DataStage applications at a job level
- Work with other team members and to work with and understand issues and troubleshoot
Datastage Architect
02/2011
-
12/2015
Detroit, MI
- Drives toward the achievement of results in a manner that focuses on service, and value provided to clients
- Perform administrative activities such as Project/User creation, Roles Management, Import and Export projects, database configuration setup, dataset management
- Work with other Database and Unix administrators to resolve any open issues
- Responsible for the pre-validation and ongoing management of the production instance and configuration of scheduling & monitoring
- Responsible for the evolution of the support & monitoring implementation including JMX services and monitoring jobs
- Engage developers early to provide support & monitoring cases for implementation
- Audit/QA the support and monitoring implementation to ensure coverage and acceptance of outcomes
- Responsible for knowledge capture and understanding of the implementation and support & monitoring processes
- Responsible for ensuring that the overnight batch processes are monitored, completed within SLA and are triaged/investigation and fixed where problems and delays occur
Software Engineer ETL Datastage
10/2005
-
09/2010
Houston, TX
- Due to the nature of the work, this role requires that the a resource dedicated to the batch processing which runs overnight
- Contribute to the ongoing evolution of the platform and enhancements to standards and frameworks
- Performs analysis and effective diagnosis of clients’ issues
- Experience using IBM DataStage 8.x/9.x
- Experience in developing ETL solutions for DW/BI implementations
- Experience in RDBMS and coding in SQL
- Experience writing SQL queries in MS SQL Server 2012/2014
- Exposure with Dimensional Modeling
Education
University of Wisconsin-Richland
1999 - 2004
Master's Degree in Computer Science
Professional Skills
- Proven stakeholder management skills, experience liaising with executive level
- Strong SQL skills including complex query building and query performance tuning
- Very strong communication skills, both verbal and written, including technical writing
- Strong understanding of Data warehousing design concepts/skills
- Strong experience implementing and maintaining business and technical rules
- Experience and proven success in roles supporting data governance, business intelligence, data management, and data quality
- Mentor team members in project teams with respect to product and domain skills on projects
How to write Datastage Resume
Datastage role is responsible for design, modeling, mainframe, integration, database, security, architecture, reporting, software, automation.
To write great resume for datastage job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Datastage Resume
The section contact information is important in your datastage resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your Datastage Resume
The section work experience is an essential part of your datastage resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous datastage responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular datastage position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Datastage resume experience can include:
- Strong interpersonal skills are needed to collaborate with end users, Business Analysts, Project Managers, Developers and Operations teams
- Good verbal and written communication skills - can write clear and concise documentation
- Partners with developer groups to ensure application functionality and data integrate securely, effectively, and efficiently with other applications
- Experience in hands-on technology experience in Data Warehouse projects
- Proven experience on InfoSphere Datastage 11.x ( Designer, Director, Administrator)
- Experience in ETL application performance tuning, optimization and monitoring
Education on a Datastage Resume
Make sure to make education a priority on your datastage resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your datastage experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in Datastage Resume
When listing skills on your datastage resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical datastage skills:
- Good understanding of data mapping, data validation, data manipulation and analysis
- Experience in designing and implementing ETL processes using IBM DataStage
- Experience supporting application running on UNIX
- Relevant hands on experience developing and enhancing DataStage ETL jobs
- Hands on experience querying and profiling data
- Experience in using DataStage to load and extract data to and from Salesforce using the Salesforce adapter
List of Typical Experience For a Datastage Resume
1
Experience For Datastage Administrator Resume
- A strong understanding of ETL principles
- Experience with version control tools such as Subversion
- Experience in IBM QualityStage
- DataStage experience as an ETL tool in both Data Warehouse and Operational system integrations
- Working with data warehouses, data marts and operational data stores
- Apply industry wide understanding of technology, tools and methodologies to assist in developing solutions on projects of strategic significance
- Analyze in detail resources required for every phase, conduct estimation of time utilization of different resources and activities, prepare resource and development plan or provide inputs and review with PM
2
Experience For Infosphere Datastage Administrator Resume
- Datastage 9.1 and 11.3 experience
- Designing and implementing security and encryption/PCI compliance measures for sensitive data
- Participate in KT sessions conducted by customer/ other business teams
- Work with business analysts to understand, define and document logical data models
- Implement bug fixes when required
- Sufficient technical expertise to understand Datastage environments and architecture
- Knowledge on key stages like Transformer, Filter, Funnel, Remove Duplicate, Change Capture, Lookup, Join, Merge, Pivot etc
- Technical contributor to translation of business requirements to technical specifications, design of new applications or enhancements including integration of purchased solutions in accordance with Enterprise wide strategy
- Performs tasks for the completion of unit testing, integration and system testing, according to detailed test plans to ensure high-quality systems
3
Experience For Datastage Architect Resume
- Assists business partners with User Acceptance Testing. Independently supports the implementation of systems into production
- Interacts and receives general direction from Project Managers or Application architects
- Evaluate and identify issues and constraints pertaining to technology approach; coordinate evaluation of solutions to insure adherence to Aetna technology standards (such as security, database, etc.)
- Partner closely with Business areas, data owners, and stewards to lead the data warehouse program to drive quality, reduces risk, and achieves value for the resources expended to conduct it
- Lead the definition of standards, frameworks and detailed design for data warehouse renovation, enhancement, and maintenance projects within the overall Group Data Warehouse program
4
Experience For Software Engineer ETL Datastage Resume
- Participate in data governance, data management, and data quality programs; and support their processes and frameworks
- Review and verify business intelligence and customer reporting specifications with Business associates for reliability, accuracy and functionality. Ensure Business associates' effective, accurate and easy access to data; translate business functional and information requirements into data structures
- Be responsible for all event modeling, conceptual, logical and physical database design, database optimization, load strategy design and implementation, security, and change management. Take overall responsibility for design and deployment of all database structures within the program including: DW, DM, OLAP, ODS , and all related repositories
- Good knowledge of SQL, relational databases and Dimensional Modeling - star schemas and NoSQL databases
- Experience in Windows, Mainframe or UNIX systems administration
- Experience in Abinitio, Big data and related components like Pig, Hive, Spark, PySpark, Python
- Experience in other toolsets to support real-time integration like IBM CastIron etc
- Perform data profiling and analysis to assess data quality patterns, recommend data cleansing rules, conforming data standard rules and matching algorithms
5
Experience For Senior Software Engineer ETL Datastage Resume
- Full understanding of ETL is required especially dealing with very large volumes of data
- Provide database query performance tuning expertise
- Participate in direct project management for all Group Data Warehouse program engagements. Focus on providing technical leadership and direction to the team
- Coordinate yearly Disaster Recovery effort
- 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.
- Expert in Dimensional data modeling
- 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
6
Experience For IBM Datastage ETL Developer Resume
- Experience with any ETL tool
- Experience with Data Stage upgrades 8.x to 10.x or 11.x
- Experience with automation of ETL code migration process and standards
- UDB, SQL Server, Oracle, My SQL, Netezza or Teradata database experience
- Knowledge of PL SQL and analytical functions
- Knowledge of SQL and at least one relational database platform (Oracle, DB2, SQL)
- DataStage PeroformanceDS Related Issue
- Microsoft Office (Outlook, Excel, Word, PowerPoint, Access)
- Eligible to work in UK/ EU without restriction
7
Experience For IBM Datastage SME Resume
- Knowledgeable in current business analytics and database technologies and toolsets including: IBM Cognos Analytics, InfoSphere DataStage, Watson Analytics, SPSS, and Oracle
- Tivoli / OPC experience
- Participate in design validation and identify any gaps
- 3-5 yrs of CI Experience
- Shell scripts -some ETLs use, .sh scripts to manipulate files
- Professional IBM certification in DataStage desirable
- Obtain MBI Required
- Support the production environment
8
Experience For Senior Developer Datastage Resume
- Troubleshoot login related issues, such as incorrect port or insufficient privileges
- Expertise in DataStage ETL design and development
- Understand project scope
- Knowledge of Datastage related software configuration management lifecycle tools
- Knowledge of file transfer protocols (Connect Direct, FTP etc.)
- Translate business requirements into well-architected solutions that best leverage the Integration platform
- Lead technical design sessions; document technical solutions that are aligned with client business objectives and follow architectural guidance
- Manage the technical delivery of integrations, and data migration elements of the implementation
- Understand the current Baxter organization and system landscape
9
Experience For Senior Lead-netezza & Datastage Resume
- Review Functional Requirement Specification document
- Identify and understand the design changes and dependencies
- Assess and recommend technical best practices
- Support of BHC Regulatory Reporting including the BHC data mart and the ETL code that generates the extracts for Lombard Risk’s Reg Reporter 6.1 application
- Collaborate with business stakeholders to understand and propose technology solutions to meet BHC regulatory reporting requirements
- Interpret written business requirements and functional requirements to produce detailed system requirements specifications, complex data flow diagrams, test plans, swim lane and process diagrams using standardized documentation methods
- Knowledge and good understanding of Best Practices in Database and DataStage development as well as BHC Regulatory Reporting
10
Experience For Datastage ETL / DWH Developer Resume
- Invests in tooling and automation -- Enhancing the productivity of developers on the platform
- Participates within disaster recovery testing; ensuring the disaster recovery plans are updated and maintained
- Provides technical mentoring and consultation to other application development staff
- Ensure that proposed solutions comply with the company’s technology direction and change and security policies
- Develop and support 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
List of Typical Skills For a Datastage Resume
1
Skills For Datastage Administrator Resume
- Data warehousing leadership experience in technology, business, and consulting roles
- Significant experience leading complex business analytics and data warehousing projects
- Experience in leading a team to support high volume data movements using DataStage or similar tools
- Experience working across multiple SDLC’s and within Agile, Iterative and Waterfall frameworks
- Excellent working knowledge of database data dictionary objects (any DB)
- Experience loading data from web services / cloud services
2
Skills For Infosphere Datastage Administrator Resume
- Experience with Data Marts, and Data Warehousing
- Experience in maintaining parameter sets at the enterprise level in Data Stage
- Experience in appropriately sizing UNIX servers for Datastage projects
- Good understanding of Data Quality and Governance
- Proven problem-solving / problem resolution abilities
- Industry Experience in Financial Services - Banking would be preferable
- Knowledge of typical line of business system data technologies and a solid understanding of business rules are very valuable
- Related experience in the insurance, banking, or financial services industries is desirable, but not essential
3
Skills For Datastage Architect Resume
- Experience in understanding of data warehouse processes
- Experience in technical requirements definition and data mapping (source to target)
- Experience in hands-on developed project deliverables using formal/structured methodology
- Experience in understanding of Datastage tools
- Good understanding of UNIX shell scripts, use of command-line utility and proficient in SQL
- Experience in the development near-real-time ETL processing
4
Skills For Software Engineer ETL Datastage Resume
- Experience of working with an offshore delivery model
- Good understanding of the IBM Infosphere platform
- Experience in tuning DataStage stages for performance improvements
- Very good understanding of Oracle databases both as a source and target platform
- Highly experienced in writing SQL on Oracle databases
- Proven knowledge in DataStage Administration or and Development
5
Skills For Senior Software Engineer ETL Datastage Resume
- Designing and Developing processes for alerting and monitoring
- Understanding of problem ticket processing and resolution with vendors
- Ensuring timely delivery of required ETL tasks Performance tuning of ETL jobs
- Working knowledge and understanding on Salesforce platform
- Patching and upgrading binaries
6
Skills For IBM Datastage ETL Developer Resume
- Designing and implementing security and encryption/PCI compliance for sensitive data
- Creating documentation including artifacts needed to raise and support an IBM ticket (PMR)
- Working with clients to understand their data needs
- Understanding of the concepts of Master Data Management
- Creating metadata repository databases on UNIX/Linux platforms
- Monitoring environment for performance and stability
- Working knowledge of high volume transaction systems
- Import jobs and unlocking jobs,Deploying applications in to the production server and scheduling as per business requirements
- General knowledge of Business Intelligence technologies including ETL, general and financial reporting, analytics, and database expertise
7
Skills For IBM Datastage SME Resume
- Physical Data Modelling and data mapping (3+ years)
- Elicit and refine requirements, implement data analysis using SQL, implement transformation physical models and mapping instructions
- Conduct training or knowledge sharing sessions
- Understand of indexes, parallel processing and partitioning
- Assists other administrators/engineers with hardware upgrades on ETL Server or other supporting environments
- Provide assistance in selection of representative employee groups for training
- Conduct / support managers in conducting appraisals for team members and share final ratings with the relevant stakeholders
- Coordinate with the project/program manager in understanding how the employee can better contribute to the project, seek feedback and address concerns
8
Skills For Senior Developer Datastage Resume
- Act as a key thought leader in the definition of strategies and roadmaps to optimum Business Analytics and Data Warehousing practices
- Familiarity with TWS or other scheduling software
- Exposure to DFA including Section 165 Regulation YY and Basel III
- Exposure to one or more of the following data specialties: ETL, Data Architecture or Data Quality
- Comfortable working in a dynamic team in transition to an agile methodology and environment
- Your role provides support to IBM WebSphere DataStage, including support to the production environment and the ability to solve file system issues
- The Senior Regulatory Reporting Application Specialist is responsible for
- ETL tools (Extract, Transform and Load): IBM Infosphere, IBM Websphere, PowerCenter Informatica, SAS DataManagement, Pentho, Talend, Pervasive, ODI (Oracle Data Integrator), Clover
- Certification in Data Integration, DataStage or related field from a reputed education provider (e.g. TDWI, IBM etc.)
9
Skills For Senior Lead-netezza & Datastage Resume
- Adherence to the company’s quality process and procedures
- Focus on data quality
- Leads others toward technical accomplishments and collaborative project team efforts
- Responsible for maintaining the InfoSphere environment primarily for the DataStage (ETL) technology stack, including: product upgrades & maintenance, data cycles, change control, code & configuration promotion, performance management, administrative support, system access control support, build & release support and supporting audit practices
- Troubleshooting and resolving complex issues
- Assists with 2nd level production issues and work directly with vendor on patching and problem records
- Maintain regular environment monitoring processes and procedures
- Assist in ETL audit process using data from the Operations Console or other sources
- Works with offshore Support when problems involve DataStage Application and Mainframe Unix Server issues
10
Skills For Datastage ETL / DWH Developer Resume
- Publishes DataStage development standards and best practices
- Conduct release reviews for ETL production changes
- Monitor progress of all ETL project related requests against specified application requirements and in accordance with a regular Production release schedule
- Maintain the overall health of the environments, Development, QA to Production
- Conducts bi-Annual Access Reviews
- Plan, schedule and install upgrades and fix packs for all environments
- Proactively monitors and recommends related performance management solutions
- Administrative knowledge to support other InfoSphere products added to the same stack, such as Information Analyzer, FastTrack, Business Glossary, etc
- Adhere to information security, compliance procedures and internal/operational risk controls in accordance with any and all applicable regulatory standards, requirements, and policies
List of Typical Responsibilities For a Datastage Resume
1
Responsibilities For Datastage Administrator Resume
- Experience with the tools in Big Data ecosystem (such as Hadoop/HDFS/Spark )
- · Experience in WebServices Restful API
- Experience with InfoSphere DataStage versions 9.1 or higher with overall DW Architecture and Best practices
- Provide subject matter expertise on the capabilities/constraints of existing systems, processes and proposed solutions
- Tune ETL jobs and SQL queries for optimization
- Troubleshoot production support issues post-deployment and insure that production support issues are minimized through implementation of continuous improvement refinements to the platform
- Ensures that the Datastage platform in relation with the appropriate network, database management, and server/operating system integration is performant and available
2
Responsibilities For Infosphere Datastage Administrator Resume
- In partnership with the Architecture function - reviews current programming standards; providing recommendations ensuring that the standards are being followed; with specific emphasis on nonfunctional requirements such as performance, logging, recoverability etc
- Performs code reviews; providing mentoring and ensuring standards are being maintained
- Partners with Analysts and Architects to ensure system and application blueprints, architectural diagrams, and schematics are up-to-date and accurate
- Responds to support requests and incidents per stated service agreements
- Partners with vendors to ensure appropriate data and system integration for upgrades and implementations
- Drive Proof of Concept (POC) and Proof of Technology(POT) evaluation on technology platforms, as applicable
3
Responsibilities For Datastage Architect Resume
- Moving data from the operational & external environments to the business intelligence environment utilizing for example DataStage (formerly Ascential) - IBM's WebSphere Data Integration Suite, Informatica, BigInsights, Pentaho or other vendors
- Use of Web services
- 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
- Relevant experience in Enterprise level IT organisation
- Strong experience in a large scale, complex system integration projects in a cross domain, cross-partner, multi-application, multi-sourced technology environment
- Familiarity with version control systems (Mercurial, Git, Perforce, Subversion)
Related to Datastage Resume Samples
Datastage Developer Resume Sample
Work Experience
• Provide expertise on decisions and priorities regarding the enterprise’s overall data warehouse architecture
• Demonstrate knowledge and experience with tables, data mart and database design and implementation for data warehouse and related functions
• Demonstrate knowledge a...
Professional Skills
• Strong Logical & Physical Data Modeling ex...
• Strong Analysis skills ; Strong experience...
• Strong Analysis skills; Strong experience ...
Firmware Engineering Resume Sample
Work Experience
• Responsible for leading and managing the company’s global firmware development organization in support of the storage products (HDD, SSD & Hybrid) division. Ensure the delivery of embedded firmware features and systems that meet customer requirements related to performance, quality and time to market
•&nb...
Professional Skills
• Excellent communication skills and interfa...
• Strong analytical skills and critical thin...
• Demonstrated leadership experience in coor...
Lead-net Resume Sample
Work Experience
• Analytics and Information Management Services
• Digital Transformation Services
• Enterprise Security Services
• Independent Testing and Validation Services
• Effectively liaise with project and support teams (i.e. PM’s, BA’s, BU ...
Professional Skills
• Problem Solving: Proactively identifies, e...
• Strong collaborating skills - working in a...
• Demonstrable record of managing Project bu...
Analyst / Senior Quantitative Analyst Resume Sample
Work Experience
• Chartered Financial Analyst (CFA), Financial Risk Manager (FRM) designation
• Monitor the effectiveness of models in use and continually update model parameters with actual results and changing trends
• Create, enhance and maintain models and model parameters for various mode...
Professional Skills
• Hands on experience with credit risk model...
• Other programming/software familiarity: st...
• Excellent interpersonal and communications...
Full Stack .NET Developer Resume Sample
Work Experience
• Design and development of software applications (primarily web based) used in various areas of the bank (such as Loans processing, Treasury, Middle Office etc.)
• Unit and Integration Testing – planning, execution and evaluation
• Production Release preparation and coordinati...
Specialist, BI Resume Sample
Work Experience
• Understands logical and physical data models, data modeling methodologies
• Experience in data reporting and visualization area with atleast 2-3 years’ experience on Tableau development
• Experience as BI/DW consultant
• Intelligence, analytical mindset...
Professional Skills
• Attention to detail and strong interperson...
• Strong skills and experience with scriptin...
• Strong project management skills including...