BI/ETL/Database Developer

As a BI/ETL/Database Developer, you will be responsible for the design and development of Enterprise Data Warehouse (EDW), Data Mart (DM), and Business Intelligence Reporting environments. for consideration, contact ken.spero@rht.com Job Requirements Responsibilities of the BI/ETL/Database Developer include: This role will be responsible to work on internal, external various data sources and system and integration of those systems with company application. He/She will work closely with business users to design and implement reporting and analytical solutions, including the design and development of table structures and the processes used to populate those structures with data from internal and external sources. He/She has to develop ETL processes using SQL, SSIS, with consideration to fault-tolerance, error logging, auditing and data quality. Create data integration and technical solutions around Microsoft SQL Server, Informatica and various other ETL Tools. Data modeling and requirements analysis. Prepare storage logical and physical models based on requirements Create end-to-end analytics and reporting solutions. Primary Success Measurements: Ability to work independently with minimum supervision. Ability to understand business requirements and providing solution in timely manner. Quality, clarity, accuracy and timeliness for Software Development and Data. Uptime / availability of the system. Time from Software development to implementation. Active participation in a group and being a team player. Education and/or Experience: Bachelor's degree in Computer Science, Engineering, or equivalent education Minimum 7 - 10 years of experience with database and ETL development. 5+ years of SSIS, SSRS, SSAS 3-4 years of experience with Informatica ETL tool. Familiar with Microsoft Office Suite of products and with Structured Query Language (SQL). Demonstrated ability to write transact-SQL / PL-SQL queries Extensive experience with database extraction and be comfortable with a tool such as Informatica or a similar BI/ ETL product. Should have worked in complex Oracle platforms involving optimization. Experience with Cloud computing concepts (private, public and hybrid) a plus Experience working with reporting tools like Power Bi, Qlik Sense, Tableau Excellent written and verbal communication skills Superior presentation skills Knowledge and/or Skills: Strong in Unix shell scripting. Expertise in developing complex Stored Procedures, Functions, Packages. Strong knowledge of performance tuning, query plan / explain plan analysis, indexing, table partitioning. Expert in Data Architecture, Modeling, and any Modeling Tool. Experienced in Enterprise Data Management and ETL. Ability to create and manage sophisticated SSIS packages that import and validate data from various other SQL databases, flat files, and feeds (e.g. JSON, XML). Validate ETL jobs against business use cases. Develop and deploy all post-production enhancements. Should have a familiarity with OLAP cubes Ability to prioritize, perform multiple tasks and be a team player

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Sr Manager, Engineering Capability Development
East Hanover, NJ Mondelez International
Team Member Development Manager
Florham Park, NJ Life Time Fitness
Team Member Development Manager
Berkeley Heights, NJ Life Time Fitness
Senior Business Development Manager, State and...
Princeton, NJ eSystems, Inc.
Technical Recruiter - Business Development
Paramus, NJ Brains Workgroup, Inc.
Senior Oracle Database Programmer - phone & in...