Design, develop, maintain and troubleshoot ETL mappings, sessions and workflows using Informatica PowerCenter. Perform performance tuning, scheduling, export/import, auditing/error handling, PL/SQL query writing/tuning, testing and implementation support in a financial domain and 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.
- At least 4 years of experience with Informatica
- Should have at least 4+ years of hands-on development/maintenance experience in Informatica 8.x, 9.x.
- Knowledge / Experience on using Informatica Power center and ETL using different data sources.
- Experience in creating com.plex mappings/sessions/workflows.
- Should have good knowledge on scheduling.
- Good in troubleshooting.
- Good in performance tuning..
- Good knowledge on export/import.
- Should be good in handling change request.
- Should be good on PL/SQL (especially query writing and tuning).
- Experience on implementing auditing and error handling.
- Experience in test planning, testing and implementation support.
- Experience to Financial domain.
- 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 4 years of experience in DW/BI related technologies and tools
- At least 4 years of experience in software development life cycle.
- At least 4 years of experience in Project life cycle activities on development and maintenance projects.
- Ability to work in team in diverse/ multiple stakeholder environment
** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.
Note:-
This is a Full-Time & Permanent job opportunity for you.
Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.
No OPT-EAD, H1B & TN candidates please.
Please mention your Visa Status in your email or resume.
** All your information will be kept confidential according to EEO guidelines.
Similar Jobs
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Define and advance data and platform architecture for Performance & Platform Management. Establish scalable patterns for data, AI, and API integrations; integrate AI/ML insights into operational workflows; partner with product, engineering, and business stakeholders; support SDLC and governance to ensure performance optimization, measurement foundations, and enterprise visibility.
Top Skills:
AgileAi/MlAPIsAzureCloud-NativeData LineageData ModelingErwinInformaticaMaestroMetadata ManagementSdlc
Healthtech
Design, develop, and support enterprise analytical and operational data solutions. Lead metric and technical design, translate business requirements into data models and ETL/ELT integrations, provide production support, documentation, change management, mentoring, and manage medium to large projects while staying current on EHR, ERP, cloud, and BI technologies.
Top Skills:
APIsAzure Data FactoryBigQueryBusiness ObjectsDatastageDb2EpicEpic SlicerdicerFabric/SynapseInformaticaJavaMS OfficeOraclePower BIPythonRedshiftSnowflakeSQLSQL ServerSsisTableauWorkday
Information Technology • Professional Services • Software • Consulting
Gather and analyze requirements, design solutions, coordinate stakeholders and manage timelines. Develop and optimize Teradata data models and SQL (views/stored procedures/macros/functions). Use Teradata utilities (TPT, TPump, BTEQ, FastLoad/FastExport, MultiLoad), Unix shell scripting, and Informatica ETL for large-volume BI/DW pipelines. Perform performance tuning and provide clear communication and status updates.
Top Skills:
BteqFastexportFastloadInformaticaMultiloadSQLTeradataTptTpumpUnix Shell Scripting
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
