**JOB SUMMARY** --------------- Senior Software Engineer responsible for the execution of custom data integration solutions supporting custom applications, MDM, data integrations, advanced analytics, and Oracle Financials and Human Resources data delivery. The role focuses on ETL development, data warehousing, XML processing, SQL optimization, and production support within enterprise environments. **Responsibilities** -------------------- * Execute **custom data integration** for custom applications, MDM, data integrations, advanced analytics, and Oracle Financials and Human Resources data delivery. * Design, develop, and maintain **ETL and EAI code**, including unit test cases, unit testing, and timely defect resolution. * Interpret **data models and mapping documents**, understand technical requirements, and prepare Technical Design Documents. * Support **project implementations** and resolve production issues during project warranty and ongoing maintenance support. * Optimize and maintain **SQL\-based data transformations** against relational databases. **Qualifications** ------------------ * Hands\-on experience with **Microsoft BizTalk**. * Knowledge of **IBM DataStage** or similar ETL processing tools. * 8\+ years of demonstrated knowledge in **data warehousing concepts**, architectures, design, and dimensional modeling. * 5\+ years of experience with **SQL** against relational databases, preferably **MS SQL Server 2008 and above**. * 3\+ years of experience handling **large XML files** using XML stages/pack in real\-time and batch processing modes. * 5\+ years of experience in **UNIX scripting**, including understanding FTP standards/processes and basic network principles. * 5\+ years of **automation experience** using scheduling software. * Working knowledge of **Azure Pipelines** and **Azure Synapse**.