Job Summary

ETL/Data Movement

  • Location:
    Reston, Virginia
  • Job reference:
  • Category:
    Information Systems
  • Contract Type:
    Contract/Temp to Hire

Modis is looking for an ETL/Data Movement resource! This position requires the ability to convert without visa sponsorship.
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
Possess a Bachelor’s degree in a computer science, plus additional related college courses or professional training certifications.

Apply Below


Note: Required fields marked with an asterisk (*).


Primary Number
[Ctrl (Cmd Mac) + Click] to select multiple industries
Upload your resume
Terms of Use


Upload your resume using

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.

Equal employment opportunity information:
EEO is the Law (poster) | EEO is the Law (poster supplement) | Reaffirmation of Affirmative Action Policy Statement