Sr. DataStage Engineer - Lafayette, United States - Mindlance

Description

Translate requirements and data mapping documents to technical design.
Develop, improve, and maintain code following best practices and standards.
Build and implement unit test plans to support regression and system testing efforts.
Debug and provide problem solutions for issues found during testing and/or production.
Communicate status, issues, and blockers with the project team.
Support continuous improvement by identifying and solving opportunities.

Required qualifications to be successful in this role

At least 7 years of shown experience in crafting and developing on IBM DataStage (11.x) designing, developing, deploying, and supporting computing applications in a large-scale, midrange, and distributed environment.

Expertise in Data Warehousing ETL Tool DataStage using Components like DataStage Designer, DataStage Director and DataStage Operations Console.
Knowledge of Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodology.

Expertise in crafting DataStage Server jobs, Parallel Jobs, Job Sequencing, Crafting Parameter Sets, Container, Environment Variables and Crafting Parallel Routines, Data Cleansing and Writing Transformation expressions to derive values and remove unwanted data.

Experience in different stages like Transformer, look up, merge stage, ODBC connector, and Oracle connector etc.
In depth experience in solving DataStage jobs and addressing issues like performance tuning.
Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and Testing.
Experienced in analytic and problem solving skills.
Experience in Unix shell script skills
Possess good SQL skills and experience working on Oracle and/or Teradata DB's.
Good teammate and co-ordinate with multiple teams
Should have experience working in Agile teams in onshore- offshore model

Desired qualifications/non-essential skills:

Understanding of AWS (especially Glue)
Knowledge of Python scripting
Knowledge of Testing methodologies
Ability and interest in learning new technologies
Candidates should be self-starter and have the capability to work in a fast paced, demanding, and constantly advancing environment.
Ability to perform detailed analysis of business problems and technical environments.
Strong oral and written communication skills.
Positive relationship and collaborating skills.
Health Care / Health Services business area domain expertise.

Education:
Bachelors degree in Computer Science on related field.