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.
Rachita
|Technology Resource Group.|
Office: 408-709-1760 Ext-941 | Rachita@tresourceinc.com |
Yahoo-IM- Rachita.recruiter10
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at http://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment