Hello Venkata Hope you are doing well.
My name is *Gagan *from *Elegant Solutions. *I have a job located in * Boise ID. *Client is looking for* SQL/ETL Developer *and the detailed description of the job is mentioned below. If you are comfortable and interested, please reply back with updated resume and following information:- Full Legal Name: Email id: Phone Number: Current Loc: Relocation: Visa Status: Availability to join: Availability for Interview: Academic Qualification: *(Including University name and Year of Completion)* Three Professional References: *(Name/Title/Company/Contact/Email)* *Position: SQL/ETL Developer* *Duration: 1 Year* *Location: Boise ID* *Client: State of ID* *Skills Required:* A minimum of 5 years experience in implementing, running and troubleshooting SQL Server ETL mechanisms • Specific experience with using SQL Server 2008 and 2012 SSIS for ETL • Experience with ETL in SQL Server 2012, 2008 or prior versions using SSIS or its predecessor DT • Advanced experience (5+ years) with design and development of complex SQL Server T-SQL, stored procedure, and ETL package/component including: • Error handling, try/catch and TRANS-based structures • Use of multiple schema in a database • Multiple data sources for input • Multiple outputs depending on error or success of steps • Use of custom- and third-party SSIS add-in components; knowledge or use of MatchIT would be a plus; knowledge or use of Lysine is desirable • Use of fuzzy-logic for data matching and transformation determinations • Data type and value conversions and transformations • Data type and value standardizations • Data type- and value-based validations, including complex dependencies between data field values • Advanced experience with SQL Server database and table modifications (i.e., schemas, tables, fields) • Experience (2+ years) with .NET (C#) programming; knowledge of CLR is desirable • Experience (2+ years) with SSRS and Visual Studio for report development, deployment and delivery • Understanding of basic mainframe concepts • Reading and understanding COBOL copybooks and data dictionaries • Understanding of data type storage concepts (e.g., EBCDIC, COMP, COMP-3, etc.) and conversions to server-based concepts (e.g., ASCII, decimal, etc.) • Understanding of Change Data Capture (CDC) implementations and customizations • Ability to communicate technically (verbally and in writing) with technical DBAs, legacy system developers, and system architects is crucial • Ability to communicate (verbally and in writing) with non-technical business subject matter experts, stakeholders and project managers for clarifications, to elucidate rules, and to provide explanations is critical • A minimum of 3 months experience with ITD DMV software development practices is required. *Gagandeep Purba* Direct: *410 800 4305* Fax:* 703-722-6628* Email: [email protected] *Elegant Enterprise-Wide Solutions, Inc* We Participate in E-Verify An SBA 8(a), ISO 9001:2008 Company *Prime on GSA Schedule 70, 8(a) STARS II, eFAST, Seaport-e & many State/Local Contracts *http://www.elegantsolutions.us -- You received this message because you are subscribed to the Google Groups "CorptoCorp" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/corptocorp. For more options, visit https://groups.google.com/d/optout.
