We use cookies to personalize content, to provide social media features and to analyze our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. For information on how to change your cookie settings, please see our Privacy policy. Otherwise, if you agree to our use of cookies, please continue to use our website.

Sr. .Net Developer ( .Net+SSIS)

Location: Pune, .
Company Description:

Merkle is a global data-driven, technology-enabled performance marketing agency and the largest independent agency in the US for CRM, digital, and search. For more than 28 years, Fortune 1000 companies and leading nonprofit organizations have partnered with us to build and maximize the value of their customer portfolios. We work with brands like Dell, T-Mobile, Samsung, Geico, Regions, Kimberly-Clark, AARP, Lilly, Sanofi, NBC Universal, DIRECTV, American Cancer Society, Susan G. Komen, and many others to build and execute customer centric business strategies.   

Job Description:

 The Senior Developer candidate must be a dynamic contributor, passionate about software development and committed to making a difference in an organization filled with smart, creative people. The incumbent will be part of a team responsible for the development and support of various SaaS (Software as a Service) integration solutions (Salesforce, Workday, Concur), traditional back-office systems (HRIS, Finance, etc.), and strategic data warehouses and reporting tools.  We seek a candidate experienced in SSIS-based data transformations, query / database optimization and consuming web services in .NET applications.  Candidate must be technically proficient and possess good interpersonal, troubleshooting, and documentation skills.  Must be comfortable working in a small team setting and possess an unrelenting focus on quality and scalability.

Key Responsibilities

  • Review Business Requirements to identify ETL requirements  and design, develop and test complex SSIS solutions
  • Create stored procedures, triggers and views
  • Monitor and optimize database objects and SQL Server databases (2008 R2, 2014, 2016) using industry-standard tools and practices (SQL Profiler, Analyzer, Query Plans)
  • Reverse engineer and understand complex integrations
  • Design and develop .NET applications to consume web services from our cloud systems
  • Working proficiency with ASP.NET Forms
  • Knowledgeable in Object Oriented Development
  • Develop and maintain data mappings between source and destination data stores
  • Document project specific processes and data flows, data dependencies, data definitions and relevant business rules. Establish data dictionaries to support the buildout of a data governance infrastructure
  • Must demonstrate strong problem solving ability, logic and analytical skills
  • Participate in data modeling initiatives
  • Perform quality assurance and testing at the unit level
  • Ability to manage multiple projects in a fast paced environment
  • Ability to work independently and collaborative with other team members
  • Troubleshoots production issues, identifying root cause and implementing sound technical resolutions in a timely manner
Qualifications:

  • 5+ years experience as a Developer
  • Hands on experience with SQL Server SSIS and ETL processes
  • Experience in .NET and visual studio
  • Experience in consuming REST and SOAP web services using Microsoft .NET
  • Familiarity with designing and implementing ETL in large databases and data warehouses utilizing both relational and dimensional design concepts
  • Familiarity with agile development techniques and objectives
  • Demonstrable development skills – packages, triggers, views, queries, etc.
  • Experience in other ETL tools is a plus
  • Experience in SSAS and SSRS is a plus
  • Degree in a technical field or commensurate experience
  • Working proficiency with ASP.NET Forms
  • Knowledgeable in Object Oriented Development

Additional Information:

More Information:

Students & Recent Graduates: Start your career at Merkle and get on the path to success. Experienced Hires: Leverage your expertise, challenge the status quo and grow your career at Merkle.

Still browsing?