-- Please Share Me Profile [email protected] <http://sourceinfotech.com/>
*Senior ETL Informatica – Lead/Architect* *Monterey Park, CA* *Long term * *Job Summary: * The Senior *Informatica* *WhereScape* ELT Developer will be involved in designing & developing extract/transform/load routines, performing intensive data analysis, loading 3NF and dimensional data models, preparing design documents and participating in all phases of testing. Hands-on experience in designing and implementing data warehouses and data marts for large financial institutions. Experience leading a development team to implement high-quality solutions using ETL and ELT tools and related database technology such as DB2, Oracle. *Essential Functions: * Responsible for design, development, implementation, and maintenance of Data Warehouse and downstream applications, system architectural direction and recommendations using *Informatica* ETL and *WhereScape* ELT technologies. Prepare detailed specs from which programs will be written. Develop complex workflows and mappings using *Informatica* ETL and shell scripts to satisfy the business requirements. Test ETL and reports of others for quality assurance, and migrating releases into testing and production environments. Support the UB Data Warehouse batch cycle and any required changes to the schedule. Assist the team by helping them in the data analysis requests, internal controls, performance tuning, etc. Contribute to peer code reviews for all ETL changes Debug and troubleshoot issues. Research and evaluate solutions and recommends the most efficient and cost effective solutions for the system design. May provide assistance or training to lower level staff Provides conceptual guidance to other senior and high-level technical experts. *Skills ,Experience and Qualifications * Bachelor's Degree in Computer Science, Information Systems with 8-10+ years of experience in performing the following: Full system development life cycle (SDLC) experience; Experience with *Informatica* ETL, Databases and UNIX a must. Experience with *WhereScape* ELT will be a huge plus Experience with Data Warehousing and dimensional data models (Star Schemas) in Banking/Financial Services experience is a must. Advance SQL knowledge, database knowledge and data modeling knowledge are a must. BI experience a big plus. Must have expertise in quality assurance and integration methodologies Must be able to perform well in high pressure, time-sensitive environments Must have strong verbal and written communication skills. Regards, *Rachita* |*Technology Resource Group.*| Office: *408-709-1760 Ext-941 *| *[email protected] <[email protected]>* | Yahoo-IM- Rachita.recruiter10 -- You received this message because you are subscribed to the Google Groups "Oracle Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/oracle-users. For more options, visit https://groups.google.com/d/optout.
