DataStage Architectures:

Arete Technologies, Inc.; Lansing (MI); On-site; USD 120,000 - 140,000; Full time

Job summary

A consulting firm is seeking a DataStage Architect with over 10 years of experience in data architecture and ETL strategies. Responsibilities include designing high-quality ETL solutions, collaborating across IT and business areas, and ensuring compliance with enterprise standards. Ideal candidates will have hands-on experience with Teradata, Oracle, and other data management tools, and are skilled in SQL and UNIX scripting. The position offers an opportunity to contribute to innovative data solutions while maintaining work-life balance.

Qualifications

• Minimum of ten years as a DataStage Architect.
• Experience in leading development services.
• Exposure to data from multiple sources such as XML and web services.

Responsibilities

• Design ETL strategies for data warehouses.
• Collaborate with IT and business areas.
• Ensure compliance with enterprise standards.

Skills

Data architecture

Data modeling

Data warehousing

Data analytics

UNIX scripting

SQL

IBM SAP Connectors

Teradata utilities

Tools

Teradata

Oracle

SAP

Microsoft SQL Server

IBM InfoSphere Suite

Job description

Arete Technologies, Inc. offers set of innovative Consulting and Outsourcing services, bridging the gap between requirements and outputs of various dexterous and facile companies worldwide. The thrust of providing global deliverables with 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. The Global delivery mechanism followed at Arete Technologies, Inc. saddles proficient schemas and unconventional channels to provide one-stop solutions for all your workforce needs. Our team is an exquisite amalgamation of vast experiences of over 30 years in IT Consulting and Staffing industry. Connoisseurs in the field of staff augmentation for IT, we operate on a 24 by 7 model with an aim of providing affordable and adept professionals with an assurance of satisfaction for both Consultants and Clients. We are pre-eminent service providers in the field of staff augmentation, IT Consultancy, Software development, Web Development providing unexcelled services and focusing on both the employers and employees.

Job Description

Responsibilities include:

• Proficient 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 to support staging, data warehouses, or data marts.
• Develop detailed implementation plans estimating duration and identifying dependencies.
• Collaborate across IT and business areas to ensure data artifacts meet 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 following established standards.
• Conceptualize, analyze, develop, and deploy strategies for data acquisition, transformation, and loading at an enterprise level.
• Identify key drivers of defined problems and propose solutions.
• Serve as an expert resource on data architecture, design in all phases of data warehouse/data mart development, implementation and support.
• Ensure logical data models and other data artifacts are consistent, accurate, flexible and scalable.
• Work within multiple requirements, design, and development approaches and methodologies (agile, iterative, waterfall, etc.).
• Minimum of ten years as a DataStage Architect.

Qualifications

• Experience leading and supporting delivery of development services.
• Experience in data architecture, data modeling, data warehousing, data mining, data entity analysis, logical and relational database design.
• Exposure pulling data from multiple sources including XML, web services, delimited flat files, and other data sources.
• Experience with Business Intelligence, dashboards or 3rd party analytics platforms.
• Experience with IBM SAP Connectors and ABAP coding.
• Experience with UNIX scripting, SQL, BTEQ, and related Teradata tools/macros.
• Experience in performing data mining and data analytics on data-sets and data-marts within a Teradata/Oracle database environment.
• Experience in programming to drive analysis tools and prepare data marts, including expertise in writing Teradata queries.
• Extensive knowledge of Teradata database, data warehousing and information management best practices.
• Experience using Teradata utilities TPT, TPump, BTEQ, fastload, fastexport and multiload.
• Experience in SQL programming (views/store procedures/macros/functions) based on user requirements and architectural guidelines and standards.
• Hands-on technical experience with Teradata, Oracle, SAP and Microsoft SQL Server.
• Experience working with IBM InfoSphere Suite.

Additional Information

All your information will be kept confidential according to EEO guidelines.