Sign in

ETL Informatica Developer

Charlotte, North Carolina, United States
January 31, 2017

Contact this candidate


Email : Phone : +1-704-***-****

LinkedIn: Location: Charlotte, NC -28262


Over 4.5 years of professional work experience in Data Warehousing and Analysis.

Experienced in multiple domains like Banking, Financial and Insurance.

Proficient in Business Intelligence, Data Analysis and Data mining technologies.

Expertise in Relational database concepts and physical design.

Cross functional resource, operated in an agile environment, ability to work independently


University of North Carolina at Charlotte Masters’ in Information Technology Aug 2015–Dec 2016 GPA: 3.8

J.N.N College of Engineering, Shimoga, India Bachelors’ in Computer Science Sep 2007–Apr 2011 GPA: 3.7


ETL Tool : Informatica 9.1/9.5

Databases : Oracle 11g, SQL Server

Big Data & Analytics : HADOOP, HIVE, SQOOP, R, Tableau

Languages & Scripting : PL/SQL, UNIX, Python, JAVA, Servlets, JSP, HTML5, CSS


Intern, Saltmines Group LLC, Florida. [USA] May 2016 – Aug 2016

Devised a POC to demonstrate how HADOOP can be integrated with existing data warehouse to improve the performance.

Deployed HDInsight clusters and developed SQOOP Scripts to import / export data between SQL Server and clusters.

Implemented Java Web application, which queries HIVE DB and then compared the results with traditional relation DB.

Involved in technical design documentation and specification documentation based on Business & Business user interactions.

Graduate Teaching Assistant, University of North Carolina at Charlotte [USA] Jan 2016 – May 2016

Worked as a Teaching Assistant for Dr. Sara Scott for the course Database System and Management.

ETL Developer, HCL Technologies Ltd., India Jan 2013 – June 2015

Client: American Automobile Association (AAA)

Developed complex ETL Mappings with relational/flat files/XML sources and targets

Worked on complex mappings involving SCD, partitioning, pushdown optimization and ETL code tuning

UNIX shell scripts - to create dynamic parameter files, indirect files, send customized mails, pre and post load auditing, etc.

Performed data integration between systems using Informatica Power Center

Fair knowledge on implementation of Web Service providers and consumer transformation

Implemented parallelism and reusability by configuring reusable transformations & the concurrent run property in the workflow

Scheduling and monitoring the jobs. Worked on debugger to analyze and debug the run time errors

Experienced in Data Modeling - Logical/Physical, Star/Snowflake schema, FACT & Dimension tables, OLAP

SQL Developer, HCL Technologies Ltd., India Sep 2011 – Dec 2012

Client: Deutsche Bank

Created Entity Relationship (ER) diagrams based on requirements.

Developing T-SQL stored procedures, functions, triggers, views.

Created Oracle Tables, Views, Constrains, Synonyms, Sequences.

Created logical model, including Entity-Relationship diagram.

Performance tuning of SQL queries in production with utilities like Explain, Trace, and Stored Outlines.


Survey on “Real Time Stream Processing Architecture in Transport Tracking System” and role of Apache Kafka and Apache Storm


Data visualization using Tableau. (!/vizhome/Project_v1/Story1)

Big Data and Analytics: statistical analysis on fortune 500 companies’ revenue, net income and patent data.

Developed a Web Application using JAVA servlets. (

Contact this candidate