*Dear Partner,* We have an Immediate Position
*胞TL Developer-Locals Preferred-*** for one of our Client. Please Submit your *Profiles *to [email protected]** *JOB POSITION:* *ETL Developer* *LOCATION:** Sacramento CA* *DURATION:** 1 Year* *START DATE:** ASAP* *Note: Locals Preferred , who can attend In-Person Interview* ----------------------------------------- *Job Description:* This is for ICD-10 project. EXPERT level SSIS (SQL SERVER INTERRATION SERVICE) ETL Developer candidates. Over 8+ years of professional IT experience in Data warehousing, Design, Modeling, Development, Analysis, Implementation and Testing. Expert knowledge in working with Data Warehousing tools (ETL tools) like Informatica Power Center 8.6.1/8.1.1/7.1/6.1/5.1, Power Mart and Power Exchange. Extensively used Informatica Warehouse Designer to create and manipulate Source and Target definitions, Mappings, Mapplets and Transformations. Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator. Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor. Expertise in Data warehousing concepts like OLTP/OLAP System Study, Analysis and E-R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling. Have work experience with Relational Data Modeling tool Erwin 7.0/4.2. Experienced in handling SCDs (Slowly Changing Dimensions) using Informatica. Over Seven Years of RDBMS experience using Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, MS Access 2000, SQL (DQL, DML, DDL, TCL), PL/SQL (Stored Procedure, Function, Package, Trigger, Bulk Load, Autonomous Transaction, Exception Handling), XML, SQL*Loader and SQL Editor (SQL*Plus, TOAD) Extensively worked on Data migration, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses. Experience in implementing update strategies, incremental loads and Change Data Capture (CDC). Knowledge of complete Software Development Life Cycle(SDLC) including Requirement Analysis, Requirement Gathering, Cost Estimation, Project Management, Design, Development, Implementation and Testing. Involved in Full Life Cycle Development (Waterfall & Agile) of building a Data Warehouse on Windows and Unix Platforms for Investment Banking, Financial, Retail, and Insurance Industries. Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations. Experience in generating reports using(Reporting tools) COGNOS and BO Performed System Analysis and QA testing and involved in Production Support. Excellent communication and interpersonal skills. Ability to work effectively working as a team member as well as an individual. Self-motivated individual with strong Technical & Analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas. *Thanks & Regards,* *Mike,* *Diligent Tech, Inc.* *[email protected]* 7726 Blueberry Hill Ellicott city,MD,21043 Work: 410-575-1129 USA | India *www.diligenttechinc.com* Note: We respect your online privacy. This is not an unsolicited mail. Under Bills.1618 Title III passed by the 105th US Congress this mail cannot be considered Spam as long as we include contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with: "REMOVE" in the subject line and your ID will be removed from our mailing list. We are sorry for the inconvenience caused to you. -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" 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/us_itgroups?hl=en.
