Senior ETL Data Analyst

1) Translates data requirements into applications that employ appropriate data models and ETL solutions. Analyzes, defines, develops, and maintains complex database structures and ETL architectures and applications. Creates data flows and ETL models defining the data transformation needs of projects. Ensures effective and efficient utilization of ETL processes when accessing, integrating, and delivering data between systems.
2) Develops and implements data validation, auditing, reconciliation, testing methodologies, and integration processes. Coordinates with business/data analysts on data cleansing and data profiling activities to improve quality of data.
3) Works closely with DBA Team and Operations to establish ETL job workflow with reliable error/exception handling and rollback framework, including scheduling, error management, restartability, email notifications, and information publishing.

Required Education and Work Experience:

Bachelors or Master s degree in Computer Science, Information Systems, or related field. Or equivalent work experience that includes knowledge of Data Warehousing, Data Integration, Data Transfer methodologies, and Database Management.

Five or more years of experience using Informatica tools such as Power Center, Data Quality and Metadata management in a bank or financial institution working with IT staff and business units to complete complex system design, development, and implementation of ETL solutions.

Prefer at least three years of experience in Data Modeling, or Data Integration, including experience using relational, star-schema, and multidimensional data models. Knowledge of current practices, theories, and approaches to performance tuning and optimization, collection of metadata, table partitioning, materialized views, and parallel processing. Proficiency in PL/SQL, SQL, and UNIX scripting.

Prefer three or more years of experience as ETL Architect/Designer, including experience installing and configuring database and ETL software. Advanced-level experience in designing, developing, and maintaining data transfer maps and processes and database structures, including measure, dimension, and hierarchy objects. Ability to analyze and interpret financial information and data to implement business/transformation rules, data profiling, data cleansing, and reconciliation processes to ensure data quality.

Knowledge of operating systems hardware and software, relational databases, and software development tools including but not limited to Linux, Windows, Oracle, SQL-Server, Erwin, MS-Access, and MS-Excel.

Strong interpersonal, communication, and writing skills; able to work independently or in a team environment.
Experience with Agile methodologies to effectively participate in cross functional teams.