Certified Sr ETL Informatica Developer available immediately
For details please contact [email protected] or call on 440-368-0209 KALYANI ETL DEVELOPER Summary: • 7 years of IT experience in System Analysis, Design, coding and testing of project implementations across Financial, Pharmaceutical industries. • Experience in Data Warehousing using Informatica Power Center 8.6.1/8.1.1/7.1.1/7.0/6.1,Warehouse Designer, Power Exchange,OLAP, OLTP. • Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files. • Strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis. • Dimensional Data Modeling experience on Data modeling, Erwin 7.1/4.5/4.0/3.5.5/3.5.2, Dimensional Modeling, Star/Snowflake Modeling, Datamarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling and Oracle Designer. • Demonstrated expertise in utilizing ETL tool Informatica power center 8.6.1/7.1.1 for developing the Data warehouse loads as per client requirement. • Complete knowledge of data ware house methodologies ,ODS, EDW and Metadata repository. • Excellent knowledge in identifying performance bottlenecks and tuning the Informatica load for better performance and efficiency. • Experience in using the Informatica command line utilities like pmcmd to control workflows in non-windows environment. • Profound knowledge about the development of the Teradata database, developed Teradata loading and Unloading utilities like Fast Export, Fast Load, Multiload (Mload). • Expertise in complex Database Design / Modeling and Development, Oracle Server installations and Database Upgrade and Migration, Capacity Planning, Space Management, Partitioning, Extensive Performance. • Ability to quickly grasp and apply cutting-edge ideas, methods and technologies and can manage important projects and programs in fast- paced, time-critical environments. Technical Skills Databases : Oracle 8i/9i/10g/11g, SQL Server 2008/2005/2003/2000, Teradata V2R5, DB2 , MY SQL5.0/4.1, MS Access. Programming Skills : SQL, Shell Scripting (K-Shell, C-Shell), PL/ SQL, PERL Operating System : UNIX, Windows 2000/2003/NT/ XP Oracle Tools : SQL*Loader, TOAD. ETL Tools : Oracle Warehouse Builder 10g/9i, Informatica 8.x/7.x/6.x, Informatica power Exchange 7.x/8.x. Education Bachelor of Technology (EEE) from JNTU, Hyderabad, INDIA Professional Experience Blue Cross Blue Shield, Atlanta, GA Oct’10 - Till date Sr. Informatica/ETL Developer Blue cross blue shield in the United States is a program managed by the states that delivers health care products and services. The objective is to implement a new point of Sale (POS) system that accepts pharmacy claims and determines the claim status and also to convert the data from previous agent to BCBS DB2 system. Responsibilities: • Worked closely with Development managers to evaluate the overall project timeline. • Involved in converting data stored in Oracle and VSAM to DB2 using power center 8.6.1. • Actively contributed in framing the Data Warehouse SDLC standards, methodologies and best practices. • Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router. • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Lookup, Router and Aggregator to create robust mappings in the Informatica Power Center Designer. • Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability. • Worked on Informatica Power Center tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor. • Designed and developed the logical and physical data models (star schema) using of all current and future development databases across all products and application branches. • Involved in Oracle database administration, patching, cloning and Table space and object reorganization to remove the fragmentation. • Used PL/SQL features to write data loading routines. • Created partitioned tables, partitioned indexes for manageability and scalability of the application. • Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines. • Extensively involved in Data Extraction from Mainframe source (VSAM), Oracle using Power Exchange when there was change in the source data sets. • Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes. • Trouble shooting of long running sessions and fixing the issues. • Developed UNIX scripts and PERL scripts for pre data manipulation. • Automated the load process using UNIX shell scripts. Environment: Informatica Power Center 8.6.1, Power Exchange, Oracle 10g, PL/SQL, VSAM, DB2, UNIX/Windows NT. Charles Schwab, San Francisco, CA Feb’10 - Sep’10 ETL Developer Sales Analytics is a new business intelligence application designed specifically to help Financial Consultants and Branch Network Managers to manage their Relationship Practice and monitor and review sales performances. It helps deepen client relationships and improves sales and retention efforts by delivering target, timely and actionable client intelligence as well as providing quality coaching opportunities for managers through succinct performance analysis and reporting. Responsibilities: • Conducted focus group sessions and interviewed subject matter experts to understand the requirement of the business partners. • Coordinating and monitoring the progress of project to assure the flow and completion of work on schedule. • Build ETL Design specifications which helps as LLD for the development of the mappings • Involved in System Study, Data Analysis, Data Cleansing • Dimensional Data Modeling to deliver Multi Dimensional STAR schemas. • Data Reconciliation, Data Discrepancy and Generated the Data Audit Reports. • Ensured the Business Rules and Data Validation. • Created the Informatica Workflows, Worklets, Mappings and Sessions • Created number of reusable transformation according to the same business needs. Majority of the transformations used are Normalizer, Joiner, Filter, Aggregator, Router, Sequence Generator etc. • Created PL/SQL Stored Procedures, Function to accomplish the business rules • Involved in the Design process of Dimension and Fact tables. • Involved in Designing the Process-flow workflow for Incremental Load. • Created Indexes, Views and Materialized Views to improve the performance. • Involved in writing the test cases and documentation • Developed Functional and Technical Design documents. • Extensively used Informatica to extract data from various Operational Systems, External Systems and Staging Area . Environment: Informatica Power Center 8.6.1, Oracle 10g, Windows XP, Erwin 4.5 Thanks & Regards- Praneeth Work: 440.368.0209 Ext. 209 Cell : 732-360-7309 Yahoo ID: praneethchoudarypara Gtalk : [email protected] -- You received this message because you are subscribed to the Google Groups "Oracle Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/oracle-users?hl=en.
