Datastage Analyst/developer USC GC GC EAD at Implify in Plano, TX

Company Description

Implify, Inc is a Global IT Solutions and services firm. Since it's inception, Implify, Inc has been providing best-quality and cost-effective IT solutions to fortune 1000 companies, mid-range companies and upcoming companies via its onsite, Offshore and in-house service models.

IMPLIFY is an IT consulting services and software development firm dedicated to business success through long-term relationships with our clients and staff. IMPLIFY has built a dynamic, profitable, service-oriented enterprise, and is positioned to successfully respond to trends and changes in the information technology industry.

Job Description

Hi ,

Greetings from Implify Inc.

I would like to update you on an open position DataStage Analyst / Developer with our esteemed client. Please go through the Job Description and please fill the below details and revert back with your your updated resume in a word format at the earliest for further process.

Need USC GC and GC EAD only

Position : 1

Job title : DataStage Analyst

Location : Plano,TX

Full Time Permanent

Qualifications Basic:

• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.

• At least 2 years of experience in Information Technology

Preferred

• 2+ years of experience with back end RDBMS and data modeling / database design(Oracle and DB2 preferred)

• 2+ years of hands on experience in Design, Development & Build activities in IBM Datastage(v8.5 and above) ETL Projects

• 2+ years of experience in software development life cycle

• 2+ years of experience in DW/BI related technologies and tools – MUST

• 2+ years of experience in Project life cycle activities on DW/BI development and maintenance projects

• At least 2 years of experience in Design and Architecture review

• Knowledge of IBM Datastage Architecture, Stages/Transformations, Design, ETL flow, advanced SQLs

• Knowledge of data loading techniques using Datastage

• Develop 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.

• Created Datastage sequences to run the batch jobs.

• Knowledge Best Practices in Datastage, Performance improvements, implementing CDC, UDFs

• Understanding of Unix/Linux system, file systems, shell scripting

• Strong understanding of scheduling tools such as Autosys, Control- M, Tivoli etc.

• Good knowledge on MF file structures along with RDBMS.

• Provides expertise in determining the strategic technical direction and system architecture for initiatives.

• Hands-on development mentality, with a willingness to troubleshoot and solve complex problems

• Extensive Experience in Oracle SQL, PL/SQL.

• Good experience with database development tools (Oracle, Toad)

• Good understanding partitioning, indexes, Bitmap indexes, triggers, materialized views.

• Good experience in Query tuning, reading explain plans.

• Experience in Financial domain

• Ability to work in team environment and client interfacing skills.

• Strong analytical skills

• Experience and desire to work in a Global delivery environment

Position : 2

Job title : DataStage Developer

Location : Plano,TX

Full Time Permanent

Qualifications Basic

• Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education

• At least 4 years of experience with Information Technology

Preferred

At least 4 years of experience with back end• RDBMS and data modeling / database design(Oracle and DB2 preferred)

At least 4 years of hands on experience in• Design, Development & Build activities in IBM Datastage(v8.5 and above) ETL Projects

At least 3 years of expe•rience in software development life cycle

At least 3 years of experience in DW/BI related• technologies and tools – MUST

At least 3 years of experience in Project• life cycle activities on DW/BI development and maintenance projects

At least 2 years of experience in Design and• Architecture review

Knowledge of IBM Datastage Architecture,• Stages/Transformations, Design, ETL flow, advanced SQLs

Knowledge of data loading techniques using• Datastage

Develop 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.

Created Datastage sequences to run the batch• jobs.

Knowledge Best Practices in Datastage,• Performance improvements, implementing CDC, UDFs

Understanding of Unix/Linux system, file systems,• shell scripting

Strong understanding of scheduling tools such• as Autosys, Control- M, Tivoli etc.

Good knowledge on MF file structures along• with RDBMS.

Provides expertise in determining the strategic• technical direction and system architecture for initiatives.

Hands-on development mentality, with a• willingness to troubleshoot and solve complex problems

Strong analytical skills•

Extensive Experience in Oracle SQL, PL/SQL.•

Good experience with database development• tools (Oracle, Toad)

Good understanding partitioning, indexes,• Bitmap indexes, triggers, materialized views.

Good experience in Query tuning, reading• explain plans.

Experience in Financial domain•

Experience and desire to work in a Global• delivery environment

Communication and Analytical skills•

Candidate Details:

First Name:

Last Name:

Primary email address:

Alternate e-mail id:

Current Home & Work Location in USA (City, State):

Please confirm your Cell Phone:

What is the best time to reach you:

What is your total Work Experience in years:

Of the above, how many years have you worked in USA:

What is your total IT experience:

Total non-IT experience:

Current Employer Name:

---

Pre-screening Questionnaire:

Do You have Bachelor's Degree:

Visa Status:

Are you willing to travel, if so up-to what percentage:

Are you willing to relocate within the USA:

What’s your lead time to join, if an employment offer is extended to you:

Please specify your current compensation:

Please specify your expected compensation:

Best Regards

Syed Dilawar

Additional Information

All your information will be kept confidential according to EEO guidelines.