Duration: 6 + Months
Position Overview:
Client is seeking a Data Warehouse ETL Developer to add to our Warehouse/BI group.
This person will work closely with our Business Analysts, Data Modeler and Report Developers in the design, development and implementation of our warehouse and business intelligence solutions.
Requirements:
Ø Understanding of Data Modeling techniques and best practices
Ø In-depth knowledge of relational data model and dimensional data model
Ø Must have strong Oracle PL/SQL and T-SQL programming skills
Ø Data warehousing, Oracle 10g/11g and MS SQL Server 2000/2005 experiences are required
Ø Excellent communication skills
Ø Experience with Hyperion 9 is a plus (not required)
Essential Functions:
Ø Working with Business Analysts and Data Modeler to understand the business requirements and data models
Ø Developing the ETL processes from the data sources to data warehouse staging and reporting database
Ø Serving as the primary FedACH Data Warehouse ETL developer, this person will work closely with Business Analysts, Report developer and Data Warehouse architect for data extracting, data cleansing, transformation and aggregation (loading) based on the data model for data warehouse systems
Ø Providing technical ETL estimates and task breakdown
Ø Participating in peer code reviews and provide support to QA/Prod during the test/migration process
Ø Support architecture efforts by following and adhering to the standards set forth by the FedACH Information Architecture group and maintain the integrity of application architecture
Ø Maintain data integration, data distribution, data performance and correct issues as they arise
Ø Provide mentoring and knowledge transfer of PL/SQL and T-SQL skills to existing staff
Education:
Ø BS in Computer Science or equivalent experience
Experience:
Ø Knowledge of relational database and dimensional modeling theory
Ø Experienced in Oracle 10g/11g and SQL Server 2000/2005 include MS SQL Server 2000/2005 Analysis Services (OLAP)
Ø Experience with MS Windows platforms and UNIX Operating System
Ø 5+ years experience in application development working with complex databases such as Oracle and MS SQL Server
Ø 5+ years experience with Oracle PL/SQL programming
Ø 2+ years experience with T-SQL programming
With Regards,
Viveka
Technical Resource Specialist
RAMY Infotech Inc.
39120#157, Argonaut Way, Fremont, CA 94538
Phone: 408- 317-9256 Ext :324 | Email: | viveka.pandita@ramyinfotech.com
Fax: 408-273-6834| www.ramyinfotech.com |
In My Absence please contact Rajat Nanda at 408-419-1749 Ext: 307 | rajat.nanda@ramyinfotech.com
Disclaimer: "Under Bill s. 1618 Title III passed by the 105th U.S. Congress this mail cannot be considered spam as long as we include a way to be removed from our mailing list. Simply send us an e-mail at remove@ramyinfotech.com and we will gladly REMOVE you from our mailing list."
No comments:
Post a Comment