JOBSEARCHER

Developer-ETL/Informatica Senior

ETL Developer, SrLocation: Remote or Onsite is fine.
Work Authorization: H1B Candidates MUST be able to commit to a full 12 month contract without the need for sponsorship. This requirement is open to sponsored candidates through sub-vendors - one layer deep. The candidates must be W2 employees of the sub vendor and have at least three years remaining on their current visa. Extension/Conversion: This is a 12 month contract.
Technical Must Haves: Informatica Power Center, SQL Database, and Unix Shell scripting. Strong Preference for Python, Snowflake and experience processing large volumes of both structured and unstructured data. Preference for Agile experience.
Soft Skill Must Haves: Must have excellent 10/10 written and verbal communication skills, needs to be able to operate independently and have excellent time management skills.
Schedule: Standard 40 Hours. Shortlisting Dates: 9/28, 9/29*, 9/30 Submittal Deadline: 9/30 @ 5:00 PMHoliday Furlough: This position is expected to be affected by the holiday furloughs. Interview Information: This is an immediate need - No reschedule Requests will be accommodated, so please ensure candidate availability during available time-slots prior to submission- Single Round Interview Process - 30 Minute MS Teams Video Interview; 4 Slots Available - 10/4 @ 10:00am, 10:30am, 11:00am, 11:30amSupplier Vetting Questions - *Please include answers to these question at the top of candidate resume. Submittals without answers will not be considered. Candidate responses will not be accepted via email. Additions or alterations to answers will not be accepted *In your current role - how much time each day do you spend doing hands-on development with ETL tools. Please describe your approach to coding, testing, implementing, debugging and documenting ETL programs. Which part of this process are you most proficient with and why? Which part of this process are you least proficient with and why? What ETL Tools do you have experience with? How many years of experience do you have with each tool? When did you last use each tool? Please provide an example of what you used each tool for. Please describe your experience processing large volumes of data. Have you worked with; structured and unstructured data, XMLs, JSONS, PDFs? Please describe a recent project. Freddie Macs Credit Capacity Department is currently seeking a ETL Developer, Sr to do design, development, maintenance and production support for various applications within the Single Family Credit Innovation Team. The qualified candidate will design, develop, and deploy software tools to increase the efficiency of AIM Data processes. This position is to support backend ETL development for our Suite of Web Applications and Data initiatives for Credit Capacity R&D department. The position will be tasked with developing deep understanding of data and current ETL code base, design analytical approaches for business questions and scenario evaluations, managing data & technology research and processing.
Responsibilities include: ETL Typically has 5-6 years of experience in Informatica Power Center, IICS and other ETL tools and technologies. Possess 3-5 years of experience in Python, R, Big Data tools and technologies. Strong understanding and working knowledge of Database SQL and experience in Oracle, Vertica, Snowflake etc. Strong background in processing large volumes and variety of data (Structured and unstructured data, XMLS, JSONs, PDFs). Cleanse, Analyze and Develop ETL scripts to load large datasets into Relational databases, Understand re-usability, parametrization, workflow design, etc. Develop ETL maps using Informatica, Scripting (Batch, shell), Data analysis, data mapping, data loading, and data validation. Maintain and manage technical meta data and documentation for data warehousing and ETL processes. Perform overall ETL solution design and creation of design specifications to implement changes. Develop the ETL processes and is involved in designing and preparing the codes that meet the program specifications as well as the client requirements. Involve in the effective implementation of Informatica programs, tests them, evaluates the requirements, addresses and resolves the issues associated with itDatabase Good knowledge of database concepts with working knowledge on SQL and Stored Procedures. SQL Development - ability to write, troubleshoot and optimize SQL code and design (stored procedures, functions, views, triggers, indexes, constraints). Understanding of logical & physical data design, tables, normalization techniques, relationships, primary & foreign keys, and data types. Automation/Production Support Participate in Requirements Analysis, design Applications based on System Requirements and Architecture, prototype if necessary, develop, unit test and deploy applications Experience with Unix Shell script, Autosys, Stored Procedures, Complex SQLs tuning, data replication between databases is preferred. Testing Develop test plan and/or test application in development status or debug application in production mode. Document or review documentation of steps in specification development, coding, testing and user acceptance for future reference and for internal control purposes. Analytical Skills Independently determines and develops approach to solutions, ability to work under limited direction. Collaborate with team members and Must be able to manage multiple priorities and meet deadlines. Ability to demonstrate a constant and quick learning ability and should be flexible to adapt to the new developing technologies. Excellent problem solving skills and the ability to handle pressure situations without compromising on quality are a must.
Basic Requirements:
  • Experience in ETL and exposure to Data Modeling
  • Experience in development and troubleshooting of complex ETL/Data applications (Informatica tool sets preferred)
  • Analytical and testing support for others in the team
  • Hands-on experience with XML and XSD based interfaces and tools
  • Experience working with JSON, XML and unstructured data processing
Possess Excellent analytical, programming, written and verbal communication skills.
Preferred Skills:
  • Knowledge of SAS would be helpful
  • Knowledge of Python is preferred
  • Strong working knowledge of Cloud Framework
  • Familiarity with Big Data Hadoop environment is a plus.
  • Agile development methodology experience preferred
  • Understanding of the secondary mortgage industry, experience with Freddie Mac and/or Fannie Mae is desirable.