*Position : Datastage Developer* *Location : NYC* *Duration : 3-6+Months* *Need Ead Gc, Gc, Usc.* *face To Face Interview.*
*Responsibilities:* • Prepare Technical Design / Specifications; develop routines for data extraction and loading • To design, build, program ETL procedures (DataStage/Unix) • 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 ______________________________________________ Regards: Amer Ali -|| IT Recruiter-|| ITBrainiac Inc. || Direct : (609-935-3773)*103 Princeton| New Jersey, 08540 Gtalk: Amer.ali8688 amer....@itbtalent.com ||Website: www.itbrainiac.com -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.
