Current jobs related to Etl Developer - Woodbridge - Syms Strategic Group, LLC (SSG)


  • Woodbridge, New Jersey, United States Innova Solutions Full time

    About the RoleWe are seeking a highly skilled Big Data Production Support Engineer to join our team at Innova Solutions. As a key member of our data analytics team, you will be responsible for ensuring the smooth operation of our big data infrastructure and providing expert-level support to our clients.Key ResponsibilitiesCollaborate with cross-functional...


  • Woodbridge, New Jersey, United States Plymouth Rock Assurance Full time

    About the RoleWe are seeking a highly skilled Senior Database Administrator to join our team at Plymouth Rock Assurance. As a senior member of our database team, you will play a critical role in the migration, maintenance, update, and support of various database platforms.Key ResponsibilitiesDatabase Management: Maintain a Snowflake data warehouse, and data...


  • Woodbridge, New Jersey, United States Innova Solutions Full time

    Job Title: Big Data Production Support EngineerWe are seeking a highly skilled Big Data Production Support Engineer to join our team at Innova Solutions. As a key member of our team, you will be responsible for providing technical support and expertise in the design, implementation, and maintenance of our big data infrastructure.Key Responsibilities:Consult...


  • Woodbridge, United States Plymouth Rock Assurance Full time

    Senior Database Administrator As a senior member of a skilled database team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, DynamoDB, and Data Migration Service (DMS). Activities will also...


  • Woodbridge Township, United States Innova Solutions Full time

    Innova solutions is hiring for a Big Data Production Support Engineer Title: Big Data Production Support Engineer Contract Type: W2 /Fulltime Duration: 9 Months (Potential extension) Location: Iselin, NJ (Hybrid) As a Big Data Production Support engineer, you will :Consult on and participate in moderately complex Software Engineering initiatives.Review and...


  • Woodbridge Township, United States Motion Recruitment Full time

    Outstanding long-term contract opportunity! A well-known Financial Services Company is looking for a Big Data Production Support Analyst in Iselin, NJ (Hybrid). Work with the brightest minds at one of the largest financial institutions in the world. This is long-term contract opportunity that includes a competitive benefit package! Our client has been...


  • Woodbridge, New Jersey, United States Plymouth Rock Assurance Full time

    The Business Intelligence Supervisor plays a crucial role in formulating strategies and guiding analytical assessments of operational processes and overall profitability to evaluate the effectiveness of operational and marketing channels, ensuring the business remains profitable. This position is tasked with developing analytics, databases, and performance...


  • Woodbridge Township, United States Plymouth Rock Assurance Full time

    Senior Database Administrator As a senior member of a skilled database team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, DynamoDB, and Data Migration Service (DMS). Activities will also...

  • Big Data Engineer

    1 week ago


    Woodbridge Township, United States Motion Recruitment Full time

    Outstanding long-term contract opportunity! A well-known Financial Services Company is looking for a Big Data Engineer in Iselin, NJ (Hybrid). Work with the brightest minds at one of the largest financial institutions in the world. This is long-term contract opportunity that includes a competitive benefit package! Our client has been around for over 150...

  • DataIku SME

    2 weeks ago


    Woodbridge Township, United States Synechron Full time

    We are seeking an experienced Data Lead / Dataiku SME to join our team. The ideal candidate will have a strong background in data analytics, with expert knowledge of the Dataiku platform. You will lead our data initiatives and collaborate with cross-functional teams to drive business value through data-driven insights.Responsibilities:Define and implement...

Etl Developer

3 months ago


Woodbridge, United States Syms Strategic Group, LLC (SSG) Full time

**Syms Strategic Group (SSG) **is seeking a talented **Extract, Transform, and Load (ETL) Developer**
**Department**:Veterans Affairs

**Location**:On-site, Washington, DC

**Type**:Full Time

**Min. Experience**:Experienced

**Security Clearance Level**:Public Trust (MBI)

**Salary Range**:$75,995 - $89,000

**Military Veterans are highly encouraged to apply**

**Essential Duties and Responsibilities**
- This is an on-site, customer facing position in downtown Washington DC supporting a federal government client. Remote work is not available.- Provide Data warehousing, Data modeling, Data integration, Data migration, ETL processes, and Business Intelligence support.
- Design, analyze, and implement Data Modeling.
- Provide data modeling design, analysis, and implementation, including conceptual, logical, and physical Data modeling, Data conversion, Data integration, and Data mining specialization in Data Warehouse and Business Intelligence.
- Install, configure, develop, support, and maintain the BI Apps, including the following environments or higher: OBIEE 12c, BI Apps.9.6.3, Web Logic Server, Informatica 9.0.1, Oracle 11.2.0.2, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL Plus, Unix, and Windows XP.
- Develop ETLs using Informatica to facilitate Extraction Transformation and Data Load from Online Transaction Processing (OLTP) systems to Online Analytical Processing (OLAP) systems.
- Design schema using Key Performance Indicators (KPIs), Fact, Dimensions, Physical, Logical, Alias, and Extension tables.
- Build the Business Model(s) and establish relationships and Foreign Keys (Physical and Logical) between tables.
- Create Lightweight Directory Access Protocol (LDAP) authentication to enable Single-Sign on for Users in Development environment leveraging Analytics Repository.
- Use Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
- Provide recommendations and identifying critical issues and process faults as they pertain to data modeling, ETLs, and Informatica.

**Required Skills and Experience**
- An ability to work collaboratively with cross-functional teams and adapt to changing requirements.

**Professional Certifications**
- n/a

**Years of Professional Experience**
- 5+ years’ experience developing and tuning complex SQL queries in Oracle relational database.

**Desired experience**
- Availability on government site in Washington, DC Monday - Friday during normal working hours and support after-hours remotely when needed.
- Prior experience in a federal data warehouse and understanding of government procedures and regulations.

**Formal Education**
- Bachelor’s degree in technical discipline or 8 years of additional relevant experience

**Citizenship Requirement**

**U.S. Citizenship required for this specific opportunity**

**Security Clearance Requirements**
- Must possess or qualify for a Public Trust (MBI)

**CRITICAL NOTES**:

- SSG will not make assumptions regarding your qualifications. Your answers to the mandatory screening questions must be supported by the information on your resume. Applications with inconsistencies will not be considered.
- Recruiters or Third parties will not be considered.
- This is an onsite position located in Washington, DC. Remote work is not available for this position.

Syms Strategic Group, LLC is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, marital status, disability, veteran status, sexual orientation, or genetic information.

2FsEAOsoxb