Job Description :
Sr. Data Warehouse Informatica ETL Developer
CONTRACT TO HIRE
Right to hire
Corte Madera, California
webex phone interview
Looking for a Sr. Data Warehouse Informatica ETL Developer.
Sr. Developer of Data Warehousing ETL using Informatica PowerCenter.
He is looking for an experienced Informatica ETL developer who worked on analytical data warehousing solutions.
A senior developer but also capable of design and architecting data warehouse solutions. If needed, he would prefer to go beyond the Sr. Developer title into Architect, but still need a hands-on person
JOB DESCRIPTION;
SENIOR DATA WAREHOUSE INFORMATICA ETL DEVELOPER.
The Senior Data Warehouse Informatica ETL Developer is a key, hands on role that will develop and deliver solutions that enable the collection, transformation and management of information from one or more sources.
This role will be integral in designing and developing the future Enterprise Data Warehouse and Analytics.
The candidate is expected to be able to handle end-to-end Data Warehouse and Data Integration by taking into consideration the business cases, objectives and requirements.
The technical domain of the position includes all aspects of the solution including data integration, data architecture, data modeling, information delivery, infrastructure, testing, performance tuning for all components of the project.
The ideal candidate is a well-organized team player, and possesses exceptional time management skills to support multiple overlapping initiatives in a fast-paced, ever-changing environment.
Responsibilities Live Our Values:
People, Quality, Service and Innovation Analyze data warehouse architecture and data model, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies Design, develop and maintain Informatica workflows and mappings using the appropriate data load technique, including Push-Down Optimization, for performance optimization; debug and tune data integration processes Analyzes the impact of changes on existing ETL/ELT processes and systems. Assesses the compatibility with goals in all areas. Analyzes cost effectiveness and feasibility Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural and requirement specifications Provide L2 and L3 support of nightly ETL/ELT processes to ensure timely completion and availability of data in data warehouse for reporting use. Analyzes and resolves problems and provides technical assistance as is necessary. Implements corrective actions May prepare or review product documentation, written instructions or technical literature for accuracy and completeness Data Quality management Maintenance of business rules associated with data integration Participate in the fulfillment of ad-hoc data requests from internal business owners Participate in design reviews and provide input to the design recommendations; provide input to information/data flow, understand and comply with Project Life Cycle Methodology in all planning steps
Requirements 5+ years of Data Warehousing and BI ETL design/development/implementation experience with emphasis on Informatica PowerCenter Can do attitude, with the ability to drive to success in both independent and group projects Demonstrated experience with data integration architectures, data analysis and implementation Demonstrated experience with ETL tools, including Informatica PowerCenter Demonstrated experience with Enterprise level Data Warehousing and data modeling Demonstrated experience with SQL Able to be agile in thinking and approach to solve the problem at hand Full Life Cycle Development Demonstrated experience and ability to deliver results quickly in a fast-paced environment on multiple projects Ability to work with other IT groups and business users Experience with IBM Netezza data warehouse appliance a strong plus Experience with cloud based data platform a plus Retail experience a plus
Seniority Level
Mid-Senior level