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
Other
Own the commercial SQL Server database and end-to-end data infrastructure supporting sales, market, product, and customer analytics. Build and troubleshoot pipelines, integrate internal and external data, manage master and reference data, enforce data quality, maintain crosswalks, and support Power BI reporting. Monitor production incidents, improve architecture, document data lineage, and partner with stakeholders and source-system owners to deliver reliable commercial datasets.
Top Skills:
APIsAWSAzureAzure Data FactoryBoomiInformaticaJd Edwards (Jde)Power BIPythonRSnowflakeSQLSQL ServerSsisTableau
Professional Services • Financial Services
Designs, builds, tests, and supports enterprise data pipelines and Snowflake archival solutions for acquisitions, integrations, reporting, compliance, and analytics. Translates business and technical requirements into mappings, transformations, quality rules, and deployment plans. Collaborates with architecture, security, infrastructure, application, business, and vendor teams. Oversees validation, monitoring, documentation, cutover, go-live readiness, hypercare, and operational handoff while improving reusable, secure, cost-efficient data engineering practices.
Top Skills:
AirflowAzure Data FactoryDatabricksDbtFivetranInformaticaMatillionPower BIQlikSnowflakeTableau
Professional Services • Financial Services
Supports data governance for acquired-company integration initiatives by maintaining inventories, metadata, ownership records, retention documentation, quality trackers, lineage, issue logs, and readiness materials. Reviews structured and unstructured content, coordinates data stewards and cross-functional stakeholders, documents privacy and compliance requirements, tracks approvals and legal holds, and assists with migration, archival, decommissioning, and analytics enablement activities.
Top Skills:
AlationCollibraInformaticaMicrosoft PurviewPower BIServicenowSnowflake
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
