Programmer Analyst 2

  • Full-time

Company Description

Positioned at Publicis Groupe's core, Epsilon is a leader in interaction management, empowering brands to transform ordinary customer experiences into meaningful, human experiences. Through a connected suite of products and services, Epsilon combines leading-edge identity management, industrial strength data and technology expertise with big brand acumen gained over five decades working with the industry’s top brands. Our human-powered, data-led marketing delivers unmatched depth, breadth and scale to help brands turn meaningful human interactions into exceptional business outcomes. For more information, visit us at https://india.epsilon.com/

Follow us on social: LinkedIn, Facebook, Instagram, and Twitter

Job Description

Establishes database management systems, standards, guidelines and quality assurance for database deliverable, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan and security policy. The role also

  • Documents and communicates database design.
  • Codes complex programs and derives logical processes on technical platforms.
  • Participates in quality assurance and develops test application code in client server environment.
  • Provides expertise in devising, negotiating and defending the tables and fields provided in the database.
  • Adapts business requirements, developed by modelling/development staff and systems engineers, and develops the data, database specifications, and table and element attributes for an application.
  • May help develop an understanding of client's original data and storage mechanisms.
  • Determines appropriateness of data for storage and optimum storage organization.
  • Determines how tables relate to each other and how fields interact within the tables for a relational model.
  • May be internal or external, client-focused, working in conjunction with Professional Services and outsourcing functions. May include company-wide, web-enabled solutions.
  • Develop and execute unit test cases. Support of production systems.
  • May be heavily involved in design and execution of reports and report development.

Qualifications

  • 3+ Years of related experience with design, implementation, administration and design of database systems, or a combination of education and experience
  • Bachelor’s degree or equivalent experience required
  • Professional proficiency in English
  • Professional attitude and aptitude to engage other team members in a productive manner
  • Proficient in:
  • Customer Data Integration (CDI)/Extract-Transform-Load (ETL) with very large data volumes 
    • Oracle SQL, procedures, functions, triggers, etc.
    • MS SQL or MySQL SQL, procedures, functions, triggers, etc.
    • Coding and unit testing modules
    • Documentation skills (Design, Tech Spec, Unit test cases, etc.)
    • Analytical and problem-solving skills
  • Working Knowledge of:
    • Knowledge of RDBMS concepts and best practices
    • Experience servicing ad hoc and scheduled requests
    • Familiarity with both OLTP environments
    • Familiarity with Data Warehouse environments
    • Work prioritization, planning and sense of urgency
    • Executing system, integration and regression tests
    • Defining and executing data validation routines
    • Supporting applications and performing production data loads with change impact process awareness
    • Software Development Life Cycle (SDLC)
    • Data file transfer tools (SFTP, Connect:Direct, etc.)
    • Data manipulation tools (Unix awk, sed, sort, etc.)
    • Database Report generation (data input and output)
    • Job scripting (Unix Shell)
    • Job scripting (Windows batch scripts)
    • Experience with a third-generation language (e.g. C, C++, Java)
    • Unix/Linux Server Knowledge
    • Windows Server Knowledge
    • Microsoft Office (Word, Excel, Project, PowerPoint) and text editor programs
    • Source code control tools (e.g. CVS, TFS)
    • Customer Facing Skills
    • Detail-oriented, able to multi-task, prioritize and able to quickly change priorities
  • Familiar with:
    • Knowledge of Data Security Standards - PII
    • Knowledge of Data Security Standards - PCI
    • Knowledge of Secure Coding
    • Working with business analysts, leads and other technical/non-technical folks on business requirements
    • Testing tools
    • Web Technologies (e.g. HTML, XML, Web Services)
    • Mobile Technology
Privacy Policy