|
|
|
|
| Desired Industry: Information Technology |
SpiderID: 8472 |
| Desired Job Location: any where in new jersey, New Jersey |
Date Posted: 8/25/2006 |
| Type of Position: Contractor |
Availability Date: 08/25/2006 |
| Desired Wage: |
|
|
U.S. Work Authorization: Yes |
| Job Level: Experienced with over 2 years experience |
Willing to Travel: Yes, More Than 75% |
| Highest Degree Attained: Bachelors |
Willing to Relocate: Yes |
Objective:
•4+ years of total IT experience and 3+ years of progressive experience in Database Programming, Data Warehousing and ETL.
•Proven expertise in Data Warehousing applications, directly responsible for Extraction, Cleansing, Transformation and Loading of data from multiple feeds and sources into Data Warehouse.
•Strong ETL experience using Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Mappings, Mapplets, Transformations.
•Experience in daily, weekly, monthly extract job.
•Extensive experience in Indexes, PL/SQL Procedures, Functions, Packages, Database Triggers and Oracle SQL query tuning concepts.
•Experience in creating various PL/SQL stored procedures.
•Experience with Informatica Server Manager to create Sessions and Workflows to run with the logic embedded in the mappings.
•Expertise in utilizing Oracle Utility tools like SQL*Loader, Import and Export.
•Good knowledge in Teradata tools such as BTEQ, FastExport, FastLoad, and TPump.
•Experience with writing daily batch jobs using Unix shell scripts.
•Expertise in developing complex UNIX Shell Scripts for automation of ETL, Archiving, Purge process and Data transfer needs from distributed disparate systems.
•Experience in E-R Modeling, Dimensional Modeling (Star schema, Snow-flake schema) and modeling tools like ERWin and Visio.
•Industry experience in full life cycle of development, implementation, administration and support of ETL processes for large-scale data warehouses using Informatica PowerCenter.
•Contributions in the areas of Dimension, Star Schema, and Snowflake Modeling.
•Experience with Cognos Impromptu and Powerplay to produce various complex cube reports.
•Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills.
•Ability to work effectively and efficiently in a team and individually.
Experience:
Professional Summary
JP Morgan Chase, New York, USA NOV’05 – Present
ETL Developer
Responsibilities
•Interfaced with Business Analysts for gathering the business requirements and designed user-friendly templates to communicate any further enhancements needed.
•Identify source tables in OLTP system and flat files to be incorporated into Teradata Data Warehouse.
•Modeled logical and physical model using Erwin and forward engineered the model to create test tables and DDL. Star Schema was implemented.
•Responsible for cleansing the source data.
•Loading the OLTP data into the warehouse OLAP and built the re-usable mappings using Informatica PowerCentre 7.1.
•Worked on installation and configuration of Informatica Server and Client tools.
•Created Repository, established database connections, registered Informatica PowerCentre Servers and Server Configurations.
•Performance monitoring and tuning of SQL using explain plans and Indexes.
•Developed facts, attributes, compound attributes, implied attributes, hierarchies and transformations, identifies relationship across attributes.
•Delivered optimal data warehouse design for different subject areas.
•Denormalised OLTP tables to create the information access layer with Star Schema Structure in Teradata data warehouse.
•Identified grain, conformed dimensions, degenerated dimensions and aggregates, assigned primary keys, surrogate keys and index across fact and dimensions tables.
•Wrote shell scripts for scheduling the sessions.
•Used Cognos impromptu and powerplay to produce various complex cube reports.
•Involved in documenting functional specifications and user documents and updated documents as necessary. Trace SR to test cases. Developed attributes matrix views, and ran automated sessions with RUP robots.
Environment
Informatica PowerCentre 7.1, Erwin 4.5, Cognos 7.0, Oracle 10g,9i, PL/SQL, SQL*Loader, TOAD, Windows2K, PVCS, Oracle, Sybase 12.x, DB2 7.x, Sun Solaris 7.0, Teradata, Trillium6.0
KnightBridge Solutions, California, USA JAN’05 – OCT’05
ETL/DW Developer
Responsibilities
•Contributed in the development of system requirements and design specifications.
•Participated in the design and development of Star Schema.
•Developed complex mappings in Informatica to load the data from various sources using various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router.
•Developed Mapplets to implement business rules using complex logic.
•Converted the PL/SQL Procedures and SQL*Loader scripts to Informatica mappings.
•Tuned the Sessions for better performance by eliminating various performance bottlenecks.
•Created and scheduled Sessions and Batches through the Informatica Server Manager.
•Wrote UNIX shell scripts to automate the data transfer (FTP) process to and from the Source systems, to schedule weekly and monthly loads/jobs.
Environment
Informatica PowerCenter 6.1, Oracle 8i, SQL Server, TOAD, SQL, PL/SQL, SQL*LOADER, Pro*C, C, Korn Shell scripts, awk, sed, ERWin, UNIX (Solaris)
Mind Tree Consulting, INDIA FEB’04 – DEC’04
Client: AOL Time Warner, New York, USA
Informatica Developer
Responsibilities
•Performed data manipulation using the basic functions and the Informatica Transformation.
•Defined reference lookups and aggregations.
•Imported Relational metadata extract and load Relational data.
•Developed ETL (Extract, Transformation & Load) processes using Informatica, PL/SQL and Pro C. Created Mappings in Informatica Designer to extract data from various data sources to load into the data warehouse with different types of transformations and wrote PL/SQL Programs required for data transformation/Loading.
•Created ftp connections, database connections for the sources and targets.
•Developed mappings/transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica PowerCenter6.1.
•Setting of the batches and the session to schedule the loads at required frequency using Power Center Server manager.
Environment
Informatica Power Center 6.1, Oracle 8, SQL*LOADER, UNIX (Sun Solaris), Windows 2000, MVS, OS/390, VSAM
Mind Tree Consulting, INDIA SEP’02 – NOV’03
Client: Siemens Medical Solutions, IL
Informatica Developer
Responsibilities
•Participate in system requirements and design specifications design and development of Star Schema.
•Developed complex mappings in Informatica to load the data from various sources using various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router.
•Developed Mapplets to implement business rules using complex logic.
•Converted the PL/SQL Procedures and SQL*Loader scripts to Informatica mappings.
•Tuned the Sessions for better performance by eliminating various performance bottlenecks.
•Developed UNIX shell scripts to automate the data transfer (FTP) process to and from the Source systems, to schedule weekly and monthly loads/jobs.
•Used Informatica Designer to create complex mappings using different transformations to move data to multiple databases.
•Worked extensively with complex mappings using expressions, aggregators, filters and procedures to develop and feed Data Marts.
•Tuned the mappings to perform better using different logics to provide maximum efficiency and performance.
•Involved in the creation of partitions in Informatica Mapping to improve the performance of Informatica sessions.
•Created various PL/SQL stored procedures.
•Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.
•Filtering data using Unix Shell Scripts (awk, sed).
•Used Informatica Server manager to create Sessions and Workflows to run with the logic embedded in the mappings.
Environment
Informatica PowerCenter, Oracle 9i/8i, VSAM, DB2 UDB, SQL, PL/SQL, SQL*LOADER, UNIX (Sun Solaris, HP-UX, AIX), TOAD, Windows 2000, MVS, OS/390, JCL, COBOL, XML
Education:
Education
B.S. in ECE
Rutgers Institute of Technology
Skills:
Data Warehousing
Tools Informatica PowerCenter/PowerMart 7.1/6.1 (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet, Transformations), SQL*Plus, SQL*Loader, BTEQ, FastLoad, TPump, Mload
Reporting Tools Business Objects 6.0/5.1, WebIntelligence, Cognos
Data Modeling Tool Designer 2000, Erwin 4.1, E-R Modeling, Star Schema, and Snowflake
Databases Oracle 10g/9i/8i, DB2, Teradata, SQL Server2000, MS Access
Languages SQL, PL/SQL, Pro*C, Unix Shell Scripting (Korn Shell), COBOL, C, C++, Visual C++, Java, Visual Basic Script
Web Technologies ASP, Java Script, HTML, DHTML, Perl, XML
Operating Systems Sun Solaris, AIX, HP-UX, Linux, Windows NT/9x/2000, MS-DOS, MVS and OS/390
Utilities Toad 7.x, SQL*Loader
Additional Information:
can be contacted at any time.
Candidate Contact Information:
This candidate has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response. |
|
|
|
|
|