SKILLS / QUALIFICATIONS
- At least 5+ years of experience in data development and solutions in highly complex data environments with large data volumes
- At least 5+ years of experience developing complex ETLs with Informatica PowerCenter
- At least 5+ years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries to perform data analysis
- At least 5+ years of experience developing complex stored procedures, triggers, MQTs and views on IBM DB2 (experience with v10.5 a plus)
- Experience with performance tuning DB2 tables, queries, and stored procedures
- Experience with scripting languages like Perl and Python
- Experience with data ingestion into Hadoop a plus
- Experience with Autosys or Airflow a plus
- An understanding of E-R data models (conceptual, logical and physical)
- Strong understanding of advanced data warehouse concepts (Factless Fact Tables, Temporal \ BI-Temporal models, etc.)
- Strong analytical skills, including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions
- Experience with both Waterfall and Agile development methodologies
- Strong communication skills both verbal and written. Capable of collaborating effectively across a variety of IT and Business groups, across regions, roles and able to interact effectively with all levels.
- Self starter. Proven ability to manage multiple, concurrent projects with minimal supervision. Can manage a complex ever changing priority list and resolve conflicts to competing priorities.
- Strong problem solving skills. Ability to identify where focus is needed and bring clarity to business objectives, requirements and priorities.
Please share CV to thiyagarajan.m@bct-consulting.com