Second Menu

Thursday, October 2, 2014

Interview(Phone/skype) : ETL Design Lead | MA |

Title : DW ETL Design Lead

Location : Lexington, MA

Duration : 2+ yrs most likely until 2017

Important Skills               

                Tech – data warehouse, ETL, Design exp, data modeling

                Soft – Team player. Communicate

Interview process : Phone and skype or onsite.

 

Overview:

 

Design, specify and deliver enterprise reporting and analytics data structures to support financial and medical analysis in our Netezza-based environment.  Position may require team leadership or key development contribution or user interaction depending upon the profile of the project.

 

Experience

·         At least 6 years functional design, technical design, coding and testing of data acquisition and ETL process.

·         Technical leadership of several (3+) person development teams.

·         Development and usage of Data Warehousing best practices and standards.

·         Repeated design/development of large-scale data warehousing environments.

·         Design experience with a variety of DW languages and toolsets.

·         Working knowledge of healthcare services industry – preferred.

Demonstrable Skills

·         Functional/Technical document (specification) authorship.  Required.  Critical.

·         Netezza DW appliance ETL development skill via SQL and other tools.  Understand NZ ETL best practices.  Preferred.

·         Ability to independently, or with business counterparts, profile, navigate and reverse engineer the data of source application databases in preparation for data and ETL design.  Required.

·         Graphical and written design of complex ETL processes – including the exceptional.  Required.

·         Good SQL, PLSQL development in Oracle and/or SQLServer.  Required.

·         Process and Data modeling in large-scale data warehousing environments.  Strongly preferred.

·         Estimation, planning and execution of small-team data warehousing projects.  Preferred.

·         Hands on skill with common ETL tools – especially Informatica - Preferred.

·         Design/Configuration of jobs using scheduling tools like Tidal or Autosys.  Preferred.

·         Very good written, oral and meeting-based communications in mostly technical settings.  Must be able to explain your design/position to multiple audiences.  Required.

·         Skill in the techniques and tools used for high-volume data acquisition and replication.  Strongly preferred.

·         Respects  timelines and surfaces issues without direct supervision.  Required.

·         Translate business information requirements to technical structure and specification.  Required.

·         Leads and participates in code walkthroughs and other deliverable reviews.  Required.

·         Netezza certification.  Preferred.

 

Best Regards

Nitesh Yadav

Technical Recruiter

P-201-285-8031 * 118  | F- 201-526-6869

APETAN CONSULTING LLC

72 Van Reipen Avenue # 255

Jersey City, NJ 07306

Nitesh@apetan.com

http://www.apetan.com

--
You received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at http://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment