Job Description

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

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

Skill Requirements

• Proficiency in informatica intelligent cloud services for data integration and workflow management.
• Strong command of sql for querying and manipulating data in relational databases.
• Experience with oracle pl/sql for developing complex stored procedures and functions.
• Familiarity with unix shell scripting for automating data processing tasks and system maintenance.
• Analytical mindset with excellent problem-solving skills.
• Strong communication and collaboration abilities to work effectively in a team environment.
• 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.

Job Tags

Traineeship, Local area,

Similar Jobs