ETL Developer Job at PTR Global, McLean, VA

NmNMUGg1T2NOcnFUYVpaL2cyN1hnVGxlTnc9PQ==
  • PTR Global
  • McLean, VA

Job Description

Job Description

Job Title: ETL/DataStage Developer

Location: McLean Virginia / Plano, TX onsite role

Duration: 03+ Months (CTH)

Supplier Vetting Questions:

1. How long have you worked on DataStage, DB2, SQL, UNIX, and Control-M and in what capacity?

2. Can you explain how you approach designing and implementing an ETL workflow using DataStage, DB2, SQL, UNIX, and Control-M?

3. Have you automated any ETL or batch processes using Unix or a python script? if so, explain.

4. Describe a time when you had to adapt your technical approach to meet changing business requirements. How did you ensure your DataStage workflows, SQL queries, and Control-M schedules stayed aligned with business objectives?

Position Overview

Client has an exciting opportunity for a Development, Prf to work in the Enterprise BTO department of the Information Technology division. We are seeking a motivated individual to design and develop enhancements to software applications on a DataStage ETL (11.x). As a member of the IT development team, the Individual would implement software changes and address data related issues. The individual would champion technology and tools changes/improvements that improve delivery processes. Work collaboratively with other open minded, technology savvy and dedicated agile team members.

Responsibilities

• Develop effective solutions to new and existing data reporting requirements and data issues primarily using DataStage.

• Perform root cause analysis and address existing issues.

• Find gaps in the existing processes, constantly improve the processes/procedures, automate manual tasks and provide stability to the applications.

• Participate in analysis of agile user stories; participate in and develop solution based on business requirements and architecture, prototype if necessary, unit test and deploy quality solutions.

• Perform analysis and make code changes to the DataStage ETL and Unix jobs.

• Support applications in production.

Basic Requirements:

• Bachelor’s degree in Computer Science or Engineering or equivalent working experience

• At least 3-4 years of experience in DataStage (ETL) preferably 11.7, UNIX, shell scripting, Control-M and db2/Sybase/Oracle SQL, Jira, Bitbucket skills.

• Strong analytical and development skills required to troubleshoot issues and develop effective solutions.

• Team player with positive attitude.

• Innovative in providing solutions and likes to take on challenges with calculated risks.

• Strive to constantly improve the application development processes and tools.

• Experience in all aspects of system development life cycle methodologies including agile development

• Quick learner of new technologies and tools.

• Excellent customer service skills.

• Excellent verbal and written communication skills. Ability to communicate effectively with team members, stakeholders, and management on both the business and IT sides.

Preferred Skills

• Working experience in Java, SAS

• Experience working on agile teams.

• Experience in Mortgage Industry.

Job Tags

Work experience placement,

Similar Jobs

Piedmont HealthCare

Palliative Care Physician Job at Piedmont HealthCare

 ...Places to Work? Here at Piedmont Healthcare we are seeking a Palliative Care Physician that is committed to providing high quality and...  ...Hospital in Conyers, GA Qualifications Board Certified in Hospice and Palliative Care (fellowship trained with Palliative Care... 

Mom to Virtual Assistant

Virtual Assistant 10-15 Hours per Week (IC-GC) Job at Mom to Virtual Assistant

 ...DropBox WordPress Mailchimp Raptive Requirements ~ Experience in WordPress (a must)~ Experience with newsletters (a must)...  ...~ Self-starter and ability to work independently~10-15 hours per week (availability to grow as role grows)~ Pacific, Mountain... 

Powerback Rehabilitation

Market Director-PB Rehab OT Job at Powerback Rehabilitation

 ...Job Description Overview: Market Director Missouri Salaried Position St James, St Louis,...  ...growing with free CEUs through Medbridge. H-1B Visa & Relocation Assistance: We support Visa or Green Card sponsorships, plus our Journey Travel Program lets you work... 

Workbox Staffing

Structural Steel Fabricator Job at Workbox Staffing

 ...Job Description Job Description 1st shift - Fabricator, $20/hr - Grand Rapids Come work for a company that f abricates structural steel beams used for the construction industry! Preferred Qualifications: Lifts, positions, and removes work pieces from conveyors... 

St. Louis Park Public Schools

Supervision Assistant | Health Office Assistant Job at St. Louis Park Public Schools

 ...Title: Supervision Assistant/Health Office Assistant DBM Classification: B21/Class 4 | B22/Class 5 Department: Elementary...  ...learning environment for all students. EDUCATION and/or EXPERIENCE Experience working with children in an educational, childcare...