SonSoft Inc. Logo

SonSoft Inc.

Informatica and Teradata Developer/Lead

Reposted 3 Months Ago
Be an Early Applicant
In-Office
Charlotte, NC, USA
Mid level
In-Office
Charlotte, NC, USA
Mid level
Design, develop, and maintain DW/BI ETL solutions using Informatica and Teradata. Perform architecture and design reviews, data loading, performance tuning, query optimization, and implement best practices (CDC, UDFs). Collaborate across stakeholders in a global delivery environment, primarily within the financial domain.
The summary above was generated by AI
Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

  • At least 4 years of experience in Software development life cycle
  • At least 4 years of experience in DW/BI related technologies and Informatica ETL tool – MUST
  • At least 2 years of experience in Teradata - MUST
  • At least 4 years of experience in Project life cycle activities on DW/BI development and maintenance projects.
  • At least 3 years of experience in Design and Architecture review
  • At least 3 years of hands on experience in Design, Development & Build activities in Informatica and Oracle Projects.
  • Knowledge of Informatica Architecture, Projection Design, ETL flow, advanced SQLs
  • Knowledge of data loading techniques using Informatica tool.
  • Knowledge Best Practices in Informatica, Performance improvements, implementing CDC, UDFs
  • Strong knowledge of Teradata Architecture: Nodes (AMP &PE), VProcs, BYNETS
  • Efficient usage of Teradata DDL Statements – Derived Tables, Volatile Tables and Global Temporary Tables.
  • Hands on Knowledge on Teradata Concepts – Primary Index, Partitioned Primary Index, Secondary Index, Join Index and Compression Techniques.
  • Understand the Concept of Locking Mechanisms in Teradata
  • Experience on Query Tuning mechanisms using indexes & proper usage of Statistics in Teradata
  • Hands-on development mentality, with a willingness to troubleshoot and solve complex problems
  • Ability to work in team in diverse/ multiple stakeholder environment
  • Experience in Financial domain
  • Experience and desire to work in a Global delivery environment

Qualifications

  • Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
  • At least 4 years of experience with Informatica.
  • At least 2 years of experience with Teradata.

Additional Information

** U.S. citizens and those who are authorized to work independently in the United States are encourage to apply. We are unable to sponsor at this time.

Note:-

  1. This is a Fulltime & Permanent job opportunity.
  2. Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.
  3. No OPT-EAD, H1B and TN Visa candidates please.
  4. Please mention your Immigration Status while applying .
  5. All your information will be kept confidential according to EEO guidelines.

Similar Jobs

16 Minutes Ago
Easy Apply
Remote or Hybrid
USA
Easy Apply
172K-245K Annually
Senior level
172K-245K Annually
Senior level
Cloud • Information Technology • Security • Software • Cybersecurity
Own strategy and cross-functional execution for a Security AI product portfolio. Lead customer discovery, define roadmaps and requirements, align Engineering, Design, Security Research, and go-to-market teams, and ship enterprise capabilities that improve security outcomes. The role requires strong product leadership, technical fluency in AI/ML or cloud security, executive communication, and experience delivering enterprise platform, developer-facing, or security products.
Top Skills: A2AAi/MlAPIsCloud Security ArchitectureIdentity ProtocolsMcpSaseTelemetryZero Trust
21 Minutes Ago
Easy Apply
Remote or Hybrid
United States
Easy Apply
0-0 Annually
Senior level
0-0 Annually
Senior level
Big Data • Cloud • Software • Database
Lead the lifecycle management of US government cloud authorizations, including FedRAMP High, DoD IL5+, CJIS, and ITAR. Manage federal assessments, continuous monitoring, vulnerability reporting, POA&M maintenance, and security artifact updates. Advise engineering teams on NIST controls, FIPS, boundary protection, and identity management. Conduct compliance gap analyses, guide remediation roadmaps, and serve as a technical SME for federal agencies, auditors, and sales stakeholders.
Top Skills: AWSCjisCmmcConfluenceDod Il5+FedrampFips 140-2Fips 140-3GCPGovrampItarJIRAAzureMongodb AtlasNist 800-171Nist 800-53
21 Minutes Ago
Easy Apply
Remote or Hybrid
United States
Easy Apply
95K-187K Annually
Senior level
95K-187K Annually
Senior level
Big Data • Cloud • Software • Database
Lead the vision, strategy, prioritization, and investment direction for MongoDB’s Finance data product domain. Establish product-led operating standards, mentor Product Managers, resolve cross-functional trade-offs, and guide enterprise architecture and adoption decisions. Define responsible AI strategies for financial workflows while ensuring compliance, governance, measurable outcomes, and scalable delivery across complex financial systems and data platforms.
Top Skills: AIData IntegrationEnterprise Resource Planning (Erp) SystemsFinancial Data PlatformsFp&A SystemsWorkforce Planning (Wfp) Systems

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

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account