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- Provides ETL processing subject matter expertise to client projects
- Designs and implements industry best ETL technologies to satisfy client requirements
- Designs and develops optimal code to maintain exceptional performance in processing large volumes of data across diverse sources
- Gathers and translates business requirements into analytical applications.
- Collaborates with other project members and drive the development of BI initiatives
- Designs, develops, and tests ETL solutions including modeling data warehouse metadata and automating data loading processes
- Establishes ETL environments according to project requirements
- Design and implements an efficient migration process to move ETL objects from development to test and production environments
- Understands database design, programming concepts, data modeling and framework management.
Daily Tasks Performed.
- Discuss and understand ETL requirements with Data Analysts
- Develop, build Informatica mapping, workflows, create scripts for
- production jobs; under a supervision of ETL Architect.
- Working with Operations to implement jobs and support warranty
- Unit test, UAT, and SIT the data and able to document all the test
- process and results.
Wants
- At least 5 years of Informatica PowerCenter experience.
- This person will be the backup developer of the existing ETL developers, working well with the person is a crucial criterion.
- Due to the project requirements, this person cannot take a long vacation (more than 1 week) in the first 6 months.
- The visa status must allow the person to work in CA for two years.
- Informatica PowerCenter v9+
- Developer with 5+ years direct experience
- Familiarity with DB2, SQL Server Database
- Knowledge of Big Data is a plus
Musts
- BA/BS in Computer Science or equivalent training
Business Experience
- Data Warehousing 3-5 years
- ETL 3-5 years
- Informatica 3-5 years
- Oracle/SQL 3-5 years
** 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 Contract job opportunity for you.
- Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD & TN-Visa can apply.
- No OPT-EAD & H1B candidates, please.
- Please mention your Visa Status in your email or resume.
** All your information will be kept confidential according to EEO guidelines.
Skills Required
- Bachelor's degree in Computer Science or equivalent
- Informatica PowerCenter v9+ experience (5+ years)
- 5+ years as an ETL/Informatica developer
- Data warehousing experience (3-5 years)
- ETL development experience (3-5 years)
- Oracle and SQL experience (3-5 years)
- Familiarity with DB2
- Familiarity with SQL Server
- Ability to design and implement migration processes from development to test and production
- Experience creating scripts for production jobs and supporting operations
- Ability to perform and document unit testing, SIT, and UAT
- Must be able to work in California for two years and cannot take a vacation longer than one week in the first six months
- Knowledge of Big Data
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.
