Design, develop and maintain ETL/ELT solutions using Informatica for data warehouses/marts. Apply dimensional modeling and DW architecture, perform troubleshooting, shell scripting on Unix/Linux, and collaborate in a global delivery environment.
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.
- Strong Knowledge of Dimensional Modelling, DW architecture, ETL Frameworks, Design and Development using Informatica, Informatica B2B, Best Practices and Troubleshooting
- Working knowledge of Informatica Data Transformation and Data Transformation studio
- Understanding of Unix/Linux system, file systems, shell scripting
- Experience with design and implementation of ETL/ELT framework for complex warehouses/marts
- Hands-on development mentality, with a willingness to troubleshoot and solve complex problems
- Ability to work in team in diverse/ multiple stakeholder environment
- Strong analytical skills
- Experience and desire to work in a Global delivery environment.
- 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 Information Technology.
- At least 3 years of experience with DW/BI and ETL tools
- At least 2 years of hands on experience in Design, Development & Build activities in Informatica Projects - MUST
- At least 3 years of experience in Project life cycle activities on DW/BI development and maintenance projects.
** 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:-
- This is a FULL TIME job oppurtunity.
- Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, TN VIsa can apply.
- No H1-B & OPT is applicable for this position.
- Please mention your email id in your email or resume.
Similar Jobs
Automotive • Big Data • Insurance • Software • Transportation
Designs, builds, and maintains scalable ETL/ELT pipelines and finance data models using Snowflake, AWS, dbt Core, Python, and SQL. Develops Medallion architecture data marts, integrates ERP systems, and partners with stakeholders on financial workflows. Implements data governance, RBAC, automated quality testing, observability, documentation, CI/CD, and secure deployments. Monitors Snowflake costs and optimizes queries while supporting Oracle EBS integrations and the migration to Workday.
Top Skills:
AWSCi/CdDbt CoreGitOracle EbsPythonSnowflakeSQLWorkday
eCommerce • Healthtech • Pet • Retail • Pharmaceutical
Develop scalable backend applications, services, and APIs using Java and AWS. Support Chewy and SmartPak platform integration across e-commerce, catalog, fulfillment, and customer experiences. Contribute to architecture, modernization, distributed-system troubleshooting, code reviews, testing, DevOps practices, and technical decisions while collaborating across engineering, product, and business teams.
Top Skills:
.NetAWSC#Ci/CdJavaKafkaKubernetesMicroservicesSpring BootTerraform
Artificial Intelligence • Internet of Things • Semiconductor
Engineering internship opportunities span hardware and chip design, testing and validation, systems performance, AI and machine learning, software and tools, technical enablement, and technical product programs. Interns may build, test, debug, model, analyze, or improve technical systems using programming, hardware, simulation, data, and engineering tools. Candidates must be enrolled in a relevant technical degree program and return to their studies after the internship.
Top Skills:
Ai/MlCC++Ci/CdEmbedded SystemsFpgaLinuxLlmsPythonRtlSimulation
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
