*Position : Sr. Datastage Developer* *Location : McLean , VA* *Duration : Long term*
*USC AND GC ONLY * *Requisition Details:* Perform development and design activities at client site for ETL Interact with stakeholders for requirement Assist on support and enhancements modules Query Optimization Review functional requirements and technical specifications and document them as needed Around 6+ years of experience on complex transformation and loading of high-volume data Experience in Datastage Experience in ODI will be an added advantage - Experience in Informatica Experienced in SQL, PL/SQL Excellent communication skills Excellent in data warehousing concept Knowledge of BO Strong DW concepts Strong Analysis skills Have good communication skills, interpersonal relations, hardworking and result oriented as an individual Strong skills in all aspects of SQL development (triggers, stored procedures, views, etc.) and implementation. Experience writing large, complex stored procedure involving temp tables, cursors, and multiple nested procedure calls. Experience in performance tuning, Strong performance tuning knowledge in SQL and ability to interpret plans, identify bottlenecks in queries and remediate them. Experience with ETL development (Datastage) and Data Integration. Strong knowledge of database technologies and principles, including data modeling, data mapping etc. Strong experience with data analysis, troubleshooting data issue. Fluent in relational database concepts and flat file processing concepts. Must be knowledgeable in software development lifecycles/methodologies Work with customers to understand reporting and system integration requirements Should have Experience in designing the data mart and data warehouse Should demonstrate excellence in understanding the existing data models and ability to redesign them as per changing business needs Should demonstrate excellent written and verbal communication skills Should have experience in dealing with business users and Sr. Management A strong knowledge of business intelligence design concepts, with a concentration in dimensional modeling in RDBMS A strong working knowledge of SQL Should have worked on projects involving medium – large data warehouses Thanks & Regards Ron HMG America LLC Ph: +1 (732) 645 1718 E: [email protected] W: www.hmgamerica.com -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" 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 https://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.
