Atria Group LLC Logo

Atria Group LLC

Teradata Lead w/ Strong SQL

Reposted Yesterday
Be an Early Applicant
In-Office
Chicago, IL, USA
Senior level
In-Office
Chicago, IL, USA
Senior level
Lead design and development of a central data repository using Teradata. Write strong SQL, work with Oracle, normalize disparate datasets, tune performance, create technical designs, estimate development effort, manage non-functional requirements, mentor offshore team members, and ensure quality through reviews and issue resolution.
The summary above was generated by AI
Company Description

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

Job Description

Technical Skill :-         

  • Lead the analysis, design and development of Central Data repository. Define the data and reporting structure and align with the TeraData roadmap/design approach and client's future data management strategy with IT team.
  • Strong SQL Skills - query writing
  • experience in Oracle databases
  • normalizing complex data sets from disparate sources to ensure data integrity, batching , and performance tuning 
  • Responsible for creating the technical design based on the solution architecture.
  • Responsible for the complete development of the specific technology modules of the project.
  • Responsible for managing the non-functional requirements and ensure that they are addressed with the technical solution
  • Responsible for the technology level development work effort estimations and work with PM/Lead to create an integrated effort estimate for the components/modules and the whole system
  • Responsible for managing and mentoring offshore team members for the development work with the assistance of PM/Tech Lead
  • Responsible for addressing technical issues related to the specific modules and ensuring the right quality and on time delivery of agreed deliverable.
  • Responsible for peer-reviews and lead reviews and provide feedback 

Additional Information

  1. Good comm skills are a big priority
  2. Duration: 12+ Months
  3. Candidate must have excellent verbal and written communication skills.

Similar Jobs

2 Hours Ago
Hybrid
Chicago, IL, USA
99K-232K Annually
Senior level
99K-232K Annually
Senior level
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead implementation of SAP compliance and security measures, analyze client requirements, manage engagements and budgets, coach teams, use SAP GRC and BW/4HANA for governance and reporting, develop governance frameworks, conduct audits and QA, and advise business leaders on risk and regulatory compliance.
Top Skills: Sap Bw/4HanaSap GrcSap Gts
2 Hours Ago
Hybrid
Chicago, IL, USA
124K-280K Annually
Senior level
124K-280K Annually
Senior level
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead SAP compliance and security consulting engagements: analyze client requirements, implement SAP security and governance solutions, advise on regulatory compliance, manage client relationships, coach teams, and validate outcomes to mitigate risk and protect sensitive data.
Top Skills: Sap Bw/4HanaSap Governance Risk And Compliance (Sap Grc)Sap Gts
5 Hours Ago
Hybrid
Chicago, IL, USA
79K-132K Annually
Mid level
79K-132K Annually
Mid level
eCommerce • Information Technology • Retail • Industrial
Build and enhance cloud-based promotional experiences across the full stack. Implement high-performance Vue.js front ends and TypeScript/Node.js backends, design scalable microservices, integrate AI-driven workflows, improve observability and CI/CD, participate in team processes, resolve high-priority issues, and maintain technical documentation and quality standards.
Top Skills: Ai ToolsCi/CdDatadogDockerInfrastructure As CodeKubernetesLarge Language ModelsMicroservicesNode.jsObservabilityPrompt EngineeringPythonServerless ContainersTelemetryTypescriptVue

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account