*NOTE : SKYPE INTERVIEW & H1B Scan copy is Mandatory * Hi
Position below…. *JOB TITLE: ETL DEVELOPER (DATA MIGRATION SPECIALIST) * *PRIMARY SKILLS: SQL, T-SQL, SSIS, SSRS LOCATION: AUSTIN, TX DURATION: 1+ YEAR* *Description (Posted to Career Page):* *DATA MIGRATION SPECIALIST* *T-SQL* • Medium to complex SQL Queries using T-SQL Code to develop stored procedures, functions, triggers, views • Must be well versed with Data Definition Language (DDL), Data Manipulation Language (DML) and Transaction Control Language (TCL) *Data Migration* • Proficient in Designing and Implementing Complete Conversion Framework • Proficient in Designing , configuration and implementing ETL Packages using SSIS • Proficient in Designing and developing Medium to Complex - SSRS reports • Proficient in performing data profiling in the source database to identify patterns. • Ability to lead data quality analysis / data profiling, and produce data quality assessment reports (and baseline). • Ability to maintain and enhance automation scripts in PowerShell. • Proficient in creating and publishing reports to SSRS • Proficient in Data Mapping documentation/ tool based (ER Studio) • Proficient in Developing data masking procedures • Working experience with Data Modeling tools - ER studio or Erwin *Documentation* • Ability to conduct Data migration mapping sessions, and produce Technical Specification documents along with data mapping matrix between the legacy and the line of business database for business function replacement. *Support* • Ability to conduct and lead formal Data Mapping, documentation and code review sessions. • Troubleshoot and fix migration issues, and perform defect fixes • Support conversion team members / business on data analysis methods and trends. *Experience Required* *• 5- 8 Years of experience in T-SQL development * *Special Requirements* • The Candidate must be able to understand high level documents and data model diagrams. • The candidate must be able to understand legacy data structures, the data model, and data mapping documents and translate business rules into T SQL scripts. *Thanks & Regards* *ARJUN * 14175 Sullyfield Circle, Suite # 400,Chantilly, VA 20151, U.S.A Email: *arj...@usmsystems.com <arj...@usmsystems.com>* , Phone: *703-953-1365* Skype: *arjunk_usm* Linkedin : in.linkedin.com/pub/kanakoti-arjun/2a/2b6/230 ISO 9001 ,ISO 20000, CMMI Level 3 Certified Company Ranked No.7 in the Washington DC area-*Washington Business Journal, 2013;* Smart CEO Award Winner By SMART CEO Magazine, Baltimore, U.S.A; *Inc5000* *Recognized Fastest growing private company in U.S.A. **www.usmsystems.com* <http://www.usmsystems.com/> *, * -- You received this message because you are subscribed to the Google Groups "OracleD2K" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracled2k+unsubscr...@googlegroups.com. To post to this group, send email to oracled2k@googlegroups.com. Visit this group at http://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/d/optout.