*Job Title:* *Data Stage Architect/Dev* *Location: **Houston, TX*
*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 Data Ware House 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 Skills*: IBM DataStage, Oracle, SQL server, Unix, XML, Ansi SQL Regards, Sai Khanna Kat Tech Systems Inc, Email:s...@kattechsystems.com Phone:630-233-8584 -- 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.
