Home   Register   Sign In
Company Info
Axius Technologies Inc.

United States

Web Site:

Company Profile

ETL Datastage Developer


Job ID:



Dallas, TX, United States 



Job Views:


Zip Code:


Employment Type:

Full time



Job Description:

Job Specific Description:
Conduct Unit Testing and create Unit Testing Results Documents.
Provide Support for QA/UA Testing
Assist Migration of code to Production.
Provide Warranty Support.
Assist and resolve production issues during Warranty Support
Supports best practices, platform usage standards and guidelines
Performs trouble shooting, analysis, research and resolution using advanced query and programming skills. Conducts root cause analysis.
Proactively identify cross functional or technical issues
Suggest and implement ideas for enhancing the customer experience. Implementing best practices for cost saving
Proactively identify cross functional or technical issues
Proactively identify cross functional or technical issues
Collaborate with ETL Team on solutions
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.
Role Overview:
Develops, enhances, debugs, supports, maintains and tests software applications that support business units or supporting functions. These application program solutions may involve diverse development platforms, software, hardware, technologies and tools. Participates in the design, development and implementation of complex applications, often using new technologies. May provide technical direction and system architecture for individual initiatives. Serves as a fully seasoned/proficient technical resource. Will not have direct reports but may lead projects and direct activities of a team related to special initiatives or operations. May have responsibility for a project and project budget. May collaborate with external programmers to coordinate delivery of software application. Routine accountability is for technical knowledge and capabilities. Works under minimal supervision, with general guidance from more seasoned consultants. Typically requires 5-7 years of experience.
Required Skills:
Bachelor’s degree in Computer Science, Engineering or equivalent experience required
7 + years of experience - large global companies preferred
5+ years of ETL development experience using Datastage and Oracle 10g/11g and using Industry best practices.
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.
RDMBS database skills, including complex SQL constructs and DDL generation
Experience in any of Scheduling Tools - Tivoli, Autosys, Ctrl-M
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
Excellent understanding of data warehousing concepts.
Ability to present technical concepts to senior level business stakeholders
Strong problem solving, analytical and interpersonal skills. 

Desired Skills:
 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
Experience in database design
Worked with advanced concepts such as materialized views, partitioned tablets, etc
Performance tuning of complex queries, procedures
Unix Shell Scripting – AIX or Linux

© 2017 Powered by Rootjobs     About Us   Sitemap   Terms and Conditions   Privacy Policy   Mobile Version     Twitter RSS LinkedIn Facebook