SUMMARY

• Have 9 + years of experience in Data warehousing technologies with Snowflake, Informatica and Business Objects tools.
• Around 2 years of experience in Snowflake.
• Have expertise on Requirements Gathering, Analysis, Design, Development, Implementation, preparing test data, Unit testing support and ETL for Data warehousing applications for various business sectors.
• Experience in copying data using SNOWSQL
• Experience in Creating Database Objects, loading and querying CSV and JSON data from S3 bucket to snowflake.
• Have experience with tasks, Streams, time travel and creating Snow Pipe.
• Experience in creating User Roles, giving Privileges to roles.
• Experience in Banking and financial Services, Marketing and Sales and Life Sciences Domain in large Data warehousing projects using Informatica, Business Objects and Oracle technologies.
• Extensively worked on data extraction, Transformation and loading data from various sources.
• Expertise in working in production support issues and handling the issues within breech limit.
• Experienced in interacting with Business users in analyzing the Business process requirements and transforming them into documents, designing and rolling out the deliverables.
• Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which include loading JSON and Parquet formatted data into snowflake tables.
• Experience in creating effective test data and development through unit test cases to ensure successful execution of data.
• Expert in ETL tools like Informatica and Reporting tools like Business Objects. Have extensive experience in working with various Extract Transformations and Load jobs.
• Experience in SQL scripts to perform necessary business transformations and operations on the data.
• Deploying objects across various environments using static and dynamic methods from test, UAT, and finally to production environment
• Experience in Error Handling and Troubleshooting Techniques using various log files.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Possess excellent written and oral communication skills, along with the ability to multitask and prioritize goals.
• Established myself as an effective leader and communicator with strong interpersonal, technical, leadership, analytical skills, Quality Process and Project Delivery.
• Efficiently trained new team members on Informatica and snowflake.
• Strictly adhere the quality processes (Organization specific) and other project specific processes (client specific).
• Enthused in learning and upgrading technical and management skills.
• Experience in Azure Data Factory and Talend

TECHNICAL SKILLS

Cloud Computing: Snowflake, AWS (S3)

ETL Tools: Informatica Power Center 8.5,9.1

Reporting Tools: Business Objects

Databases: IBM DB2, Oracle, SQL Server, NETEZZA

Languages/Technologies: Shell scripting, SQL, PL/SQL, SnowSQL, Unix,Linux, Basics of Python and java

Operating Systems: Linux, Windows

PROFESSIONAL EXPERIENCE

Confidential

Snowflake Developer/ETL

Responsibilities:

• Understanding the existing process by conducting multiple KT sessions between offshore and onshore
• Creating Views and Stored procedures to load data in Snowflake
• Worked on many production issues
• Used Timetravel and Clone utilities in Snowflake for validating and fixing production issues.
• Updating the GIT with the updated views and procedures.
• Used Jira to assign tasks and tickets.
• Assisted in verifying data and validating fixes in production.
• Involved in Client meetings to understand the issues in the Medicare center applications

Confidential

Snowflake Developer

Responsibilities:

• Created Internal, External stage for data load.
• Involved in Copying the data from internal and external stages into Snowflake by using SNOWSQL and Snowpipes.
• Involved in creating Streams and Tasks
• Experience in using Timetravel and Clone utilities
• Creating Refine queries and Refine procedures
• Created Snow pipe for continuous load data and used copy command to load the data.
• Involved in migrating data from SQL server to Snowflake
• Assisted in verifying data and validating fixes in migration.

Confidential

Snowflake Developer

Responsibilities:

• Created Databases, Schemas and tables on Snowflake as per the business needs.
• Once the data is loaded into the tables, I have validated the data from source systems to Snowflake Data Warehouse cloud platform.
• Experience with Snowflake Multi - Cluster Warehouses.
• Experience in building SnowPipe.
• Participated in daily meetings and used to coordinate with different cross functional team in the organization. knowledge of Data Sharing in Snowflake.
• Experience in using Snowflake Clone and Time Travel.
• Understand the existing ETL in Informatica and rewrite using snowflake.
• Built streams to keep track of data whenever there is any update and insert, DML changes in the target table.

Confidential, TX

ETL PLSQL Developer

Responsibilities:

• Participated in Requirement Gathering data and converting them into detailed logic flow.
• Provided the documentation and captured all the Unit test cases.
• Involved in the Technical design phase took ownership for few resources all the way through development, unit testing and production support migration phase.
• Implemented UNIX shell scripting to validate and update the xml file downstream.
• Involving in Extraction of data from mainframe, db2, Oracle, Dataset/Flat Files.
• Performed ETL coding, extensively used stages available to design and perform the required integration.
• Experienced in loading data in the form of xml using the XSD design, DB2, Flat files, datasets, Hierarchical stage, FTP and SFTP.
• Creation of Sequencer Jobs and parallel and server routines.
• Worked SCDs to populate Type I and Type II slowly changing dimension tables from several operational source files
• Implemented Shared container for multiple jobs and Local containers for same job as per requirements.
• Experienced in developing parallel jobs using various Development/debug stages (Peek stage, Head & Tail Stage, Row generator stage, Column generator stage,Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)
• Used the DataStage Director for monitoring the running jobs and viewing the job logs and scheduling the jobs.
• Successfully implemented pipeline and partitioning parallelism techniques and ensured load balancing of data.
• Environment: IBM Data stage 11.5 data warehousing, SQL server, WINSCP, PUTTY and UNIX, ORACLE

Confidential

ETL/PLSQL Developer

Responsibilities:

• Played the role of Sr ETL Developer. Interacted with Users to understand Business requirements. Extracted Source (XML, text, CSV and XLS file) Data using Informatica tool, Stored procedures and packages from Source Systems and also involved to load multi source data into single target.
• Designed various mappings using transformations like Lookup, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, Expression and XML Parser Transformation.
• Involved in Creation and also enhancement of mappings using Informatica data integration technology to Extract, Transform and Load data.
• Developed mapping which involved parameters and variables.
• Ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• Test Cases and test data Preparation, Execution using Informatica and SQL Developer/Toad.
• Has played a vital role in design review and has contributed to the preparation of Low Level Design documents and Technical specifications as part of ETL development process.
• Coding, Unit-Testing and Component-Testing of Informatica mappings.
• Preparation of various technical and functional documents (where applicable depending on the request types), Component Test cases Document, Code Review Checklist, Checklist for Test Case Preparation and Template for Unit Test case document.
• Have responsibilities to understand Client Processes and to work efficiently to meet targets and deliver solutions in accordance business practices and procedures.
• Played a vital role in support activities by resolving the issues with in no time and gained client belief and appreciations
• Peer review (Mappings/Mapplets/Workflows)