Hi,
Please find below *2 ETL/Datawarehouse Developer* consultants available for projects; please send me all your open requirements to [email protected] *A.R – ETL/Datawarehouse Developer* *Current Location: Washington, DC Relocation: Open* * * *Summary:* · Over 7 years of experience in IT industry with expertise in database and data warehousing. 5+ years of strong experience in designing and implementing *Data Mart / Data Warehouse* applications using *ETL tools*such as *INFORMATICA PowerCenter 8.6,**8.5, 8.1.2, 8.1.1*,*7.1.1/6.2 and PowerMart *to transfer the data from legacy systems (Mainframes) to common/ different targets and 2+ years of experience with *Oracle SQL and PL/SQL development.* · Experience in Implementing Data Warehousing on *Insurance, Trading, Financial and Telecommunications *Domains · Experience on Data Design Analysis, Business Analysis, User Requirement Gathering, Data Cleansing, Data Transformations, Source Systems Analysis and Reporting Analysis · Strong knowledge in *OLTP*, *OLAP* Systems, *Kimball and Inmon*methodology * *and models, Dimensional modeling* *using* Star schema** and Snowflake schema*.** · Experience with *Installation, Creating Domain, Repository, integration service, Folders, User, User management, Privileges, Grid, upgrading, deployment and maintenance of Informatica Power Center.* · Experience in data extraction, migration transformation and loading using *Informatica PowerCenter* *(Source Analyzer, Repository Manager, Data Warehousing Designer, Mapping Designer, Mapplet Transformation)*.** · Strong Experience in developing Sessions/tasks, Worklets, Workflows using *Workflow Manager* Tools - *Task Developer, Workflow & Worklet Designer.* · Worked extensively with complex mappings using different transformations such as *Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.* · Expertise in design and implementation of *SCD* - slowly changing dimensions types (1, 2 and 3) and *CDC – *Change data capture, *Surrogate keys, Normalization/De normalization.* · Experience in integration of various data sources such as *Oracle, Teradata, SQL Server, Flat Files, IMS, Excel, CSV *and* Xml* into the data warehouse. · Experience in writing, testing, and implementation of the *triggers, cursors, procedures, and functions at database level using PL/SQL.* · Experience in *debugging mappings.* Identified bugs in existing mappings by analyzing the data flow and evaluating transformations. · Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow. · Experience in working with database tools such as *SQL*Plus, SQL Developer, Toad*.** · Experience in scheduling tasks using *Scheduler, Timer* in workflow manager and other functions such as *Event Rise, Event Wait, Worklet, Control*. · Used *Mapping Parameters and Variables* to implement Object Orientation techniques and facilitate the reusability of code · Expertise in *UNIX shell* *scripting* · Excellent *multitasking* ability and proven track record of delivering timely and quality solutions.** · Excellent communication and interpersonal skills, very good team player and self-starter with ability to work independently and as part of a team, good analytical reasoning and high adaptability to new technologies and tools. *Educational Background:* Bachelors in Electronics and Communication Engineering, JNTU, INDIA *Technical Skills:*** *ETL Tools* Informatica Power Center 9.1/8.6.1/8.1/7.1/6.2(Repository Manager, Designer, Workflow Manager, Workflow Monitor) *Databases* Oracle 11g/10g, Oracle 9i/8i/7.3, DB2 V8.0, MS SQL Server 2000/7.0, TeradataV2R5/R6, V11/V12 *Data Modeling* Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions) ER Diagrams, ERwin 4.0/3.5.2/2.x. OLAP, Star Schema. *Miscellaneous Tools* TOAD, Fast Load, Multi Load, Fast Export, T-Pump, Teradata, SQL*Plus, iSQL*Plus, SQL*Loader, AutoSys, SQL Developer *General Software & Programming* Excel, Word, PowerPoint, C, C++, Unix shell scripting, SQL,PL/SQL, Transact SQL, Perl Scripting *Operating Systems* Windows 7/Vista/2000/98/XP/NT, UNIX, LINUX *Reporting Tools* Cognos 8.4 Frame work manager, Report Studio, Analysis Studio, Query Studio * * *M.K – Informatica/ Datawarehouse/ ETL Developer* *Current Location: Phoenix, AZ Relocation: OPEN* * * *Summary:* · Over *6* years of experience in Analysis, Development, and Implementation of business applications including more than 5 years of Development and Design of *ETL* methodologies using *Informatica PowerCenter * for Insurance, Pharmaceutical, Financial, and Telecom sectors. · *5+* years of Experience as *ETL Developer* in designing and implementing *Data Mart / Data Warehouse* applications using *INFORMATICA PowerCenter **8.x / 7.x / 6.x *(*Designer*, *Workflow manager, Workflow monitor and Repository Manager).* · *Designed* and *developed Complex mappings* from various * Transformations* like *Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy *and more, *mappings* using *Stored Procedure’s*, Normalizer, XML, External Procedure, Java transformations and Web Services. · Expertise in implementing complex business rules by creating *re-usable transformations*, and *Mappings/Mapplets *and* Creating Repository*, Source, Target Databases. · Good knowledge on *SDLC (software development life cycle)* and experience with unit testing and integration testing. · Preparing the High level *Design Specifications for ETL Coding and mapping standards.* · Experience in integration of various data sources like *Oracle*, *SQL server, Netezza and MS access, flat files, Teradata, and XML files.* · Expertise in *OLTP/OLAP *System study, developing Database schemas like *star schema, snow flake schema* Dimensional Data Modeling used in relational, dimensional modeling and *slowly changing dimensions*(SCD’s). · Performed *ETL* procedure to load data from different sources into *data marts* and *Data Warehouse* using *Power Center*. · *ETL* experience in development of mappings and tuned existing mappings for better performance using *Informatica* *PowerCenter* as per the business rules. · Expertise in writing *Oracle PL/SQL Stored Procedures/Functions/Packages *and* Triggers* with expertise in writing DDL, DML, DCL, and TCL commands · Develop, execute *ETL* test plans, Document *ETL* processing and generate required metadata. · Involved in the installation and configuring the *Informatica* * PowerCenter* server and client. · Experience in creating reports using Oracle Business Intelligence 10x, and Siebel Analytics. · Good knowledge of star-schema database designs in *Data Warehouse*systems. · Extensive experience and knowledge in *Data warehousing* concepts such as *Dimensional Modeling (Star Schema & Snow Flake Schema), Data Marts, Fact* and Dimensional tables. * * *Skills/Tools:* * * *ETL Tools* *Informatica 8.x/7.x/6.x (Power Center, Power Mart)*** *Databases* *Oracle* 8i/9i/10g/11g, Terradata, Netezza, V2R5, DB2, MS Access** *Data modeling Tools* *Erwin *4.5/4.0/3.x** *Operating Systems* UNIX Windows 95/98/2000/2003, Server/NT Server Workstation 4.0, *Query Tools* SQL, SQL*Plus and TOAD** *OLAP/Reporting Tools* Microstrategy 8.0.1, OBIEE** *Languages* UNIX/LINUX/DOS Scripting, *PL/SQL*** * * *Education:* Bachelor of Electronics and Communications Engineering, Nagarjuna University. * * *Regards,* * * *Abhay Patel I AVP - Business Development * *22260 Haggerty Rd, Suite 285, Northville, MI 48167* *W **248-270-3860** . F **248.715.6434*** *[email protected]* <[email protected]>** *An E- Verified Company* *Certified Minority Business Enterprise (MBE)* *[image: Description: Description: Description: cid:[email protected]]* <http://www.rsrit.com/> [image: Description: Description: cid:[email protected]]<http://www.linkedin.com/pub/abhay-p/34/178/733> *If you know anyone who is looking for Jobs in IT Industry, Please pass on my contact info and you will be part of our referral Program, for any additional Info on referral Program, Please contact me.* * * *“Reliable Software Resources is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, gender, sexual orientation, age or any other basis as covered by law. Employment decisions are based solely on qualifications, merit and business needs.”* Note: We respect your Online Privacy. This is not an unsolicited mail. Under Bill s.1618 Title III assed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. To be removed from our mailing list, email to [email protected] , with the subject "REMOVE”. Any inconvenience caused is unintentional and is sincerely regretted. * Reliable Software Resources, Inc is an* e*qual opportunity employment organization.* -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" 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/sap-vendor?hl=en.
