HCL Global System - Farmington Hills, MI
posted about 2 months ago
The ETL Developer position involves a comprehensive role in the analysis, design, development, implementation, testing, and support of ETL applications. The successful candidate will utilize Agile methodology throughout the Software Development Life Cycle (SDLC) and will be responsible for analyzing both business and technical requirements. This includes drafting functional and technical specifications, as well as creating data flow and process diagrams. The role requires the integration of various data sources into a data staging area, performing data analysis, and creating automation scripts, SQL queries, and user-defined functions. In addition, the ETL Developer will be tasked with developing database programming for data warehouses and dimensional modeling. This includes creating stored procedures, functions, triggers, views, and queries, as well as designing and developing server jobs. Performance monitoring and tuning are critical aspects of the role, as is the implementation of change control systems and processes. The developer will also prepare test cases and validation procedures, conduct ETL testing, and provide quality assurance while assisting with production support. Debugging mappings, testing stored procedures and functions, and unit testing sessions, batches, and data are also key responsibilities. The position requires proficiency in various tools and technologies, including UNIX, Oracle, SQL Server, DB2, Teradata, Informatica, Datastage, OLAP, SQL, PL/SQL, JavaScript, UNIX Shell Scripting, XML, and Flat files. The role is designed for individuals who are willing to relocate and have a strong background in software development, systems analysis, and programming. Candidates should be prepared to engage in a dynamic work environment that emphasizes collaboration and continuous improvement.