*Role:* Datastage Developer *Location:* NYC, NY
*Duration*:6+ months *Experience: 8+ Years* *Responsibilities:* • To design, build, program ETL procedures (DataStage/Unix) • Prepare Technical Design / Specifications; develop routines for data extraction and loading • This is a highly technical role requiring critical thinking, hands on development, and attention to detail from analysis through implementation and post-production QA. Provide technical/user documentation and training; perform peer reviews of work items produced at various stages of the project • Responsible for analyzing data requirements and developing ETL for clinical systems. The individual in this role will work closely with data architects, translate complex business data requirements into efficient ETL packages, will understand and apply the concepts of proper ETL design, and gain a strong understanding of source data to ensure the design approach results in a logical and efficient ETL solution to support the Data Conversion efforts • Assists in the identification and resolution of inefficiencies in ETL designs • Determines and implements solutions for ETL design problems • Validates ETL designs for accuracy and performance, identifying opportunities for improvement • Analyzes the impact of source system data design changes as they relate to existing ETL solutions and makes appropriate changes to existing ETL solutions • Performs analysis to prevent data redundancy across systems and employs data integration best practices • Performs data profiling, understands source data, and designs ETL solutions to accommodate any nuances that may exist • Works with implementation team to ensure smooth deployment of packages and ensures resolution of outstanding issues *Required Technical Skills:* - Strong *DataStage* Developer - QualityStage, Information Analyzer and other tools such as metadata workbench is a plus - PL/SQL, T-SQL Scripts, UNIX Shell scripts, Stored Procedures, Triggers, etc. - Performance tune of large clinical databases, employing various techniques such as schema bound views, database partitioning, and ETL/Query optimization. - Extensive knowledge of data architectures related to large database implementations geared towards OLTP *Number of years of experience:* • 8+ yrs IT experience • 6 + yrs ETL experience Thanks & Regards Nazir || Technical Recruiter || ALFA Services USA INC., 45W 34th Street Suite 801-2 ,New York, NY 10001 Tel No. 347-809-5401|| Fax No. (413)-375-4665 Email: na...@alfaservicesusa.com -- You received this message because you are subscribed to the Google Groups "Companies Looking for IT Out Staffing & Recruitment" group. To unsubscribe from this group and stop receiving emails from it, send an email to arunsinh+unsubscr...@googlegroups.com. To post to this group, send email to arunsinh@googlegroups.com. Visit this group at http://groups.google.com/group/arunsinh. For more options, visit https://groups.google.com/d/optout.
