SUMMARY

• 7+ Years of IT experience with expertise in Data Warehouse Process involved in Analysis, Design, Development of various business applications, different platforms using Informatica Powercenter 10.2.0/9.5.1/8.6 , Oracle 11g, Teradata 16, Tableau, Infoworks 2.6.5.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow &Worklet Designer and Tableau.
• Prepared dashboards using calculated fields for different logics for trends, parameters, calculations, groups, sets and hierarchies in Tableau.
• Expertise in optimizing the session performance by eliminating performance bottlenecks by optimizing target, source, mapping, transformations, session, grid deployment and optimize the system
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Extensively worked with Teradata utilities like BTEQ, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Expertise in Database Design, Entity-Relationship modeling, Dimensional data modeling, Star schema modeling, Snowflake modeling, Data Normalization. Experienced in integrating various data sources/targets like Oracle, Teradata, SQL Servers, B2B, DB2, Fixed Width delimited Flat Files & XML Files.
• Experience in preparing Tableau reports on Capturing daily trends in Drug, Claim, Plan, and Member data.
• Experience on both UNIX and Windows platforms. Extensive experience in creating UNIX Shell Scripts.
• Experience in scheduling Informatica jobs using external job schedulers like IBM Tivoli Workload Scheduler .
• Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
• Good understanding of Project Life Cycle and gathering requirements for ETL Development.
• Strong experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions.
• Experienced in interacting with Business users in analyzing the Business process requirements and transforming them into documents, designing, and rolling out the deliverables.
• More than one year of comprehensive experience in Big Data processing using Hadoop (Infoworks) and its ecosystem (MapReduce, Hive and HDFS).

TECHNICAL SKILLS

ETL TOOLS: PowerCenter10.2.0,PowerExchange9.5/9.1,Teradata SQLAssistant, Teradata Manager

Data visualization: Tableau

DATABASE EXPERIENCE: DB2Oracle 11g/10g/9iTeradata 12.0/13.0/14.0/15.0/16.0

LANGUAGES: C, C++,UNIX Scripting, PL/SQL,SQL

DB TOOLS: Toad, Sql developer,Infoworks,SQL Assistant

Version Control: Gitlab

Big Data: Hadoop, HDFS, Hive, Infoworks.

PROFESSIONAL EXPERIENCE

Confidential

Developer

Responsibilities:

• Preparing AAD document from requirements provided by business and external client.
• Create LLD technical document which includes process flow, data model, STT logic, Error handling techniques, Physical design (File, table, Mapping, Bteq and script detail) and Batch Scheduling details.
• Implementing Multiple File to landing Informatica workflows calling Teradata utilities.
• Developed complex bteq’s to profile incoming data coming from various adjudication systems
• Implemented SCD Type II and type I using Bteq’s and Informatica workflows.
• Wrote UNIX shell scripts to validate incoming files and perform file auditing before loading into tables.
• Created tableau dashboards to display claim count for combination of Drug name, Drug Form code and Drug strength which will help business to identify right NDC.
• Developed stored procedure to in corporate split batch process.
• Developed shell scripts to disable or enable constraints in tables and truncating the tables to avoid fragmenting the database table due to frequent deleting of the records.
• Wrote UNIX shell Scripts to put or get files from external servers using SFTP/FTP.
• Created UNIX scripts to send Notification to users whenever there is delay and if there are unresolved records in error table.
• Send request to scheduling team to create new schedule/Jobs to run daily/weekly/monthly.

Environment: Informatica Power Center 10.2, Tableau, Teradata, Oracle 12g, PL/SQL, UNIX shell scripting, TOAD, Teradata utilities, SQL, Flat Files, GITLAB, SQLAssistant, IBM scheduler.

Developer

Confidential

Responsibilities:

• Involved in the analysis of the Business requirements from Envolve and identifying the sources for CAG and Benefit data.
• Prepared the technical spec document and reviewed with SME and PO.
• Developed Bteq’s involving all CLIENT, ACCOUNT and PLAN base tables to extract client specific data as per requirements
• Developed Informatica Mapping and workflows to generate the extracts for CAG and plan data separately.
• Developed UNIX scripts to SFTP the extracts to Envolve and archives the extacted files.
• Reviewed the Bteq’s with DBA’s for identifying any bottlenecks beforehand.
• Responsible for Migrating these objects using DevOps process (GITHub).
• Meet QA team to Walkthrough the test process and review the test cases and corresponding results.
• Scheduling New batch Jobs using Tivoli and hand it over to Production support team
• Providing Warranty support for all the projects that are implemented.

Environment: Informatica Power Center, Teradata, Oracle, PL/SQL, UNIX shell scripting, TOAD, SQL, Flat Files, Teradata utilities, VISIO, GITLAB, IBM scheduler, SQLAssistant.

Confidential, NJ

Developer

Responsibilities:

• Requirement gathering from Business and Internal Teams and Coordinated with the Business users to understand business needs and implement the same into a Datawarehouse design.
• Work closely with project Business Analyst, Data Modeler and BI Lead to ensure that the end to end designs meet the business and data requirements
• Developed ETL mappings, Transformations and Load plans using Informatica and Teradata load utilities like mload, tpt, fast loads and BTEQ.
• Used Informatica to extract data from source files (Flat ) and load the data into the landing database
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations.
• Written shell scripts in UNIX to execute the workflow, to send the automated email confirmations and to perform archiving process of source files.
• Used TIVOLI tool for creating new schedule that runs daily to send extracts to ESL/COS/Digital teams.
• Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment schema and data models.
• Responsible for submitting DBA requests, following up with data base DBA’s and Informatica administrators, handling all the signoff’s for the production, updating all changes with new versions using Serena Migration tool.
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.

Environment: Informatica Power Center, Teradata, Oracle, PL/SQL, UNIX shell scripting, TOAD, Teradata utilities, SQL, Flat Files, Erwin, Serena, IBM scheduler.