Location: Chicago, IL
Interview: Phone Screen and Onsite Interview – MUST BE LOCAL IN ILLINOIS
(Min 10 yrs. of experience with ERP application)
• Work closely with business, IT teams and help team to understand and document requirements
• Work with application teams, SME’s to understand source systems and produce mapping documents for new solutions.
• Study / Analyze source application documents, data models, data profiling and flush out technical requirement documents.
• Good understanding of Database Design, Integrity, and optimization process.
• Good understanding and prior experience in working with ERP conversion/migration projects for data analysis and data conversions.
• Write SQL Code for Data Profiling, Data Quality & Data Validation
• Work with technical teams to build the desired solution as per requirements
• Perform Data validation
• Functional testing of applications
• Strong Analytical and problem solving skills
• Perform data extraction and transformation activities
• Strong SQL / Advance SQL Skills (SQL Server, Oracle)
• Good to have knowledge of Data Modeling, Data Warehousing and data virtualization concepts.
• Good to have knowledge of data Integration, application integration experience
• At least 10 - 12 years of experience in data analysis and SQL
• Be able to write analyze and tune complex SQL scripts
• Able to derive transformation rules from complex SQL scripts
• Expert level experience in using relational databases Oracle,SQL Server with SQL and PLSQL
• Have excellent communication skills and partner with both Business & Technology stakeholders
• Analyze existing data platform and sources and formulate new designs and capabilities
• Devise logic procedures, prepare flowcharts, perform ETL/coding, and test/debug output
• Develop conversion and standardization plans
• Prepare and obtain approval of system and programming documentation
• Recommend changes in development, maintenance, and system standards
Thanks & Regards,
Business Development Executive
2701 Dallas Parkway, Suite 550
Plano TX, 75093