*Please send profiles to : [email protected] <[email protected]>*
*Role : Data Modeler & SSIS ETL Developer Location : NYC, NYDuration : 6+ Months ContractInterview : Face to Face After Telephonic * *REQUIREMENTS* *Skills:* ETL developer and coder Data Modeler / ER/Studio MS SQL Server SSIS ETL and TSQL. Oracle and SQL and PL/SQL. Knowing the tools will not be enough; must have excellent knowledge of SQL and relational database concepts Performance and tuning optimization of SSIS Jobs and SQL Code *Experience:* 6-8 years’ experience including at least 4 enterprise level data solutions. Experience with MS-SSIS and IBM Datastage, SOA. Deep understanding of relational Oracle DBMS and SQL server. A minimum of 4 years of full lifecycle ODS and DW experience in ETL data integration efforts in large scale programs. *Job Description* Under the direction of the Project Manager and Chief Data Architect, serves as the ETL developer using SSIS or Data Stage and Star Schema data modeler using ER/Studio. Create the dimensional model and code programs to extract transform and load functions within SSIS, ESB SOA architecture and SQL Server platform. This position requires you to have deep knowledge and experience with using SSIS and loading dimensional marts in a large scale environment. *Duties and Responsibilities:* Program, design, and code in the ETL Tool Develop dimensional models in ER/Studio Program in TSQL and PL/SQL – SQL server and Oracle Develop and code ETL batch and real time jobs Develop all SSIS ETL from Staging to ODS and Master Data databases to Data Marts Performance and tuning of SSIS and Oracle Test and develop production jobs *Minimum Core Competencies:* Must be an expert in SSIS and Data Stage. Must be proficient with ER/Studio and Data Mart design Must have excellent skills as ETL developer (designing and coding) 6-8 years of satisfactory full-time programmer analysis experience with at least 5 years as a specialist in Data Stage and ETL development and implementation. A minimum of 5 years of full lifecycle ODS and DW experience in large scale programs Ability to design and code complex Oracle SQL and PL/SQL statements Ability to design and load dimensional databases Thanks and look forward to your prompt and positive response... *Sumanth Pittu *| Account Manager Office: 732 777 0800 ext. *504* Gtalk/Yahoo/Skype: sumanth.p151 *BS**M* Learn More <http://bsm.us.com/> • Facebook<https://www.facebook.com/pages/BSM-Business-Success-Management/186763063930>• LinkedIn <http://www.linkedin.com/company/bsm-business-success-management>• Twitter <https://twitter.com/BSM_now> - 13 years in business with referable clients - Minority & Women Owned Business Enterprise - Microsoft Certified Partner - Oracle Certified Partner - SWaM – Small, Women and Minority Vendor for State of VA - APICS Corporate Member HQ: 2 Tower Center Blvd., 20th Floor, Suite # 2004 | East Brunswick, NJ – 08816 | United States Global: United States | Europe | MEA The information contained in this e-mail transmission is confidential and may be privileged. It is intended only for the addressee(s) stated above. If you are not an addressee, any use, dissemination, distribution, publication, or copying of the information contained in this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify us in reply *with the word "REMOVE" in the subject line*. We apologize for inconvenience, if any caused. -- You received this message because you are subscribed to the Google Groups "SAP ABAP" 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/sap-abap. For more options, visit https://groups.google.com/d/optout.
