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 Duties:
- 4+ years development, maintenance and enhancement experience in Informatica PowerCenter,
- Informatica Job Purpose: Independently handle the Informatica PWX/CDC projects from requirement gathering till project closure
- 3+ years of experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes
- 4+ yrs. experience in Power Exchange CDC tools and should have worked extracting data from different source system like SAP, Oracle, and AS400 etc.
- Good Knowledge on DWH concepts
- Experience in developing and deploying Informatica in Unix and Oracle 11g database environment
Responsibilities:
- Designs, develops, modifies, configures, debugs Informatica workflows using Informatica PowerCenter and PowerExchange CDC tools
- Design technical and Business solutions in our change data capture technologies.
- Build infrastructure to extract and format captured change data and provide that data to other Informatica components and products.
- Expertise in handling data recovery, solution designing, Production implementation, Testing and support of interfaces PWC and PWX.
- Responsible for the development/customization of interfaces, conversions, and enhancements
- Analyses existing applications and systems and formulates logic for new systems, devises logic procedures, logical database design, performs coding and tests/debugs programs
- Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members
- Implements data clean-up procedures, data import/export utilities, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets
- Performs Data analysis, data mapping, data loading
- Responsible for the development and documentation of deliverables, and specifications on a project-by-project basis as defined in the IT Methodology, in collaboration with business analyst and other project team members
- Performs migration of workflows from development/Test to production environment and provide post-deployment support
- Documents all technical specifications and associate project deliverables
- Should have worked in multi-location delivery environment
- Preferred worked with multiple databases like Netezza,Oracle etc.
Skills/Qualifications: Bachelor's Degree in computer science/related field or equivalent experience, Professional Informatica certification a PLUS. Should have Strong Analytical and interpersonal skills with good written and verbal communication.
Key Skills: Sr. Informatica Developer/ Lead
Additional Information
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.
Skills Required
- 4+ years development, maintenance and enhancement experience in Informatica PowerCenter
- 3+ years experience developing and maintaining Informatica mappings, workflows, and processes
- 4+ years experience with PowerExchange (PWX) CDC tools and extracting data from SAP, Oracle, AS400
- Good knowledge of Data Warehouse (DWH) concepts
- Experience developing and deploying Informatica on Unix and Oracle 11g environments
- Experience with data recovery, production implementation, testing and support of PWX/PWC interfaces
- Experience performing data analysis, data mapping, data loading, and building transformations, scripts, and stored procedures
- Bachelor's degree in Computer Science or related field or equivalent experience
- Experience working in multi-location delivery environments
- Professional Informatica certification
- Experience with Netezza or multiple databases (preferred)
- Strong analytical, verbal and written communication and interpersonal skills
- Must be US Citizen, Green Card Holder, GC-EAD, H4-EAD or L2-EAD (no OPT-EAD, H1B, or TN candidates)
What We Do
SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.
