Previous Job
ETL Developer
Ref No.: 17-27183
Location: Los Angeles, California
Required Skills :

Basic Qualifications :
Informatica, Oracle, and SQL

Job Description :
Client: Large Financial Institution in Southern California
Location: Remote
Type: Contract
Position: ETL Developer

Basic Qualifications:
*Minimum 5 years' experience as a business or data/programmer analyst required.
*Minimum 5 years' experience programming in a financial setting, preferably in a brokerage or wealth management line of business using ETL and reporting tools from Microsoft, Informatica or SAP.
Skills and Knowledge:
ETL Technologies
Responsible for coding, testing, debugging and implementing Extract, Transform, Load (ETL) mappings and workflows using Informatica, SAP or Microsoft tools.
Reviews business requirements and ensures the ETL design meets the goals.
Participates in implementing data policy.
Understands and translate business needs and data models into supporting long-term ETL solutions.
Data migration experience.
Ensures data quality in the data warehouse by enforcing data integrity rules
Analyze data-related system integration challenges and propose appropriate solutions
Tracks industry trends and maintains knowledge of new technologies to better serve the organization's information needs
Assists in developing long-term strategy for data integration with other parts of Business Intelligence and data management areas to meet Wealth Management requirements.
Database Management and Reporting
Knowledge of data warehouse concepts using either Oracle or MS SQL server DBMS.
Advanced SQL skills including development of SQL statements and stored procedures.
Logical database design skills.
Familiarity with end user reporting tools (i.e. Business Objects, SSRS, Tableau, etc.)
Familiarity with industry tools (Toad, Erwin, etc.)
Work well with a variety of teams and organizations to provide responsive and quality support.
Strong verbal and written communication skills, with an ability to express complex technical concepts in business terms.
Ability to work on multiple, concurrent projects in a matrixed personnel environment using Agile methodologies.
Work within formal Change Management methodologies.
Wealth Management industry or financial services industry experience is strongly preferred.