- Develops, implements, refines, and supports a data warehouse used for analytics and reporting, optimizing ETL processes while working closely with Business Analysts, Business Managers, Project Managers, and internal customers.
- Designs, codes, runs tests, and implements complex programs and scripts, and performs source-to-target data mapping.
- Reviews and implements project plans and business rules via stored procedures, middleware, or other technologies.
- Backs up the Senior ETL developer with providing rotational after-hours support. The ETL Developer may be required to work evenings or weekends.
- Be available on government site in Washington DC Monday – Friday during normal working hours and support after-hours remotely when needed.
- Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.
- Data Modeling design, analysis and implementation - conceptual, logical, and physical data modeling, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence.
- Installing, configuring, developing, supporting and maintaining of the BI APPS. Environment or higher: OBIEE 12c, BI Apps.9.6.3, Web Logic Server, Informatica 9.0.1, Oracle , SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP.
- Developing ETL's using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
- Designing schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Building Business Model and established relationships & Foreign Keys (Physical & Logical) between tables.
- Creating LDAP authentication to enable Single-Sign on for Users in Development environment leveraging Analytics Repository.
- Using Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
- Providing recommendations and identifying critical issues and processing faults as it pertains to data modeling, ETLs and Informatica.
- Bachelor's Degree in technical discipline, 8 additional years of experience considered in lieu of degree.
- 5+ years' experience in ETL tools, especially Informatica and data warehousing applications.
- 5+ years' experience developing and tuning complex SQL queries in Oracle relational database. Ability to work collaboratively with cross-functional teams and adapt to changing requirements.
- Prior experience in a federal data warehouse and understanding of government procedures and regulations is preferred.
- Must be authorized to work for any employer in the U.S.
- Must be able to obtain and maintain the required security clearance.
-
ETL Developer
4 weeks ago
IntePros Consulting Washington, United StatesThe ETL Developer is responsible for supporting the data and business intelligence needs of our teams at both Team Headquarters and in the Field. The successful candidate will ensure that our stakeholders have the information reporting tools needed to support better decision maki ...
-
ETL Developer
4 weeks ago
IntePros Consulting Washington, United StatesThe ETL Developer is responsible for supporting the data and business intelligence needs of our teams at both Team Headquarters and in the Field. The successful candidate will ensure that our stakeholders have the information reporting tools needed to support better decision maki ...
-
Database ETL Developer
2 weeks ago
Pyramid Consulting Washington, United StatesImmediate need for a talented Database ETL Developer. This is a Fulltime opportunity with long-term potential and is located in Washington DC (Remote). Please review the job description below and contact me ASAP if you are interested. · Ensure all your application information is ...
-
ETL Developer
3 weeks ago
engine Coraopolis, United StateseNGINE builds Technical Teams. We are a Solutions and Placement firm shaped by decades of interaction with Technical professionals. Our inspiration is continuous learning and engagement with the markets we serve, the talent we represent, and the teams we build. Our Consulting Wor ...
-
Associate ETL Developer
1 week ago
eNGINE Pittsburgh, United StateseNGINE builds Technical Teams. We are a Solutions and Placement firm shaped by decades of interaction with Technical professionals. Our inspiration is continuous learning and engagement with the markets we serve, the talent we represent, and the teams we build. Our Consulting Wor ...
-
ETL Informatica Developer
1 week ago
CGI Technologies and Solutions, Inc. Pittsburgh, United StatesETL Informatica Developer · Category: Software Development/ Engineering · Main location: United States, Pennsylvania, Pittsburgh · Position ID: J · Employment Type: Full Time · Position Description: · Position description · As a Senior ETL Informatica Developer, the candidate wi ...
-
ETL Informatica Developer
3 weeks ago
Mastech Digital Pittsburgh, United StatesRole: ETL Informatica Developer · Location: Pittsburgh, PA · Job Type: Full time/ Permanent role · Responsibilities: · ETL Development · Data Analysis · Performance Optimization · Application design/Data Modeling · Metadata Management · Qualifications: · Must have a minimum of 6 ...
-
ETL Informatica Developer
2 weeks ago
CGI Technologies and Solutions, Inc. Pittsburgh, United States**ETL Informatica Developer** · **Category:** Software Development/ Engineering · **Main location:** United States, Pennsylvania, Pittsburgh · **Position ID:** J · **Employment Type:** Full Time · **Position Description:** · Position description · As a Senior ETL Informati ...
-
Informatica ETL Developer
2 weeks ago
TEK Connexion Pittsburgh, United StatesMandatory Skills · Experience with web service integration, understanding of REST, SOAP and effective web service design. · Informatica ETL Experience · Lead experience · Relational Database Experience · Key responsibilities: · Design and develop customized solutions for te ...
-
SQL ETL Developer
6 hours ago
Kyyba Pittsburgh, United StatesJob Title: SQL ETL Developer · Job Type: Contract · Job Location: Pittsburgh, PA / Cleveland, OH / Remote · Job Details: · Mandatory Skills: · SQL and ETL along with SSRS and SSIS +.NET. · Job Description: · HTML: Hyper Text Markup Language is fundamental for creating web pages. ...
-
Informatica/ETL Developer
2 weeks ago
Saxon Global Pittsburgh, United StatesThis is a full time role with PNC Bank. USC/GC. 100% remote. Only EST/CST candidate. Avoid PA candidates. 5-8 years of development experience 4 - 6 Years Advanced design and programming skills in Informatica power center 9.6 & above and Oracle SQL/PLSQL 4 - 6 Years Designing HTTP ...
-
SQL ETL Developer
4 days ago
Cynet Systems Pittsburgh, United StatesJob Description: · Pay Range $45hr - $52hr As a .NET Full Stack developer, you ll need a versatile skill set to handle both front-end and back-end development. · Let s explore the essential skills for this role: · HTML: Hyper Text Markup Language is fundamental for creating we ...
-
SQL ETL Developer
4 days ago
TechDigital Corporation Pittsburgh, United StatesExperience: 6-10 years · Mandatory ExperienceExperience required in SQL Server (2008 to present) · Experience required in ETL · Experience required in SSIS · Experience required in SSRS · Experience required in ( MVC, Web Pages, Web API) · Experience required in Classic ASP · Exp ...
-
SQL ETL Developer
2 weeks ago
Cynet Systems Pittsburgh, United StatesJob Description: Pay Range $45hr - $52hr s a .NET Full Stack developer, you'll need a versatile skill set to handle both front-end and back-end development. Let's explore the essential skills for this role: HTML: Hyper Text Markup Language is fundamental for creating web pages. I ...
-
Indotronix International Corporation Pittsburgh, United StatesIndotronix is seeking a Hybrid-ETL Informatica Developer in Pittsburgh, PA location · Position: ETL Informatica Developer · Location: Pittsburgh (2 days in office) - open to remote · Duration: Contract to hire · Candidate Technical and skills profile: · Key responsibilities: ...
-
Data Quality Analyst
4 weeks ago
IntePros Consulting Washington, United StatesThe Data Quality Analyst is responsible for supporting the data and business intelligence needs of our teams at both Team Headquarters and in the Field. The successful candidate will ensure that our stakeholders have the information reporting tools needed to support better decisi ...
-
Senior Data Engineer/Architect
2 weeks ago
Blue Bridge People Washington, United StatesSenior Data Engineer/Architect - Analysis Services Tabular Cubes · Hit Apply below to send your application for consideration Ensure that your CV is up to date, and that you have read the job specs first. · Do you have a passion for data analysis and building robust BI solution ...
-
System Engineer
1 week ago
Talascend Washington, United StatesTalascend is currently seeking an Azure Cloud Data Engineer for a fully remote contract opportunity · Make sure to apply with all the requested information, as laid out in the job overview below. · NOTE: This is a W2 Assignment and Requires US Citizenship with ability to obtain ...
-
Team Leader
3 weeks ago
Tractor Supply Washington, United States:RequirementsMinimum 7+ years of development experience on the Salesforce platformMinimum 5 + years experience leading Enterprise Salesforce implementation with over 300 users with integration with enterprise applications like Oracle, Sap etc.Minimum 1 complex data migration (i.e ...
-
Senior Data Engineer
1 week ago
CleanChoice Energy Washington, United States · Job Title: Senior Data Engineer · Full-Time 40 Hours/Week · Classification: exempt under FLSA · Location: 100% Remote · Skills, Experience, Qualifications, If you have the right match for this opportunity, then make sure to apply today. · About · CleanChoice Ene ...
ETL Developer - Washington, United States - iTCO Solutions
Description
100% onsite location G St, NW Washington, DC
Does not want SQL ETL developers
Want only Oracle ETL Developers
Requires Bachelors degree
Candidates should take the time to read all the elements of this job advert carefully Please make your application promptly.
Professional Level Information:
As an Engineer 1, your duties may include assisting in the design, development, and testing project components, identifying problems and discovering solutions, working on ongoing projects based on specifications or drawings, and collaborating with teams of other engineers. Typically performs multiple engineering-related tasks in various assignments within the project and firm. An Engineer, 1 has strong technical skills and background, a knack for learning new technologies, and a blend of good problem-solving and innovation needed to resolve a wide variety of technical production challenges.
Functional Job (LCAT) Information:
Responsibilities:
Requirements: