15 days old
2018-01-022018-01-30

ETL Developer - NY

New York, NY 10022
  • Job Code
    593729

Design and Build ETL / ELT solutions utilizing Data Analysis, Dimensional Modeling and ETL Design


Support and Develop Informatica code, Design, Develop and modify mappings and workflows


ETL/ELT performance tuning and optimization


Maintenance and support nightly batch schedule


Support Microsoft SQLServer 2008R2 using SSIS, SSRS and T-SQL


Support Oracle 11.x and 12.x using PL/SQL, Stored Procedures, functions and Packages


Develop and support shell scripts (Bash, Korn or C) to support ETL/ELT processes.


Leverage best practices, disciplined approaches, and standards to solving technical problems.


Perform ongoing monitoring, optimization, and refinement of reports and BI solutions.


Collaborate and work with cross functional IT teams. Qualifications


REQUIREMENTS (EDUCATION, EXPERIENCE, CERTIFICATIONS, AND OTHER SKILLS)


BA/BS degree in Computer Science or related field


7+ years working in IT with a thorough understanding of SDLC methodology for implementing Data Warehousing projects


7+ years' experience in Business Intelligence and Data Warehousing


Strong experience working with the ETL tools (design and development)


Able to design and architect an ETL solution, including Data analysis, Dimensional Modeling and ETL / ELT Design using Informatica and ODI in a Data warehousing environment using Oracle and SQLServer


Expertise in PL/SQL and T-SQL


Strong scripting skills (Unix and Windows)


Solid understanding of requirements for Data Quality, Metadata, Data Lineage, Operational Data Management and Operational Data Stores


Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy and plan, Data archiving, Data reconciliation, ETL Error Handling, Error logging mechanisms and proactive monitoring, standards and best practices


A strong sense of methodology, process and metrics


A self-starting team player able to operate in a fast-paced environment.


Must be End-to-end process and results oriented.

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 Developer - NY

Randstad Technologies
New York, NY 10022

Share this job

ETL Developer - NY

Randstad Technologies
New York, NY
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