Bala Patil

Professional with adequate experience in the ETL/ELT Architecture, Analysis, Design, Implementation, Maintenance of systems mainly Enterprise Data Warehousing and Business Intelligence using DWH tools and technologies. Worked with Wells Fargo,Credit Suisse, Union Bank Of Tokyo and Mitsubishi [MUFG] & McGraw Hill and GMAC Insurance USA.  Proficient in ETL scripting, Unix scripting. SQL scripting, performance tuning for ETL scripts, Informatica cache management, DB tuning, DB indexes, SQL query optimization using hints. Exposure on database partitioning, optimizers and execution plans. Experience in Data analysis, Data dictionary, Data profiling, preparing complete Data lineage, Data mapping, Data quality and Data Governance. • Familiar with cloud or data-related AWS services (S3, EC2 Athena, Redshift, Glue, DynamoDB, EMR, Kinesis etc Good exposure to data quality tools like Informatica IDQ and experienced in defining data quality process model, data quality rule design, rule execution, quality scorecards and data governance. Sound knowledge on the Big Data / Hadoop Technologies.  Implemented ETL POC on Big Data Ecosystem Apache Spark, SQoop, HDFS / Hive using Phyton.  Exposure on functional requirements transformation into high level technical requirements and performed feasibility analysis.  Provided solutions to the architectural problems with the data integration into the system and provided guidance on the data model adjustments & enhancements.  Involved in analysis, design & development of the database and ETL solutions. Developed technical specifications that included Flow Diagrams and Process flows.  Engaged in L3 level project support, extensively worked on troubleshooting production issues, analysis, quick fixes & Performance tuning. Good understanding on Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational & Dimensional Data Modeling, SCDs, Physical & Logical data modeling Exposure to Control M , Tidal scheduling tools. Good knowledge on SFDC & BO reporting.