Senior DataStage Developer (Hybrid Work Schedule)

  • Freddie Mac
  • McLean, VA, USA
  • Aug 01, 2022
Full time Other

Job Description

At Freddie Mac, you will do important work to build a better housing finance system and you ll be part of a team helping to make homeownership and rental housing more accessible and affordable across the nation.

As part of Freddie Mac s return to the office pilot, all employees, contingent workers and visitors must be fully vaccinated against COVID-19 in order to be on-site unless they have an approved accommodation.

Position Overview:

Are you passionate to work with the most valuable asset of an organization - "Data"? Do you love to explore the options with ETL? Do you embrace change and innovation and push the boundaries of what is possible? Do you embody Agile delivery at the core of your being? If you said YES to one of these, our Senior Development position with Platform & Data Solutions division could be for you!

This position is a hybrid work schedule, requiring 2 days in the office and 3 days remote

Our Impact:

The Information Technology (IT) Division helps enable and transform Freddie Mac's business. We provide data platforms and capabilities that benefit the enterprise, customers, employees and our business partners. Our technology enhances the services we offer to our customers and improves productivity for our employees. Freddie Mac will support your continued professional development through access to targeted training courses and learning opportunities, as well as exposure to senior management!

Your Impact:

Help implement enterprise data product vision and communicate effectively to key partners and be part of a team designing and coding the future technologies and applications that support Freddie Mac's mission of making home possible.

What you'll be doing:

Develop and deliver ETL components, as specified in the design, functional and non-functional requirements, within established budget, time and quality standards. Provide resolution to an extensive range of complicated application related problems, proactively and as issues surface. Identify application bottlenecks and opportunities to optimize performance. Perform code version control activities via GitHub. Autosys or another job scheduler.

5+ years of ETL tool experience using IBM Information Server (DataStage) 11.5/9.1/8.x/7.x.
Experience in writing technical specification documents, translating user requirements to technical specifications.
Experience in designing and developing jobs using Data Stage Designer.
Experience in importing/exporting DataStage jobs using DataStageManager7.x and using IBM Information Server (DataStage) 11.5/9.1/8.5/8.0.1 Designer
Experience with Pl/SQL concepts like Stored Procedures, Packages, Functions, and Triggers.
Experience in using highly scalable parallel processing Infrastructure using DataStage Enterprise Edition (PX).
Strong understanding of the Data Warehousing Techniques and Star/Snow flake models.
Proficient in working with ETL processes across Oracle, Access, SQL Server, and DB2 Databases.
Strong experience with Data Modeling and Dimensional Modeling techniques, proficiency in design and implementation of Star and Snowflake schemas.
Extensive experience working with Data Marts and Data Warehouses.
Strong experience working with DataStage plug-in stages
Excellent knowledge of studying the data dependencies using Metadata of Data Stage and preparing job sequences for the existing jobs to facilitate scheduling of multiple jobs.
Experience with DataStage job scheduling process using the Autosys, Control-M tools and DataStage scheduler.
Strong experience in writing UNIX shell scripts for Data validations, Data cleansing, DataStage job executions etc.
Keys to Success in this Role:
Excellent problem solving and analytical, and technical skills
Ability to think critically and act expeditiously to evaluate situations, make decisions and tackle problems
Strong oral and written communication skills, and ability to work well with a variety of teams
Ability to work effectively with continuous change and short deadlines
Proven business acumen, problem solving skills, intellectual maturity, and relationship management skills

Current Freddie Mac employees please apply through the internal career site.

Today, Freddie Mac makes home possible for one in four home borrowers and is one of the largest sources of financing for multifamily housing. Join our smart, creative and dedicated team and you ll do important work for the housing finance system and make a difference in the lives of others.

We are an equal opportunity employer and value diversity and inclusion at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by applicable law. We will ensure that individuals with differing abilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

Notice to External Search Firms: Freddie Mac partners with BountyJobs for contingency search business through outside firms. Resumes received outside the BountyJobs system will be considered unsolicited and Freddie Mac will not be obligated to pay a placement fee. If interested in learning more, please visit and register with our referral code: MAC.

Time-type:Full time

Job Category:Information Technology

FLSA Status:Exempt

Freddie Mac provides anticipated base salary ranges where required by law.