SUMMARY

• 11 Years of experience in Designing, Architect, Development and Implementation of Data Warehouses & Data marts & Data Integration with Informatica Power Center 9.1,8.6/7.1 and Talend 6x, 7x for Big Data and ESB
• Expertise in performance tuning.
• Experience designing with Type 1 and Type 2 mappings and Change Data Capture
• Expertise in both OLTP and OLAP architecture
• Experience Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
• Loaded various different targets from Flat files (.dat/.csv/.xls/.txt,etc) to OLTP /OLAP databases(Oracle/Teradata/DB2/SQL Server, etc) to CRM systems(Salesforce).
• Extensive experience in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, testing, implementation and maintenance
• Extensive experience with Information IDQ for maintaining data quality using data cleansing, data scrubbing, etc
• Extensive experience with data governance, data protection and data analytics
• Experience with various Heterogeneous Systems like Oracle, Teradata, MS SQL, SQL Server, Flat files, etc
• Strong working experience creating data models using Erwin, MS - VISIO and Toad Data Modeler, ER Studio
• Extensive experience working in a fast-paced agile methodology and scrum methodologies
• Ability to work in fast paced environment and meet deadlines
• Excellent communication and interpersonal skills, with the ability to manage responsibilities individually or as part of a team environment
• Strong Experience in enhancing performance, fixing bugs in products as well as projects
• Experience with both Cost Based Optimization (CBO) and Rule Based Optimization (RBO)
• Ability to explain technical concepts and communicate with users and system administrators at all levels
• Well versed with System Development Life Cycle (SDLC) & software quality measures
• Worked with various domain like utility, telecom, finance, automobile retail, Ecommerce.
• Mentored, coached, cross-trained junior developers by providing domain knowledge, design advice
• Proven ability in defining goals, coordinating teams and achieving results

TECHNICAL SKILLS

Data Warehousing/ ETL: Informatica PowerCenter 8x/9x

Data Integration Tool: Talend for ESB (7x) and Talend Cloud for Real time Big data (6x/7x) and Talend Open Studio (6x/7x) (TAC)

Programming Languages: SQL, PL/SQL, C, C++, HTML, Shell script, Java, JavaScript, Python 2.7

Platforms: MS-DOS, Windows 9x/2000/XP, Red Hat Linux 4.0 and 5.3, Solaris, AS 400

Databases: Oracle 9i/10g/11g/19c, Teradata, My SQL, DB2, SQL Server, MariaDB, Vertica, Microsoft Azure sql server

Modeling Tools: Oracle JDeveloper, MS Visio, Rational Rose

Application Packages: Sql *Loader, Database Import and Export

Reporting Tools: JasperSoft iReports 1.3.2, Tableau, Cognos Report Studio

IDE: Oracle SQL Developer, Quest Toad, Pl/SQL Developer, Eclipse, Ganymede, MyEclipse, Nexus, Microsoft Sql Server Studio, DBeaver

Version Control: WinCvs, Totoise SVN, Perforce, Github/ Gitbucket

Application: Microsoft Office 97/2000/XP/2003/2007 and Acrobat Professional.

Data Modeling: Erwin, Toad Data Modeler, Microsoft Visio

Quality Management: JIRA, HP Quality Center (QC), Inbuilt defect tracking systems

Incident/Log Tracking: BMC Remedy, Splunk, Sumo Logic, HP Service Manager

Scheduler: Autosys, Go Plan, Tivoli

CRM: Salesforce Classic/ Lightning

PROFESSIONAL EXPERIENCE

Confidential

Lead Data Integration Developer

Responsibilities:

• Gathered Business requirement for data migration and data integration.
• Performed data migration from Salesforce Classic to Lightning process using Talend Cloud Real Time Big Data and Talend Opens Source for ESB and Oracle 19c.
• Proposed design solutions and build project plans and finalized the design plan.
• Worked with Dev ops to build CICD pipeline for Talend Artifactory and Build deployment.
• Integrating various sources like MDM system, flat files, Postgres, Oracle, Salesforce, etc. using Talend.
• Preformed data validation and data cleanup on source data.
• Created Apache Camel routes using Talend to process real time bi-direction synchronization between different Salesforce Objects
• Created Apache Camel routes using Talend to send, send and process Active MQ messaging
• Developed and designed Real Time integrations using Apache Camel, Apache Kafka and Talend Real Time ESB
• Designed and developed ESB Integrations.
• Performed code review and project estimate and delivery estimate

Environment: Oracle 19c, Git, Salesforce, Talend Cloud, Bitbucket

Confidential

Senior Data Engineer

Responsibilities:

• Gathered requirement with Client and business involved in all sources.
• Perform data analysis on the multiple sources and target data.
• Integrate various sources Oracle, Hadoop and Salesforce using Talend jobs (spark jobs and regular) into Salesforce CRM system.
• Worked with Talend team to resolve Talend 7.0 issue with build creation using Jenkins.
• Developed code in both Talend Enterprise edition (7.0) and free edition (7.2) for Big Data.
• Created physical, logical and conceptual data model using lucid chats.

Environment: Linux, Oracle, Unix, Sql developer, Beeline, Hadoop, Spark, Hive, Autosys, Git, Salesforce, Talend, TAC, Bitbucket