*Hope you are doing great!!!!!!*

*Posting ID:  43377 Columbus, OH - IT - DOT - Business Analyst 3/BA3*

*Role: Business Analyst 3/BA3*

*Location: Columbus, OH*

*Onsite Interviews are REQUIRED. Local candidates. *

*Do not submit candidates unavailable to interview onsite!  *

*Re-post from 41464 (I would not recommend re-submitting candidates
previously submitted, but they will NOT be automatically rejected).
Candidate previously selected was removed from assignment. *

Description of Duties:

50% of Total Work Effort: Elicit, analyze, document, and communicate
business requirements as well translate them into more detailed user
stories and/or use cases, and other functional requirements documents such
as process flows, screen mock-ups, gap analysis (also known as Business
Requirements Documents)

40% of Total Work Effort: Work with business units and other stakeholders
to gather requirements, using techniques like interviews and requirement
gathering sessions

10% of Total Work Effort: Work closely with the program manager, project
manager and senior business analyst.

Candidate will be working on a RIMS projects. RIMS is the modernization of
our Roadway Inventory maintenance, editing and distribution of related data
to system throughout the enterprise

Minimum Requirements:

•             7 years’ experience in the analysis, documentation of
business requirements functional and non-functional

•             7 years’ experience creating application prototypes and
screen mockups

•             7 years’ experience creating graphical representations of
complex business processes

•             7 years’ experience in using Microsoft products; Visio,
PowerPoint, Excel and Word

•             7 years’ experience facilitating workshops for requirements

•             5 years’ experience managing requirements on several projects
at the same time

•             7 years’ experience in analyzing data elements of enterprise
applications; determining how the data elements relate to each other

•             6 years’ experience with business process modeling methods
and techniques

•             7 years’ experience performing Gap analysis As-Is/To-Be for
large applications

*Please revert back with the below requested information along with a
latest copy of your profile.*

Position id:

Full Name:

Available for Face to Face:
Work Authorization:
Validity if H1b:
Rate (Hourly):

*List of Domains you worked with:*

*Technical Specializations :*


*Hope you are doing great!!!!*

*Posting ID:  43379 Columbus, OH - IT - DOH - Technical Specialist 1/TS1*

*Re-posted from ID# 42746 (no candidate selected after interviews were
completed).  Please do not re-submit candidates previously submitted to
42746 (they will not, however, be removed automatically from
consideration).  They are looking for someone with as many of the skills
listed below as possible, the more exposure to various technologies, the

*Technical Specialist 1/TS1 SSIS ETL Developer*


*In person interview (only Locals)*

Description of Duties:

25% of Total Work Effort: Requires 5-7 years’ experience as an SSIS ETL
Developer working in Microsoft SQL Server

25% of Total Work Effort: Knowledge of administration of SQL Server for
transactional and analysis systems

25% of Total Work Effort: Strong cube/analytical data model design
expertise (preferred)

25% of Total Work Effort: Snowflake and Star Schema design

The *SSIS ETL Developer* is responsible for designing, developing, and
delivering high-quality output and proactive involvement in the successful
delivery of BI systems; through coordination within the rest of the
technology department and the business owners.

The SSIS ETL Developer is responsible for data profiling of new source
systems, designing custom reporting tables (such as fact and dimension),
and using SSIS to create ETL packages to fully support reporting solutions
in Cognos. Has thorough knowledge of data warehousing and ETL (SSIS

The Resource must have a good understanding of the business needs and the
technical capabilities and be able to help align the BI solutions to meet
the business growth objectives.

*Must have:*

• 5-7 years of experience as an SSIS ETL developer

• Data profiling and data modeling experience

• Strong in data warehousing concepts and techniques

• SQL, T-SQL, PL/SQL techniques

• Experience creating custom reporting tables using SQL (such as fact,
dimension, aggregate, slowly-changing dimension)

• Snowflake and Star Schema design

• Effective verbal and written communications skills and effective
presentation skills

• Self-motivator, independent, cooperative, flexible, creative


• Strong OLAP/cube/analytical data model design expertise

• Cognos experience


• Bachelor’s degree in Computer Sciences or Computer Engineering or
associated discipline or the equivalent experience.

• Microsoft Certified Solutions Developer (MCSD) certification is a plus

• Knowledge of administration of SQL Server for transactional and analysis

• Strong cube/analytical data model design expertise (preferred)

• Specific knowledge of Software Deployment Requirements for BI/DW Projects

• Effective verbal and written communications skills and effective
presentation skills.

• Self-motivator, independent, cooperative, flexible, creative.

*Essential Duties and Responsibilities*

• Designs, develops and monitors Enterprise Transformation Language (ETL)
processes using SSIS

• Performs data profiling, ETL development and administration, and release

• Data modeling using modeling tools and methodologies

• Gathering, documenting, and designing data requirements

• Strong quantitative and analytical skills with accuracy and attention to

• Ability to work well independently with minimal supervision, manage
multiple priorities, and remain flexible in a dynamically changing

• Establishes and implements standards and strategies for data management,
lifecycle, and quality

• Defines and implements best practices and standards for the data modeling

• Creates and maintains the logical and physical data models for the
production and Business Intelligence Data Warehouse and Data Marts.

• Collaborates in data design walkthroughs to communicate Data Warehouse
and Data Mart table designs to the development team.

• Develops prototype views and works with business users both internal and
external to refine their requirements.

• Demonstrates self-reliance in researching technical solutions and product

• Continuously improves existing approaches by seeking opportunity to
creatively transform current business practices into fresh alternative

• Monitors production support issues and develops corrective solutions.

• Conducts performance tuning of existing data structures.

*Data Profiling*

We currently are pulling data from a few source systems and are gathering
requirements for dozens of new dashboards, each from at least one (and
maybe more) source systems. Each dashboard project will require data
profiling, ETL, and report development work. On some projects, the ETL
developer will take on the data profiling responsibilities in addition to
the actually ETL work itself. This involves working with the business
analyst, end-user, report developer, and maybe the technical subject matter
expert. The Resource must have strong experience creating reporting tables.
The reporting tables created will contain the business logic required for
the reports, so that the calculations are performed during ETL. There will
be reporting tables created for each dashboard project. The ETL Resource
needs to have strong SQL skills in order to optimize the table builds, in
addition to reviewing and optimizing the SQL code of other developers.

*ETL Development*

Create ETL packages and jobs to pull data from source system and also
create reporting tables (such as fact and dimension). Resource must have
experience with data warehousing techniques, including aggregates and
slowly changing dimensions. Create new ETL jobs and tune existing ETL jobs.
Review code from other data modelers and make recommendations for changes
in order to improve performance. Create indexes for tables which are being
pulled in as needed.


Administer ETL system by setting-up new data sources, monitor performance
of ETL jobs and resolve all issues, communicate any issues to team and
business users, implement practices to mitigate issues, and work with DBAs
as needed to investigate any data source connection issues. Schedule ETL
jobs to run at optimal times as to not interfere with live operational
data, yet pull the most current data. Set-up notification emails to monitor
success or failure of ETL jobs. Communicate status of ETL jobs to team and
mentor other developers on how to resolve issues. Monitor ETL sequence and
make changes as needed. Mid-day data refresh as needed in Development and
Production environments. Coordinate Cognos read access to Data Warehouse
data sources.

*Monitor Growth*

The data housed in our data warehouse will be growing exponentially, and in
a short time frame. This Resource will be responsible for tracking the
growth rate and keeping the team and management updated on any hardware
changes and recommendation so that our systems can handle our growth.

*Release Management*

Selected Resource will learn and follow our release management process.
This includes identifying the schedule in which the deployment needs to
occur (standard release, non-standard release, or emergency release). The
ETL Resource will be responsible for identifying the database rollback
process for each database deployment.

*Please revert back with the below requested information along with a
latest copy of your profile.*

Position id:

Full Name:

Available for Face to Face:
Work Authorization:
Validity if H1b:
Rate (Hourly):

*List of Domains you worked with:*

*Technical Specializations :*


*Hope you are doing great!!!!*

*Posting ID:  43374 Columbus, OH - IT - DPS - Programmer 5/PR5*

*Job Classification             .Net PR5 (Programmer)*

*Location: Columbus, OH*

*Candidates MUST be available for interview on October 27th between 8:30am
and 11:30am.*

*(This is a repost of 43104.  Two of the three positions have been filled.)*

 Requirement Description:  short description on what they will be working
on, objectives, and tasks/deliverables                The selected
Consultants will work closely with the designated I.T. supervisor, project
managers and other developers in an agile development environment.  The
work scope of the consultant will include requirements gathering,
application design, application development, testing, deployment and
technical support.

*The Consultants, in working with ODPS staff, will be responsible for
rewriting legacy applications to .NET applications utilizing C#, MVC, WCF,
SQL Server and other technologies. *

The new applications will implement a N-tiered architecture and comply with
ODPS coding standards.

This is canned statement with hours, background check and interview
date/time             During the interview process with the ODPS staff, the
resource consultant must demonstrate competence/experience in their
specific area(s) of project assignment. The resource’s experience must also
be documented for review and verification. Offered resources not showing
technical or functional competence/experience will be sufficient reason to
reject the Offeror’s proposal.  It is the responsibility of the Offeror to
pre-screen their candidates to ensure compliance.  Resource will have a
background check conducted by ODPS.

1.            Strong communication/ leadership skills.

2.            Strong influence, collaboration and negotiation experience.

3.            Ability to collaborate with supporting resources across
business and/or functional lines.

4.            Have excellent oral and written skills/possess strong meeting
and work session facilitation skills.

5.            Have the ability to work independently and as part of a team,
the ability to manage time and resources to meet assigned deadlines.

6.            Have strong understanding of prioritization stemming from the
elicitation of system and/or user requirements.

7.            Have excellent organizational skills, proven analytical,
planning, problem solving, and decision-making skills.

8.            Must be knowledgeable in the English language/speak clearly
and understandably use the English language.

*Mandatory Requirements/Time*

1.  5 years of verifiable experience as a Senior .Net Web Developer
developing ASP.NET WebForms applications at least 4 years

2.  5 years of verifiable ASP.NET experience developing with the C – Sharp
(C#) language.

3.  5 years of verifiable experience with SQL Server Database Design and
development including optimization of queries, creating tables, views,
stored procedures, and functions.

4.  2 years of verifiable experience developing web applications utilizing
the 4.0 .Net Framework or higher.

5.  3 year of verifiable Service Oriented Architecture (SOA) experience
developing and securing Windows Communication Foundation (WCF).

6.  1 year experience or a demonstrable understanding of N-tier
environments as it relates to development and deployment.

7.  2 year experience or a demonstrable understanding of code repository
strategies, code promotion strategies and recovery using Team Foundation

8.  2 years of verifiable experience implementing Asynchronous JavaScript
and XML (AJAX) enabled controls within Active Server Pages (ASP).Net Web

9.  1 year of verifiable experience developing reports in SQL Server
Reporting Services (SSRS) and making them accessible within an MVC web

*Please revert back with the below requested information along with a
latest copy of your profile.*

Position id:

Full Name:

Available for Face to Face:
Work Authorization:
Validity if H1b:
Rate (Hourly):

*List of Domains you worked with:*

*Technical Specializations :*

Thanks and Regards,

*Kalyan Kumar*

*Data Systems Integration Group Inc, *5131 Post Rd, Suite 175,

Dublin, OH - 43017
Email : kal...@dsiginc.com

Gmail & Yahoo :* kalyankumar.recruiter*

Direct: 614-344-4600 x 113



[image: Email Signature2]

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

Reply via email to