Job Description :
Client is currently seeking an experienced Data Integration Specialist (DIS) with strong knowledge of IBM Infosphere Information suite (DataStage, QualityStage, Glossary) and AWS (S3, Redshift, EMR

The DIS is responsible for the definition, development, and testing of the processes and programs necessary to extract data from the client''s operational databases/files and deliver it to the desired data platforms. Strong knowledge of Reporting and Analytics. The role also requires analysis of upstream systems like SAP, Island Pacific and IOT systems for data integration with cloud platforms like AWS, Azure and IBM. Required to work closely with business users, business analysts and architects.

Duties include extraction, transformation, cleansing and loading of data into data lakes, AWS, data warehouse, data marts, etc. The DIS is experienced with all the techniques used to manage and maintain data platforms. The DIS defines the program specifications for the data migration processes, as well as the necessary test plans used to ensure successful execution. The DIS is also responsible for managing the metadata associated with the ETL processes used to populate the data platforms. Knowledge of data warehousing ETL procedures such as changing dimension strategies and use of surrogate values is a necessity. Depending on one’s performance, ability, and career goals, there will be ample opportunities to expand ones skill sets beyond ETL development and into the various aspects of the IBM InfoSphere Information Server Suite, such as QualityStage, Information Analyzer, Change Data Delivery, Balance Optimizer, and Master Data Management.

Job Responsibilities
Participate in the development and support of an enterprise wide data transformation and movement architecture and platform.
Design, develop and test ETL applications consistent with application architecture guidelines.
Design error-processing routines.
Create/manage batch processes.
Access disparate data sources (databases, XML and flat files) and apply internal and external business rules, policies and data quality measures.
Insure the data is safely and securely transferred to target destinations.
Gather mapping and reporting requirements and coordinate all data movement activities.
Analyze business requirements as they relate to the ETL process, research, evaluate and recommend alternative solutions.
Transform business requirements into technical requirement documents.
Analyze, develop, install, test, upgrade, maintain and support complex data/process models, and processes in an ETL environment.
Work productively in a team environment.
Communicate effectively with business and IT staff across functional departments.
Work with management and staff to establish best practice standards for ETL functions.
Provide after business hours support for production ETL systems.
Maintain an in-depth knowledge of current and emerging technologies and standards and provide technical direction to management and users.
Provide technical direction to other team members including contractors and employees.

Bachelor''s degree in Computer Science or equivalent degree.
8+ years of total IT experience.
5+ years of experience with the IBM InfoSphere Information Server ETL tool in a data warehouse environment is a must.
Experience with UNIX scripting, SQL strongly preferred.
ETL. Datastage. Database concepts. Unix. Datastage MDM.
Experience with IBMs MDM software is a definite plus.
Knowledge of Extraction, Transformation, and Loading (ETL) disciplines.
Knowledge of database loading methods.
Knowledge of data warehousing methodologies.
Knowledge of IBM DB2 database platforms.
Knowledge of mainframe file structures, namely copybooks is a plus.
Knowledge of AIX UNIX systems and tools.
Knowledge of all phases of the system development life cycle.
Strong problem resolution skills.
Strong testing and debugging skills.
Strong communication and interpersonal skills.
Demonstrated ability to take ownership responsibility for development and maintenance projects.
Strong knowledge of Retail industry processes like OTC, Point of Sales is a must.
Strong knowledge of SAP modules, functional knowledge of Sales and Finance must.
Knowledge of SAP HANA is desired.