5+ years of full SDLC lifecycle experience participating in development efforts within ODS / data warehouse environment with complex dataflow and data integration from multiple sources Knowledgeable with data warehouse concepts such as: SCDs, star schema, hierarchy, aggregation, ODS, MDM Demonstrated ability to understand and work effectively within complex IT environment containing onshore / offshore model, multiple development and testing environments, sharing of environment with multiple teams, load balancing and disaster recovery setup Hands on proficiency with the following tools / skill sets are required: Informatica, database physical objects design, Oracle and Linux scripting, code version control Good communication skills - must be comfortable leading design review sessions as well as interact with Operate team and the occasional user interaction in Level 3 capacity Ability to coordinate works with offshore team during US non-office hours as needed Knowledge of one or more of the followings would be a plus: Vertica, Autosys and star schema-based reporting Some Java knowledge and experience would be a plus