Job Description :
Role : ETL Developer
Location : Chicago, IL
Interview : Phone and F2F
Duration : 12+months
No H1B
Please note the manager wants someone with ERP experience
Job Responsibility
Write SQL and T-SQL scripts/statements to analyze and translate legacy ERP data into new ERP platform
Interface directly with the business analysts, product owners to define mapping specifications based on data analysis
Create, debug, and execute T-SQL scripts and stored procedures that match data mapping specifications
Perform ETL (extract, transform, load) data imports, exports, and modifications – ETL tool is SSIS
Perform quality assurance and database validation on all test and live conversions
Work on assigned tasks as a member of a project team as required
Review data and database backups
Ability to deal with ambiguity. Make decisions on the basis of the information you have, even if that isn''t the whole picture.
Ability to learn on the fly. Quickly and effectively integrates new information and skills to enhance personal performance or the performance of the organization. Learns from successes and failures, regards all experience as an opportunity to learn and improve
Good problem solving skills.
Process Management. Aligning processes with the organization''s strategic goals, designing and implementing process plans, establishing process measurement systems that align with organizational goals.
Ability to learn new technical skills, when required
Ability to organize and plan how to divide your time between specific activities
Qualification
Bachelor’s degree in Computer Science, Management Information Systems or equivalent
Experience working with MS Access or other SQL-query-based database programs
Strong Knowledge of Microsoft SQL Server 2012 and 2014 (knowledge of Microsoft SQL Server 2005 and 2008 a plus)
Strong Transact-SQL & knowledge.
Experience with CRM solution (Salesforce, Quickbase) is a plus
Strong analytical skills and attention to detail
Ability to work in a team/collaborative environment but to also work independently with the customer
Solid communication and interpersonal skills is a must
Prior experience with C# or Visual Basic programming would be an asset
Thanks and Regards,
Shivangi Singh | Team Lead | KPG99, INC
Certified Minority Business Enterprise (MBE)
Direct| |