ETL(Informatica) Developer
UNISH CORP - Palo Alto, CA

This job posting is no longer available on Indeed. Find similar jobs: ETL Developer jobs - UNISH jobs

To apply for this job goto:

::::Job Description:::

Understanding Data Sources; Use Data Modeling concepts to design and develop Dimensional Model for a Data Warehouse

Design & Development of Data Integration processes using Informatica PowerCenter
Administer PowerCenter environment to ensure security, auditability
Data Validation, Data Analysis, performance tuning and other required data integration related activities.

Analysis, design, deployment, coding and testing of Data warehousing using Informatica (ETL) on OLAP and OLTP environment and implementation of Database Management Systems for Health care clients.
Proficient in Agile/scrum project methodology

Database Modeling/Designing using Erwin to design Conceptual/Logical/Physical Modeling, Forward/Reverse eng and ER Modeling, Dimensional Modeling (Star Schema, Snowflake Schema) and Data Warehousing, OLAP tools.

Implementation of Data Warehousing, Data Marts, Star and Snow Flake Schema Modeling,
Dimensional Modeling on OLTP and OLAP concepts using Ralph Kimball and Bill Inmon methodologies.
Designing and developing mappings, mapplets and reusable transformations using Informatica Designer. Proficient in Normalization/Denormalization techniques

:::::::::::::::::::Skill set Required ::::::::::::::::::::

ETL/Reporting Tools – Informatica, Oracle Data Integrator, Golden Gate, SQL* Loader
Data Modeling tools – ERwin 8.1, ER Studio Data Architect 8.5, Toad Data Modeler 3.4, MS Visio 2007, Aqua data Studio Modeler
Databases – Oracle, Teradata, Sybase ASE, Sybase IQ, MS SQL Server
Languages – Teradata Bteq Scripting, PL/SQL, T-SQL, UNIX Shell Scripting, Pro*C
Operating systems – UNIX, Windows
Testing/Config Tools – Quality Center, Bugzilla, TeamTrack, Test Case Manager, Autosys, Appworx, Rally, Resultspace, JIRA

::::::::::::::::::::::Wish you All The Best::::::::::::::::::::::::::
Unish Corporation