Ab Initio Data Integration Specialist

Location: Carthage

Job Title:

Ab Initio Data Integration Specialist Designation:
Solutions Manager

Location:

Alpharetta, GA ( 5 Days onsite mandatory) - Local preferred Duration:
Long Term 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.