Data Engineer (4122-1) Milford or Milwaukee, WI hold

Job Summary

• IT experience in Design, Development, and implementation of large scale and medium scale.
• Data Warehousing applications using ETL tool IBM Infosphere Information server DataStage, SQL and Unix.
• 5-7 years with a broad portfolio of AWS Infrastructure tools (EBS, S3, EC2, Elastic IP, Route 53, VPC) and with cloud infrastructure Management and automation technologies.
• Working with basic structured, semi-structure, and unstructured data.
• Exposure to modern data/analytics architecture (Big Data, Cloud, etc.,).
• Exposure to advance analytics tools (Python, R, etc.).
• Scripting (shell, python, ruby) skills for monitoring and automation.
• Developing and maintaining pipelines for efficient data extraction, transformation and loading (ETL) processes.
• Advanced knowledge and expertise in designing and developing ETL jobs using IBM Infosphere DataStage and sounder experience in other IIS Suite like Information Analyzer and basics on Quality Stage.
• Performance Tuning and Optimization of ETL Jobs and SQLA queries in ad-hoc and complex report environments.
• Worked in various databases like Oracle 10g/9i/8i, DB2, SQL Server, Teradata.
• Experience in writing PL/SQL stored procedures, functions and packages.
• Proficient in writing Unix shell scripts and extensive experience working with Unix operating systems.
• Extensive experience with ETL to load data from Flat files, XML, Oracle and DB2 to ODBC databases and to perform various transactions using Filter, Transformer, Join, Lookup, Aggregator, Change Capture, Remove Duplicate, Shared Container, Nested condition, Routines, Command activity stages to create robus mappings in the DataStage Designer.