Design and implement enterprise data architecture and ETL solutions using Informatica and Oracle Exadata. Develop data models, data integration pipelines, and performance-tuned SQL. Collaborate with business and technical teams, maintain metadata and data dictionaries, and ensure scalable, high-performance data warehouse solutions.
Job Description
Hi,
This is Raju. I am Recruiter at Randstad Technologies and I am reaching out in regards to your background. I have an exciting opportunity
*Candidates MUST be able to work on W2 to qualify for this role.*
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:
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 InformationJob 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
- 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.
All your information will be kept confidential according to EEO guidelines.
Similar Jobs
Other • Consulting
Designs and develops scalable data platforms and architectures using Azure or AWS. Translates business objectives into technical solutions, supports data warehousing, business intelligence, master and reference data management, and develops data-as-a-service capabilities. Leads client initiatives, establishes architectural governance, creates system diagrams, analyzes business processes, advises on emerging technologies, and mentors junior data professionals. The role involves significant client interaction and 30–50% travel, with remote work from a home office when not traveling.
Top Skills:
AWSAzureAzure Data CatalogAzure Service FabricAzure SqlBusiness IntelligenceCloud Data PlatformsData Lake PlatformsData WarehousingItilMaster Data ManagementMicroservicesReference Data ManagementRest ApisSdlcTogaf
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Lead enterprise data architecture across warehouses, data lakes, downstream applications, and AI workloads. Design data models, Medallion Architecture, ELT standards, semantic layers, APIs, access controls, and reusable datasets. Partner with business and BI teams to drive adoption, conduct architecture reviews, establish platform standards, and mentor data and analytics engineers. The role requires deep Snowflake, dbt, data modeling, pipeline, and semantic-layer expertise, with experience in AI data patterns and cloud infrastructure preferred.
Top Skills:
AWSAzureDatabricksDbtDelta LakeGCPGraphQLLlmsPower BIRagRestSnowflakeSnowflake Unity CatalogTableau
Information Technology
Designs and delivers Snowflake data architectures on AWS, including dbt-based data engineering and AI-enabled solutions. Leads RAG, vector search, embedding, semantic search, and analytics initiatives from proof of concept through production. Directs project teams, oversees solution quality and budgets, supports proposals and business cases, and serves as a trusted technical advisor to clients. Requires strong data engineering, governance, documentation, communication, and stakeholder-management skills, with travel as needed.
Top Skills:
AWSDbtEmbedding PipelinesGenerative AiPrompt OrchestrationRetrieval-Augmented GenerationSemantic SearchSnowflakeSQLVector Search
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
