Company Description
Company Description
ekSource Technologies is committed to providing value through the effective use of technology. ekSource excels in putting together teams with strong functional knowledge and technical expertise. ekSource partners with leaders in the industry to fully harness their potential and bring the right solutions for your Business.
Job Description
We are looking for Senior ETL Consultants - SSIS Informatica SQL Server Cognos for our direct client, is a global leader in providing information, analytical and marketing services to organizations and consumers to help manage the risk and reward of commercial and financial decisions.
Location: Irvine, CA
Duration: 6 months extendable
Type: Corp-Corp, 1099
Job Description:
Data Warehouse ETL developer is responsible for ETL development using Informatica in Microsoft SQL Server environment and all aspects of data warehouse reporting.
• Work as part of a team to deliver federated dimensional model for growing online consumer subscription service.
• Play key role in adding data to the Data Warehouse through development of source to targets maps and transformation rules.
• Participate in requirement definition, solution development and implementation phases of data warehouse and reporting projects
• Informatica ETL and Cognos FM, cube, and report development.
• Create and maintain ETL specifications and process documentation to produce the required data deliverables (data profiling, source to target maps, ETL flows).
• Assist in definition of logical and physical data models B2C ecommerce business.
• Configure and tune ETL infrastructure to optimize the data warehousing architecture, Troubleshoot and resolve data, system issues and performance issues.
• Champion and manage new initiatives to completion to improve and streamline operations processes and maximize systems efficiency
Qualifications
Skills Required:
• Senior ETL resource with expertise in Informatica and dimensional modeling.
• Experience with business intelligence or reporting tools (preferably Cognos BI tools: Framework Manager, Power Play, ReportNet, Metric Studio).
• SQL Server – SSIS, SQL queries and stored procedures.
• Extensive experience with data warehouse concepts and methodologies.
• Experience with database design & modeling.
• Must have working experience in ecommerce industry and web analytics
• Good written and oral communication skills; excellent technical skills.
• Highly motivated self-starter, detail and quality oriented and able to work independently
• Experience with data modeling tool (ER/Studio)
Additional Information
Please send your profile at sam@eksource.com or call Sameer at 703-595-4177 Extn: 107
We look forward to receiving your application!
All your information will be kept confidential according to EEO guidelines.
Location: Irvine, CA
Posted: Nov. 6, 2024, 10:12 p.m.
Apply Now Company Website