EDI Data Integrations Engineer II

BA Degree in computer science or related field preferred 3-5+ years of experience in MSSQL T-SQL development 3-5+ years of experience in MSSQL SSIS development 3-5+ years of experience with Data Warehouse - (ETL) Extract, Transform, and Load Skilled at building and optimizing complicated SQL queries and stored procedures Proficiency in programming languages (C# / Python), scripting, and data analysis tools Bachelor's degree in IT or equivalent experience Excellent communication skills Must possess analytical and complex problem-solving skills

Design, code, test, deploy, maintain, monitor and execute production ETL processes Investigate production ETL issues / problems Work with business users to gather requirements and design, create, and implement database systems & applications Lead troubleshooting episodes and communicate solutions/resolutions to the team Translate concepts to requirements and technical design Complete projects and development activities timely and accurately while following the System Development Life Cycle (SDLC) Develop, implement, and optimize stored procedures and functions using T-SQL Analyze existing SQL queries for performance improvements Create and update EDI document mappings Take ownership of SQL development for future products and enhancements of existing products Performance tuning of database assets and writing queries used for front-end applications (websites, desktop applications, or cloud apps) Evaluating new tools, new technologies to help modernize existing applications Designing Architecture for ETL/SSIS packages and Designing SSIS packages with different data sources (SQL, Flat files and XMLs etc.) and loaded the data into target source by performing different kinds of transformations