ETL Lead in Pleasanton, CA

Mastech Inc is a growing company dedicated to innovation and teamwork. We are currently seeking an ETL Lead for our client in the Health Care domain. We value our professionals, providing comprehensive benefits, exciting challenges, and the opportunity for growth. This is a W2 position and the client is looking for someone to start immediately. Duration: 12 months Location: Pleasanton, CA/ Zip Code: 94588 Compensation: $50 - $55/ Hourly on W2 Role: ETL Lead Role Description: The ETL Lead would need to have over 10 years of experience. This ETL Lead would be involved in at least 3-4 end-to-end DW/BI implementation projects and would be current with the latest industry trends. The candidate would be a self-starter with the ability to lead, design, develop, and implement ETL jobs. This candidate would be primarily focused on the creation, management, and availability of all data needs for the Business Intelligence and Reporting solutions as per the data model created by Data Modeller. Responsibilities: - Would load, verify, and publish data. - Work in conjunction with the Data Modeller and Architects to create, modify, or update data flows from the Source Systems to Staging; Staging to Repository; and Repository to Reporting (OLAP Cubes and Data Marts). - Perform analysis, design, development, testing, documentation, and implementation of Ab Initio software components - Follow development guidelines, standards, and procedures. - Participate in requirements, design, and code reviews and get the big picture. - Administer and maintain the ETL metadata repository in a multi-user environment. - Lead the project independently and communicate with Business Analysts, ETL developers and QA team. Required Skills: - 7+ years of development experience including 5+ years of Informatica development experience (total of 10 years plus experience is required). - Experience with Star Schema and OLAP modeling. - Experience with Oracle, DB2, and SQL. - Experience with UNIX internals and Shell scripting. - Deep knowledge of Ab Initio and Informatica deployment and architecture. - Understanding of Change Management and automation/repeatability. - Strong knowledge and use of Full Lifecycle Development Methodologies, standards, and procedures. - Ability to multi-task and provide expertise for multiple development teams across concurrent project tasks. - Resourceful and self starter with minimal hand holding required. - Good team work and communication skills. - Must be able to also perform as a Data Analyst and address overall data quality, including the design of ETL strategies to source, match, and merge from various disparate systems. - Ability to communicate effectively with both technical and business team members. Nice to have skills: - Experience with PL/SQL. - Experience with any Informatica ETL tools would be a plus. Education: Bachelor's degree. Experience: 10+ years Relocation: This position will not cover relocation expenses Travel: No Local Preferred: Yes Recruiter Name: Angelin Thilaka Recruiter Phone: 412 360 7820 Experience: ETL To Apply to this job go to http://www.GadBall.com or click here