Job Description :
ETL Developer 4
Duration: 6 Months
Location: San Ramon

Summary:

Bank of the West is seeking a ETL Developer to be responsible for managing data availability, integration, transformation, and delivery to the data mart.
Develops and implements comprehensive data integration processes, standardizes the presentation of information derived from multiple subledger
transaction systems, and develops data sources necessary to support financial reporting needs.

Job Responsibilities:

*Design, implement, automate and maintain large scale enterprise data ETL processes.
*Extracts structured and unstructured data from source systems, transforming it to fit business performance management needs, and loading it into a data mart.
*Ensures ETL process is developed in modular fashion in shared folders and reusable objects to enforce consistency timely development.
*Reviews ETL production design for performance optimization.
*Collaborates with business functional leaders by analyzing and evaluating business requirements; diagnose the design, propose/design alternatives and recommendations.
*Plans and coordinates the implementation of new data requirements
*Oversees the data load production process and the implementation of new data load files in accordance with the department?s change management process
*Resolves issues through troubleshooting and quick diagnoses.
*Ensures data quality by designing and implementing adequate internal controls and monitoring processes.
*Includes controls to identify individual ETL flows that are performance issues.
*Ensures controls are maintained when designing new structures by utilizing object naming conventions to encourage consistent development and ease of
migration from development to test to production.
*Works closely with Information Technology staff through the phases of coding and implementation of external data source files providing clarifications as necessary.
Maintains effective ongoing communications with the business and IT community and operational management regarding system plans, projects, budgets, expenditures and policies.
*Participates in the research and resolution of enterprise data governance issues.

Qualifications:

*Bachelor''s degree in a technical field such as computer science, computer engineering or related field required
*8-10 years experience required
*Experience in providing technical support, covering database administration and operations to include monitoring maintenance capacity, performance
monitoring/planning and incident/problem troubleshooting and resolution
*Strong knowledge of SQL.
*Expert knowledge of relational databases, flat files and non-relational database structures.
*Expert knowledge of Help Desk tools and trouble ticket tracking processes.
*Expert knowledge of support agreements and their implied service levels.
*Proven ability to write excellent technical documentation.

Additional Job Details:

ETL Developer Qualified and motivated candidate to be responsible for proper ETL development, standards and best practices, collaborating with existing ETL resources to set cutting edge industry standards.

Essential Functions
Manages development and testing tasks and ensuring adherence to previously agreed to timelines communicating status;
Evaluates the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies;
Counsels team members on the evaluation of data using the Informatica Data Quality (IDQ) toolkit. Applies data analysis, data cleansing, data matching, exception handling,
and reporting and monitoring capabilities of IDQ;
Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members;
Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc.;
Implements data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets. Skills
Bachelor’s Degree in Computer Science or related field required;
experience at Enterprise-level ETL development and ETL architecture using Informatica and understanding the COBOL file structures;
Strong Oracle Database technical knowledge in the areas of general SQL and PL/SQL;
Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer,
Transformation Developer, Workflow Manager and Workflow Monitor;
Good knowledge of analytical and logical conceptual level programming skills;
Good knowledge of Erwin model generation tools (logical and physical);
Data analysis, data mapping, data loading, and data validation;
Understand reusability, parameterization, workflow design, etc.;
Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions;
Should have thorough understanding of Entire life cycle of Software and various Software Engineering Methodologies;
Performance tuning and end-to-end lifecycle experience with Enterprise wide data warehouse. Required Experience
7 – 10 years of experience at Enterprise-level ETL development and ETL architecture using Informatica and understanding the COBOL file structures;
3+ years in banking and financial services is preferred
3+ years of experience deploying large scale projects using Informatica Tools


Client : Bank of the West

             

Similar Jobs you may be interested in ..