ETL Developer with DataStage Specialist - Plano TX McLean VA McLean VA preferred - Hybrid

Role: ETL Developer with DataStage Specialist

Location: Plano TX / McLean VA (McLean VA preferred) Hybrid

Hire Type: Long Term Contract W2/C2C

Experience : 10 Years

Call Notes:

• Plano TX / McLean VA (McLean VA preferred)
• Open for all visa
• Must Haves: DataStage Unix SQL and ControlM. Preferred: SAS AWS Python & Java
• Working on agile team 2week sprint
• Doing some data research perform ETL development.
• Python is preferred but not required.

Category

Name

Required

Importance

Experience

Software Skills

ControlM

Yes

1

4 6 Years

Software Skills

SQL

Yes

1

4 6 Years

Software Skills

UNIX

Yes

1

4 6 Years

Software Skills

Amazon Web Services (AWS)

No

2

Software Skills

Java

No

2

Software Skills

SAS

No

2

Technical Skills

Python

No

2

Developer ETL/DataStage Specialist

MSP Owner: Ashley Dultmeyer

Location: HQ3 onsite is required Mclean in preferred will consider Plano but candidate must be onsite twth

Assignment Type: 3 months possible extension no plans to convert.

Work Authorization: This requirement is open to sponsored candidates through subvendors one layer deep. The candidates must be W2 employees of the sub vendor

Must Haves: DataStage Unix SQL and ControlM. Preferred: SAS AWS Python & Java

Interview Information:

Rounds: 1

Duration: 60 mins

Interview Type: MS Teams Video Mandatory

Interview Placeholders: 03/:30 pm 3/:00 PM3/8 @12:30 PM

Interview Debrief: 3/11

Position Overview:

Are you looking for an opportunity to join our fast paced and passionate team that supports multiple IT applications built on various technologies with continuous modernization in progress Within Corporate Technologies Finance Delivery Services organization we are a multiskilled agile team that continuously strive to collectively discover new opportunities to implement innovative automated and costefficient solutions. If this excites you please apply now!

Our Impact:

• We build and enhance software applications required for mandatory reporting of Freddie Macs mortgage loan data to Federal Housing Finance Agency.

Your Impact:

You will have significant impact on our team and in our organization. You will primarily develop code for data centric software applications while embracing and promoting the Agile attitude. You will help implement Regulatory Reporting product vision and communicate effectively to key partners. You will also assist with evaluation of new technologies with quick proof of concepts and support applications in production.

Responsibilities include the following.

• Develop scalable and reliable data solutions to move data across systems from multiple sources in real time as well as batch modes
• Develop innovative and automation solutions in the areas of data engineering including technology implementations using Agile construct
• Support applications including providing fixes to production defects and making enhancements
• Quickly evaluate defects investigate causes and come up with solutions to address defects
• Provide production support and providing clear communication on the resolution of incidents

Qualifications:

• Bachelors degree in Computer Science or Engineering or equivalent working experience
• 4 years of experience in delivering solutions using Software Development Life Cycle
• 4 years ETL experience using DataStage Unix SQL and ControlM
• Strong data analytical skills using complex data sources including databases and text data files

Optional Skills:

• Data Engineering solution delivery using SAS AWS (S3 Glue Athena EMR PySpark Data lake) Python Snowflake Dev Ops and CI/CD tools
• Knowledge and experience working with Informatica
• Knowledge and experience working with Java

Keys to Success in this Role:

• Ability to work effectively and productively in a team or independently
• Technologyfirst mindset outstanding analytical skills and drive for innovation
• Willingness to try new things fail fast and learn fast