Seeking an experienced Senior Developer who specializes in Informatica, Oracle database and PL-SQL / Data warehouses / Unix servers and shell scripting. Ability to design solutions and conduct data analysis is required. CRM and knowledge of marketing concepts are pluses. The position will be supporting a custom CRM application, specifically the analytical repository. The repository is an Oracle database, the OS is Unix AIX 6.x. The responsibilities for the position include the analysis, design, and development.
The candidate will be assigned to work on a specific project related improving data quality, under the supervision of the ECRM team lead.
Responsibilities • Provides ETL processing subject matter expertise to client projects • Designs and implements industry best ETL technologies to satisfy client requirements • Designs and develops optimal code to maintain exceptional performance in processing large volumes of data across diverse sources • Gathers and translates business requirements into analytical applications. • Collaborates with other project members and drive the development of BI initiatives. • Designs, develops, and tests ETL solutions including modeling data warehouse metadata and automating data loading processes. • Establishes ETL environments according to project requirements • Design and develop ETL processes to satisfy all program area requirements • Develops and implements an efficient migration process to move ETL objects from development to test and production environments • Understands database design, programming concepts, data modeling and framework management. • Supports star schema modeling and implementation of a data warehouse • Communicates ideas to both technical and non-technical people in all levels of the organization. • Effectively communicates technical architecture details of INFORMATICA and other parts of the BI solution to others • Develops advanced, and complex INFORMATICA • Works with Business Analysts, Data Architects, Enterprise Architects and ETL Architects to ensure business requirements are being met with the solution being developed. • Identify and reuse of ETL components and services to avoid duplicative implementations • Mentor other team members in developing, documenting and modifying ETL components • Support and administer the INFORMATICA environments Musts BA/BS in computer science or equivalent training. • Full understanding and experience in implementing BI solutions and data warehousing is required • Full understanding of INFORMATICA 9 is required especially dealing with very large volumes of data, real time or micro batches • Full comprehension of SQL, cardinality, levels of granularity, normalized vs de-normalized, handling of slowly changing dimensions, auditing, database and tool optimization techniques and other such data architecture best practices is required. • Data architecture and modeling experience implementing proper data structures for a BI solution using tools such as INFORMATICA
Experience Level: • Data Warehousing – 3-5 year(s) • ETL – 3-5 year(s) • Informatica – 3-5 year(s) • Oracle/SQL – 3-5 year(s)
El Segundo, CA, 90245