Job Description: The Data Warehouse Developer is responsible for developing
and maintaining all data warehouse and Business Intelligence (BI) Systems. The
position requires expertise in Data Warehousing methodologies, database design,
database administration, application development and business intelligence.
Preferred Qualification: Experience with development
processes and production release management; application and database tuning
and interdependencies on operating system configuration is highly desired;
Expertise in Data Warehouse methodologies and warehousing tools; Experience in
real time/near real time data warehousing.
Skills and Abilities: The ETL Developer require at
least 7-8 yrs of experience and will be responsible for developing and
maintaining all ETL tasks. The position requires expertise in Data Integration
and ETL methodologies, database design, and database development. Informatica
ETL tool will be preferred.
A minimum of five years hands-on experience working with database
and ETL technologies and architectures; including both logical and physical
designs, data mart creation, ETL tools, loaders and development and reporting
tools is required. This experience should include influencing global data
architecture directions and defining major data architecture related technology
standards; experience writing Oracle stored procedures and packages,A minimum
of two years hands-on experience in various data definition and modeling
projects and demonstrated capabilities in carrying best practices and common
objects/components to other projects is required.
Analyzes and revises data and information centric initiatives
including database structure, ETL processes, and external data interfaces,
Develop and maintain ETL maps based on the design documentation provided,
Develop and maintain workflows based on the design documentation provided;
Develop Program Units (such as Stored Procedures, Packages) required for the
ETL process.
Strong expertise in database
design and database development, Data Integration and ETL methodologies and
concepts, Data Integration tool or ETL tool, Development processes and
production release management; application and database tuning and interdependencies
on operating system configuration is highly desired. Analyzes and revises data and information
centric initiatives including data warehouse structure, ETL processes, and
external data interfaces. evaluation and recommendation of software tools,
definition of hardware requirements, and system configuration. Deliver
reporting models that define relationships between tables in the data warehouse
and simplify the report development process. Interact with the other
departments to understand and identify data needs and requirements and work
with other members of the IT organization to deliver warehouse and reporting
solutions to address those needs. Interact with data analysts in IT and other
departments to understand the documentation and training requirements needed to
efficiently utilize the BI infrastructure including the development and
maintenance of an enterprise metadata repository. Provide second level support
of production BI environments. Perform design and code reviews for data
warehouse developers, report developers, and data analysts. Monitor performance
of all warehouse and reporting systems; provide ongoing performance tuning,
review logs, clean temp files and all other administrative issues required to
ensure applications and databases are performing efficiently.
Send Your Updated CV deen@iitcompany.com
