-- Please Share Me Profile [email protected]
*Title : ETL Developer / Informatica* *Location : Costa mesa, CA* *Duration : 6+ Month * Interview : phone and in-person REG ROLE: 5 yrs min / SENIOR Role 8 years min Data Warehouse ETL developer is responsible for ETL development using Informatica in Microsoft SQL Server environment and all aspects of data warehouse reporting. The objective is to transition legacy data warehouse to a structure focused on supporting customer behavior analytics. • Work as part of a team to deliver federated dimensional model for growing online consumer subscription service. • Design and develop ETL specifications, processes, and documentation to produce required data deliverables (data profiling, source to target maps, ETL flows, scripts, etc.). • Support of ETL environment including but not limited to automation, job scheduling, monitoring, maintenance, security, and administration. • Assist in definition of logical and physical data models B2C ecommerce business. • Configure and tune ETL mappings to optimize the data warehousing architecture • Troubleshoot and resolve data, system issues and performance issues. • Champion and manage new initiatives to completion to improve and streamline operations processes and maximize systems efficiency. • Participate in requirement definition, solution development and implementation phases of data warehouse and reporting projects. Skills Required: • Passionate ETL resource with expertise in Informatica and dimensional modeling. • SQL Server – SSIS, SQL queries and stored procedures. • Extensive experience with data warehouse concepts and methodologies. • Experience with database design & modeling. • Must have working experience in ecommerce industry and web analytics • Good written and oral communication skills; excellent technical skills. • Highly motivated self-starter, detail and quality oriented and able to work independently • Experience with data modeling tool (ER/Studio) • Education: BS degree or higher in MIS or engineering fields. Skills Preferred but Not Required: Cognos or other BI tools Regards, Mukesh *E-Mail* : [email protected] Cell : 732-722-2842 **Yahoo-IM- mukeshinc -- You received this message because you are subscribed to the Google Groups "GTA DBA" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/gtadba. For more options, visit https://groups.google.com/groups/opt_out.
