Ab Initio Data Integration Specialist

Overview

On Site
$DOE
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - Long Term

Skills

Data Transformation
SQL
Performance Tuning
Data Integration
Technical Documentation
Production Support
troubleshooting
Data Cleansing
Data Profiling
Cross-functional collaboration
Data Quality Management
AB Initio
Informatica Intelligent Cloud Services (IICS)
Oracle PL/SQL
Unix Shell Scripting
ETL Development
Data Workflow Optimization

Job Details

Job Title: Ab Initio Data Integration Specialist Designation: Solutions Manager

Location: Alpharetta, GA (5 Days onsite mandatory) - Local preferred

Duration: Long Term

Visa: ANY

JD:

IICS Technical Specialist with SQL,Oracle PL/SQL, Unix Shell Scripting

Job Summary
The Technical Specialist will be responsible for managing and optimizing data integration processes, utilizing Informatica Intelligent Cloud Services, SQL, Oracle PL/SQL, and Unix Shell Scripting. The individual will play a key role in ensuring the efficiency and effectiveness of data workflows and systems.

Key Responsibilities
1. Develop and implement data integration solutions using informatica intelligent cloud services.
2. Design, develop, and optimize sql queries and scripts for data manipulation and reporting purposes.
3. Create and maintain oracle pl/sql procedures for data extraction, transformation, and loading.
4. Write unix shell scripts to automate data processing tasks and improve overall system performance.
5. Troubleshoot and resolve data integration issues in a timely manner to minimize disruptions.
6. Collaborate with cross functional teams to gather requirements and implement data solutions that meet business needs.

Skill Requirements
1. Proficiency in informatica intelligent cloud services for data integration and workflow management.
2. Strong command of sql for querying and manipulating data in relational databases.
3. Experience with oracle pl/sql for developing complex stored procedures and functions.
4. Familiarity with unix shell scripting for automating data processing tasks and system maintenance.
5. Analytical mindset with excellent problem-solving skills.
6. Strong communication and collaboration abilities to work effectively in a team environment.
7. Ability to prioritize tasks, manage deadlines, and adapt to changing business requirements.

Exp: 8 -12 Years

Ab Initio 8-10 Years experience.

Other details:

  • Design and develop ETL processes: Create data integration solutions using Ab Initio to extract data, transform it according to business rules, and load it into target systems.
  • Analyze requirements: Collaborate with data architects and business analysts to understand data requirements and translate them into technical specifications.
  • Optimize performance: Monitor and optimize data workflows and existing production pipelines for efficient processing.
  • Ensure data quality: Perform data profiling, cleansing, and transformation to ensure data accuracy, integrity, and consistency.
  • Troubleshoot and support: Debug production issues, resolve data-related problems, and provide support for existing applications.
  • Collaborate: Work with cross-functional teams, including data architects, business analysts, and QA teams, to ensure project success.
  • Document solutions: Create and maintain technical documentation for Ab Initio solutions.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Aroha Technologies