SUMMARY

• 大约8年的萃取经验, Transformation and Load (ETL) of data from Legacysystems using Informatica (9.1.0/9.0.1/8. x).
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server, DB2.
• 数据仓库全生命周期开发知识.
• Have extensively worked in developing ETL program for supporting Data Extraction, 使用Informatica Power Center进行转换和加载.
• Experience with dimensional modeling using Star Schema and Snowflake models.
• Expertise in Data Warehousing concepts like Bill Inmon methodology and Ralph Kimball methodology, 事实表, 维度表.
• Understand the business rules completely based on High Level document specifications and implement the data transformation methodologies.
• 熟练使用信息源分析器等Informatica Designer组件, 映射的设计师, Mapplet设计师, 转换开发人员(可重用转换), 工作流管理器, 工作流监控.
• 与缓慢变化的维度广泛合作.
• Extensive experience in ETL process consisting of data transformation, 采购, 映射, 转换和装载.
• 能够审查项目可交付成果的完整性, 质量, 并遵守项目标准和规范.
• 精通Oracle 10g/9i/8i/7.3、PL / SQL开发蟾蜍、SQL、PL / SQL、Teradata.
• Excellent analytical, communication, inter-personnel, team player and Leadership skills.
• 能够快速学习和适应新兴的新技术.

技术技能

数据仓库ETL: Informatica 9.1.0/9.0.1/8.6/8.1.2、Informatica Designer, 工作流管理器和Workflow monitor.

BI工具: 业务对象.

编程语言: C, c++， COBOL.

数据库: Oracle 8i/9i/10g/11g, IBM DB2, SQL Server, MS-Access, Teradata.

操作系统: Windows 95/2000/NT/XP/Vista, UNIX.

数据建模工具: 欧文4.0/4.1.

公用事业: Oracle SQL Developer, 蟾蜍, SQL*LOADER

作业调度工具: 信息调度，控制- M

开发工具: Excel, Outlook, Word, 矢量绘图软件.

专业经验

保密,德州

Informatica开发人员

职责:

• Gathered Requirements from users, translated user inputs into ETL 设计 documents.
• 从事Informatica Power Center组件-源分析仪, 数据仓库设计人员, 映射设计器和转换.
• Developed 映射s and reusable Transformations for ETL using Informatica Power Center.
• 使用Informatica功能实现Type I, II, III在缓慢变化的维度表中变化.
• 使用表达式创建复杂映射, 无关的查找, 分选机, 标准化者, 联盟, 聚合器, Dynamic Lookup and Router transformations for populating target table in efficient manner.
• Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
• 配置了带有Email任务的工作流, 控制任务, Event-Raise任务, Event-Wait任务, 计时器任务, 命令的任务, 分配任务和决策任务.
• Performed Unit 测试 of Informatica ETL process to ensure ETL logic.
• Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
• Used Teradata SQL Assistant to run the SQL queries and validate the data.
• Provided Knowledge Transfer to the end users and created extensive documentation on the 设计, 发展, implementation of the daily loads and process flow of the 映射s and 发展 of Ad hoc Reports.
• 跟进订单并解决问题.

环境: 信息力量中心.1.0/9.0.动力中心设计师, 工作流管理器, 工作流监控), Teradata, 业务对象, 欧文, SQL, PL / SQL, MS-矢量绘图软件, 办公室女士, DB2, Oracle 10 g / 11 g.

机密，底特律，密歇根州

ETL开发人员

职责:

• 参与SDLC从需求收集开始的所有阶段, 设计, 发展, 测试, 生产, 生产环境的用户培训和支持.
• Developed the 映射s using needed Transformations in Informatica tool according to technical specifications.
• 使用Informatica Power Center开发映射/会话.0.1 .数据加载.
• 创建 Complex 映射s that involved implementation of Business Logic to load data intostaging area.
• 使用任务管理器开发工作流, worklet 设计er and workflow 设计er in 工作流管理器 and monitored the results using workflow monitor.
• Effectively used Informaticaparameter files for defining 映射 variables.
• 审查和分析功能需求, 映射文档, 解决问题和排除故障.
• Used Teradata and Oracle as sources for building the datamarts to analyze the business individually.
• 创建 command files and used Control-M for running the jobs to make sure all dependencies (映射s) are in good shape before moving the code to 生产.
• Generated DML Queries for manipulating database objects like tables, 的观点, 使用插入, 更新和删除命令.
• 参加每周例会, and conducting internal and external re的观点 as well as formal walk through among various teams and documenting the proceedings.
• Monitor and communicate the availability of Informatica Environment. 跟进订单并解决问题.

环境: 信息力量中心.0.动力中心设计师, 工作流管理器, 工作流监控), SQL, PL / SQL, 业务对象, Teradata, Oracle 9 i, 蟾蜍, ms project中, 矢量绘图软件, 微软字处理软件, ms excel, DB2, Control-M.

机密，密歇根州安娜堡

Informatica开发人员

职责:

• Understanding business needs and implement the same into a functional database 设计.
• 参与需求收集.
• 参与SDLC的所有阶段.
• Developed new Informatica 映射s and workflows based on specifications.
• 开发批处理，源和目标对账.
• 进行提取, 转换和加载来自RDBMS表的数据, Flat Files into Teradata in accordance with requirements and specifications.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• 编写存储程序(过程 & Functions) to do Data Transformations and integrate them with Informatica programs and existing applications.
• 创建, 计划, 并在按需运行的基础上监控工作流会话, 按时运行, 使用Informatica Power Center工作流管理器.
• 创建 Netezza DB Objects using best practices of Netezza in order to avoid data skews on the Netezza Objects.
• 创建 NZLoad scripts to load the Flat Files into Netezza staging tables.
• Used 欧文 data modeling tool to do conceptual/logical/physical data models.
• Developed UNIX shell scripts to scheduling Scripts by using scheduling tools.
• 为每个测试场景的映射设计Excel表格.
• Worked with 生产 issues like bottlenecks, data validation and report errors.

环境: 信息力量中心.0.1, Teradata TD 13, Netezza, UNIX, Flat files, Windows 7 Professional.

机密，长岛，纽约

Informatica开发人员

职责:

• 收集客户所需的需求.
• 开发用户需求和功能/技术规范.
• Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
• 配置了带有Email任务的工作流, 控制任务, Event-Raise任务, Event-Wait任务, 计时器任务, 命令的任务, 分配任务和决策任务.
• Used debugger in identifying bugs in existing 映射s by analyzing data flow, 评估转换.
• Promoted Informatica 映射s from 发展 to test to 生产 environment.
• Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
• 开发技术系统文档.
• Monitor and communicate the availability of Informatica Environment. 跟进问题单

环境: 信息力量中心.6、PL / SQL, Oracle 10g/9i, 欧文.5/4.0、db2、hp-unix.20、Toad、OBIEE、Microsoft Tools (excel、visual等).

保密

ETL /数据库开发人员

职责:

• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs.
• 创建 Source and Target Definitions in the repository using Informatica Source Analyzer and Warehouse Designer
• Identify source systems, connectivity, tables, and fields, ensure data suitability for Mapping
• Used SQL Over rides in Source Qualifier and Lookups to improve 映射 performance.
• 根据需求实现缓慢变化的维度.
• 创建 sessions and executed them to load the data from the source system using Informatica 工作流管理器

环境: 信息力量中心.6、Oracle 9 i、PL / SQL、业务对象.5、Shell脚本，Sun Solaris UNIX, Windows 2005.

保密

Jr ETL开发人员

职责:

• Designed the ETL Mapping Documents for 发展 team members for their implementations.
• 从事Informatica Power Center组件-源分析仪, 数据仓库设计人员, 映射设计器和转换.
• Promoted Informatica 映射s from 发展 to test to 生产 environment.
• 使用informaticto提取物, transform and load data from different input sources like flat files and XML files into Oracle 10g database.
• 创建了Informatica Power Center映射, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement.
• 配置了带有Email任务的工作流, 控制任务, Event-Raise任务, Event-Wait任务, 计时器任务, 命令的任务, 分配任务和决策任务.
• Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
• 跟进订单并解决问题.

环境: Informatica 8.1.2、Oracle 10g, SQL, PLSQL, Microsoft Excel, 微软字处理软件, COBOL.