15 days old
2018-01-052018-02-02

ETL Software Engineer - Data Movement

Reston, VA 20190
  • Job Code
    594087
  • Payrate
    $28 To $45

ETL/Data Movement Software Engineer


Reston, VA


Randstad Technologies is searching for a senior level (4-7 years) ETL/Data Movement Software Engineer to support our client on a contract role in Reston, VA


Job Description:*


Create design specifications, perform unit testing and prepare technical documentation. In collaboration with the Information Technology division and Operations and key business units, analyze procedures and design and implement data movement solutions to attain high data quality and process automation.


Design, develop and implement solutions based on standards and processes that establish consistency across the enterprise data, reduce risk, and promote efficiencies in support of the organization's goals and objectives .


Perform complex Extract, Transform, Load ("ETL") coding. The ideal candidate will have designed, developed and implemented software solutions in support of data quality and automation. The candidate will also possess technical skills and experience in the data management domain that will help their ability to design and develop elegant and efficient data processes and systems.


Required Skills:*


- Solid, quantifiable experience in using ETL tools such as Informatica, Data Modeling ERD-Dimensional modeling tools such as ERWin, and RDBMSs such as Oracle, AWS Redshift, and MS SQL Server databases.


- Expertise in writing and tuning complex SQLs


- Expertise in using partitioning, transformations, incremental caching in Informatica tool set.


- Expert understanding slowly changing dimensions (SCD's) in Informatica.


- Expert understanding of join logic and query optimization in Informatica


- Experience in handling both on premise and on Cloud (AWS) ETLs.


- Experience in using Apache Sqoop and Spark.


- Expert in using real time and batch web services using web services hub.


- Experience with stored procedures, Triggers, PL/SQL in Oracle.


- Development knowledge and experience with most or all of the following languages and specifications: XML, XML Schema, XPath, XQuery, JSON with informatica toolset.


- Expert in writing efficient Analytic and windowing functions in Oracle.


- Query tuning , tuning ETL integration using Query Plans, Indexing, Partitioning etc


- Experience with Distributed Service Standards (SOAP, REST)


- Experience in agile Software development and JIRA


- Function as a consultant and contributor on enterprise projects to provide data analysis, design, modeling, and implementation support to project teams.


- Gather technical and business requirements, develop customized solutions and manage customer expectations.


- Strong and evolving competence in several programming languages and technologies, working knowledge of multiple tools sets, technologies and implementation environments


Preferred Skills:*


- Minimum 5 years demonstrated experience with Informatica power center, power exchange development and relational databases.


- 5 - 7 years of experience in software systems development and programming,


- Experience working with heterogeneous data systems (Oracle, SQL Server, AWS RedShift, XML,Json, flat file, etc.)


- Familiar with database analysis, design, architecture and programming.


- Experience with real time oracle change data capture using Informatica power exchange.


- Experience with Cloud based technologies such as AWS Redshift, Apache Spark and Apache Sqoop.


- Experience with programming languages such as Java and Python


- Ability to handle multiple projects and assignments simultaneously and effectively in a cross-functional team environment


- Ability to focus on the goals of quality, time and budget


- Ability to work independently and have strong problem solving and analytic skills


- Ability to support production jobs on nights and weekends.


- Positive attitude; desire to learn new things, teach others and continuously improve


Education/Certifications:*


Possess a Bachelor's degree in a computer science, plus additional related college courses or professional training certifications.


If you're interested in the ETL Developer/ Data Movement Engineer Please send your resume to [email protected] ASAP!

Categories

  • Information Technology

Randstad utilizes a technology-driven focus with a human touch to provide better staffing and business solutions to organizations around the world. Our team of experts match professionals with available career opportunities in a variety of fields.

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

ETL Software Engineer - Data Movement

Randstad Technologies
Reston, VA 20190

Share this job

ETL Software Engineer - Data Movement

Randstad Technologies
Reston, VA
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast