Data Architect

Randstad; Charlotte (NC); On-site; USD 120,000 - 150,000; Full time

Job summary

A prominent staffing firm is seeking a seasoned Data Architect for a 12-month position in Charlotte, NC. The ideal candidate will possess over 10 years of experience in data warehousing, specifically with skills in Informatica and Oracle Exadata. Responsibilities include designing ETL solutions, collaborating with teams, and developing data models. Strong scripting knowledge, particularly in Python, is essential. This is a valuable role requiring expertise in complex data architecture and data management.

Qualifications

• 10+ years experience in a large Data Warehouse environment.
• 10+ years experience in Oracle/Teradata/Netezza.
• 8+ years experience in complex data architecture solutions.
• 8+ years in various scripting languages preferably Python.
• 8+ years experience in Informatica PowerCenter (9x/10x).

Responsibilities

• Design and implement solutions using SQL on Oracle Exadata and Informatica.
• Develop strategies and specifications for technical data solutions.
• Document programming problems and resolutions for future reference.
• Work closely with team on maintaining data model and metadata.

Skills

Informatica (9x/10x)

Oracle Exadata

Data modeling

Shell scripting

Performance tuning

Python

ETL/Data design

Collaboration skills

Tools

MS SQL Server

Teradata

Netezza

Job description

Job Title

Data Architect

Duration

12 Months

Location

Charlotte, NC

Job Description

This role will interface directly with Corporate Treasury Data Management, Global Liquidity Risk Management business teams as well as work across other business and technology partners to ensure appropriate delivery of technology solutions. The individual selected for this role will be experienced in Informatica (9x/10x) and possess strong Oracle Exadata 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 Oracle Exadata (primary), MS SQL Server, Teradata and Netezza. 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.

Essential Functions

• Demonstrates expertise in a variety of the fields concepts, practices, and procedures related to ETL/Data design, architecture and development.
• Design and implement solutions using SQL on Oracle Exadata and Informatica (9x/10x).
• 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/ELT 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 other scripting languages.

Experience

• 10+ years experience in a large Data Warehouse environment.
• 10+ years experience in Oracle/Teradata/Netezza.
• 8+ years experience in complex data architecture solutions comprising the various phases of planning, design and implementation.
• 8+ years in various scripting languages preferably Python.
• 8 + years experience in Informatica PowerCenter (9x/10x). Experience working complex transformations including update strategies, routers, normalizers etc.
• 4 -5 years experience with scheduling tools such as Autosys, TIDAL etc. Strong understanding of Data Warehouse/MDM concepts (ETL, Star Schema, slowly changing dimensions).

Note

If you feel this job description does not suit your profile then kindly let me know your preferred job roles so that I can be in touch with you with similar jobs and you can refer me a suitable person for this job as well. Hope to hear from you soon.

Additional Information

All your information will be kept confidential according to EEO guidelines.