Etl Developer

4 days ago

Silver Spring, 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.

e8mYdsa95L

  • Software Developer

    2 months ago

    Silver Spring, United States Dansources Technical Services Full time

    Job DescriptionJob DescriptionOur client is seeking an Informatica Developer to work with the Enterprise Information Management team to administer, develop, implement, and maintain Enterprise Data Warehouse (EDW) and related Operational Data Stores (ODS). The candidate will contribute throughout the data management lifecycle process areas such as data...

  • Software Developer

    4 days ago

    Silver Spring, United States Dansources Technical Services Full time

    Job DescriptionJob DescriptionOur client is seeking an Informatica Developer to work with the Enterprise Information Management team to administer, develop, implement, and maintain Enterprise Data Warehouse (EDW) and related Operational Data Stores (ODS). The candidate will contribute throughout the data management lifecycle process areas such as data...

  • Software Developer

    3 weeks ago

    Silver Spring, United States Dansources Technical Services Full time

    Job DescriptionJob DescriptionOur client is seeking an Informatica Developer to work with the Enterprise Information Management team to administer, develop, implement, and maintain Enterprise Data Warehouse (EDW) and related Operational Data Stores (ODS). The candidate will contribute throughout the data management lifecycle process areas such as data...

  • Lead Architect

    1 month ago

    Silver Spring, United States Dansources Technical Services Full time

    Job DescriptionJob DescriptionRole Description/Responsibilities:Ability to assess current state, identify customer requirements, and define the future state and/or business solution. Research, gather and synthesize information. Align with specific iterations of work, managing User Stories and traceability, assisting with task tracking, and getting...

  • Lead Architect

    4 weeks ago

    Silver Spring, United States Dansources Technical Services Full time

    Job DescriptionJob DescriptionRole Description/Responsibilities:Ability to assess current state, identify customer requirements, and define the future state and/or business solution. Research, gather and synthesize information. Align with specific iterations of work, managing User Stories and traceability, assisting with task tracking, and getting...

  • AWS Big Data Architect

    1 week ago

    Silver Spring, United States Executive Recruiting Full time

    Job DescriptionJob DescriptionAre you an experienced Cloud Big Data Expert looking to make a significant impact in a dynamic and mission-driven environment? Do you have a passion for AWS and data lake technologies? Join our remote team and play a pivotal role in supporting cloud initiatives for the National Oceanic and Atmospheric Administration (NOAA) and...

  • AWS Big Data Architect

    1 week ago

    Silver Spring, United States Executive Recruiting Full time

    Are you an experienced Cloud Big Data Expert looking to make a significant impact in a dynamic and mission-driven environment? Do you have a passion for AWS and data lake technologies? Join our remote team and play a pivotal role in supporting cloud initiatives for the National Oceanic and Atmospheric Administration (NOAA) and National Environmental...

  • AWS Big Data Architect

    5 days ago

    Silver Spring, United States Executive Recruiting Full time

    Job DescriptionJob DescriptionAre you an experienced Cloud Big Data Expert looking to make a significant impact in a dynamic and mission-driven environment? Do you have a passion for AWS and data lake technologies? Join our remote team and play a pivotal role in supporting cloud initiatives for the National Oceanic and Atmospheric Administration (NOAA) and...

  • Oracle and WebLogic Database Administrator

    1 month ago

    Silver Spring, United States Booz Allen Hamilton Full time

    Job Number: R0198226 Oracle and WebLogic Database Administrator The Opportunity: Your combination of people skills and technical knowledge makes you the team hero, solving one problem after another. As a database administrator who specializes in Oracle database administration, including Oracle RDBMS, RAC, and Data Guard a t Booz Allen, you can use those...

  • Oracle and WebLogic Database Administrator

    4 weeks ago

    Silver Spring, United States Booz Allen Hamilton Full time

    Job Number: R0198226 Oracle and WebLogic Database Administrator The Opportunity: Your combination of people skills and technical knowledge makes you the team hero, solving one problem after another. As a database administrator who specializes in Oracle database administration, including Oracle RDBMS, RAC, and Data Guard a t Booz Allen, you can use those...

  • Sr. Data Modeler

    3 weeks ago

    Spring, United States JobRialto Full time

    MAIN FUNCTIONS In General: MAIN FUNCTION BI Modeling includes designing, building, and maintaining data models using physical and logical modeling to translate complex business data into usable computer systems. Data Modeling structure data stored in databases for efficient processing, manage the flow from databases through the database management system,...

  • Sr. Data Modeler

    2 weeks ago

    Spring, United States JobRialto Full time

    MAIN FUNCTIONS In General: MAIN FUNCTION BI Modeling includes designing, building, and maintaining data models using physical and logical modeling to translate complex business data into usable computer systems. Data Modeling structure data stored in databases for efficient processing, manage the flow from databases through the database management system,...

  • (Req: 02) Data Scientist

    5 days ago

    Spring, United States Cyrten Full time

    Location: Houston, TX Clearance: DHS Suitability - nice to have US Citizenship is requiredExperience: 5+ years Remote/Hybrid/Onsite: 100% Onsite work (non-negotiable) Skill Level DesiredYears ExpSenior5-10Expert11-15Subject Matter Expert16+ Full Time: Direct Hire No 3rd Party Vendors - No exceptionsNote: Available Immediately & Benefits posted below...

  • Sr. Data Modeler

    3 weeks ago

    Spring, United States Compunnel Full time

    MAIN FUNCTIONS In General: MAIN FUNCTION BI Modeling includes designing, building, and maintaining data models using physical and logical modeling to translate complex business data into usable computer systems. Data Modeling structure data stored in databases for efficient processing, manage the flow from databases through the database management system,...

  • Oracle and WebLogic Database Administrator

    1 week ago

    Silver Spring, Maryland, United States Booz Allen Hamilton Full time

    Job Number:ROracle and WebLogic Database Administrator The Opportunity:Your combination of people skills and technical knowledge makes you the team hero, solving one problem after another. As a database administrator who specializes in Oracle database administration, including Oracle RDBMS, RAC, and Data Guard a t Booz Allen, you can use those skills to...

  • 514 - Data Engineer

    1 week ago

    Spring, United States Pantheon Inc Full time

    Job DescriptionJob DescriptionTraditional Data Engineer needed for Enterprise AI work 1. Experience with Databricks data processing / analytics, and ETL data transformation. Proficient in ingesting data from Snowflake, Azure storage account, Azure Data Explore. 2. Strong programing skills in Python, SQL, Pyspark. Able to develop and maintain code in Github...

  • Maximo(WAM)- Sr. Business Application Developer

    1 month ago

    Spring Lake, United States Dale Workforce Solutions Full time

    We are looking for a Maximo Sr. Business Application Developer WAM (Work and Asset Management) who will be responsible for technical support of our Enterprise Asset Management (EAM). This includes supporting and developing current and future state architectures, solutions design, providing guidance, and sharing best practices to the technical and functional...

  • Data Modeler

    4 weeks ago

    Spring, United States BravoTECH Full time

    BI Modeling includes designing, building, and maintaining data models using physical and logical modeling to translate complex business data into usable computer systems. Data Modeling structure data stored in databases for efficient processing, manage the flow from databases through the database management system, and structure the space required for the...

  • Data Modeler

    4 weeks ago

    Spring, United States BravoTECH Full time

    BI Modeling includes designing, building, and maintaining data models using physical and logical modeling to translate complex business data into usable computer systems. Data Modeling structure data stored in databases for efficient processing, manage the flow from databases through the database management system, and structure the space required for the...

  • Snowflake Architect

    1 month ago

    Spring, United States LTIMindtree Full time

    About Us:LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700+ clients, LTIMindtree brings extensive domain and technology expertise...