Programmer Professional Markets - Charlotte, NC

Bank of America


Location:
Charlotte, NC
Date:
08/22/2017
2017-08-222017-09-21
Job Code:
bankofamerica-17019409CharlotteNC
Bank of America
  •  
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details

Advertisement
Company Bank of America

Job Title Programmer Professional Markets - Charlotte, NC

Jobid bankofamerica-17019409CharlotteNC

Location: Charlotte, NC, 28230, USA

Description **Job Description:**



Responsible for developing, enhancing, modifying and/or maintaining applications in the Global Markets environment. Software developers design, code, test, debug and document programs as well as support activities for the corporate systems architecture. Employees work closely with business partners in defining requirements for system applications. Employees are expected to have in-depth capital markets product knowledge, and manage a high level of risk. Employees typically have in-depth knowledge of development tools and languages. Is clearly recognized as a content expert by peers. Individual contributor role. Typically requires 5-7 years of applicable experience. This job code is only to be used for associates supporting Global Markets.



This position will sit within the Global Liquidity Risk Management Technology Group within Bank of America. This position seeks to fill the need for a senior ETL developer. The individual selected for this role will be experienced in Informatica (9x/10x), Metadata Manager, Python, Oracle Exadata and possess strong SQL and data warehousing skills as well as be well versed in the SDLC lifecycle processes. The scope of ETL design and development includes but is not limited to data extraction from heterogeneous data sources, data transformation (e.g., data cleansing), database loading, and support to meet the needs of the business. Individual should have experience with various databases platforms including Netezza (primary), Oracle Exadata , Teradata and SQL Server. Strong knowledge of relational databases, Data Warehouse and business Intelligence solutions Excellent teamwork and collaboration skills. Proficient in shell scripting and performance tuning within a Unix/Linux Environment Excellent written/verbal communications skills. Ability to meet deadlines with attention to detail and accuracy. Ability to handle multiple concurrent tasks/projects according to priorities. Ability to work in a group or team environment



Responsibilities:



Demonstrates expertise in a variety of the fields concepts, practices, and procedures related to ETL/Data design and development.

Implementing solutions using Informatica PowerCenter 9x/10x (Designer/Monitor).

Develop and recommend strategies and specifications for (technical) data solutions based on the analysis of the business goals, objectives, needs, and existing data systems infrastructure.

Data Modeling and experience in developing new logical, conceptual, and physical models for data and system flows. Develop technical strategies and architectures for high-performance, scalable and complex enterprise-grade system.

Work with ETL developers, business analyst, DBAs, system administrators, to architect data model, design and implement database as well as write ETL related programs.

Work closely with the team responsible for the maintaining the data model, including data dictionary/metadata registry. Document programming problems and resolutions for future reference.

Work with Metadata Manager and business glossary to match technical data to business terms.

Work with Python and BOB scheduler to extract data from Quartz applications

Prior knowledge on SANDRA would be plus



Required Skills:



At least 7-10 years experience in a large Data Warehouse environment.

At least 7-10 years experience in Informatica PowerCenter (9x/10x), focused on utilizing push down optimization, mapplets and worklets. Experience working complex transformations including update strategies, routers, normalizers etc.

6+ years experience in Linux/Unix 3-4 years experience in databases Netezza or Teradata preferred

5+ years Unix shell scripting

2-3 years experience with scheduling tools such as Autosys, TIDAL etc Strong understanding of Data Warehouse/MDM concepts (ETL, Star Schema, slowly changing dimensions).

4+ years experience with Python and usage of the Quartz framework



**Posting Date** : 03/27/2017



**Location** : US-NC-Charlotte



**Travel** : No



**Full / Part-time** : Full time



**Hours Per Week** : 40



**Shift** : 1st shift



**Assistance for Applicants with Disabilities**



Bank of America is committed to ensuring that our online application process provides an equal employment opportunity to all job seekers, including individuals with disabilities. If you believe you need a reasonable accommodation in order to search for a job opening or to submit an application, please visit the Applicants with Disabilities page at http://careers.bankofamerica.com/us/applicants-with-disabilities .



**Diversity & Inclusion**



At Bank of America, our commitment to diversity and inclusion is helping us to create not only a great place to work, but also an environment where our employees, our customers and our communities around the world can reach their goals and connect with each other. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.



**Frequently Asked Questions**



Need to know how to apply online, view a list of your submitted job applications or reset your password? Visit our FAQ at http://careers.bankofamerica.com/us/faq section for answers to these questions and more.



Powered By