Job Description :
KAYGEN is an emerging leader in providing top talent for technology based staffing services. We specialize in providing high-volume contingent staffing, direct hire staffing and project based solutions to companies worldwide ranging from startups to Fortune 500 and Managed Service Providers (MSP) across a wide variety of industries

Title: Senior ETL Developer
Location: El Segundo, CA

Additional Details:
Project Overview - We are looking for a Data Modeler with hands-on ETL Informatica Development experience
Role & Responsibilities - · Developing or Enhancing Data model (Logical and Physical Modeling) for a highly scalable and available platform.
· Implementing dimensional/relational modeling techniques
· Design, development, implementation, administration troubleshooting and support of ETL process using Informatica
· Tune performance of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval
· Designing, developing and implementing extraction, transformation and load techniques on multiple database platforms and operating system environments
· Design, development and maintenance of database for financial industry
· Develop the delivery project plans and milestones
· Motivated to take independent responsibilities and be able to drive the offshore team on the milestone deliveries

Other Requirements - · Strong Data Modeling experience in Logical and Physical Modeling for a highly scalable and available platforms.
· Good understand of the dimensional/relational modeling techniques
· Excellent experience in requirement gathering, Gap Analysis from both functional and technical perspectives
· Strong experience in design, development, implementation, administration troubleshooting and support of ETL process using Informatica
· Designed and developed the ETL process using Informatica tool
· Expertise with Performance tuning of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval
· Worked on performance tuning, identifying and resolving performance bottlenecks on various levels like sources, targets, mapping
· Experience in designing, developing and implementing extraction, transformation and load techniques on multiple database platforms and operating system environments
· Developed all mapping, session and workflows according to the design need
· Extensive experience in implementation of data cleanup procedure, transformations, scripts and execution of test plan for loading the data successfully into the target
· Excellent analytical, programming and communication skills
· Financial industry expertise a strong plus

Years of Experience Required - 6-10

At KAYGEN, we are always looking for dynamic, talented and experienced individuals. We invite you to join our team of talented IT professionals, consulting at client locations across the globe. Our culture is team-orientated; we strive to stand by our core values of respect, honesty and integrity. Our team of experienced staffing experts will work with you to find you the best opportunity. For more information please visit us at .