Arthur Lawrence is urgently hiring for a Data Modeler with hands-on ETL Informatica Development experience in El Segundo, CA for a short-term contract. Kindly find below the details and job requirements.
Requirements:
- Must have 6-12 years of experience in Data Modelling with ETL Informatica Development
- Strong Data Modeling experience in Logical and Physical Modeling for a highly scalable and available platform.
- 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
- Financial industry expertise a strong plus
Please call Robert at 213 784 2016 or email to robert@arthurlawrence.net for more information