*MAX RATE IS $52/hr C2CRole: ETL Developer* *Location: San Francisco, CA* *Duration: 3- 6 months*
*JOB DESCRIPTION:* *ETL Developers: * • 7 - 10 years of overall IT experience with exposure to the entire SDLC - User Interaction, Business Analysis, Design, Development, Integration, Planning, testing and documentation - in data warehouse applications, ETL processing and distributed applications. • Strong expertise in DWH technologies, ETL designing, mapping development including Type-I, Type-II, Type-III slowly changing dimensions (SCD) using Informatica Power Center 8.x/9.x. • Expertise in writing SQL, PL/SQL program in Oracle database. • Expertise in Performance Tuning and Debugging of existing ETL processes or long running jobs and Oracle SQL Scripts. • Hands on experience in writing UNIX shell scripts to process Data Warehouse jobs. • Experience coordinating with Business Users, functional Design team and testing team during different phases of project development and resolving the issues. • Working knowledge in BI tools like OBIEE, Tableau and BO. • Working experience in implementation of Finance and Risk Mart (FARM) to provide consistency and conformity across business lines to support IRR, SCCL Reporting and Credit Risk Model. • Extensive experience in end to end implementation of Comprehensive Capital Analysis & Review (CCAR) and Intermediate Holding Company (IHC) Applications to be compliant with Fed CCAR requirements. • Hands on experience with Data Quality projects such as SOR DQ, Fed EDIT Checks, and KDE using Informatica Data Quality (IDQ) 9.x and PWC 9.x. • Experience in Master Data Management projects using Informatica MDM and PWC along with Oracle. • Excellent written and verbal communication. *Job Responsibilities:* • Working on ETL development for the projects/BAU by following standards & best practices, and proactively coordinating/working closely with QA/Analysts/PMs/Delivery Managers/Business on daily basis • Coordinates with business analyst /business owners on reviewing business and technical requirements documents. • Coordinate/Manage development and testing tasks and ensuring adherence to agreed timelines and communicating status • Help and coordinate with team on the industry standards and best practices for effective use of Informatica data integration and data quality technologies and exception handling • Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members • Ensure transition to production support is facilitated in an organized and planned manner *Skills:* • Strong technical knowledge in Informatica Power Center, Informatica Data Quality and Metadata Manager • Strong Oracle Database technical knowledge in the areas of general SQL • Thorough understanding of Entire life cycle of Software and various Software Engineering Methodologies • Performance tuning and end-to-end lifecycle experience with Enterprise wide data quality solutions • 7-10+ years of experience at Enterprise-level implementation of data Warehouse, regulatory projects and MDM using Informatica PowerCenter, Informatica Metadata Manager and IDQ • 5+ years in banking and financial services is preferred • 5+ years of experience deploying large scale projects using Informatica Tools • Previous experience around Data Warehouse, regulatory projects, data quality control, MDM and Fraud Monitoring projects is preferred and great value addition • Excellent written and verbal communication • Experience in handling multiple projects, cross functional team and off shore teams *Education/Experience:* Master’s or Bachelor’s Degree in Systems Analysis, Computer Science, Software Engineering, Information Systems, Financial systems and accounting or equivalent combination of education and experience required Anjali Dixit Technical Recruiter eTeam, Inc. “ACCELERATED HIRES” 1001 Durham Avenue Suite 201 South Plainfield, NJ, 07080 Direct: (732) 318-3791 Main: 732-248-1900 Ext.122 Email: anj...@eteaminc.com Web: www.eteaminc.com -- You received this message because you are subscribed to the Google Groups "Associate Programs" group. To unsubscribe from this group and stop receiving emails from it, send an email to associate_programs+unsubscr...@googlegroups.com. To post to this group, send email to associate_programs@googlegroups.com. Visit this group at https://groups.google.com/group/associate_programs. For more options, visit https://groups.google.com/d/optout.
