Job Description :
Company Overview:

Creating value by bringing together the right people to achieve results is our motto. Our clients and employees say they choose to work with us because of how we work with them - with service that exceeds their expectations and a personal commitment to their success.

Our client, with missions in University teaching, research and public service and half-million annual enrollments, seeks an accomplished ETL Developer.

Description:
ETL Developer with Unix/ Shell Scripting skills to implement the migration to manage File Transfer project.
The position requires considerable administrative and technical coordination in a highly complex technical and organizational environment and results in systems designed to meet the migration effort.
Responsible for implementing changes required to onboard with the new managed file transfer process, designing and implementing robust Extract Transform and Load applications and processes to load data and supporting metadata into the decision support systems.
Create/ modify Unix/ Shell scripts (60%): work towards implementing changes for new managed file transfer process. Create / modify existing Unix/ Shell scripts, batch jobs to process files transferred through MFT process.
Build and Maintain ETL processes (30%
Working closely with Data Architect, data modelers, data analysts, business analysts and BI developers to understand requirements and using the InfoSphere toolkit and ETL best practices, develop ETL processes in support of the requirements, validate that they meet business and technical specifications, ensure that any issues raised during testing are addressed prior to migration into production; and manage ongoing maintenance of the system and data.
Design, build, test and maintenance of extract processes to assure the selection of correct data, including design, test and implementation of parsing rules to assure selection of correct data and build of data profiling to assure ongoing correctness of extracted data.
Design, build, test and maintenance of transform rules and processes to derive the correct data from the extracted data and to transform it into the required format and structure to support the business requirements
Design, build, test and maintenance of the process to properly load the transformed data into the target database and the associated metadata into the enterprise metadata repository.
Development and execution of ETL test plans.
Manage maintenance of the system and data including monitoring and data profiling to assure ongoing data quality, ongoing monitoring and optimization of the system to manage scalability and performance; and identification and implementation of improvement opportunities for key development processes.
Provide the BI Manager and the Data Architect with status and progress reports on development and maintenance activities as required.

Requirements:
Bachelor''s Degree in Information Systems or a related field or an equivalent combination of education and experience.
Minimum five years’ experience in data related work with at least 2 years’ experience on UNIX / Shell scripting and as a senior ETL analyst / developer for large, complex decision support systems.
Experience working with encryption protocols like PGP Encryption, SSH keys.
Hands on experience with IBM DataStage, including extensive experience with parallel job design and development and strong SQL coding skills, is required.
Working experience with revision control systems, Linux platform, Shell scripting, and DB2 database is required.
Strong familiarity with multi-dimensional Star schema and general DBMS concepts is required.
Extensive experience in extract transform and load, data profiling, data quality, metadata management and data intake for large complex data systems.
Ability to analyze, verify, and document the accuracy of the developed ETL code through self-directed testing.
Deep knowledge of best practices through relevant experience across data-related disciplines and technologies particularly for enterprise wide data architectures and data warehousing/BI.
Experience with IBM data warehouse environment.


I''d love to talk to you if you think this position is right up your alley.

If you''re looking for rewarding employment and a company that puts its employees first, we''d like to work with you. We''re driven, people driven.


NOTE: Candidates that are offered a position are required to pass pre-employment drug and background screening. Qualified candidates with criminal histories, are considered in a manner that is consistent with local, state and federal laws.