SQL Developer (dw/t-sql ETL) - TOP MNC

KAMMS Management Consultants Private Ltd
  • Bangalore, Pune
  • 3-3 lakh
  • 5-8 years
  • Views
  • 02 Jan 2018

  • Software Design & Development

  • Consumer Durables/ Semi Durables
Job Description

Responsibilities: The SQL Developer will work as part of a data integration (ETL) development team in the Financial Systems & Technology (FS&T) group to support the Financial Accounting Control System (FACS) platform. The successful candidate must be a client-focused senior developer able to assist with the development and delivery a technology solution that meets the needs of the end users while maintaining compliance with client change management processes and procedures. This role involves frequent interaction with end user business analysts so excellent communication skills and a pleasant personality is required. FACS is a data warehouse with complex transformation logic. After extracts are loaded into the database via Informatica, all transformations and loads are performed via SQL and Stored Procedures. Informatica is used only to load the raw data and coordinate the batch. This role is to use T-SQL to develop the transformation logic, which is where all the business logic and complexity of the system resides. While a little Informatica would be nice to have to monitor and kick of jobs, this role will not involve Informatica development. This role is to support those new integrations to FACS. This will be primarily a development role. Support responsibilities are expected to be less than 10%. Required Skills: Extremely strong T-SQL skills. Ability to write queries that execute quickly and efficiently even when dealing with millions of rows. This is the single most important skill. Experience with SSIS is not a replacement for this skill. SQL Server 2005 and/or SQL Server 2008 experience, including experience with large-scale relational databases (> terabyte). Also experience creating reports using SSRS. Experience in database or data warehouse system ETL processes using Stored Procedures and SQL. Understanding of database maintenance processes (pertaining to Statistics, Indexes, Performance Analysis) Strong communication and problem solving skills, a positive attitude and the ability to work with business users required. The ability to work in a multi-tasking team environment. The users often change their minds or have many small enhancement requests interspersed with projects. Candidate needs to be able to switch tasks as needed and juggle multiple assignments while still meeting deadlines. Some people do not like this. This role will not be working on one single thing for weeks/months at a time. There will be constant interruptions. Make sure candidates are OK with this. Ability to analyze and document system recommendations and changes SDLC knowledgeable Ability and desire to interact with business counterparts. Nice to Have Skills: 5+ years data integration development experience. 3+ years of ETL / Data Warehouse experience. Knowledge of Kimball methodologies; star schema with Fact tables and Type-2 Dimensions. Accounting and/or financial industry experience is desirable. Excel, MS Access. MS Certifications Autosys UNIX Some light Informatica experience. No full Informatica developers as they will not be happy in this role.


Job Posted By