SUMMARY

• 7年以上工作经验，具备良好的分析和编程能力.
• 5年以上使用Informatica Powercenter的经验.x/8.x/7.x).
• 丰富的数据源经验，如Oracle, 该软件, Teradata，也致力于整合平面文件中的数据, CVS文件, 和XML文件转换成通用的报告和分析数据模型.
• 有使用Informatica Power Designer的ETL流程经验, 服务器管理器, Repository Manager.
• 具有缓慢变化维度的工作经验(类型1，类型2).
• 了解变更数据捕获(CDC)机制.
• 有完成应用程序SDLC的经验.
• Have extensively worked in developing ETL program for supporting Data Extraction, 使用Informatica Powercenter进行转换和加载.
• Experience with dimensional modeling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• 创建 UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• 具有较强的关系数据库设计概念.
• 熟练使用oracle 12c/11g/10g/9i/8i编写和使用SQL查询, SQL * Loader, 存储过程, 触发器, 物化视图, 游标, Ref光标, 大量收集, 集合, 分区, 使用解释计划的异常处理和优化调优技术, SQL跟踪.
• Extensively worked with Informatica performance tuning involving source level, 目标级和映射级瓶颈.
• 参与ETL工作的QA测试.
• Independently perform complex troubleshooting, root - cause analysis and solution development.
• 能够在最后期限前完成并处理多项任务, 果断，有很强的领导才能, 工作时间灵活，有良好的沟通能力.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• 综合的技术、口头、书面和沟通能力

技术技能

操作系统: Windows, Linux, hp - ux

软件/应用程序: MSXP, ms2000, Word, Excel, Access, Outlook, PowerPoint

ETL: 信息动力中心.x/8.x/7.x，元数据管理器，SSIS 2008/2005, Informatica Power Exchange

数据库: Oracle12c/11g/10g/9i, SQL Server 2008/2007/2005, Teradata.

OLAP / BI工具: Cognos 8系列

语言: SQL, PL / SQL, Perl & Shell脚本，c++，核心Java, HTML, XML

工具: 蟾蜍, SQL开发人员, Oracle Form Developer, Oracle Report Developer, SQL*plus, SQL Loader

专业经验

机密，欧文，得克萨斯州

ETL Informatica开发人员

职责:

• Developed ETL programs using Informatica to implement the business requirements.
• 创建 shell scripts to fine tune the ETL flow of the Informatica workflows.
• 性能调优是在功能级和映射级完成的. Used relational SQL wherever possible to minimize the data transfer over the network.
• 创建 new mapping designs using various tools in Informatica designer like Source Analyzer, 仓库设计, Mapplet设计师, 和映射设计器.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, 聚合器, 乔伊纳, 源限定符, 路由器的查找, 已经连接的/, 和过滤.
• 使用任务开发器开发工作流, Worklet designer and workflow designer in workflow manager and monitored the results using workflow monitor.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, 修改存储过程以增强代码.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, 评估转换.
• 设计了带有决策的许多会话的工作流, 分配任务, 事件等, 事件引发任务, 使用Informatica调度器来调度作业.
• 创建, 测试和调试存储过程, 功能, 包, 使用PL / SQL创建触发器和游标.
• 审查和分析功能需求, 映射文档, 解决问题和解决问题.
• Implemented slowly changing dimension methodology for accessing the full history of customers.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

环境: 信息动力中心.5、Oracle 12c、hp - ux、蟾蜍、SQL +、Erwin.2, Cognos.

机密，凤凰城，亚利桑那州

ETL Informatica开发人员

职责:

• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, 仓库设计, 地图设计器和映射设计器.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• 创建 complex mappings that involved implementation of Business Logic to load data into staging area.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, 聚合器, 乔伊纳, 源限定符, 路由器, 查找连接的/, 和过滤.
• 使用Informatica Powercenter开发映射/会话.1 .数据加载.
• 创建工作流和使用各种任务，如电子邮件, 时间调度程序, 控制, 工作流管理器中的决策和会话.
• Performed data manipulations using various Informatica Transformations like Filter, 表达式, 查找(已连接和未连接), 聚合器, 更新策略, 标准化者, 乔伊纳, 路由器, 分类与并集.
• 使用任务开发器开发工作流, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• 创建, 测试和调试存储过程, 功能, 包, 使用PL / SQL的触发器和游标.
• Execution of jobs using “控制-M” tool for scheduling and monitoring UNIX Scripts/Jobs.
• 根据用户需求构建报告.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• 为UNIX环境下的工作流编写Shell脚本.
• Optimizing performance tuning at source, target, mapping and session level.

环境: 信息动力中心.x, Oracle 11 g, SQL Server 2008/2005, Teradata 14, Teradata SQL助手, 蟾蜍, SQL +, Erwin 8, hp - ux.

保密，印第安纳州印第安纳波利斯

ETL开发人员

职责:

• 使用Informatica Powercenter进行(ETL)提取, transformation and loading data from heterogeneous source systems into target database.
• 使用设计器创建映射，并从各种来源提取数据, 根据需求转换数据.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• 利用聚合器开发了信息映射, SQL覆盖查找中的用法, 源限定符中的源过滤器使用情况, 并使用路由器将数据流管理成多个目标.
• 创建会话并从各种来源提取数据, 根据需求转换数据 and loading into data warehouse.
• 使用各种转换，如过滤器, 表达式, 序列发生器, 更新策略, 乔伊纳, 路由器 and 聚合器 to create robust mappings in the Informatica Powercenter Designer.
• 对视图进行了广泛的研究, 存储过程, 触发器 and SQL queries for loading the data before feeding the flat files.
• 使用Informatica Powercenter 8导入各种异构文件.x源分析仪.
• Developed several reusable transformations and mapplets that were used in other mappings.
• 创建 simple list reports, cross-tab reports and Drill through reports using Impromptu.
• 准备技术设计文档和测试用例.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• 实现了各种性能调优技术.

环境: ETL、Informatica (Powercenter.5.1/8.6.1)、信息电源交换.1.1, Oracle 11 g, SQL Server 2008, Windows XP, Shell Scripting, Cognos Impromptu & Powerplay7.x和蟾蜍.

保密

Oracle开发者/ETL开发者

职责:

• 开发Oracle PL / SQL包、过程、触发器和函数.
• 编写Oracle SQL，根据需要创建临时报告.
• 生成用于数据操作和验证的服务器端depl /SQL脚本.
• Worked on SQL*Loaderto load data from flat files obtained from various facilities every day.
• 使用标准包，如utl FILE, dmb SQL, and PL / SQL集合 and usedBULKBinding involved in writing database procedures, 前端模块的功能和包.
• 广泛研究Ref Cursor, External Tables和集合.
• 参与生产问题的持续改进和修复.
• Involved in supporting and maintaining Oracle Import, Export and SQL*Loader jobs.
• 参与支持和维护UNIX shell脚本作业.
• 使用Informatica Powercenter进行(ETL)提取, transformation and loading data from heterogeneous source systems into target database.
• 使用设计器创建映射，并从各种来源提取数据, 根据需求转换数据.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• 利用聚合器开发了信息映射, SQL覆盖查找中的用法, 源限定符中的源过滤器使用情况, 并使用路由器将数据流管理成多个目标.

环境: Oracle 10g/11g, PL / SQL, SQL *加载程序, SQL +, 蟾蜍, Informatica Powercenter 8.1.

保密

Oracle开发人员

职责:

• 创建表，视图，约束.
• 开发复杂的数据库对象，如存储过程, 功能, 使用SQL和PL / SQL的包和触发器.
• Developed materialized views for data replication in distributed environments.
• 使用SQL Loader将数据加载到Oracle表中.
• 参与PL / SQL的性能调优.
• 创建 包 and Procedures to automatically drop the table indexes and create indexes for tables.
• 广泛研究Ref游标，外部表和集合.
• 具有动态SQL、集合和异常处理方面的专业知识.
• 为业务需求编写UNIX脚本.
• 使用Oracle表单生成器和报表生成器开发表单和报表.

环境: Oracle 9 i / 10 g, PL / SQL, SQL *加载程序, SQL +, 蟾蜍, SQL开发人员, Oracle报表生成器, Oracle表单生成器.