SUMMARY:

• Over 14 years of total IT experience in system analysis, design, development, testing, implementation and production support of databases, data warehousing, and Mainframe applications for various industries
• Over 10 years of experience in Data warehousing and Data Integration experience in Extraction, Transformation and Loading (ETL) processes using Talend, Informatica ETL wif focus on Banking, Insurance, Retail and Pharma.
• Over 5 years of experience in Data Modelling, Business Analyst, Business Intelligence, Architecture, Data presenter & Architect and administrator of cloud services (AWS, Talend, Informatica Power center, MDM) etc.
• Over 5 years of experience leading Data warehouse applications' build/maintenance around the globe.
• Has good industry exposure wif Informatica/Talend/Data stage ETL, Unix, Hive/EMR, Python and Mainframes.
• Working on the multiple projects comprises Talend Open Studio, Informatica and its associated technologies.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat files and databases like Redshift, Oracle, DB2.
• Excellent knowledge of CDC, OLTP and OLAP Systems, developing Database schemas - Star and Snow-flake schemas.
• Extensive experience on Cloud technologies like AWS Console, S3, Salesforce, MDM, Hive, EMR etc
• Ability to work efficiently, quick learning & working to fulfil project needs

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Engineer

Responsibilities:

• Design Data stage jobs for business data flow and integration Handling weekly status meeting wif the overall team, Line of business and updating status of the tasks. Analyzing the business functionalities of the existing modules of Customer information system Preparing unit test cases and unit test results
• Performing reviews and ensure the overall quality of the project Establish "Best Practices" and plan for continuous improvement of processes and Proactive Critical job monitoring Taking back - up of those data for analytical purposes. Taking part in discussions wif the Subject Matter experts of Source and
• Target systems and IT Teams in understanding the overall requirements. Data Lineage and CSI, Ontime data (business) delivery and Prepare Reusable repositories.Technologies: Talend studio, Ab Initio, Geneos ITRS, Oracle, NDM, Mainframes, Stored procedures, Autosys, Linux, MQ

Confidential

Sr. Data Analyst

Responsibilities:

• Supporting the 30+ J&J Applications for the smooth data transition between source to target. Testing all the modules involved in Automation and Global pricing applications. Analyzing the functionalities of existing Jobs and preparing the scope for the Job Automation Analyzing the business functionalities of the existing and prepare equivalent easier and quick response for the same Developing jobs to extract data from source table and jobs to perform calculations of the running applications Handling daily status meeting wif Stake holders
• Development team, and offshore. Creating the high - level documentation for the frequent list of abends and resolutions Performing reviews and ensure the overall quality of the project Implement the changes in Production by casting the packages and provide post implementation support Establish "Best Practices" and plan for continuous improvement of processes. Providing Application knowledge to entire team and leading the overall project

Technologies: Talend data integration, Informatica Power Center & MDM, LINUX, Python, AWS Console, S3, Hive, Salesforce, Teradata, Oracle, Redshift, SQL Server, Tableau, Qlik sense.

Confidential

Sr. Data Engineer & Business Analyst

Responsibilities:

• Analyze the migrated data using IBM info - sphere Data stage for completeness Taking part in discussions wif the Subject Matter experts of Source and Target systems and IT Teams in understanding the overall requirements.
• Performing reviews and ensure the overall quality of the project Implement the changes in Production by casting the packages and provide post implementation support
• Establish "Best Practices" and plan for continuous improvement of processes. Providing Application knowledge to entire team and leading the overall project

Technologies: Talend data integration, Informatica power center, Datastage 9.1, Oracle, DB2, SAS, Python, Informatica power center, UNIX, Tableau

Confidential

Sr. Data Engineer

Responsibilities:

• Learning the mapping of the exact fields from the source system to the corresponding fields in the BB&T system. Testing all the modules involved in conversion related to Credit cards. Developing jobs to extract data as per business requirement and Load credit card details to BB&T database. Taking part in discussions wif the Subject Matter experts of Source and
• Target systems and IT Teams in understanding the overall requirements. Data stage jobs for business data flow and integration Handling weekly status meeting wif the overall team, Line of business and updating status of the tasks. Analyzing the business functionalities of the existing modules of Customer information system Developing jobs to extract data from source table and jobs to perform calculations required to find corporate data.
• Handling weekly status meeting wif the overall team, Line of business and updating status of the tasks Creating the high - level Technical Specification documents for each module which will has the business functionalities Analyze the migrated data using IBM info-sphere Data stage for completeness Taking part in discussions wif the Subject Matter experts of Source and Target systems and IT Teams in understanding the overall requirements

Technologies: Talend data integration, Informatica PC, Oracle, SQL server, DB2, Mainframes, SAS, Python, Tableau, UNIX

Confidential

Sr. Data Engineer (offshore)

Responsibilities:

• Design Data stage jobs for business data flow and integration Taking back - up of those data for analytical purposes. Taking part in discussions wif the Subject Matter experts of Source and Target systems and IT Teams in understanding the overall requirements.
• Handling weekly status meeting wif the overall team, Line of business and updating status of the tasks. Analyzing the business functionalities of the existing modules of
• Customer information system Preparing unit test cases and unit test results Performing reviews and ensure the overall quality of the project Establish "Best Practices" and plan for continuous improvement of processes.

Technologies: Talend data integration, Data stage 9.1, Oracle, DB2, Mainframes, Stored procedures, Autosys, Linux