Sr. Developer

1.Job title ETL DEVELOPER 2.Job summary Data Warehouse Developer will be involved in eliciting requirements, designing dimensional data models, preparing written design documents, developing extract/transform/load routines using either PL/SQL or Informatica PowerCenter performing intensive data analysis. 3.Experience 8to10yrs 4.Required Skills Technical Skills- ,Informatica Domain Skills- 5.Nice to have skills Techincal Skills- ,Informatica Cloud,Oracle Domain Skills- 6.Technology Data Management 7.Shift Day 8.Roles & Responsibilities Data Warehouse Developer will be involved in eliciting requirements, designing dimensional data models, preparing written design documents, developing extract/transform/load routines using either PL/SQL or Informatica PowerCenter performing intensive data analysis. Testing ETL and reports of others for quality assurance, and migrating releases into testing and production environments. ETL Lead with hands-on experience in designing and implementing data warehouses and data marts for large financial institutions. Experience leading a development team to implement high-quality solutions using Informatica and Business Objects and related database technology such as DB2, Oracle. Work with business and technology teams to analyze requirements, estimate, plan, and design solutions. Develop complex workflows and mappings using Informatica ETL and shell scripts to satisfy the business requirements. Develop web services for Data Warehouse and implement near real-time warehousing solutions. Will also support the Enterprise Data Warehouse batch cycle and any required changes to the schedule. Will assist the team by helping them in the data analysis requests, internal controls, performance tuning, BI requests. Lead medium sized projects, lead peer code reviews for all ETL changes. Design, Code, Test, schedule, and Implement project using Informatica/Oracle ETL. Interact with users to identify their requirements and deliver results appropriately. Debug and troubleshoot production issues. Demonstrated requirements elicitation and analysis experience. Demonstrated strong problem-solving abilities and multitasking capabilities. Ability to perform well in high pressure, time-sensitive environments, strong verbal and written communication skills. Demonstrated ability to understand and document business processes. Strong organizational skills. 10-12+ years experience performing the following: Full system development life cycle (SDLC) experience Technical team leader experience Strong 9.Job Location Primary: USCAMNYC01-Monterey Park (LA)-CA USA, CLT Alternate: - , - 10.Job Type 60CW00 Business Associate 11.Demand Requires Travel? N 12.Certification(s) Required NA Additional Sills: Skills: Category Name Required Importance Experience No items to display. 3B Staffing LLC