Sr. Systems Data Analyst

Master’s degree in Information Systems Security, Computer Science with 6 months of experience; Use Informatica Power Center, create mapping parameters and variables to support SQL overrides in Source Qualifier and Look-up transformations; Create sessions, set up workflows to extract data from various sources using XML, Notepad++, and transform data before loading it into the data warehouse. Monitor user-reported incidents raised using the incident management system Samanage, and study system issues to determine the root cause and resolve them; Correct system faults by creating tickets in a defect-tracking program such as JIRA and incorporating them into monthly releases; Using Microsoft tools such as Word and Excel, modify current mappings to meet new business requirements; Write SQL Queries in SQL Server and define identify and validate the code written for data transfer into database tables, as well as fine-tune the queries for better efficiency. Skills: Informatica Power Center, XML, SQL server, Samanage, JIRA and Notepad++. Must be willing to travel and/or relocate to work in company’s various worksite locations throughout the US.

Send resume to 24×7 ESI, Inc, 30 Downing Street, New York, NY 10014.

Sr. Systems Data Analyst

Master’s degree in Information Systems Security, Computer Science with 1 year of experience; Create sessions, configure workflows to extract data from various sources Like XML, CSV and transform data, and load it into the data warehouse; Write and deploy .Net and C# code to create API’s (Application Programming Interface) on AWS EC2 server; Develop mapping parameters and variables to support SQL overrides in Source Qualifier and Look up transformations using Informatica Power Center; Generate end-to-end data flow reports using Tableau & SQL Server management Studio; Perform Unit testing and Interact with QA team for system/integration testing; Document column definitions to provide a data dictionary to end users using Notepad++, MS Office and Miro; Fix identified system issues by creating tickets using a defect-tracking tool JIRA and implement it following SDLC (Software Development Life Cycle);Skills: XML, CSV, AWS EC2 server, Tableau & SQL Server management Studio, JIRA, SDLC, Notepad++, MS Office & Miro. Must be willing to travel and/or relocate to work in company’s various worksite locations throughout the US.

Send resume to 24×7 ESI, Inc, 30 Downing Street, New York, NY 10014.