Deepak Barla
Data Architect @Carilion Clinic
Signup · Get unlimited contacts
WORK HISTORY
Data Architect @Carilion Clinic
Roanoke, VA, US
Architect the framework and data pipelines for the Enterprise Data Warehouse.Design/Develop data pipelines for new/existing data pipelines.Work with staff and customers to understand the business requirements and business processes, design data warehouse (\" DW \") schema and define extract-translate-load (\"ETL\") and/or extract-load-translate (\" E LT\") processes for DW. Lead the teams in establishing analytic environments required for structured, semistructured and unstructured data. Drive rapid prototyping and design for new projects and analytic R&D environments. Translate broader business initiatives into clear team objectives and concrete individual goals, aligning appropriately with other groups for efficient, coordinated action.
EDUCATION
University of Massachusetts Lowell
Master of Science - MS, Information Technology
Nalanada Junior College
High School, Maths Physics Chemistry
Kakatiya Institute of Technology & sciences
Bachelor’s Degree, Computer Science
SKILLS
ABOUT DEEPAK BARLA
Experience in Data Analysis, Design, Development, Implementation and Testing of Database/Data warehousing/Client/Server/Legacy applications using Data Modeling, Data Extraction, Data Transformation, Data Loading and Data Analysis.•Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse.•Experience in design and implementation of Star, Snowflake schemas and multi dimensional modeling.•Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL Loader.•Worked on both Unix- based and Mainframe-based Warehouse environments.•Worked for multiple DataStage initiatives on a large Data Warehouse that processes more than 15 TB/year that grows at nearly 1 TB/year.•Sound knowledge on DataStage /Unix based ETL development and performance tuning•Experience in integration of various data sources like SQL Server, Mainframes, Oracle, Sybase, MS Access and Flat Files into staging area.•Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension Type II phenomenon, surrogate key assignment and change data capture.•Hands on Experience in UNIX Shell Scripting.•Proficient in Data analysis, Data modeling, Database design and Data migration. •Worked extensively on different types of stages like Join, Lookup, ODBC, XML Pack (XML Input, XML Output and XML Folder stage), Hashed File, Aggregator, DB2UDB, Transformer, Merge, Sort, Pivot, FTP, Change Data Capture(CDC), Filter, Modify, MQ Connector, Shared Containers for developing jobs.•Used the DataStage Director and Tivoli Maestro Scheduler, UC4 Scheduler extensively to run, schedule, monitor, debug and test the application on development, and to obtain the performance statistics.•Good working knowledge of various Databases like Oracle11g/10g/9i/8i, DB2 UDB, SQL Server, Paraccel, Teradata.•Trained in Big Data,Hadoop.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.