We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.
In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.
We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.
Job DescriptionExperienced in creating Data Stage jobs to Extract, Transform and Load data from diverse source systems to both Normalized (3NF) structures and Star Schemas in a Data Warehouse environment.
Very strong ORACLE SLQ is mandatory as is experience with history data using Slowly Changing Dimensions.
Minimum of 5-7 years experience
SKILLS REQUIRED EXPERIENCE
Data Stage 8.5 5 years
Parallel Processing 2 years
Quality Stage 2 years
Slowly Changing Dimensions 5 years
Unix Shell Scripts 2 years
ORACLE SQL 5 years
Change Data Capture 5 years
Source to Target Mapping 2 years
Creating and executing Test Cases 2 years
Additional Information- Good comm skills are a big priority
- Duration: 6 months
In person interview required
Interviews to begin next week
Skills Required
- Minimum 5-7 years ETL/Data Stage experience
- DataStage 8.5 (IBM DataStage)
- Slowly Changing Dimensions (SCD) implementation
- Oracle SQL - strong
- Change Data Capture (CDC)
- QualityStage
- Parallel processing experience
- Unix shell scripting
- Source-to-target mapping
- Creating and executing test cases
- Experience building ETL for normalized (3NF) and star schema data warehouses
- Good communication skills
What We Do
Atria Group LLC, also operating as Atria IT, is a specialized IT staffing and consulting firm headquartered in Plano, Texas. The company provides comprehensive workforce solutions, including staffing, consulting, software development, and training services, specializing in enterprise solutions for small to medium-sized businesses. Their primary objective is to assist these enterprises in maximizing their IT resources to meet evolving technological challenges.








