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 DescriptionTOP REQUIREMENTS:
1. DataStage, SQL Server 2008 R2 or later
2. Oracle 11gR2
3. Experience gathering requirements for projects
4. Prefer some architecture/modeling experience but not required
JOB SUMMARY
Job comprises of various Data Integration ETL tasks with custom interfaces to external data sources & systems. This job also includes various internal Applications data load, reconciliation, on time as well as near real time data delivery tasks. Prior experience in reusable ETL interfaces is needed.
EDUCATION/EXPERIENCE REQUIREMENTS
- Good understanding of IBM Information server platform
- Ability to troubleshoot ETL processes failures or warnings and provide technical support for all ETL- DataStage related issues.
- Basic Knowledge in MS-SQL Server 2008 DB.
- Strong UNIX / Linux Scripting
- Experience in SSIS preferred
- Experience with IBM CDC/ IBM® Info SphereTM Data Replication preferred
- Basic knowledge Database Netezza or Oracle preferred
- 7+ years of experience in ETL-IBM Data Stage development for data movement, data quality, data cleansing and other ETL- related activities.
- DataStage Administration experience preferred
ESSENTIAL JOB FUNCTIONS
- Design and develop ETL jobs from function specification.
- Develop reusable interface frame works with reasonable assumptions of future specs.
- Performance tuning of ETL jobs to keep data loads within SLA.
- Other duties as needed.
- Graduation from a 4-year college or university with major course work in a discipline related to the requirements of the position is preferred.
- Good comm skills are a big priority
- Duration: 3 Months CTH
Skills Required
- 7+ years of ETL development using IBM DataStage
- Working knowledge of DataStage administration
- Experience with SQL Server 2008 R2 or later / MS-SQL Server
- Oracle 11gR2
- Good understanding of IBM Information Server platform
- Ability to troubleshoot ETL process failures and provide technical support for DataStage issues
- Strong UNIX / Linux scripting skills
- Experience gathering requirements for projects
- Experience in SSIS
- Experience with IBM CDC / IBM InfoSphere Data Replication
- Basic knowledge of Netezza or Oracle databases
- Good communication skills
- Graduation from a 4-year college or university
- Prefer some architecture/modeling experience
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.
