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 bull Provides ETL processing subject matter expertise to client projects bull Designs and implements industry best ETL technologies to satisfy client requirements bull Designs and develops optimal code to maintain exceptional performance in processing large volumes of data across diverse sources bull Gathers and translates business requirements into analytical applications.
bull Collaborates with other project members and drive the development of BI initiatives.
bull Designs, develops, and tests ETL solutions including modeling data warehouse metadata and automating data loading processes.
bull Establishes ETL environments according to project requirements bull Design and develop ETL processes to satisfy all program area requirements bull Develops and implements an efficient migration process to move ETL objects from development to test and production environments bull Understands database design, programming concepts, data modeling and framework management.
bull Supports star schema modeling and implementation of a data warehouse bull Communicates ideas to both technical and non-technical people in all levels of the organization.
bull Effectively communicates technical architecture details of INFORMATICA and other parts of the BI solution to others bull Develops advanced, and complex INFORMATICA bull Works with Business Analysts, Data Architects, Enterprise Architects and ETL Architects to ensure business requirements are being met with the solution being developed.
bull Identify and reuse of ETL components and services to avoid duplicative implementations bull Mentor other team members in developing, documenting and modifying ETL components bull Support and administer the INFORMATICA environments Musts BABS in computer science or equivalent training.
bull Full understanding and experience in implementing BI solutions and data warehousing is required bull Full understanding of INFORMATICA 9 is required especially dealing with very large volumes of data, real time or micro batches bull 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.
bull Data architecture and modeling experience implementing proper data structures for a BI solution using tools such as INFORMATICA Experience Level bull Data Warehousing ndash 3-5 year(s) bull ETL ndash 3-5 year(s) bull Informatica ndash 3-5 year(s) bull OracleSQL ndash 3-5 year(s)