ETL developer

Location: San Francisco, CA
Job title: ETL Developer
Location: San Francisco, CA (local candidates only)
Contract position
Job description
ETL Developer responsible for responsible for supporting the Informatica footprint by developing and maintaining required ETLs. Work within an agile team structure and contribute to increase the footprint and quality of integration with other systems.
The developer will work with architects, data analysts and business analysts to review defined requirements, translate these requirements into solution design and code where applicable, and participate in the full development process life-cycle from concept through testing, implementation, and support using the Agile development methodology. This includes leveraging/improving established frameworks, code reviews, identifying approaches to creatively solve data problems, POC, data quality, bug fixing, vendor coordination, environments management, L2 support and release/change and deployment planning.
-Work with IT team to develop/maintain the ETL footprint and quality
-Participate in cross-functional meetings to review business requirements/use stories, assist in fit/gap analysis and provide detailed technical design documentation
-Profile and understand the large amounts of source data available, including structured and semi-structured/web activity data
-Work with data originators to fill in gaps in the data collected, and/or to adjust source-system data structures to facilitate analysis and integration with other company data
-Assist users with the report design, running, and troubleshooting
-Monitor and maintain system performance and provide statistical reporting
-Establish and maintain working relationships with technical and architectural team members across the technology organization
Experience & Skills
-7+ years of Informatica PowerCenter experience a must
-2+ years of MS SQL Server Database design/development or Oracle design/development
-5+ years of Data Warehousing experience
-3+ years leading Data Warehouse projects
-3+ years writing PL/SQL procedures and functions
-Experience with Banking Data
-Data Analysis skills
-3+ Years Unix/Linux scripting
-Expertise in Informatica PowerCenter, IDQ, Advanced SQL Development
-Knowledge of Tableau, Microsoft SSRS, or Oracle OBIEE
-Exposure to .NET technology stack
-Experience with Linux and Shell Script
-Ability to debug and performance tune
-Relational database design/modeling using tools such as ERstudio or ERwin
Preferred skills
-Informatica Metadata Manager and MDM Concepts
-Challenges of large relational data sets, including load performance, query performance, archiving, etc.
-Wealth or Investment management knowledge and experience
Warmest regards,
Aileen Bradley
Addastaff Consulting, Inc.
Senior Technical Recruiter
650-638-9633 x303

this job portal is powered by CATS