Need Data Analyst Local to IL

[Amit bajpai]

Please send resume to ami...@idctechnologies.com



Data Analyst for a 6-9+ mo contract in downtown Chicago.  Locals only



*Description:*



This individual will be the analyst responsible for data integrity for
members and non-member email and phone contact information.   This is in
preparation for the next phase of the project which will be to create an
account management application that will be a central repository for
member/non-member profile information and preferences.



· Use complex SQL to extract data from multiple sources with the
given requirements

· Use data quality assurance applications to perform, review, and
report on results of data quality checks

· Create and maintain documents, workflows and data flows to
support configuration management as new processes are developed

· Define data quality standards, identify and develop data
solutions to resolve business issues

· Utilize statistical analysis to profile data sets in support of
business cases identifying dependencies and risks with results
delivery through data quality score carding as well as providing
supplemental analysis for data quality improvement efforts

· Work with all stakeholders to quickly identify and address root
causes of data quality issues

· Use Informatica to identify and enhance ETL code to address Data
Quality issues

· Prepare, deliver reports and recommendations on, and propose
approaches to address data quality issues



*Required:*



   - SQL 2007 +
   - Informatica 9.5 or 9.6
   - ETL code
   - Data profiling and testing tools



*Thanks and Regards,*

*Warm Regards,*

*Randhir Kumar*

*IDC Technologies*

*1851 McCarthy Blvd. Suite 116, Milpitas, CA 95035*

*Email: **randhir.ku...@idctechnologies.com*


*Phone: *
*408-459-1535 Web: **www.idctechnologies.com*


-- 
You received this message because you are subscribed to the Google Groups "SAP 
or Oracle Financials" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sap-or-oracle-financials+unsubscr...@googlegroups.com.
To post to this group, send email to sap-or-oracle-financials@googlegroups.com.
Visit this group at https://groups.google.com/group/sap-or-oracle-financials.
For more options, visit https://groups.google.com/d/optout.

Need Data Analyst Local to IL

[Amit bajpai]

*Hi,*



*Please send resume to **ami...@idctechnologies.com*






*Title: Data Engineer*

*Location: Chicago 60613 (north side near Wrigley Field)*

*Duration: 3-6 months+*

*Strongly prefer locals only*

*Candidates will have to complete a SQL assessment (online)*

*Phone & F2F interview with assessment*



The company is growing quickly and is looking for someone who thrives in a
fast-paced environment while maintaining superb attention to detail.  A
strong candidate will be someone who is constantly cultivating new ideas
and methods to improve our processes and better serve our clients.



In this role, candidates will work with multiple tools, primarily SQL, to
build and support data service operations to help our clients improve data
integrity and provide reporting solutions to drive business decisions.  The
candidate should have 5-10 years of experience in working with (custom)
data service applications that extract, transform, modify, normalize, and
clean data to produce data sets for analysts.



   - Work as part of the Engineering team to build and maintain core
   systems that perform data operations for our clients which include:
  - Lead the implementation and transition of clients to SQL Server
  core system
  - Design and development of new client solutions
  - Maintain key integration data flows from our clients’ systems to
  our data warehouse
  - Diagnose operational breakdowns in the data flow escalated from the
  production team and lower engineering resources (Tier 3 support)
  - Lead the transition of client projects from development to
  operations
   - Work with client managers to provide business analyst services
   including:
  - Gathering business requirements
  - Develop functional descriptions and mapping to SQL procedures
  - Develop and lead functional and UAT testing
   - Candidates should be able to completely own deliverables after a short
   ramp up time





*Desired Skills:*

   - 5-10 years of SQL experience with ability to:
  - Troubleshoot data loading and transformation procedures to resolve
  operational issues
  - Understand & develop stored procedures (SPOC’s)
  - Write export definitions and test outcomes
   - Solid experience in database operations and/or data warehouses,
   particularly those based on SQL Server
  - Ability to quickly learn db structure, table layout and production
  processes
  - Have an “application” view to conceptualize processes from
  end-to-end
  - Ability to detect and diagnose issues with data services
  - Develop and support core Data Warehouse functions
   - Business Analyst skills to
  - Record, assess and document business requirements
  - Develop functional designs given understanding of systems of record
  and current data infrastructure
  - Lead client interactions in the design and development phase
   - Advanced Excel skills including:
  - Pivot tables
  - Pivot tables formulas
  - Working knowledge of macros
  - Table functions
   - Tableau experience is a plus, but not required
   - Organizational skills and high attention to quality and detail







*Thanks and Regards,*



*Warm Regards,*

*Amit Vajpayee*

*IDC Technologies*

*1851 McCarthy Blvd. Suite 116, Milpitas, CA 95035*

*Email: **ami...@idctechnologies.com* 

*Phone: *
*408-459-3314 Web: **www.idctechnologies.com*


-- 
You received this message because you are subscribed to the Google Groups "SAP 
or Oracle Financials" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sap-or-oracle-financials+unsubscr...@googlegroups.com.
To post to this group, send email to sap-or-oracle-financials@googlegroups.com.
Visit this group at https://groups.google.com/group/sap-or-oracle-financials.
For more options, visit https://groups.google.com/d/optout.