Salesforce Extract Transform Load (ETL) Specialist

Infinite Solutions Inc, headquartered at Sacramento, California, focuses on global delivery model to meet the needs of its most valued customers. Infinite Solutions Inc provides services in the areas of IT consulting, development, training and mentoring. Core areas of services include Custom application development; web 2.0 rich internet applications, Mainframe and client server applications, telemedicine, application consulting services.

Infinite Solutions Inc. is looking for a qualified individual to fill the role of a Salesforce Extract Transform Load (ETL) Specialist

Mandatory skills

1. Must have at least five (5) years of experience working with SQL for querying, joining, and manipulating data from relational databases.
2. Must have a minimum of five (5) years of experience working with ETL tools such as Informatica, Talend, SSIS (SQL Server Integration Services).
3. Must have a minimum of five (5) years of experience working with programming languages like Python, Java, or Scala is often required for scripting and custom ETL processes.
4. Must have a minimum of five (5) years of experience as an ETL Developer utilizing extract, transform, and load (ETL) toolsets on legacy data to Salesforce data projects.
5. Must have a minimum of five (5) years of experience on a legacy mainframe DB2/VSAM data conversion project, including data assessment to evaluate data sources and data quality.
6. Must have a minimum of five (5) years of experience in the following:
7. A project involving data migration from existing to new system(s), conducting the following specific activities:

1) Data migration planning

2) Pre-migration validation testing

3) Extract, transform, and load (ETL) actual data transfer and transformation

4) Post-migration validation to ensure data accuracy and completeness

5) Data security measures for the entirety of the migration process

1. Must have a minimum of five (5) years of experience performing ETL on a project involving more than two hundred (200) million legacy data records to Salesforce.
2. Must have a minimum of five (5) years of hands-on experience supporting and working with Salesforce, Postgres, Talend, and OwnBackup.
3. Must have a minimum of five (5) years of experience working with various relational databases (e.g., Oracle, SQL Server, PostgreSQL) and cloud data warehouses (e.g., Snowflake, BigQuery).
4. Must have a minimum of five (5) years of experience with cloud data engineering services (e.g., AWS, Azure).
5. Must have current certifications in ETL tools (e.g., Informatica), database management, or cloud platforms (e.g., AWS, Azure) can demonstrate expertise and enhance your profile. A copy of certificate must be attached.

Desirable skills

1. The staff must have a minimum of seven (7) years of experience working with Salesforce.
2. The staff must have a minimum of three (3) years of experience working with Snowflake.
3. The staff must have a minimum of seven (7) years of experience working with Service Now ETL, Talend, or PostgreSQL.
4. The staff must have a minimum of seven (7) years of experience establishing master data management strategy and solutions.
5. The staff must have a minimum of three (3) years of experience working with mainframe data storage, virtual storage access method (VSAM) files.
6. The staff must have experience working with IBM Query Management Facility (QMF) and IBM Db2 Analytics Accelerator (IDAA) for z/OS.
7. The staff must have experience decomposing and mapping Binary Large Object (Blob) / Character Large Object (CLOB) data to normalization data repositories.
8. The staff must have a minimum of three (3) years of experience with object-oriented programming.
9. The staff must have a minimum of three (3) years of demonstrated FTE experience in the last ten (10) years writing and developing functional/technical documentation with emphasis on developing detailed requirements on a project valued at 20 million dollars or more.
10. The staff must have possession of at least one (1) of the following certifications, current and active (must attach certifications):

1) Certified Business Analysis Professional (CBAP)

2) Certified Software Tester (CSTE) offered by the Quality Assurance Institute (QAI)

3) One or multiple levels of certification as an ISTQB Certified Tester by the International Software Testing Qualifications Board (ISTQB)

4) ISO/IEC/IEEE 29119 Software Testing Standard

5) ISO 9001 Quality Management System

6) Project Management Professional (PMP) certification by the Project Management Institute

1. The staff must have a minimum of five (5) years of FTE experience in the last ten (10) years working with highly complex target application environments involving complex integration and multiple stakeholders.
2. The staff must have a minimum of five (5) or more years of FTE experience in the last ten (10) years using issue management tools.
3. The staff must have a minimum of five (5) years of FTE experience in the last ten (10) years setting up and performing test automation using Tosca Testing Automation Suite
4. The staff must have a minimum of one (1) year of experience working with Motor Vehicle organizations implementing Salesforce solutions.

If you are qualified/interested for this position please send your resume to