*Hello,*
Please get me matching profiles for below position. *Job Title: Sr DataStage Architect* *Duration: 10 months* *Location: Houston, TX* *Skills:* IBM DataStage, Oracle, SQL server, Unix, XML, Ansi SQL. *Roles and Responsibilities:* · Scrutinize functional requirements, specifications and source to target mapping documents, identifying underspecified requirements and other design challenges. · Experience in creating Technical Design and Implementing ETL solutions for Datawarehouse. · Perform exploratory source data analysis, including ad-hoc SQL queries, to proactively find and expose data quality problems or data that violate assumptions and business rules, and may cause unexpected output in the developed solution · Effectively leverage automated data profiling tools when available. · Design & develop the Data Integration framework. · Assimilate and understand the application architecture and develop ETL components that properly integrate with it. · Create documented designs and unit test plans. · Develop code that promotes reusability, maintainability and good, scalable performance. · Build and execute repeatable unit & regression test cases. · Conduct code reviews and mentor junior resources. · Support application development through system testing and user acceptance testing, bridging the gap between business rules and technical implementation when necessary. · Create production support manuals as necessary. · Support production deployment. · Oil and gas Industry experience is a plus. *Education:* Bachelor’s or Master in Computer science *Experience:* · *10+ years of DataStage design and development experience in a complex EDW environment.* · *5+ years working in a DataStage Architect capacity.* · *Experience in two or more of the Infosphere Suite components and architects solutions that leverage the entire suite capabilities (metadata, data quality & profiling).* · Demonstrates an in depth understanding of advanced parallel job development (parallel architecture, configuration files, stages and connectors, environment variables, parameters & routines). · Ability to architect and design strong audit, balance and control architectures with exception handling, data flow monitoring and reporting constructs. · *Experienced in architecting data acquisition, staging and delivery strategies.* · Experience with Infosphere CDC, balanced optimization is a plus. · Knowledge and/or experience with real-time development is a plus. · Experience using advanced performance monitoring/debugging techniques using data set management tools, environmental variables and job monitoring is required. · *Experience with metadata concepts and metadata interfaces is required.* · *Experience in source code control integration with external tools and code deployment is required.* · Knowledgeable in extending core functionality of DataStage when required. · Experience or knowledge with Grid technology is a plus. · *5+ years working within a BI environment (knowledge of SSRS, SSAS, or Cognos is a plus).* · *10+ years of experience writing SQL – expert level is required*. · Expert in performance & tuning of data integration process. · UNIX shell scripting experience is required. · *Strong RDBM skills (Oracle,SQL Server 2008, 2012).* · MPP experience a plus. · Strong written and verbal communication skills. · Strong understanding of BI Data Modeling (Star Schema) and how it is designed Preferred *Thanks & Regards,* *prasanth k* *prasanth.itintelle...@gmail.com <richard...@itintellects.com>* IT Intellects Inc 475 Wall Street, Princeton NJ 08540 Direct: 828-919-8799 | Fax: (732) 359-1525 | www.itintellects.com -- You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" group. To unsubscribe from this group and stop receiving emails from it, send an email to open-source-erp-crm+unsubscr...@googlegroups.com. To post to this group, send email to open-source-erp-crm@googlegroups.com. Visit this group at http://groups.google.com/group/open-source-erp-crm. For more options, visit https://groups.google.com/d/optout.