This Oracle Data Warehouse Software Engineer role involves the following responsibilities:
Lead and participate in gathering business requirements, analysis of source systems, define underlying data sources and transformation requirements, design suitable data models, and develop Metadata for Data Warehouse / Analytical Reporting
Prepare technical design specifications; develop routines for data extraction and loading
Provide technical/user documentation and training
Perform peer reviews of work items produced at various stages of the project
Effectively communicate with various teams and stakeholders, escalate technical and managerial issues at the right time and resolve conflicts
Demonstrate passion for quality and productivity by use of efficient development techniques, standards and guidelines
Analyze and determine the impact of technology capabilities and limitations
Translate high level design to detailed design specifications
Develop, test and deploy code/application in various environments
Perform effort estimation for various Data Warehouse activities
Meet project deliverables as per requirements, on time within budgets
This is a highly technical role in requiring critical thinking, hands on Oracle PL/SQL and SQL development, and attention to detail from analysis through implementation and post-production.
Strong Computer science background
Bachelor's degree or higher in computer science
Minimum of 5-10+ years of industry experience
5+ years in working with large data sets and analyzing data to identify patterns
5+ years in heavy PL/SQL or SQL coding for large data warehousing projects with at least 5 years of full life cycle experience in implementation and support of Data Warehouse Solutions on Oracle Platforms
Extensive knowledge in ETL, OLAP, Oracle 9i/10g/11g and SQL and PL/SQL
Extensive knowledge in Data warehouse designing techniques like Star Schema/Snowflake
Extensive design and coding skills in Perl, Shell Script, XML on Unix Platforms
Knowledge of tuning and scaling in a Data warehouse environment is highly desired
Hands-on experience with Pentaho a plus.
Very good technical expertise and strong business skills, as this person will lead the team in delivering Business Intelligence solutions
Aware of testing process and Data Ware
Strong customer focus, ownership, urgency and drive
Excellent communication skills and the ability to work well in a team
Effective analytical, troubleshooting and problem-solving skills
Experience in Erwin Data modeling and Data Quality tool
Cequint provides competitive salaries, DOE, full benefits spread, 401k, discount health-club membership, and a host of other benefits.
Transaction Network Services - 20 months ago
TNS, Inc. (TNS) is an international data communications company, which provides networking, data communications and value-added services to...