ETL contract jobs near you / remote

Talend ETL Developer

Reston, VA

12 months plus contract

Atleast 7 years of experience in the architecture, design, and development of Data Warehousing solutions

Atleast 7 years of experience with databases such as Vertica, Teradata, Sybase, Oracle, or DB2

Good experience with ETL tools such as Informatica and Talend

Working experience in Agile, Scrum and Kanban

Experience working in a CI/CD environment; with Micro Services and Open Source tools such as Spring Boot, Jenkins, and Maven is a plus

Experience working in Cloud environments, AWS, Big data environments

Job Type: Contract

Experience:

• Informatica: 3 years (Preferred)
• Talend: 5 years (Required)

Location:

• Reston, VA (Required)

Work authorization:

• United States (Required)

Work Location:

• One location

Job Summary
*Position: J0619-0474 Sr. Informatica Developer
Location: Herndon, VA*

*Sr. Informatica Developer
*

Your future duties and responsibilities
Must have hands on ETL development experience.

• Must be working as senior ETL developer in the current assignment.
• Provides technical direction in the maintenance and development of the extract, transform and load (ETL) aspects of the data warehouse.
• Maintains an understanding of the inputs received from the data source providers.
• Performs analysis, design, development, and implementation of new ETL requirements.
• Recommends changes to enhance the data warehouse data cleansing and conversion processes.
• Supports testing and validation of the new data conversion processes.
• Responsible for planning and monitoring schedule milestones and deliverables for assignments.
• Possesses strong SDLC experience and manages appropriate levels of systems documentation as required.

Required qualifications to be successful in this role

• 8 to 12 years of ETL development experience
• 8 years of experience with Informatica PowerCenter
• 8 years of experience with Informatica Data Quality
• 4 Years of experience with Informatica PowerExchange (change data capture)
• Strong UNIX experience
• Design, develop, test, implement, and troubleshoot ETL mappings and workflows in a large Data Warehouse environment
• Strong experience developing and maintaining Informatica mappings/workflows in a data warehouse environment
• Strong experience optimizing Informatica mappings, sessions and workflows
• Experience writing complex SQL, PL/SQL and Performance Tuning is a plus
• Strong database experience, data analysis and analytical skills
• Experience creating ETL design documentation and maintaining overall design document and deliverables
• Strong working experience of the SDLC processes
• Strong written and oral communication skills
• Good understanding of dimensional modeling and ETL designs for loading Star Schemas

Education Requirements:
Bachelor degree in Computer Science, Information Systems or related field

Thanks,
Sam Jacob
+16096190970

Job Type: Contract

Experience:

• Informatica: 5 years (Required)
• IDQ: 4 years (Required)

Contract Length:

• More than 1 year

Contract Renewal:

• Likely

Full Time Opportunity:

• Yes

Responsibilities and Duties
1. Understanding business requirements & helping in assessing them with the development teams.
2. Creating high quality documentation supporting the design/coding tasks.
3. Participate in architecture / design discussions and Develop the ETL/ELT using PySpark and
SparkSql
4. Conduct code and design reviews and provide review feedback.
5. Identify areas of improvement in framework and processes and strive them to make better.
Key Skills
Desired Skill:   1. Airflow  2. Understanding Object oriented programming  3. Devops implementation knowledge  4. Git Commands  5. Python Sphinx, Pandas, SQL Alchemy , Mccabe, Unitest etc.. Modules
Required Experience and Qualifications
Qualifications:
1. At least 3 years working experience in a Big Data Environment
2. Knowledge on design and development best practices in datawarehouse environments
3. Experience developing large scale distributed computing systems
4. Knowledge of Hadoop ecosystem and its components – HBase, Pig, Hive, Sqoop, Flume, Oozie,
etc.
5. Experience of Pyspark & Spark SQL
6. Experience with integration of data from multiple data sources
7. Implement ETL process in Hadoop (Develop big data ETL jobs that ingest, integrate, and export
data.) Converting Teradata SQL to PySpark SQL.
8. Experience in Presto, Kafka, Nifi.

Job Type: Contract

Salary: $60.00 to $65.00 /hour

Experience:

• Data Developer: 4 years (Preferred)

Job Summary

• Good ETL experience including ETL tools like Informatica.
• At least 4 year in testing on various industry-leading
• ETL/BI platforms, data warehouse testing - ETL, BI - reports.
• Strong knowledge in SQL and unix environment.
• Experience building automated tests in ETL domain.
• Experience working with developers and SMEs
• Experience working as tester or developer in fast-paced
• Agile environments Worked in test methodologies like SDLC , Agile etc.
• Excellent client interaction and communication skills.

Job Type: Contract

Experience:

• ETL Tester: 4 years (Required)

Education:

• Bachelor's (Required)

Location:

• Herndon, VA (Preferred)

Contract Renewal:

• Likely

Work Location:

• One location

We are looking for a mid-level SQL Developer/Jr DBA who is a quick learner and a team player. Ideal candidates will have a minimum of 5+ years of experience designing and developing MS SQL Server databases and business intelligence data solutions. The person will work with Director of Database Engineering and ETL team to implement data models, database designs, data access and table maintenance scripts; resolve database performance issues, database capacity issues and other database related issues.

Responsibilities

• Exploiting raw digital data from a variety of sources including, but not limited to OLTP, SQL databases, Excel, Access and flat files.
• Design, develop, revise, and maintain SQL scripts, code, and queries for data translation, conversion, and reporting.
• Retrieve data from various sources and prepare data for analysis. Assist data analysts with complex query development, tuning and schema refinement.
• Review and evaluate the existing data sources, Correlating data from multiple data sets. and analyze the conversion steps required.
• Convert existing data, using ETL processes, creating queries and scripts to manipulate the data into the format needed.
• Creating and preparing intelligence products that explain the meaning of findings in a way that resonates with senior policy makers.
• Refine and automate existing database processes, track issues, and document changes.
• Provide post conversion issue resolution, inefficiencies and/or recommendations for existing process changes.
• Works as needed with application developers to ensure that database environment optimally supports application requirements and that changes in the database environment are implemented promptly and smoothly
• Performance monitoring and tuning
• Train data analysts in SQL and SSIS solutions development.

Skills and Qualifications

• 4+ years MS SQL Server Developer experience including 2+ years of SSIS Development
• Strong SQL development skills; demonstrated competence developing complex Stored Procedures, Functions, Triggers and other database objects, as well as developing SSIS packages.
• Solid understanding of Microsoft SQL Server 2008R2, 2012 and 2014 database engine.
• Ability to design and implement relational databases
• Experience with SSIS - SQL Server Integration Services /DTS
• Experience with SQL Server Profiler.
• Experience in Health care domain is a plus.
• Self-starter that takes initiative to fill in gaps where needed
• Team player with strong soft skills (e.g., communication, interpersonal, collaboration)

This is a 3-6 month contract with possible extension depending upon performance. Please include hourly rate and availability in the application.

Job Type: Contract

Job Type: Contract

Experience:

• DBA: 1 year (Preferred)
• SQL: 3 years (Preferred)

Education:

• Master's (Preferred)

Location:

• Leesburg, VA (Required)

Work authorization:

• United States (Required)

Full Time Opportunity:

• Yes

Looking for a Scala Engineer.

8+ years IT experience

Experience on SCALA, Spark

Experience / Knowledge of Hadoop ecosystem

Design and Developer ETL for their reporting.

Responsibilities:

• Building ETL for Data & analytics team.
• Lead the development capabilities and manage the team.

Job Type: Contract

Looking for a Senior ETL developer for our Chicago, IL location.

REQUIRED SKILLS:

• ETL analysis, design and implementation using Apache Spark, Python

and MySQL

• Relational and non-relational database experience using major

databases such as MySQL and Redis, MongoDB;

• Experience with database design and development;

• Experience in design and implementation of RESTful API;

• Experience in continuous integration and delivery;

• Experience with AWS environment and deployment;

• Experience with Git;

• Strong problem solving skills;

• Must have hands on skills (minimum of 2 years) - Spark, MySql, AWS &

AWS Glue

• Nice to have experience with Snowflake and Alteryx

THE ETL DEVELOPER WILL:

• Work on (MySQL, SPARK, Python) stack, along with AWS Cloud

deployments.

• Apply industry standards, and best practices;

• Develop and consume APIs using HTTP/Rest;

• Develop systems for event driven architecture;

• Exposure to relational / non-relational DB;

REQUIRED QUALIFICATIONS:

• Bachelor's degree in Computer Science or related discipline

• Minimum 10 years of experience software development experience

• Minimum 5 years of hands-on experience developing ETL process and

backend service

• Experience with integration technologies and platforms

• Strong understanding of object-oriented design and MVC patterns

• Programming skills in other languages like Go will be preferred

• Experience with MySQL and NoSQL data stores

• Experience with systems across multiple platforms Windows, Linux and

UNIX

• Experience with the open source software

• Excellent understanding of enterprise security practices

• Good understanding of Agile development and continuous integration

• Strong written and verbal communication skills

DELIVERABLE:

• Work on (MySQL, Express, React, NodeJS) stack, along with AWS, REST

and JSON.

• Apply industry standards, and best practices;

• Develop and consume APIs using HTTP/Rest;

• Develop systems for event driven architecture;

• Exposure to relational / non-relational DB;

• Skills on at least AngularJS and Angular 2+ frameworks;

• Develop front end using HTML, CSS, and JavaScript.

• Agile design, development, testing and production implementation

Job Type: Contract

Job Description:

- 7+ years of relevant work experience: experience in large/complex IT architecture environments and experience as a solution or application architect on large-scale development projects

- Strong problem solving and analytical skills demonstrated by the ability to assimilate new information, understand complex topics and arrive at sound analysis and judgment

- Proven working knowledge of OOPS concept, Java, J2EE, Web Services, Oracle and related technologies

- Experience architecting designing, programming, and configuring the Salesforce.com platform and deep functional understanding of its capabilities and limitations.

- Minimum 4+ years with advanced Salesforce.com development tools and techniques, e.g. APEX language, Force.com custom development, triggers, controllers, Force.com, SOAP and REST APIs, JSON, sObjects, SOQL, SOSL, outbound messaging and creating Visual Force pages. Experience integrating Salesforce.com with enterprise-level applications though all available integration channels as well as Salesforce-to-Salesforce integrations

- Experience with cloud ETL tools, such as Data Loader and Informatica Cloud, as well as web-service integration.

- Strong analysis and design skills, including requirements analysis, Object Oriented design patterns, and UML

Job Type: Contract

Job Description

We are looking for an expert SAS programmer in Base SAS to assist with development of models, data validation and testing and building reports using SAS tools and applications.

Summary:

The SAS consultant will be working with our loss forecasting team to develop models, modify/change existing code and take it through the development life cycle (design, build, test, support)

Requirements

* Bachelor's degree in Computer Science, Math, Engineering or a related field with 5 years of work experience

* Minimum of 2 years of experience developing code using Base SAS

* Participated in the development life cycle of at least 1-2 models end-to-end (build, test, validate & monitor)

* Deep expertise, knowledge and experience in SAS products and SQL programming

* Understanding of SAS products, data structures and programming technologies

* Strong technical writing skill with excellent business communications

Desired Characteristics

* Experience in Financial services industry preferred

* Familiarity with SAS Visual analytics & SAS applications (e.g. MIP, RFW, IRM) is a plus

* Unix/Linux, ETL and data warehousing experience in support of BI and reporting systems

* Experience with relational & multi-dimensional databases and data management tools

* Advanced report design and build experience

Job Type: Contract

Experience:

• Work: 5 years (Preferred)
• Financial Services: 1 year (Preferred)
• SAS Programming: 3 years (Required)
• SQL & Risk Modeling: 1 year (Required)

Education:

• Bachelor's (Preferred)

Work authorization:

• United States (Required)

Required travel:

• 50% (Preferred)

Contract Renewal:

• Possible

Responsibilities

· Creating and maintaining optimal data pipeline
architecture.
· Assemble large, complex data sets that meet
functional/non-functional business requirements.
· Identify , design, and implement internal process
improvements: automating manual processes. Optimizing data delivery,
re-designing code and infrastructure for greater scalability.
· Build re-usable data pipelines to ingest, standardize,
shape data from various zones in Hadoop data lake.
· Build analytic tools that utilize datapipeline to provide
actionable insights into customer acquisition, revenue management,
Digital and marketing areas for operational efficiency and KPI's.
· Design and build BI API's on established enterprise
Architecture patterns , for data sharing from various sources.
· Design and integrate data using big data tools - Spark,
Scala , Hive etc.
· Helping manage the library of all deployed Application
Programming Interface (API)s
· Supporting API documentation of classes, methods scenarios,
code, design rationales, and contracts.
· Design/build , maintain small set of highly flexible and
scalable models linked to client's specific business needs.

Required Qualifications:

· 5+ years experience in data engineering /data integrationrole.
· 5+ years Advanced working SQL knowledge and experience working with
relational databases, query authoring (SQL) as well as working
familiarity with a variety of databases.
· Experience building and optimizing 'big data' data
pipelines, architecture and data sets.
· Build programs/processes supporting data transformation,
data structures, metadata, dependency and workload management.
· Experience in Data warehouse , Data Mart ETL
implementations using big data technologies.
· Working knowledge of message queuing , stream processing
and scalable data stores.
· Experience with relational SQL and NoSQL databases, Graph
databases (preferred).
· Strong experience with object oriented programming - Java,
C++ , Scala (preferred)
· Experience with AWS cloud services: strom, spark-streaming
etc.
· Experience with API, web services design and development

Preferred Qualifications:

· Functional experience in hospitality
· End-to-end experience in building data flow process (from
ingestion to consumption layer)
· Solid working experience with surrounding and supporting
disciplines (data quality, data operations, BI/Data WH/Data Lake)
· Effective communicator, collaborator, influencer, solution
seeker across variety of opinions
· Self-starter, well organized, extremely detail-oriented and
an assertive team player, willing to take ownership of
responsibilities, and possess a high level of positive energy and
drive.
· Excellent time management and organizational skills
· Ability to manage multiple priorities, work well under
pressure and effectively handle concurrent demands to prioritize
responsibilities

Job Type: Contract

Essential Job Functions:

• Production experience in large-scale SQL, NoSQL data infrastructures such as Cosmos DB, Cassandra, MongoDB, HBase, CouchDB, Apache Spark etc.
• Application experience with SQL databases such as Azure SQL Data Warehouse, MS SQL, Oracle, PostgreSQL, etc.
• Proficient understanding of code versioning tools {such as Git, CVS or SVN}
• Strong debugging skills with the ability to reach out and work with peers to solve complex problems
• Ability to quickly learn, adapt, and implement Open Source technologies.
• Familiarity with continuous integration (DevOps)
• Proven ability to design, implement and document high-quality code in a timely manner.
• Excellent interpersonal and communication skills, both written and oral.

Educational Qualifications and Experience:

• Role Specific Experience: 2+ years of experience in Big Data platform development.

Certification Requirements (desired):

Azure Designing and Implementing Big Data Analytics Solutions

Required Skills/Abilities:

• Experience with NoSQL databases, such as HBase, Cassandra or MongoDB.
• Proficient in designing efficient and robust ETL/ELT using Data Factory, workflows, schedulers, and event-based triggers.
• 1+ experience with SQL databases (Oracle, MS SQL, PostgreSQL, etc.).
• 1+ years of hands on experience with data lake implementations, core modernization and data ingestion.
• 3+ years of Visual Studio C# or core Java.
• Experience at least in one of the following programming languages: R, Scala, Python, Clojure, F#.
• 1+ years of experience in Spark systems.
• Good understanding of multi-temperature data management solution.
• Practical knowledge in design patterns.
• In depth knowledge of developing large distributed systems.
• Good understanding of DevOps tools and automation framework.

Desired Skills/Abilities (not required but a plus):

• Experience in designing and implementing scalable, distributed systems leveraging cloud computing technologies.
• Experience with Data Integration on traditional and Hadoop environments.
• Experience with Azure Time Series Insights.
• Some knowledge of machine learning tools and libraries such as Tensor flow, Turi, H2O, Spark ML lib, and Carrot (R).
• Understanding of AWS data storage and integration with Azure.
• Some knowledge of graph database.

Job Type: Contract

6+ years of experience with solution architecture and solution experience across multiple architecture domains such as business, data, integration, and application
6+ years of experience with system Integration patterns and Integration of Data & Business architectures
5+ years of experience in driving the Enterprise Architecture strategy, methodology and standards that delivers enterprise data model, associated meta model, common business vocabulary and taxonomies
Expertise in AWS/Cloud based managed services such as S3, EMR, Glue, RedShift etc. is considered essential
Strong understanding of SOA concepts, Design Patterns, tools, techniques and best practices
Hands on experience in applying advanced Data Architecture/Design concepts such as Datawarehouse, Datamart, Data Virtualization, Data Lake, Big Data, Logical Datawarehouse
Hands on experience in applying advanced Enterprise Architecture/Design concepts such as Cloud Computing, Microservices, 12 Factor Application development
TOGAF or an equivalent architecture framework certification is preferred
AWS or Cloud based Architecture/equivalent certification is preferred

Desired Skills:
7+ years of Design & Development (Enterprise-grade applications) encompassing backend Design Patterns, APIs, Cloud Adoption, Security framework, ETL, Reporting and Relational data stores
Ability to communicate across diverse audience of business analysts, architects, business users, technical project staff, senior leadership across business and technology
Demonstrate ability to influence others and advocate point of view when appropriate

Qualification:

Ability to apply complex design patterns to defined problems
Ability to manage large development teams
Excellent knowledge in application of design techniques, methodologies, and languages

Job Type: Contract

Looking for a solid Abinitio Administrator for our Reston, VA location.

Responsibilities:

• Responsible for all the tasks involved in administration of ETL Tool (Ab-Initio).
• Provide guidance on the design and integration of ETL to ETL Developers.
• Manage metadata hub, Operational Console and troubleshoot environmental issues which affect these components.
• Responsible for technical Metadata management.
• Design and develop automated ETL process and architecture.

• Interact with the Client on daily basis to define the scope of different applications.
• Work on the break fix and continuous development items and review and inspection for the production changes.
• Work with the various other groups – DBAs, Server Engineer Team, Middleware Group, Citrix Group, Network Group, data transmission, etc. to resolve the performance related/integration related issues.

Required Skills:

• 9+ years of overall industry experience
• 6+ years experience working with ETL tools with multiple RDBMS (prefer DB2) environments on multiple platforms.
• 4+ years' Experience with Advance knowledge of Ab Initio Graphical Four (4) years' Experience with Advance knowledge of Ab Initio Infrastructure
• 4+ years' Experience with Advance knowledge of Ab Initio Meta Data Hub
• 4+ years' Experience with Advance knowledge of Ab Initio Operational Console

Preferred Qualifications:

• Healthcare industry experience
• Experience with Ab Initio running on Cloudera Edge Nodes

Job Type: Contract