Application Architect V/ ETL Developer - Data Warehouse Specialist - Analysts Charlotte , North[...]
Charlotte, NC, United States
**Application Architect V/ ETL Developer - Data Warehouse Specialist**
Charlotte, North Carolina Contract Added - 9 hours ago **Location**
Application Architect V/ ETL Developer - Data Warehouse Specialist **Job Description**
**Location: Charlotte, NC**
**Duration: 12+ Months Contract** **Hi,**
**My Name is Sachin and I'm a Technical Recruiter working at Data Inc. We have an immediate need for a long term consulting assignment with our Direct Banking Client in Charlotte, North Carolina. If you are looking for a new opportunity, please share your updated resume at [email protected] OR 585.625.4143**
**Job Title: ETL Developer**
**Job Description:**
Position Summary
The candidate for the Backend/ETL developer position will be responsible for designing and developing batch/ETL interfaces using the proprietary meta data driven approach as part of the LIBRA Interface Team.
The candidate will be responsible for maintenance and support of the existing interface processes including investigation of issues and production troubleshooting.
Candidate will be responsible for maintaining the data lineage to facilitate the end-to-end traceability as and when changes to the ETL. In addition, candidate will responsible for Liquidity report specific derivations.
**Required Skills
Extensive experience with Oracle/Exadata SQL, PL/SQL and perform application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE and AWR Reports. Should have a clear understanding of Oracle Server Process Architecture and memory structures PGA (Program Global Areas) & SGA (System Global Areas) to optimize memory usage.
Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads etc. and that maximizes re-usable components and services that incorporate versioning, reconciliation and exception handling
Experience in Unix/Linux shell scripting and/or Perl Scripting. Knowledge of python is desirable.**
Implementation experience with monitoring and measurement of data quality using business rules. Hands on experience hands with data quality assessment and resolution desirable.
Maintain metadata, data glossary and data catalog processes. Ensure adherence to data security by using data encryption procedures and protocols.
Ability to work in fast paced environment
Experience in Financial Industry with some risk background.
Knowledge of Agile methodology is desirable
Knowledge of Liquidity Reports like Fed5g, LCR, NSFR, CRD IV etc is a plus
Knowledge of Tableau is desirable
**Thanks & Regards,**
**SACHIN** **MISHRA**
at Data Inc.
**A:**
510 Thornall Street, Suite 370, Edison, NJ 08837
**P:**
#J-18808-Ljbffr