Need ETL developers, DBA, PM, BA, Technical Writer

1 view
Skip to first unread message

CODESOFT

unread,
Jul 8, 2009, 10:23:41 AM7/8/09
to CodeSoft Reqs, pra...@codesoft.net
Please mention the requirement # while submitting the resumes.

Role: ETL Developer REQ: 885241
Location: BANKING DOMAIN CLIENT
Bridgeport, CT Start Date: 5/18/09
End Date : 4+ months

Purpose of the role - How it adds value


Deliverables: criteria/results by which success can be measured:
Microsoft SQL Server Data Warehouse Developer with 5-10 years of
experience as a data warehouse application developer, working on both
the database backend and information delivery aspects of the
warehouse. Substantial experience in developing both warehouse ETL
and OLAP application code is required. Primary development
experience in Oracle data warehouse development is very helpful.
Data Warehousing; SQL Server; SQL; Business Analyst; Erwin
Substantial experience working on database design aspects of data
warehouse applications. Knowledge of transaction system database and
data modeling design approaches (entity-relationship diagrams,
normalization) as well as business intelligence approaches (star
schema, denormalization). Demonstrated experience in developing data
architectures and ETL applications related to warehouse data
sourcing. Expert knowledge of data warehouse architectural concepts
along with warehouse production support experience. Development
experience should include quasi-DBA support functions like DDL or DCL
scripting experience or script generation through a data modeling or
database administration tool experience developing and maintaining
data models using either ER-Studio or Erwin is preferred.
Excellent ability to interpret business requirement and functional
specs and convert these to technical designs and databse application
code. Significant experience working with data quality assurance
issues in connection with warehouse data sourcing and/or information
delivery development tasks. Experience building ETL code which
promotes and sustains warehouse data quality.

Technical Knowledge:
MS Project ; Data Warehousing; SQL Server; SQL; Business Analysis;
Erwin
Expert knowledge of SQL, Transact-SQL, DTS/SSIS, Analysis Services and
proven development experience using the MS SQL Server 2000/2005
technology base.
Solid experience in analyzing query performance issues and modifying
data structures or application code to remedy performance problems.
College degree required; Business or Computer Sciences preferred.
Knowledge of credit card or financial services industry a plus
People Management:
Provide technical support and coaching to team members
Strong command of English Language

Role: Business Analyst REQ: 893690
Location: BANKING DOMAIN CLIENT
Cranston, RI Start Date: ASAP
End Date : 3+ months

Purpose of the role - How it adds value


Deliverables: criteria/results by which success can be measured:
The business analyst will perform the functions of gathering business
requirements, designing a solution and documenting them either
textually or within models. They will act as a liaison between
business partners and process engineers who have a business problem
and technology partners who will create the solution.

The business analyst will assist in the process innovation efforts
where an analysis of business processes at an organizational level are
needed before more detailed requirements can be specified.

Key Roles and Responsibilities:
Fact Finding and interviewing
Gathering and Understanding of detailed requirements
Conduct user interviews/JAD sessions with relevant business Units
Identify, document and facilitate if possible the resolution of
business issues
Technical documentation of process flows and business requirements



Technical Knowledge:
Must have experience in large change management programs with a focus
on process efficiency
Experience of 7 - 9 years as Business Analyst with background
supporting business problems rather than software technical
specifications
A balance of business and technical knowledge at conceptual level
Diagramming skills including data flows and flow charts
Facilitation skills including leading JAD, meetings and brainstorming
exercises
Strong communication and presentation skills with experience in
communicating at C-Level
Demonstrates a broad-based view of issues, events and activities and a
perception of their longer-term impact or wider implications
Must have strong MS PowerPoint and Visio skills
People Management:

Provide technical support and coaching to team members
Strong command of English Language



Role: Project Manager REQ: 895761
Location: BANKING DOMAIN CLIENT
Cranston, RI Start Date: ASAP
End Date : 3 months

Purpose of the role - How it adds value
The Business Change Manager key focus is on the delivery of
benefits. They will act on behalf of the Business Partner for
defining the benefits, assessing progress towards realization and
achieving measured improvements. The business change manager will work
within a Program and may cover multiple projects.

Deliverables: criteria/results by which success can be measured:
Ensuring that the interests of the sponsoring business partner are met
by the project or program.
Ensures that the scope of each project covers the aspects required to
deliver the products or services that will lead to the operational
benefits.
Ensuring that maximum improvements are made in the existing and new
business operations
Preparing the affected business areas for transition to new ways of
working
Manage and communicate clear vision of program or projects objectives
and motivate cross functional project team to achieve them
Prepares, implements, monitors and updates the project plan


Technical Knowledge:
7-10 years of working in Business Change Management ideally with
experience with business process re-engineering.
Experience in
Project experience including manage, document, report and support
planning, execution, monitor and control and closure of projects.
3 - 5 Years leading large business and technology integration projects
Demonstrates a broad-based view of issues, events and activities and a
perception of their longer-term impact or wider implications
Communication and presentation skills to various levels of management
including C-Level
Financial Services preferred.
Experience in off-shoring preferred
People Management:

Provide technical support and coaching to team members
Strong command of English Language



Role: Database Administrator REQ: 903006
Location: BANKING DOMAIN CLIENT
Bridgeport, CT Start Date: ASAP
End Date : 4+ months

Deliverables: criteria/results by which success can be measured:
The DATA WAREHOUSE CONSULTANT will lead the analysis, design, and
development of the ETL and OLAP components of our warehouse and as
needed migrate ETL from DTS/Transact-SQL to SQL 2005 SSIS and OLAP
2005. ***Emphasis in OLAP.

The warehouse consultant is expected to produce the migration plan,
and to track timelines and deliverables in accordance to plan, and
well as engage members of our BI team in design sessions, and share
knowledge with team members.
The ideal candidate will also coordinate development activities and
produce test plans as well as production migration scripts.
Produce/maintain documentation according to our life cycle
methodology.
Must be accustomed to working in a fast paced environment with
shifting priorities.


Technical Knowledge:
*3 or more years of experience planning, organizing, designing,
developing, and deploying ETL/OLAP processes for an enterprise class
data warehouses in SQL 2005 SSIS.
*Experience in designing scalable ETL streams that are sensitive to
high/changing data volumes.
*Expert in SQL Server 2000 DTS, and in SQL 2005 SSIS ETL technology
specifically.
*Working knowledge of Transact-SQL, triggers, stored procedures and
functions
*Working knowledge of SQL Server Analysis Services cubes (2000 and
2005) including design and development.
*Experienced in data warehousing methodologies and their
implementations
*Working knowledge of the full SDLC process; analysis, design,
development, testing, deployment, and support.
*Banking industry warehouse development experience is a plus.
Other Qualifications
- Excellent organizational and communication skills.
- Ability to work independently, while performing well within teams.
- Solid MS Office skills. College Degree in MIS/Comp Sciences
People Management:

Provide technical support and coaching to team members
Strong command of English Language



Role: Application Programmer Developer - OBIEE
REQ: 913334
Location: BANKING DOMAIN CLIENT
Cranston, RI Start Date: ASAP
End Date : 3 months

Purpose of the role - How it adds value


Deliverables: criteria/results by which success can be measured:
Work with the Business Analysts to understand the business
requirements.
• Assessment of functional business requirements, provide alternate
solutions, create functional and technical specifications.
•Develop, validate, test and promote BI solutions that satisfy the
business requirements
•Work closely with internal resource and a third-party vendor to
coordinate the parallel development of an Oracle BI reporting and
dashboard solution.
•Provide technical guidance to staff members.
Required Skills
•At least 6-8 years of IT experience with a minimum of 3-4 years of DW/
BI expertise
•Must have at least 2 OBIEE implementation experience in a large
organization
•Oracle database, star schema modeling + DB performance, indexing,
etc.
•Must have strong skills in logical and physical data modeling
•Significant experience developing and deploying Oracle Business
Intelligence Enterprise Edition (OBIEE) solutions
•Expertise with Oracle Dashboards, Oracle Reports
•Full life cycle BI/DW dashboard implementation experience
•Experience working with IT development staff on complex projects
•Excellent written and oral communication skills a must
•Strong technical and problem solving skills
•Must be detail oriented with the ability to multi-task in a fast-
paced environment

Technical Knowledge:
Oracle
People Management:

Provide technical support and coaching to team members
Strong command of English Language



Role: Project Manager
REQ: 918793
Location: BANKING DOMAIN CLIENT
Cranston, RI Start Date: ASAP
End Date : 6 months

Purpose of the role - How it adds value


Deliverables: criteria/results by which success can be measured:
Manage the delivery of business requirements for all interfaces
into a commercial loan origination and servicing system for a large
straight through processing implementation and conversion project.
Identify interface owners and subject matter experts. Coordinate and
schedule business requirements sessions. Act as a liaison between the
business and technical groups to execute the analysis required to
complete the interface business requirements. Identify, evaluate, and
track progress of risks, issues and dependencies, escalating them
appropriately with suggested mitigating actions and implementing as
directed. Develop project and resource plans and the use of a project
management methodology to ensure that the ongoing progress of the
interface workstream is in accordance with project goals/objectives,
budgets, and timelines. Prepare and Delivery project/program status
reports to senior management.


Technical Knowledge:
Project Manager
5 years + experience project experience and/or program level
experience.
Proven ability to plan, organize and prioritize own workloads and work
on own initiative.
Excellent organizational, interpersonal, leadership, oral and written
communication skills - ability to effectively communicate with
colleagues at all levels and across disciplines.
Strong problem identification and resolution skills.
Proficient knowledge of Microsoft Office applications MS Excel, Word,
Project and Visio skills required.
Understanding of commercial lending industry is desirable but not
essential.
People Management:

Provide technical support and coaching to team members
Strong command of English Language



Role: Business Analyst
REQ: 922626
Location: BANKING DOMAIN CLIENT
Cranston, RI
Tripps Lane, E.Prov, RI Start Date: ASAP
End Date : 3+ months

Purpose of the role - How it adds value


Deliverables: criteria/results by which success can be measured:
Ability to research and resolve complex issues
Financial Services experience
Basel II experience
SQL, DB2/UDB
Java, J2EE, perl,
Excellent communications skills

Technical Knowledge:
Business Analyst
People Management:

Provide technical support and coaching to team members
Strong command of English Language



Role: Project Manager
REQ: 922769
Location: BANKING DOMAIN CLIENT
Bridgeport, CT Start Date: ASAP
End Date : 4 months

Deliverables: criteria/results by which success can be measured:
Project Manager and Business Liaison with deep background in data
warehouse and business intelligence reporting, with demonstrated
ability to perform following tasks:
Project manage multiple projects at same time
Assess and communicate progress regularly.
Manage detailed project plans using Microsoft Project.
Lead issue definition, tracking and resolution activities.
Identify and communicate resource and development constraints and
problems to management
Organize and facilitate meetings in support of creating SDLC
deliverables. Create and distribute minutes and action items.
Coordinate, track and prioritize the activities of team members
including business analysts, data modelers, ETL developers and
reporting specialists.
Review SDLC deliverables for completeness, accuracy and depth;
facilitate the review, revision and approval process for warehouse
design and development deliverables.
Assist in business analysis and warehouse technology planning
leveraging past experience with data warehouse development.
Oversee the coordination of business SMEs and warehouse team
resources through various stages of testing, especially UAT.
Ideal candidate will demonstrate excellent written and
interpersonal communication skills, and must be a self-starter with a
drive to quickly and rigorously oversee the completion of formal SDLC
deliverables within tight timeframes. An individual who can
anticipate problems and identify solutions across the skill sets and
project stages.
Experience supporting retail financial services business analytics,
portfolio management and collections is preferred. Technical skills
in the area of information requirements, data analysis preferred.
Potential conversion to permanent position for the right individual

Technical Knowledge:
Business Analysis; Data Warehousing; MS Office; MS Project; Project
Analysis; Project Management; SQL Server

People Management:
Provide technical support and coaching to team members
Strong command of English Language



Role: Business Systems Analyst
REQ: 922927
Location: BANKING DOMAIN CLIENT
Bridgeport, CT Start Date: ASAP
End Date : 6 months

Purpose of the role - How it adds value


Deliverables: criteria/results by which success can be measured:
5-7 years of experience as a business systems analyst, preferably
with at least 1-2 years of experience with business analysis and
requirements definition for data warehouse or business intelligence
application environments. Must be able to quickly grasp and
communicate about complex business concepts and processes. Strong
knowledge of relational databases, data warehouse design concepts, and
use of SQL for database querying. Knowledge of and proven experience
in following various software development and project lifecycle
methodologies. Self-starter; able to work autonomously and anticipate
next steps. Exceptional communications skills (both written and
verbal).
College degree required. Some previous experience working with
Financial Services data warehouses is helpful but not essential.

Responsibilities:
Perform business analysis needed to drive out detailed information
requirements for business intelligence software applications.
Facilitate design meetings and requirements gathering sessions.
Document detailed data and information requirements. Create and
maintain source-to-target mapping documents for ETL development.
Create quality assurance approach documents and test cases. Perform
QA using SQL for direct querying or other reporting tools. Track
project issues and assume ownership to resolve issues related to BI
requirements and/or QA findings. Interact with other project team
members and project roles including: project manager, ETL developer,
OLAP developer, report developer and business SMEs. Provide input to
project plans and track time spent on assigned project deliverables.

Technical Knowledge:
Business Analyst; SQL; Data Mapping
People Management:

Provide technical support and coaching to team members
Strong command of English Language



Role: Tech Writer
REQ: 926658
Location: BANKING DOMAIN CLIENT
Cranston, RI
E. Prov., RI Start Date: ASAP
End Date : 3 months

Purpose of the role - How it adds value


Deliverables: criteria/results by which success can be measured:
We are looking for 1 technical writer with Visio experience to
support the Information Risk Management GLBA (Gramm Leach Bliley Act)
initiative.

Technical Knowledge:
Technical writer MS Office
People Management:

Provide technical support and coaching to team members
Strong command of English Language


Thanks Prathibha
Prathibha P Hanumanthappa
Recruiting Manager - Global Sourcing Solutions
CODESOFT International, Inc
Direct: 678-619-4748
Toll Free: 800.695.6484 X 239

Reply all
Reply to author
Forward
0 new messages