Hi
Greetings,
This is Rajesh from Supreme soft Corp. We have an urgent requirement for the following. If you are available for this, please send your latest resume to rajeshk.s@supremesoft.net If you have any quires call me on 703-254-5464 Ext: 120
Position: ETL Developer
Location: Baltimore/Columbia – MD
Duration: 6 months CTH
Type of Interview : Telephonic + F2F (So near by states Consultants preferred)
This is a temp to perm job and client is looking for EAD, GC or citizens who can go full time with them after 6 months.
We are currently supporting an international educational organization with their Data Warehouse initiative and are seeking two ETL Developers to support this mission critical project.
DUTIES AND RESPONSIBILITIES
• Develop and implement the business logic and the ETL mechanism to populate the dimensional structure. Program ETL tool with business rules to be applied to data from source input to target data repository, automating data extraction/load programs to run on regular schedule.
• Assist in development of EDW architecture including the design, development and implementation of the physical data model and reporting and data structures including Cubes, Star schemas and Operational Data Stores.
• Develop database objects, stored procedures and packages, views, tables, and triggers as needed
• Assist in developing detailed business and technical specifications based on project requirements and in converting business and technical specifications into data extraction/load programs.
• Develop and assist in implementing system and unit test programs ensuring correct application of transformation logic from source to target. Develop and implement automated test scripts to ensure that source system data is accurately represented in the final reporting objects of the Data Warehouse.
• Work with other application developers and computer operations to support test, QA and production reporting environments including daily administration, batch processing, configuration management, environment migration, and tool automation
• Document all phases of work including gathering requirements, joint relationship diagrams, database diagrams and other program technical specifications using current specified design standards for new or revised solution.
SKILLS REQUIRED
• Minimum 5 years ETL development and Data Warehousing experience including SQL Server Integration Services (SSIS) and/or other tools such as Informatica, Ascential, and Oracle Warehouse Builder
• Experience implementing ETL processes in a production data warehouse, relational and multi-dimensional data modeling, including the use of standard data modeling tools, preferably Erwin
• 3 + Technical ETL experience with SQL Server 2005 and Oracle databases writing queries, scripts, stored procedures, triggers, and views. Experience developing stored procedures with T-SQL.
• Sound understanding of BI Best Practices/Methodologies, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques
• Experience in business requirements gathering
• Experience using data cleansing, data quality tools
• Experience implementing technical solutions under tight time, quality, and performance standards.
--
Thanks & Regards.
Rajesh
Supreme soft Corporation
Office : 703-254-5464 Ext: 120
Fax :(800) 507-5275
rajeshk.s@supremesoft.net
www.supremesoft.net
No comments:
Post a Comment