*Please send resume to **[email protected]* <[email protected]>*only with contact information and location of candidate **.*
Face to Face required after phone screening local or nearby consultant preferred *Sr. ETL Developer* *6 months+* *Face to face required after phone screening.* *Job Description* * * The ETL Developer will be responsible for designing, developing and implementing data loading processes from multiple application systems into Data Warehouse. The ETL Developer will work very closely with Business Analyst and Data Modeler to ensure the requirements are well understood and develop ETL process that are robust and perform at acceptable service levels. The candidate must demonstrate knowledge of full life cycle of data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading and performance tuning. *Responsibilities * * * • Perform detailed data analysis to understand the source system data. • Participate in reviewing the data warehouse data model. • Design high level ETL process and data flow from source system to DW. • Review source to target data mapping document for ETL processes. • Review physical Database objects including fact tables, dimensions, staging, materialized views, indexes provided by Data Modeler. • Develop & unit test Informatica ETL processes for optimal performance. • Develop & unit test Unix scripts for pre and post loading processes. • Performance tune ETL mappings and report queries. • Work with QA Lead and test engineer and review high level ETL design, source to target data mapping document and be the point of contact for any ETL related questions. • Coordinate ETL and database development work with offshore ETL developers and conduct code reviews. • Work closely with database administration team and ensure the database is architected and designed to handle concurrent ETL and reporting query jobs. • Provide level-4 production support for data warehouse jobs. *Qualifications* * * • BA/BS degree in Computer Science or related field. • 8 years experience implementing Data Warehousing and Business Intelligence solutions. • 8 years of experience in ETL Developer role with strong hands on experience in developing complex ETL processes using Informatica Power Center. • 6 years of experience with Oracle databases and strong SQL and PL/SQL knowledge. (have to be able to CODE in SQL) • Good understanding of Data warehousing project life cycle, especially tasks within the ETL phase. • Extensive experience in performance tuning Informatica ETL jobs. • Solid knowledge of Unix shell scripting. • Demonstrated ability to implement scalable ETL processes. • Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment. • Must be a team player and be able to lead and mentor other developers onsite and offshore. • Good communication and presentation skills and must have the ability to work with people in various groups and departments. • Self starter with ability to manage priorities. • Experience on OV Suite of Products (OVIS, OVPI, OVSR, OVSD, OVSC, SM etc.) is a plus. • Knowledge on ITIL and ITSM is a plus. *Regards,* * Ning* *West Coast Consulting, LLC** **Work – 949 743 0065 x 213 • Fax – 714 844 9091 * *ning**@westcoastllc.com* <[email protected]>* * *www.westcoastllc.com* <http://www.westcoastllc.com/> YahooIM: zavungn ** <http://www.westcoastllc.com/>** -- You received this message because you are subscribed to the Google Groups "SRAOSS REKS" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sraoss-reks?hl=en.
