Data Warehouse Engineer
||Data Warehouse Engineer
|Job Posting Date:
||3395 N. Arlington Heights Rd, Arlington Heights, IL 60004
||Arlington Heights, IL & Various Unanticipated locations throughout the U.S.
||Travel and/or relocation required.
Verinon Technology Solutions Ltd. has an opening for the position of Data Warehouse Engineer (Ref# DWE1215CP) to work in Arlington Heights, IL and various unanticipated locations throughout the U.S. Job Duties: Responsible for the administration, design, development, implementation, data modeling, testing, deployment, and support of data warehousing and business intelligence applications. Involved in project requirements meetings and translate business needs into technical and system design specifications. Analyze the requirements for new data marts and provide the data in required format. Design and develop ETL (Extract, Transform & Load) to build data warehouse / data mart using ETL tools DataStage, Ab Initio, Informatica, and Teradata BTEQ. Prepare source to target documents for all extracted files. Convert the ETL code in DataStage to Ab Initio graphs. Configure the ETL graphs in the scheduler for processing the daily/weekly/monthly jobs. Develop scripts to generate business level reports. Perform data warehousing concepts including Star Schema and Snowflake Schema and logical and physical data modeling. Responsible for fine tuning of SQL queries. Develop and build ETL test strategy to compare the output files. Process the data from AWS cloud (S3) to Snowflake. Perform data reconciliation between Teradata and Snowflake. Troubleshoot issues in different phases of the project. Perform change control methods in the projects including root cause analysis and resolution of production abends for various applications. Catalogue all the files in datahub and define retention period. Introduce data quality checks in all Ab Initio graphs. Responsible for DataStage administration activities. Use of IBM InfoSphere DataStage, Ab Initio, Informatica, Oracle, Teradata (Teradata BTEQ, Teradata SQL Assistant, FastLoad, and MultiLoad), Snowflake, SQL, Python, UNIX shell scripting, Hadoop (HDFS), Amazon Web Service (AWS) cloud (EC2, EMR, S3), AIX, Linux, and Windows. Travel and/or relocation required.
Requirements: This position requires a Master’s degree or foreign academic equivalent in Computer Science, Electrical / Electronics Engineering, CIS, MIS, or a related field. Plus 2 years of experience in the job offered or 2 years in a related occupation including Applications Consultant, Software Engineer, Module Lead, or related experience. Will accept a Bachelor’s degree plus 5 years of progressive experience in lieu of the required education and experience. Position requires 1 year of experience with logical & physical data modeling, Ab Initio, Teradata BTEQ, and UNIX shell scripting. Will accept any suitable combination of education, training, or experience as per the requirements cited herein. 40hrs/week.
Application Instructions: To apply, please MAIL resume to referenced address, ensuring to indicate the position reference code (Ref# DWE1215CP) for which you are applying. Mail to: Verinon Technology Solutions Ltd., Attn: Vice President, 3395 North Arlington Heights Rd., Arlington Heights, IL 60004.