Job Description Data Analyst II Location: Urbana, MD Duration: 6-7 months with extension Description: The client is seeking a Data Analyst II to coordinate changes to computer databases, test, and implement the database applying knowledge of database management systems. The initially the primary focus will be on Systems integration testing. Job Responsibilities: – Work with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies – Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions – Design, implement, automate and maintain large scale enterprise data ETL processes – Modify existing databases and database management systems and/or direct programmers and analysts to make changes – Test programs or databases, correct errors and make necessary modifications Education/Experience: – Bachelor’s degree in a technical field such as computer science, computer engineering or related field required – 8-10 years applicable experience required – Experience with database technologies – Knowledge of the ETL process – Knowledge of at least one scripting language – Strong written and oral communication skills – Strong troubleshooting and problem solving skills – Desire to be working with data and helping businesses make better data driven decisions. – Knowledge of automated job control system(Autosys) to execute data load jobs – Understand the test cases /scenarios/ design – Create test cases for complex modules based on the defined test strategy for the assigned modules – Exposure to Database testing using DB2, Oracle and other relational Databases.
– Good in SQL and understanding transformations and converting them to SQL queries for data validations – Nice to have UNIX knowledge and Automation skills Call notes: Required Skills: Query Data/Automation tool is very good. System integration testing is plus ETL shop is good along with workflows Additional Notes: Manager is Part of multifamily. Follow Agile circle. Work with BA along with the product owners in converting user stories and test cases.
Oracle and Informatics as extract. Involved on req gathering, acceptance criteria, testing. Worked with Multifamily is double bonus. Follow Scrum methodology.
Data Profiling. Last 4 to 5 years into relevant work area. 30 % Business and 70 % technical knowledge. As an equal opportunity employer, ICONMA prides itself on creating an employment environment that supports and encourages the abilities of all persons regardless of race, color, gender, age, sexual orientation, citizenship, or disability.