Please note that this is a 10 months contract position.
We are seeking an experienced individual for a Senior ETL Developer/ Architect position with a strong technology and solution delivery background. This position is accountable for the successful development, delivery and support of ETL solutions. This position will work closely with other team members (onshore and offshore) to ensure quality delivery of project requirements. This position s main role will be to develop/architect ETL solutions to pull data from a variety of sources and then implement the appropriate business rules to join those sources together in order to serve customers with the analytics data they need. This position will collaborate with business users, developers, architects, project management, and business analysts. The scope of the ETL Senior Developer role involves all aspects of the project life cycle from inception to implementation and support. This role will require designing solutions, determining requirements, analyzing efficiencies, coding, support for functional testing, debugging, documentation, scheduling/managing new program releases, configuring/deploying system updates for implementation and ongoing maintenance.Essential Functions Lead development activities of onshore/offshore team members to implement Informatica based ETL routines and mappings based on customer requirements. Lead and support ETL design sessions with other team members. Ensure user requirements are complete and design meets customer requirements. Provide direction/guidance to onshore and offshore ETL team members. Work with key system users and stakeholders to identify user requirements. Implement Informatica (ETL) solutions based on business requirements. Perform a leadership role in assessing the ETL informatica architecture for enhancement and optimization opportunities. Lead and facilitate design, code, unit test review sessions required by the project team. Oversee development of project plans, including requirements and level of effort (LOE). Coordinate and develop process automation, job scheduling, testing and defect analysis. Ensure communication of project status to leadership and issues within team. Remain current on new ETL techniques and methodologies and communicate trends and opportunities to management and other developers as needed. Experience working across complex organizational initiatives involving multiple stakeholders. Must have excellent oral/written communications, organizational and interpersonal skills.Additional Requirements: 6 + years of Informatica Power Center development experience using 8.x or 9.x versions. 6+ Experience running and monitoring ETL using Informatica Workflow Monitor. 6+ years of experience writing complex SQL queries in a Unix environment. Knowledge of data quality, data profiling and dimensional modeling concepts. Self-starter with strong analytical and problem-solving skills.Education Bachelor's degree in computer information systems, computer science, business OR related field OR four (4) years equivalent experience.
Applicants must provide their phone number. Reference Job Number A25
San Francisco, CA, 94159Contact