Previous Job
Previous
IDQ Developer / Lead
Ref No.: 17-08586
Location: Sunnyvale, California
Experience in SQL, ETL skills, UNIX, shell, autosys;
  • Informatica Data Quality (IDQ) Product Expertise;
Qualifications:
  • College Degree or equivalent experience; advanced studies/degree preferred;
  • Minimum six (6) years overall current and hands-on development experience with Informatica Data Quality (IDQ) (minimum three (3) years), Informatica Master Data Management (MDM) and Informatica PowerCenter;
  • Minimum five (5) years of current and hands-on experience with complex SQL and high-volume Relational databases and SQL Query performance tuning;
  • Minimum two (2) years of current and hands-on UNIX shell scripting experience;
  • Minimum two (2) years of current and hands-on Autosys experience;
  • Minimum two (2) years of current and hands-on experience with code management tools such as GitHub or ClearCase;
  • Self-starter that takes initiative to fill in gaps where needed;
  • Work with initiative leads, business areas, technical leads, architects, subject matter experts, developers, technical support groups and test teams to deliver value to the business;
  • Review and accept software and interface requirements;
  • Refine and decompose requirements to the level of detail required to initiate development;
  • Design, prototype, develop, test, and document existing and new MDM/IDQ components and make recommendations for functions that result in a more cost effective product delivery;
  • Develop and deliver MDM/IDQ components as specified in the design, functional and non-functional requirements, within established budget, time and quality standards;
  • Perform unit testing of MDM/IDQ components and document test results;
  • Complete code reviews MDM/IDQ components, and complete documentation of issues identified and action items;
  • Correct testing defects and support all testing, including but not limited to: Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing, and Performance Testing.
  • Perform troubleshooting on MDM/IDQ components;
  • Identify application bottlenecks and opportunities to optimize performance;
  • Provide resolution to an extensive range of complicated MDM/IDQ related problems, proactively and as issues surface;
  • Perform code version control activities via GitHub.
Preferred Skills:
  • ETL Development experience with Informatica PowerCenter;
  • ETL Development experience with DataStage (v 8.5 and higher) (desired, not required);
  • Understanding of the secondary mortgage or financial services industry, experience with Freddie Mac and/or Client is desirable;
  • Experience in AGILE based project development;
  • Strong decision making and problem solving skills and experience with project delivery;
  • Technical project coordinator experience. Ability to work independently on multiple projects; and l lead junior and mid-level developers in technology delivery;
  • Superior communications skills, comfortable with working with middle and senior management;
· Experience with DB2, Oracle, Stored Procedures, Complex SQLs tuning, data replication between databases is preferred.