Job Description :
Role: BI DEVELOPER WITH QLIKVIEW AND DATAWAREHOUSE DEVELOPER
Location: New York NY
Duration: 1 year contract
Local candidates first. They will consider skype for great candidates
Notes:
* Must be able to pass a credit, criminal and drug test. will be
asked to go for fingerprinting
* BI developer with Qlikview and datawarehouse developer (built by
Anna''s hexaware team)
* build lots of reports
* maintenance of ODI 12c
* on top of DWH, build reports on top of it
* This req is officially not out but the manager has the budget
approved.
Below is the JD that we had in the past when we hired a consultant against
this req. The manager gave us a brief overview above but I am including
what we had in the past below.
DESCRIPTION
ODI ETL Developer for Compliance Systems Division primarily
responsible for analyzing, validating and manage requirements, flows and
adapting strategic business needs and functional processes into horizontally
integrated data management solutions in line with the Firm''s overall Data
Governance strategy.
ODI (ETL) developer will own the technical understanding of
the existing and future database schema and related programs used across all
products and business lines. Project data deliverables include gathering of
data requirements, data flow diagrams, data sourcing plans, data
privacy/security architecture, data integration specifications, design,
development, testing, status updates and implementation.
The individual will work with business and IT groups to
design a data integration workflow design that provides for the extracting,
loading and transforming of data, primarily for compliance reporting and
analytics using Oracle ODI. The Developer must be capable of working in a
collaborative environment to support rapid development and delivery of
highly demanding projects.
Responsibilities:
* Designing ETL interfaces and packages from several data sources
* Dimensions, Hierarchies, Fact Tables
* Experience with Oracle ODI
* Development, ETL designs, datastores, etc.
* Strong understanding of relational databases and Data warehousing
concepts
* Strong PL/SQL knowledge
* Nightly refresh of data load plans
* Hands on experience with Unix/Linux
* Experience with requirements gathering process with Business
Analysts and Users
* Experience working on troubleshooting and performance tuning of ETL
interfaces
* Experience creating data validation test cases, etc.
* Experience with Star and Snowflake schemas
* Draw out, analyze, validate and manage requirements, flows and
deliverables for projects.
* Ensure functionality of product meets with business requirements and
expectations.
Key Skills:
* Ability to independently manage, organize and prioritize multiple
tasks and responsibilities.
* Very Strong understanding of SDLC
* Strong understanding of job Schedulers like Autosys
* Strong SQL skills across various databases including Oracle, SQL
Server and DB2.
* Database: ORACLE, SQL Server, DB2
* Knowledge of database analysis tools like TOAD, SQL Developer, etc.
* Strong organizational, analytical and design skills.
* Excellent oral and written communication skills.
Qualifications:
* Proven experience in data analysis, designing and development of ETL
* Demonstrated experience with IT requirements development; systems
design, and integration
* Expert analytical skills. Able to critically evaluate the
information gathered from multiple sources, decompose high-level information
into details, abstract up from low-level information to a more general
understanding, and distinguish solution ideas from requirements.
* A self-starter can manage multiple responsibilities without close
supervision.
* A team player and work independently.
* Experience working with a Global team.
Experience and Education:
* Bachelors'' degree in computer science or other engineering
discipline.
* At least 5 years of experience in ODI ETL development.