SonSoft Inc. Logo

SonSoft Inc.

ETL ,Informatica Consultant (GC-EAD,GC,USC)

Reposted One Month Ago
Be an Early Applicant
In-Office
New York, NY, USA
Mid level
In-Office
New York, NY, USA
Mid level
Design, develop and maintain DW/BI ETL solutions using Informatica and Oracle. Produce technical designs (HLD/DLD), mappings, code, perform testing, performance tuning, CDC/UDF implementation, production rollout and post-production support in a global onshore/offshore delivery model, primarily for financial domain projects.
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

Preferred
• 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 4 years of experience in Project life cycle activities on DW/BI development and maintenance projects
• At least 3 years of experience in Oracle Databases
• At least 3 years of hands on experience in Design, Development & Build activities in Informatica and Oracle Projects
• At least 3 years of experience in Design and Architecture review
• At least 2 years of experience with Unix Scripting
• 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
• Understand Requirements and Functional Design.
• Complete Technical Design – (DLD/HLD).
• Create mapping documents for data elements.
• Complete coding and ability to analyze and fix Technical Design and Coding Defects.
• Provide System Integration Testing and User Acceptance Testing Support
• Production Rollout, Implementation Validation and Post Implementation support.
• 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
• Strong analytical skills
• Experience and desire to work in a Global delivery environment; Comfortable working in an on/offshore model.

Qualifications

Qualifications Basic
• 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 as an Informatica Develper

Additional Information

** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Note:-

  1. This is a Full-Time Permanent job opportunity for you.
  2. Only US Citizen, Green Card Holder, TN Visa, GC-EADH4-EAD & L2-EAD can apply.
  3. No OPT-EAD & H1B Consultants please.
  4. Please mention your Visa Status in your email or resume.

Similar Jobs

A Minute Ago
Hybrid
New York, NY, USA
120K-175K Annually
Expert/Leader
120K-175K Annually
Expert/Leader
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Own the strategy, roadmap, backlog, delivery, governance, and business outcomes for Liberty Mutual Investments’ Enterprise Data Management product. Lead security, pricing, reference, issuer, FX, and cash-flow data capabilities; improve quality, automation, workflows, and operational resilience. Coordinate Product, Technology, Operations, Accounting, Data, vendors, and senior stakeholders. Drive platform modernization, agile delivery, AI-enabled workflows, responsible AI adoption, incident response, and vendor accountability across a complex investment-management environment.
Top Skills: AladdinBny Data & Analytics EagleEfrontGenerative AiGoldensourceGresham Opus EdmMarkit EdmRetrieval-Augmented GenerationRimesS&P Global EdmSimcorp DimensionSnowflakeWso
45 Minutes Ago
In-Office
New York City, NY, USA
124K-207K Annually
Senior level
124K-207K Annually
Senior level
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Supports the development, prioritization, testing, launch, and continuous improvement of AI-powered marketing products. Partners with marketers, product leaders, data scientists, engineers, UX, and change-management teams to translate business needs into product requirements, manage backlogs and testing, monitor adoption, resolve issues, and promote AI-enabled workflows across commercial teams.
Top Skills: Agile Product DevelopmentAnalytics PlatformsArtificial Intelligence (Ai)Digital ProductsMarketing Technology (Martech)User Acceptance Testing (Uat)
45 Minutes Ago
Hybrid
New York City, NY, USA
147K-272K Annually
Senior level
147K-272K Annually
Senior level
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Build and manage consumer CRM audiences, personalization, and data extensions in Salesforce Data Cloud for Pfizer’s owned-channel email campaigns. Partner with CRM strategists, Marketing Channel Delivery, Accenture, engineering, website, data science, and analytics teams. Manage audience intake and QA workflows, support data dictionaries, analyze campaign performance, and improve targeting strategies using CDP data, Salesforce Marketing Cloud analytics, and SQL.
Top Skills: Data SchemasJIRARelational DatabasesSalesforce CRMSalesforce Data CloudSalesforce Marketing CloudSQL

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account