Data Architect /Modeler Level III - (Ref Code :103112-IO42-KATFOR)
Long Term Contract
Washington DC
Visa type: Any
Please use the same subject line with reference code while submitting
profiles
Do sent profiles to
careers@iormyx.com
The candidate should have combined business analysis and OLAP/Relational
Database technical background, a proven record of accomplishment, and a
minimum 7 years of workplace experience.
The candidate should have an understanding of the development and
documentation of user requirements. The candidate should have strong oral
and written communication skills.
The candidate should have an excellent understanding of designing and
developing of Data Warehouse applications on Oracle platform. The candidate
will also potentially carry out development in a relational database/data
warehouse environment; therefore, he or she should have a background in
designing tables and views in relational databases and be able to use PL/SQL
proficiently. Experience with Informatica ETL is a must.
General Requirements:
In-depth theoretical understanding with regards to data warehousing
architecture and methodology
Min. 7 years of hands-on data warehousing expertise covering all aspects of
software project life-cycle, i.e. business and data modeling, data analysis,
system design, development, etc.
Experience in working with the large-scale (100+ entities) relational data
models
Must have prior experience in leading development teams
Thorough understanding of relational and dimensional data modeling
techniques
Min. 6 years of hands-on expertise with Oracle databases, especially 9i/10g
Strong knowledge of SQL, PL/SQL, performance tuning techniques for working
with the large volume tables
Familiarity with data modeling tolls such as ERWIN (3.5 and 4.1)
Familiarity with various process modeling techniques (activity hierarchy
diagrams, data flow diagrams, sequence diagrams, workflow diagrams, system
interface diagrams)
Excellent communication and facilitation skills
The candidate must demonstrate knowledge of data warehouse implementation
process, from business requirements through logical modeling, physical
database design, data sourcing and data transformation, data loading, SQL,
end-user tools, database and SQL performance tuning.
Identify business and functional requirements, and actively participate in
the requirements, design and build phases; delivering high quality
deliverables
Provide overall support to ensure the successful planning, design, testing
and implementation of Business Intelligence applications.
Team with and collaborate with IT professionals to determine if solutions
currently exist (internally or externally) or whether new solutions are
feasible to meet business requirements and to ensure consistency among
related workflows.
Masters degree, majoring in Engineering/Computer Science/Information
Systems/Finance, specialized training or equivalent work experience with a
minimum of > 8 years relevant technical and business work experience
At least 8 years of experience in defining and implementing technology
solutions for large scale enterprise application systems, preferably from a
major financial institution, asset manager, or Wall Street bank
At least 8 years of experience in analysis, design, development, and
deployment of large scale enterprise application systems
Extensive experience in documenting technical design, developing functional
specifications, and defining data models (logical and physical)
Good knowledge and experience with Financial industries complement a high
level proficiency in DBMS Technologies, Data Extraction and Integration
Strategies (ETL and ELT), and Data Warehouse Modeling using traditional and
hybrid Methodologies.
>6 years Oracle PL/SQL development experience
>6 years Unix scripting
>3 implementations of large multi subject data warehouses at Fortune 500
companies
Familiarity with Cognos a plus
Familiarity with Sybase development environment