Ethix Solutions Incorporated is the leader in the field of information technology (IT) consulting and solutions. With a national presence in most major cities throughout North America, Ethix Solutions has the reach to deliver IT services in virtually any major metropolitan area in the US.  Ethix Solutions works with a large and select group of growth companies in numerous vertical markets ensuring our consultants have only the “cream of the crop” opportunities to choose from.

With a wealth of experience in Information Technology Recruiting, Ethix Solutions has expertise in virtually all technology disciplines. Please send your resume to resumes@ethixsolutions.net to be considered for this opportunity.

The Senior Enterprise Data Warehouse Developer is responsible for the design, development, maintenance and support of the Finance Data Mart. The developer function includes all phases of data warehousing, including requirements gathering, data warehouse design, logical modeling, data acquisition design, development, testing, and deployment, as well as documentation. 

Principal responsibilities May Include:    


• Must have experience and be comfortable engaging and working with all levels of business stakeholders


• Demonstrated understanding of concepts, best practices and functions of a data warehouse in the corporate environment
• Ability to troubleshoot and resolve performance issues with overall infrastructure


• Ability to write advanced PL/SQL programs (performance tuning, packages, triggers, exceptions, collections)


• Experience developing maintainable, high performing ETL processes

• Experience designing, implementing and supporting high performance database architectures with large volumes with the abilities to maximize performance, data integrity and recoverability


• Expertise in developing star schemas (dimensions, facts, and measures)

• Experience designing and implementing Operational Data Stores and OperMarts


• Strong proficiency for analyzing source data and creating staging designs and dimensional data models


• Experience with IDQ and First Logic Software for data cleansing
• Experience with Erwin and PowerDesigner for data modeling
• Experience working with data for shareholder accounting, fund accounting, and other industry related data
• In depth knowledge of Cognos, including framework and report design, development and implementation
• Experience with Oracle running on Linux
• Experience with high availability for Oracle (RAC) and Informatica


Competencies for Success:


• 4 year college degree in Computer Science or Engineering or equivalent experience


• 5-7 years of experience working in an Oracle, Informatica, UNIX production data warehousing environment as a Data Warehouse developer


• 5-7 years of experience of data modeling using Erwin or PowerDesigner

• 5-7 years of experience designing and implementing ETL processes using Informatica PowerCenter


• 5-7 years of experience with Oracle databases (10g or higher preferred) and expertise in SQL and PL/SQL programming and performance tuning on UNIX

• 5-7 years of experience developing UNIX shell scripts to support initiating and monitoring ETL processes

NO 3RD PARTIES

LOCAL CANDIDATES PREFERRED