Hello Business Partners, Hope you are doing great! Please find below mentioned job description and revert back with the updated resume to [email protected]
*Please share resume with consultant Full Name.* Need Visa & Photo ID Copy Position: Sr. ETL Developer Location: San Francisco, CA Duration: 6-12+ Months *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 *Position details: * - 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. - 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. - 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. - Development experience in compliance related data warehousing projects for Commercial Baking Group (CBG), Regional Banking Group (RBG), Wealth Management Group (WMG) and National Finance Group (NFG). - 10+ years of overall IT experience with exposure to the entire SDLC - User Interaction, Business Analysis/Modeling, 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. - Experienced in using advanced concepts of Informatica like push down optimization (PDO). - Working expertise in data model design using Erwin data modeling tool and good knowledge of Dimensional Data modeling, Star Schema, Snow-Flake Schema, and FACT and Dimensions tables along with CDM, LDM and PDM building. - Expertise in writing SQL, PL/SQL program, Stored Procedures, Package, Functions, Triggers, Views, Materialized Views. - Expertise in Performance Tuning and Debugging of existing ETL processes or long running jobs and Oracle SQL Scripts. - Extensive knowledge of databases like SQL Server, DB2 and Teradata. - Conceptual knowledge of ETL tools like OWB, SSIS and Ab-initio. - 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. - Knowledge of Cloud based and Digital technologies, Informatica Cloud, MS – Azure, AWS, Hadoop, Big data. - Working knowledge in BI tools like SSRS, Cognos, OBIEE, Tableau and BO. - Excellent written and verbal communication. *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 -- Regards Mahesh Kumar Resourcing Specialist Desk No: 201-528-5307 Ext: 422 [email protected] -- You received this message because you are subscribed to the Google Groups "VB.NET 2003 Group" 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 https://groups.google.com/group/vbnet2003group. For more options, visit https://groups.google.com/d/optout.
