3018 Oracle sql Jobs

Position Overview:

Do you have passion for understanding customer needs and using technology to deliver value? Are you a ETL developer or Cloud Engineer that thrives in a fast-paced and constantly evolving environment? Do you have broad technical knowledge, production support experience, sound judgment, and strong analytical skills? If you love problem solving, implementing process improvements, inspiring change, and collaborating with others, this may be the role for you! Apply today to join our Platform and Data Solutions ETL development team!

Our Impact:

The Corporate Data Warehouse (CDW) is a corporate data repository that makes accessible historical and current business relevant data from disparate data sources residing within Freddie Mac's transaction processing and end-user systems into one relational database for decision support, management reporting, ad-hoc and trend analysis, modeling, and data mining purposes.

We are also leading the change to build Cloud Native Data Warehouse in Snowflake using our Cloud Native Data Lake platform that enable consolidating, centralizing and consuming shared data for the enterprise to serve various data analytics and reporting needs!

The Development ETL team promotes a more collaborative and productive work environment by bringing development, testing and operations together. It is the combination of ETL and Cloud skills, process, practices, and tools that enhances our ability to deliver services at large scale with high velocity and reliability!

Your Impact:

• Lead team of ETL developers, perform root cause analysis, and develop effective solutions to existing issues.

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

• Participate in Requirements Analysis; participate in the designing of solutions based on System Requirements and Architecture, prototype if necessary, develop, unit test and deploy applications.

• Contribute to the enhancement of department application development/delivery standards, tools and processes.

• Able to do analysis and make code changes to the DataStage ETL, Java, Talend (Cloud), and Unix jobs.

Qualifications:

• 5+ years of experience in DataStage (ETL), shell scripting, and DB2/Oracle SQL skills, Mainframe JCL, Cobol, SAS.
• 2+ years of demonstrated ability with Cloud Stack in AWS, Talend (Integration Tool), Snowflake (Cloud computing data storage and analytic service), Spark, etc.
• Experience with IICS (Informatica Intelligent Cloud Services), Informatica Power Center, and Talend.
• Strong analytical and development skills required to trouble the issues and developed effective solutions.
• Good knowledge of database concepts with working knowledge on SQL, DB2 or Sybase database, and Stored Procedures
• Good attitude that will allow the team to perform better, work as a great teammate.
• Innovative in providing solutions, likes to take on challenges with calculated risks.
• Experience in all aspects of system development life cycle methodologies including waterfall and/or agile development
• Bachelor’s degree in Computer Science or Engineering or equivalent working experience

Keys to Success in this Role:

• Not a just developer, but a developer with an attitude to think holistically to build a reliable, flexible, and well performing system.
• A spirit for innovation and ability to work in the space of “no longer” and “not yet”
• Ability to quickly comprehend the functions and capabilities of new technologies
• Strong written and oral communications skills.
• Proactive in nature with customer satisfaction as primary goal.
• Innovative in providing solutions, likes to take on challenges with calculated risk.
• Quick learner of new technologies and tools.

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.

CA Applicants:  Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

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 www.BountyJobs.com and register with our referral code: MAC.

Time-type:Full time

FLSA Status:Exempt

Freddie Mac offers a comprehensive total rewards package to include competitive compensation and market-leading benefit programs. Information on these benefit programs is available on our Careers site.

This position has an annualized market-based salary range of $116,000 - $174,000 and is eligible to participate in the annual incentive program. The final salary offered will generally fall within this range and is dependent on various factors including but not limited to the responsibilities of the position, experience, skill set, internal pay equity and other relevant qualifications of the applicant.