SQL BI Developer Job opening Location New York, NY

AurionPro Solutions Leading Global IT Consulting Services.

We’ve Urgent requirement with one of our client for SQL BI Developer Job opening Location New York, NY

Position Title: SQL BI Developer

position Type: 6 Months Contract

Location: New York, NY

Responsibilities:

Business Intelligence developer will be a core global team member to provide expertise in SSAS, Reporting Services, data modeling, SSIS and BI development to support/enhance the existing data integration and reporting architecture frameworks/functionalities. Candidate will assist for reviewing and clarifying business requirement documents as well as BI related development.  The individual needs to have broad development experience in developing BI reporting. The department currently encompasses the use of SQL Server and Oracle. The candidate will also assist to evaluate and test emerging business intelligence reporting tools to enhance reporting functionalities for future needs.

Main Duties

The main responsibility of the candidate will be to develop and  maintain, and enhance data marts, OLAP reporting development using SSAS/SSRS/PerformancePoint/PowerPivot, database and reporting functionalities. The candidate should be innovative and forward looking and is able to take challenges in a fast environment. The requirements for BI development are growing rapidly so the candidate must be able to think quickly but always be looking for new ways to improve the existing technology and framework under tight deadlines.

·         Experience in all aspects of data analysis, data mart design and development, Microsoft business intelligence development including OLAP cube(SSAS), Reporting Services, SSIS development, PerformancePoint

·         Experience in data warehouse design and architecture

·         Experience in data quality, KPIs and dashboards development

·         Review/clarify business requirements with team members and business analysts

·         Support and troubleshooting performance issues in OLAP cube, database, ETL and query performance

·         Coordinate BI related activities such as scheduled maintenance, upgrade, performance tuning and trouble shooting

·         Assist with team members to understand functionalities and coordinate with global testing team for QA/UAT process

·         Willing to learn new technologies and adapt new changes

·         Occasionally assist development other than regular duties

Person Requirements Basic Qualifications-

·         Solid understand of Enterprise business intelligence and data warehouse design methodologies

·         Demonstrated  experience in Microsoft BI solutions including SSAS/SSRS/SSIS, large OLAP cube, PerformancePoint/PowerPivot

·         Experience in SQL (MS SQL Server 2005/2008) technology is a must.

·         Experience in large data warehouse

·         Degree in engineering, computing or other numerate discipline

·         7+ years of development experience in IT

·         5+ years of SQL Server OLAP cube and data mart development

·         3+ years of XMLA/MDX/AMO

·         5+ years of SQL Server database development

·         5+ years of SQL/procedure/view/function/trigger development and performance tuning

·         3+ years of SSRS/PerformancePoint reporting and dashboard development

·         2+ years of SSIS development and management

·         1+ years of ERwin or other data modeling tool

·         1+ years of VB script

·         Preferred Qualifications-

·         Previous experience in .Net development and integrate with reporting application is a big plus

·         Understand other BI tool such as Cognos.QlikView or Business Objects is a big plus

·         Experience in Office Web Components is a big plus

·         Experience with Information 8.X for ETL development is a plus

·         Knowledge of all phases of Software Development Life Cycle (SDLC)

·         Knowledge of Identity Management and App Security is a plus

·         Ability to develop strong client relationships

·         Excellent written and verbal communication skills

Thanks

Vignesh

e mail:  vignesh.renikuntla@aurionpro.com 

Linkedin:  http://www.linkedin.com/in/viggy1

Phone: 408-754-6161

Fax: 732 909 2221

AurionPro Solutions, Inc.

Edsion, NJ

www.aurionpro.com

SSIS ETL/DW Developer Job opening

AurionPro Solutions Leading Global IT Consulting Services.

We’ve Urgent requirement with one of our client for SSIS ETL/DW Developer Job opening Location New York City, NY

Position Title: SSIS ETL/DW Developer

Duration: 6 months

Location: New York City, NY

Job Description:

SSIS ETL and Data Warehouse developer will be a core global team member to provide SQL Server development and administration expertise, data modeling, SSIS, and BI development to support/enhance the existing data integration and reporting architecture frameworks/functionalities. Candidate will assist for reviewing and clarifying business requirement documents as well as database/ETL related development.  The individual needs to have broad development experience in developing database backend for data integration and reporting. The department currently encompasses the use of SQL Server and Oracle. The candidate will also assist to evaluate and test emerging business intelligence reporting tools to enhance reporting functionalities for future needs.

Main Duties

The main responsibility of the candidate will be to develop, maintain, and enhance data integration, database and reporting functionalities. The candidate should be innovative and forward looking and is able to take challenges in a fast environment. The requirements for database/ETL development are growing rapidly so the candidate must be able to think quickly but always be looking for new ways to improve the existing technology and framework under tight deadlines.

•             Experience in all aspects of database design and development, stored procedure development, SSIS development, Reporting Services development and business intelligence development

•             Review/clarify business requirements with team members and business analysts

•             Development and maintenance in SSIS server and process

•             Support and troubleshooting issues in database, ETL and query performance

•             Coordinate database related activities such as scheduled maintenance, upgrade, performance tuning and trouble shooting

•             Assist with team members to understand functionalities and coordinate with global testing team for QA/UAT process

•             Identify bottlenecks on existing database/ETL process and be able to enhance it to the next level using best practice

•             Willing to learn new technologies and adapt new changes

•             Occasionally assist development other than regular duties

Person Requirements Basic Qualifications-

•             Solid understanding of data warehouse modern design methodologies

•             Solid understanding of best practices for SQL Server, the SQL Server Storage Engine and RDBMS

•             Experience in SQL (MS SQL Server 2005/2008) technology is a must.

•             Experience in very large database, data warehouse and high-volume ETL process

•             Degree in engineering, computing or other numerate discipline

•             7+ years of development experience in IT

·         5+ years of ETL and data warehouse development using SQL Server 2005/2008 database

·         5+ years of T-SQL/procedure/view/function/trigger development and performance tuning

·         5+ years of SSIS development and management

·         1 + years of Oracle PL/SQL development

·         1+ years of data modeling

·         1+ years of VB script

·         1+ years of SSRS or other reporting tool experience

Preferred Qualifications-

•             Previous experience in SQL Server administration and management is a big plus

•             Understand OLAP and data warehouse is a big plus

•             Experience with SQL Server Business Intelligence(SSAS) and .Net development is a plus

•             Experience with Information 8.X for ETL development is a plus

•             Knowledge of all phases of Software Development Life Cycle (SDLC)

•             Knowledge of Identity Management and App Security is a plus

•             Ability to develop strong client relationships

•             Excellent written and verbal communication skills

Thanks

Vignesh

e mail:  vignesh.renikuntla@aurionpro.com 

Linkedin:  http://www.linkedin.com/in/viggy1

Phone: 408-754-6161

Fax: 732 909 2221

AurionPro Solutions, Inc.

Edsion, NJ

www.aurionpro.com

SSIS Developer with recent experience in EDI Job opening

AurionPro Solutions Leading Global IT Consulting Services.

We’ve Urgent requirement with one of our client for SSIS Developer with recent experience in EDI Job opening Location New York City, NY.

Position title: SSIS Developer with recent experience in EDI

Location: New York City, NY

Duration: Full time

Note:  Required who Can work on our Organization W2 / H1 Transfer would accepted

Job Description:

Need a SSIS Developer with recent experience in working in EDI . Project involves development of SSIS programs to process EDI like documents. Will also be involved in Sales force integration. Proficiency in C# is desired (intermediate level)

Thanks

Vignesh

Sr. Talent Acquisition

e mail:  vignesh.renikuntla@aurionpro.com 

Linkedin:  http://www.linkedin.com/in/viggy1

Phone: 408-754-6161

Fax: 732 909 2221

AurionPro Solutions, Inc.

Edsion, NJ

www.aurionpro.com

SQL 2008 developer Job opening

AurionPro Solutions Leading Global IT Consulting Services.

We’ve Urgent requirement with one of our client for SQL 2008 developer Job opening Location New York City, NY.

Position title: SQL 2008 developer

Location: New York City, NY

Duration: Full time

Note:  as per the client Discretion required someone can work on our W2 / H1 Transfer would accepted.

Job Description:

SQL 2008 developer. Must be very strong database concepts, expert  in writing Store procs, resolving Syntax errors. Prior conversion from Sybase to SQL is highly desirable.

Thanks

Vignesh

Sr. Talent Acquisition

e mail:  vignesh.renikuntla@aurionpro.com 

Linkedin:  http://www.linkedin.com/in/viggy1

Phone: 408-754-6161

Fax: 732 909 2221

AurionPro Solutions, Inc.

Edsion, NJ

www.aurionpro.com

SAP Security Functional Analyst Job opening

AurionPro Solutions Leading Global IT Consulting Services.

We’ve Urgent requirement with one of our client for SAP Security Functional Analyst Job opening Location Cherry Hill, NJ

Position Title: SAP Security Functional Analyst

Duration: 6 Months Contract

Location: Cherry Hill, NJ

Role Requirements:

·         Analyzes and defines SAP functions, business processes, and user needs and performs functional security configuration and maintenance tasks for SAP ECC systems according to operational and business needs.

·         Design and Create user role and authorization and associated T (transaction)-codes created with ECC.

·         Define process in SAP ECC that supports the master data configuration for : RTR( Record to Report), PTP ( Procure to Pay) and HTR ( Hire to Retire)

·         Triage issues for role authorization and associated T-codes.

·         Work with super users to develop standard configuration.

·         Delivers quality solutions that meet both business and functional requirements.

·         Develops best-practice business knowledge and supports the business integration into an SAP solution.

Experience and Expertise:

·         A Bachelor’s degree

·         At least 2 – 3 years of SAP experience working as an SAP Security Analyst working with ECC      ( ERP Central Component)

·         At least 1 full lifecycle SAP implementation project experience

·         Strong knowledge of how to configure T- codes and role mapping – created with ECC.

·         Experience with issue triage with end users. 

·         Strong communication skills, both written and spoken

·         Customer service orientation

·         Additional work hours as occasionally required, including weekends

·         Ability to effectively prioritize and execute of tasks in a high-pressure environment

Thanks

Vignesh

Sr. Talent Acquisition

e mail:  vignesh.renikuntla@aurionpro.com 

Linkedin:  http://www.linkedin.com/in/viggy1

Phone: 408-754-6161

Fax: 732 909 2221

AurionPro Solutions, Inc.

Edsion, NJ

www.aurionpro.com

Administrator Web / Apps Job opening CA

AurionPro Solutions Leading Global IT Consulting Services.

We’ve Urgent requirement with one of our client for Administrator Web / Apps Job opening Location Mountain View.  CA

Position title: Administrator Web / Apps

Location: Mountain View.  CA

Duration: 6 Months Contract

Note: As per the client discretion required Must be US Citizen or Green card Holder

Job Description:

5 to 7 Years’ experience in Linux is a must.

3 to 5 Years’ experience with Apache and Tomcat is a must.

1 to 2 Years’ experience in OpenVPN and Yum is must.

1  to 2 year of experience in implementation of certificates in websites and SSH keys.

Solid experience in system & network administration of RHEL Linux.

In depth knowledge of System/OS level & TCP/IP Networking is a must.

Some experience in VMware ESX 4 is a plus.

Some experience in shell and perl scripting is a plus.

Some experience in MySQL is a plus

Should put in security as a priority in all the administration and tools management.

Should be able to work independently and lead/complete project as per guidelines.

Excellent interpersonal and communication skills, as well as oral and written skills.

Participate in off-hours, weekends and holidays on-call support as required.

Ability to acquire and maintain “Trusted” employee status.

Must be able to lift 50 lbs and work inside a data center environment

Thanks

Vignesh

Sr. Talent Acquisition

e mail:  vignesh.renikuntla@aurionpro.com 

Linkedin:  http://www.linkedin.com/in/viggy1

Phone: 408-754-6161

Fax: 732 909 2221

AurionPro Solutions, Inc.

Edsion, NJ

www.aurionpro.com

Project Manager Job opening

AurionPro Solutions Leading Global IT Consulting Services.

We’ve Urgent requirement with one of our client for Project Manager Job opening Location Voorhees, NJ

Position Title: Project Manager

Employment Type: Permanent

Location: Voorhees, NJ

Responsibilities:

Project Manager Key Accountabilities :

Monitoring and managing budgets and schedules for several medium to Knowledge: General knowledge of Engineering, Project Management and construction Key Interfaces/Relationships: Technical services colleagues

Primary Role:

Responsible for the scoping, planning, and execution of multiple, small to medium-size IT projects using American Water Project Management Methodology. Responsibilities and processes include scope, cost, schedule, issues, risks, resource management, and status reporting. Successfully manages the day-to-day activities of projects through the project life cycle from initiation to close including requirements gathering, system analysis/design, development/configuration, testing and implementation phases. Assumes ownership of the project deliverables and results. Acts as primary liaison between the business and the various ITS teams and security.

Key Accountabilities:

·         Performs a project leader role, providing planning, direction, coordination, and daily supervision to the project team to ensure the objectives and tasks of the project are accomplished on time and within budget. 

·         Consults with the business departments and process owners in defining business requirements and ensuring the solution meets those requirements.

·         Ensures that the project team follows proper life cycle development techniques, PMO processes and procedures, and company and internal policies and practices. 

·         Prepares projects for the ITS Steering Committee & CIMC governance.

·         Ensures the project deliverables are stored and maintained in the project repository and meet all documentation requirements for quality. 

·         Identifies, tracks, escalates, and helps solve project issues, conflicts, and problems. 

·         Identifies and tracks project risks and mitigates risks that jeopardize the project deliverables.

·         Forecasts project costs, resource requirements, and timelines.  Works with ITS Managers and Human Resources to staff for each phase of the project.  

·         Manages changes in project scope via the Scope Change process

Education:

·         Bachelor’s degree in Computer Science, Information Science or related discipline. Significant additional experience and/or  certifications or other education and training may be substituted for each year of formal education.

·         Strong interpersonal, people and people management skills (e.g. listening, coaching, facilitating, tact/diplomacy, employee relations, development, motivation, team building).

·         Good consulting, client relations skills and customer service orientation.

·         Excellent planning, time management and organization skills.

·         Good verbal and written communications skills, including presentation expertise.

·         Ability to successfully interact with and be responsive to other management and professional employees of the Corporation and its affiliates.

·         Ability to interact in a professional and persuasive manner with the appropriate stakeholders.

·         Knowledge of IT system environments/platforms and development tools.

·         Working knowledge of utility/financial business processes.

Experience:

·         5+ years IT experience including analysis, design, or application development.

·         Demonstrated project management expertise (minimum 5 years). Advanced knowledge of project management methodologies and tools with proficiency in MS Project.

·         Demonstrated experience in managing small to medium-size development projects from initiation to implementation. This includes managing multiple projects concurrently.

·         Demonstrated knowledge/proficiency and comprehension of core business functions, processes, and operations.

·         Certifications & Licenses: PMI Certification Required or Equivalent Experience.

Thanks

Vignesh

Sr. Talent Acquisition

e mail:  vignesh.renikuntla@aurionpro.com 

Linkedin:  http://www.linkedin.com/in/viggy1

Phone: 408-754-6161

Fax: 732 909 2221

AurionPro Solutions, Inc.

Edsion, NJ

www.aurionpro.com

Sr Salesforce Developer Job opening Location

Sr Salesforce Developer – Job opening Location South San Francisco, CA

Position Title: Sr Salesforce Developer

Duration: 6 Months

Location: South San Francisco, CA

Need Local to California to Attend In person Interview

Job Overview: 

Need 10 years of IT back ground experience and Sr. Salesforce Developer with The incumbent will translate business needs into real solutions and collaborate with a group of talented software engineers to design a scalable service platform.

Responsibilities:

Successful candidate will create and manage complex workflow rules, data validation, and APEX triggers as well as create and maintain Salesforce.com applications using Visualforce, APEX

Primary Skills:

Strong Developer on Salesforce.com

Create user profiles for executives, customer portal and end users.

Proficient in relevant languages including Apex

Excellent analytical skills and the ability to engage effectively with business and technical tiers

Proven knowledge of the software development life cycle and Salesforce integration

Preferred Skills:

Experience leveraging the Salesforce API via SOAP or REST

Creating reports and dashboards within the Salesforce environment

Certified in Salesforce Developer 401 OR 201

Thanks

Vignesh

e mail: vignesh.renikuntla@aurionpro.com 

Linkedin: http://www.linkedin.com/in/viggy1

Phone: 408-754-6161

Fax: 732 909 2221

AurionPro Solutions, Inc.

379 Thornall Street

2nd Floor Edison NJ 08837

www.aurionpro.com

Supply Chain Software Pre Sales Consultant Job opening

AurionPro Solutions Leading Global IT Consulting Services.

We’ve Urgent requirement with one of our client for Supply Chain Software Pre Sales Consultant Job opening Location Radnor, PA

Position Title: Supply Chain Software Pre Sales Consultant

Employment Type: Permanent

Location: Radnor, PA

Job Description:

Role Overview:  Responsible for the identification, development and presentation of the Client advanced planning, scheduling and supply chain optimization solutions to market-leading companies with complex supply chain planning needs. 

Key areas will be to lead the solving of customers’ issues and addressing their requirements in a combination of presales activities which include, but is not limited to, business scan, demo challenge, and proof of concept. Additionally, establish a strong partnership with the Sales Executive, Project Manager, Technical Consultants and Client Specialists, all with one goal: to sell and help run a successful project, and as a result, have a happy customer.

The proven Client Project Life Cycle (QPLC) implementation methodology and project management tools are key instruments to be used and mastered. 

Skills:

·         High Abstraction, Analytical and Critical Problem Solving Skills

·         Requirement Assessment

·         Gap Analysis

·         Solution Creation

·         Algorithmic Puzzle Solving

·         Supply Chain Advanced Planning and Scheduling Solution experience

·         Full Solution Life Cycle

·         Business process modeling

·         Discover optimization potential

·         Solution Definition

·         In-depth experience with software implementations (e.g. APS, SCM or ERP)

·         Iterative development experience with object-oriented modeling

·         Proven results in providing advice and direction to customers for delivery success and client satisfaction

Characteristics:

·         Team Player

·         Energetic and Flexible

·         Self-directed and self-motivated

·         Excellent communication skills with all levels ( management to planners )

·         Strong listening skills

·         Proven ability to bridge the gap between sales and technical consultants

·         Ability to develop and deliver proposals and presentations

Education:

Bachelor's degree in computer science, economics, business administration or related field Remuneration Package:

Excellent working conditions, good salary and benefits (e.g. flexible working hours, 401(k), time-for-time and profit sharing).

Thanks

Vignesh

Sr. Talent Acquisition

e mail:  vignesh.renikuntla@aurionpro.com 

Linkedin:  http://www.linkedin.com/in/viggy1

Phone: 408-754-6161

Fax: 732 909 2221

AurionPro Solutions, Inc.

Edsion, NJ

www.aurionpro.com

Supply Chain Software Engineer Job opening

AurionPro Solutions Leading Global IT Consulting Services.

We’ve Urgent requirement with one of our client for Supply Chain Software Engineer Job opening Location Radnor, PA

Position Title: Supply Chain Software Engineer

Employment Type: Full time

Location: Radnor, PA

Supply Chain Software Engineer Function description For our Client’s fast growing office in Radnor (PA) near Philadelphia, we are looking for software engineers. You will be working with their state-of-the-art Supply Chain advanced planning and scheduling platform to develop planning solutions for our diverse range of customers

If you have the ability and experience to work in an object-oriented development environment, if you like complex puzzles, if you combine technical skills with functional understanding, if you like rapid application development and relatively short and dynamic projects (several weeks up to nine months), then this is the job for you!

The Client software is a best-of-breed planning and scheduling platform and provides an extensive range of tools for state-of-the-art visualization, modeling of planning and scheduling knowledge, and implementation of business rules as well as several optimization algorithms. You'll use this toolset to program and create solutions that help our customers increase their bottom line. Your passion is in creating technologically advanced solutions, while being part of a small team that directly interacts with our customers.

Skills and Experience:

·         Background at academic level in computer science, econometrics or similar, high abstraction and analytic ability

·         Experience with object-oriented programming and modeling in 3GLs (for example languages such as Java, C++, C#) or 4GLs.

·         Some knowledge of optimization techniques in operations research or artificial intelligence (e.g., linear programming, genetic algorithms, heuristic search techniques, constraint programming, etc.) is a plus.

·         Essential is that you are an energetic and flexible individual

·         Strong verbal and written communication skills

·         Enjoy working on solving complex design and configuration challenges with your colleagues.

Company profile

Our Client is an innovative, profitable, private company with headquarters in Pennsylvania and The Netherlands, and offices in Germany, the United Kingdom, China, Australia, Italy, Finland, Switzerland, and Malaysia. Our Client has over 500 employees, grows about 50% year on year, and is recognized by industry analysts as one of the most innovative software platforms for the complex area of planning and scheduling. Customers in the USA include FAA, DHL, Washington State Ferries, QVC, most large aluminum producers, and many others.

Remuneration package

Excellent working conditions and compensation package. (e.g. flexible working hours, 401(k), time-for-time and profit sharing).

Additional information

Please send a position specific cover letter (explaining your particular interest in this job) and your resume to   Resumes without cover letters or resumes with generic cover letters, will not be reviewed.

Thanks

Vignesh

Sr. Talent Acquisition

e mail:  vignesh.renikuntla@aurionpro.com 

Linkedin:  http://www.linkedin.com/in/viggy1

Phone: 408-754-6161

Fax: 732 909 2221

AurionPro Solutions, Inc.

Edsion, NJ

www.aurionpro.com

Advanced Planning & Scheduling Supply Chain Consultant Job opening

AurionPro Solutions Leading Global IT Consulting Services.

We’ve Urgent requirement with one of our client for Advanced Planning & Scheduling Supply Chain Consultant Job opening Location Radnor, PA

Position Title: Advanced Planning & Scheduling Supply Chain Consultant

Employment Type: Full time

Location: Radnor, PA

Job Description:

Our Supply Chain Software Client is looking for consultants for their fast-growing office in Radnor (PA) near Philadelphia. You will be working with their state-of-the-art advanced planning and scheduling platform to develop planning solutions for their diverse range of customers.

If you have the ability, enthusiasm and experience to work in a complex software environment, if you like difficult puzzles, if you combine functional understanding with technical skills, if you enjoy rapid application development and relatively short and dynamic projects (average projects are generally 4 to 9 months long), then this is the job for you! Our client’s consultants are key in solving their customers’ puzzles in a combination of presales activities (business scan, demo challenge, proof of concept) and implementation projects at fortune 1000 companies in the USA and Canada.

As an Advanced Planning & Scheduling Supply Chain Consultant, you are responsible for implementing Our client’s software at their customers’ locations and in some cases in collaboration with their partners.  You must be able to discuss business rules, user interface design, and optimization solutions with management as well as planners.  You must be able to quickly understand the business processes, discover optimization potential, define the solution and communicate it to programmers as well as the customers.  You would enjoy “solving the daily puzzle,” designing solution vision and being the face of our client to their customers.  Their customers range from mid-sized to large industrial companies in metal, manufacturing, logistics, rail, workforce and other markets; knowledge of one or more of these markets is helpful.

Skills and Experience:

·         B.S. Computer Science or Econometrics

·         High abstraction and analytical ability

·         Advanced Planning & Scheduling in industry or logistics

·         Object-oriented modeling (UML)

·         Optimization techniques in operations research and artificial intelligence (linear programming, genetic algorithms, heuristic search techniques, constraint programming, etc.)

·         ERP systems is a plus

·         Energetic and flexible

·         Strong written and verbal communication skills, especially in an environment of top professionals

·         Minimum of three to five years working experience.

Company profile

Our client is an innovative, profitable, privately held company with dual headquarters in The Netherlands and the United States, and other offices in Germany, the United Kingdom, Finland, Italy, China, Australia, and Malaysia.  Our Client has over 500 employees, grows about 50% year on year, and is recognized by industry analysts as one of the most innovative software platforms for the complex area of planning and scheduling. Customers include FAA, Novelis Oswego, Air Products, DHL and many, many others.

Remuneration package

Excellent working conditions, strong benefits package, including 401k and profit sharing, and competitive salary.

Additional information:

Please send a SPECIFIC cover letter (explaining your particular interest in this job) with your resume. Resumes without cover letter, or resumes with generic cover letters, will not be reviewed.

Thanks

Vignesh

Sr. Talent Acquisition

e mail:  vignesh.renikuntla@aurionpro.com 

Linkedin:  http://www.linkedin.com/in/viggy1

Phone: 408-754-6161

Fax: 732 909 2221

AurionPro Solutions, Inc.

Edsion, NJ

www.aurionpro.com

Data Architect Job opening

AurionPro Solutions Leading Global IT Consulting Services.

We’ve Urgent requirement with one of our client for Data Architect  Job opening Location Vacaville, CA

Position Title: Data Architect

Employment Type: 6 Months Contract

Location: Vacaville, CA

Job Description:

The tasks for the Data Architect include, but are not limited to, the following:

·         Translate client user requirements into technical architecture vision and implementation plan

·         Design and develop the architecture for all data warehousing components (e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)

·         Design of the data warehouse data storage strategy/technique (ODS, EDW, DM, ROLAP, MOLAP, etc.)

·         Design of data warehouse sub-system (e.g. QA/QC, ETL and Query metrics)

·         Oversight of tool evaluation and selection

·         Hardware recommendations, sizing and configuration

·         RDBMS installation, configuration and tuning

·         Oversight and/or coordination of system testing phase

·         Problem and issue resolution

·         Mentoring and developing junior staff

·         Participation in proposal development and client presentations

·         Work with the Business and IT teams to complete the project analysis, scoping, and scheduling

·         Attend and contribute to project meetings

·         Ensure that all project documentation is produced in the standard format, that it follows internal documentation processes and is reviewed and approved prior to delivery to State Fund.

Technical Knowledge and Skills

Consultant resources shall possess most of the following technical knowledge and experience:

·         A minimum of 5 years of experience architecting large scale data warehouses using Oracle

·         A minimum of 5 years of relevant consulting experience preferred or 7 years of corporate IT

·         Expert data modeling skills (i.e. conceptual, logical and physical model design - with both traditional 3 rd normal form as well as dimensional modeling (star, snowflake), experience with Operation Data Stores, Enterprise Data Warehouses and Data Marts

·         Expert with pro's and con's of multiple warehouse architectures

·         Expert RDBMS knowledge of Oracle (release 9i and 10g) including very large databases

·         Expert in load design strategies and optimization techniques

·         Implementation experience with ETL concepts and tools such as: DataStage, Informatica, Oracle Warehouse Builder

·         Implementation experience with one or more of the following BI/Enterprise Reporting tools: Business Objects, Oracle Discoverer, Cognos, Brio, and Micro strategy

·         Possess strong communication and client management skills.

·         Ability to effectively manage multiple projects simultaneously

·         BS in Computer Science or equivalent experience in a relevant field

·         Extensive Experience with writing Oracle Procedures, Packages, Functions to support application development

·         Strong Knowledge of writing PL/SQL scripts to manipulate data and create ad-hoc reports

·         Analyze and load data from different sources (flat files, other databases)

·         Strong Knowledge of primary / foreign keys, indexes, constraints, views, schemas etc.

·         Strong Knowledge of Query performance tuning

Demonstrable Skills

·         The Consultant resource(s) shall possess most of the following skills:

·         Strong analytical skills with the ability to analyze information and identify and formulate solutions to problems.

·         Provide more in-depth analysis with a high-level view of goals and end deliverables.

·         Complete work within a reasonable time frame under the supervision of a manager or team lead.

·         Plan and manage all aspects of the support function.

·         Extensive knowledge of and proven experience with data processing systems, and methods of developing, testing and moving solutions to implementation.

·         Strong knowledge in project management practices and ability to document processes and procedures as needed.

·         Work collaboratively with other support team members and independently on assigned tasks and deliverables with minimum supervision

·         Communicate effectively with users at all levels, from data entry technicians up to senior management, verbally and in writing.

·         Self-motivated, working closely and actively communicating with team members to accomplish time critical tasks and deliverables

·         Ask questions and share information gained with other support team members, recording and documenting this knowledge

·         Elicit and gather user requirements and/or problem description information, and record this information accurately

·         Listen carefully and act upon user requirements

·         Convey and explain complex problems and solutions in an understandable language to both technical and non-technical persons

·         Present technical solutions to management and decision makers

·         Follow the lead of others on assigned projects as well as take the lead when deemed appropriate

·         Think creatively and critically, analyzing complex problems, weighing multiple solutions, and carefully selecting solutions appropriate to the business needs, project scope, and available resources

·         Take responsibility for the integrity of the solution

Thanks

Vignesh

Sr. Talent Acquisition

e mail:  vignesh.renikuntla@aurionpro.com 

Linkedin:  http://www.linkedin.com/in/viggy1

Phone: 408-754-6161

Fax: 732 909 2221

AurionPro Solutions, Inc.

Edsion, NJ

www.aurionpro.com