DataStage Architectures:

Arete Technologies, Inc. offers a set of innovative consulting and outsourcing services, bridging the gap between requirements and outputs of various companies worldwide. The thrust of providing global deliverables with a focus on providing paramount and unsurpassed services combined with cost-saving solutions to the clients.We understand the business requirements in the present day corporate scenario and aspire to provide world-class services enabling the organization to burgeon and flourish while keeping the work-life balance intact. Our team is an exquisite amalgamation of vast experiences of over 30 years in IT consulting and staffing industry.Job DescriptionProficient at the formulation of architectures, including requirements discovery and analysis, formulation of solution context, solution alternatives identification and assessment, technology selection, and architectural configuration. Design and architect Extract, Transfer and Load (ETL) strategies needed to support required staging, warehouse, or data marts.Develop detailed implementation plans estimating duration and identifying dependencies. Collaborate across Information Technology areas and business areas to ensure data artifacts meet requirements of upstream and downstream claim processing needs. Ensure all artifacts comply with enterprise standards and governance.Design, build and deploy high-quality, performance, integrated, and documented ETL solutions while following established standards. Conceptualize, analyze, develop, and deploy strategies for data acquisition, transformation, and loading on an enterprise level. Identifies key drivers of a defined problem and proposes solutions.Serves as an expert resource on matters of data architecture, design in all phases of data warehouse and data mart development, implementation and support. Ensure logical data model and other data artifacts are consistent, accurate, flexible and scalable. Ability to successfully work within multiple requirements, design, and development approaches and methodologies (agile, iterative, waterfall, etc.). Minimum of ten years as a DataStage Architect.Skills RequiredExperience of leading and supporting delivery of development servicesExperience in data architecture, data modeling, data warehousing, data mining, data entity analysis, logical and relational database designExposure to pulling data from multiple sources including: XML, web services, delimited flat files, and other data sourcesExperience with Business Intelligence, Dashboards or 3rd party analytics platformsExperience with IBM SAP Connectors and ABAP codingExperience with UNIX scripting, Structure Query Language (SQL), Basic Teradata Query Reference (BTEQ), MacrosExperience in performing data mining and data analytics, on data-sets and data-marts within a Teradata/Oracle database environmentExperience in programming, in particular to drive analysis tools and prepare data marts, including expertise in writing Teradata QueriesExtensive knowledge of Teradata database, data warehousing and information management best practicesExperience in using Teradata utilities TPT, TPump, BTEQ, fastload, fastexport and multiloadExperience in SQL programming (views/store procedures/macros/functions) based on User requirements and architectural guidelines and standardsHands-on technical experience with Teradata, Oracle, SAP and Microsoft SQL ServerExperience working with IBM InfoSphere SuiteAdditional InformationAll your information will be kept confidential according to EEO guidelines. #J-18808-Ljbffr