etl informatica

Sr. ETL/Informatica Analyst/DeveloperSeeking 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. Auto industry, 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 projectsDesigns and implements industry best ETL technologies to satisfy client requirementsDesigns and develops optimal code to maintain exceptional performance in processing large volumes of data across diverse sourcesGathers and translates business requirements into analytical applicationsCollaborates with other project members and drive the development of BI initiativesDesigns, develops, and tests ETL solutions including modeling data warehouse metadata and automating data loading processesEstablishes ETL environments according to project requirementsDesign and develop ETL processes to satisfy all program area requirementsDevelops and implements an efficient migration process to move ETL objects from development to test and production environmentsUnderstands database design, programming concepts, data modeling and framework managementSupports star schema modeling and implementation of a data warehouseCommunicates ideas to both technical and non-technical people in all levels of the organizationEffectively communicates technical architecture details of INFORMATICA and other parts of the BI solution to othersDevelops advanced, and complex INFORMATICAWorks with Business Analysts, Data Architects, Enterprise Architects and ETL Architects to ensure business requirements are being met with the solution being developedIdentify and reuse of ETL components and services to avoid duplicative implementationsMentor other team members in developing, documenting and modifying ETL componentsSupport and administer the INFORMATICA environmentsMusts:BA/BS in computer science or equivalent trainingFull understanding and experience in implementing BI solutions and data warehousing is requiredFull understanding of INFORMATICA 9 is required especially dealing with very large volumes of data, real time or micro batchesFull 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 requiredData architecture and modeling experience implementing proper data structures for a BI solution using tools such as INFORMATICA and COGNOS is requiredINFORMATICA 8 or 9 certification, Scrum Master Experience or Certification (Preferred)Experience Level: Data Warehousing – 3-5 year(s) ETL – 3-5 year(s) Informatica – 3-5 year(s) Oracle/SQL – 3-5 year(s) Data transformation (ETL): 7+ YearsOutstanding Informatica design and development abilitiesExperience in ETL performance tuning/optimizationExperience working with complex Informatica transformationsStrong experience identifying, researching, and resolving ETL issues and producing root cause analysis documentationExperience writing ETL ETL specificationsExperience developing complex ETL mappingsExperience with Extraction, Transformation and Loading (ETL tools) to facilitate loading large amounts of dataExperience with versioned repositories and configuration managementIdentifies areas of improvementOracle Database: 7+ Years Understanding of Oracle PL/SQL techniques to write stored procedures, triggers and packages that analyze several million rows across several database tablesAbility to grasp relational data models quickly and program using SQL and PL/SQLClear understanding of SQL's analytical processing capabilitiesUnderstanding of Oracle dynamic SQL and ability to write complex procedures using dynamic SQLFamiliarity with Oracle Data Partitioning techniques to manage, support and performance tune very large databases (VLDB's)Understanding of Parallel execution features of Oracle to dramatically reduce response times for data intensive operationsAbility to write efficient PL-SQL procedures. Design complete solutions.Database / Other: 5+ Years Experience in the analysis, design, development & deployment of large scale databasesExperience in the design and development of data warehousing is a plusAbility to write and understand complex SQL requiredKnowledge of Oracle PL/SQL best practices and development methodologies or standards - Stored Procedures, Packages, Triggers, Debugging, TuningData modeling Experience a plusData Warehousing experience a plusUnix OS: 5+ Years Experience working with Unix serversExperience with Shell scriptingBachelor's degree in computer science or related discipline or have equivalent experienceStrong ETL design and development abilities, PL-SQL and Stored Procedures to upload data from different sources