SUMMARY:

8+ years of experience in Information Technology with strong expertise in Data Warehousing, Analysis, Cleansing, Profiling, Reporting in various domains like Financial Services, Insurance, Healthcare, Wealth Management. A good team player with excellent communication skills and technically adept.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.x/9.x, AWS Stack (Glue, Lambda, Athena)

BI Visualization Tools: Tableau, Excel

Data Modeling: Dimensional Data Modeling - Logical & Physical data modeling, Star & Snowflake schema, OLAP & OLTP systems

Databases: Oracle, SQL Server, Teradata, DB2, PostgreSQL, Redshift

Languages: SQL, PL/SQL, UNIX Shell Scripting, Python

Tools: Teradata Studio, Putty, SQL Developer, Autosys, ESP, Visio, CA Workload Automation

Version Control Tools: SVN, Git

CI/CD Tools: Jenkins, Harness

Environment: UNIX, Windows, AWS Cloud

Others: Agile, Waterfall, Microsoft Office, JIRA, Rally, Confluence, Performance Tuning, Debugging

WORK EXPERIENCE:

Confidential, Columbus, OH

Specialist, IT App Development

Responsibilities:

• Involved in requirements gathering, translation of business requirements to technical specifications
• Worked as SME on delivering three major applications for Connected car program with Ford and Toyota, Customer communication Texting, Smart Ride mobile program in AWS Cloud
• Handled AWS Cloud implementation and set up of ETL architecture for Smart Ride Mobile Program
• Worked in a highly competitive Agile scrum team with extensive iteration planning and deliverables of features
• Collaborate and communicate with RA, Tech Keys and cross-platform developers of Java & Mainframe in integrating and implementing ETL solutions in Smart Ride projects
• Created Lambda functions and set up triggers to read and load data to specified sources from S3
• Used AWS Glue crawlers and developed scripts as per ETL requirements to extract and load data to staging area
• Experience working in Athen querying service and updating the tables
• Part of design and implementation of logical and physical data models to define the needs of application
• Perform data source analysis, data sourcing specifications, ETL design and implementation for JSON, Parquet and Flat file from Amazon S3
• Created complex mappings to load data from various sources into operational data store using Informatica on on-prem applications
• Developed SQL scripts and procedures as per business requirements
• Automated batch jobs using shell scripts
• Implemented quick and efficient defect fixes that reduced the incident tickets by 50%

Confidential, Fremont, CA

Application Developer Analyst

Responsibilities:

• Used Informatica Power Center as ETL tool on data warehouse application IHUB (Information HUB)
• Created complex mappings using Source Qualifier, Expression, Joiner, Connected/Unconnected Lookup, Sorter, Aggregator, Filter, Update Strategy and Router transformations for populating target tables in efficient manner
• Extensively involved in performance tuning of the Informatica ETL mappings to reduce run times
• Used Informatica Power Center for extraction, loading and transformation of data in the Data mart
• Worked on several workflows/worklets/sessions associated with the mappings across various data sources like Flat files, SQL Server, Oracle and Teradata
• Extensively worked with Slowly Changing Dimensions Type 1, Type 2
• Developed Unix Shell Scripts for automation of ETL process and scheduled automated jobs to run on daily basis using Autosys Scheduling Tool by writing JIL codes
• Involved in doing error handling, debugging, and troubleshooting sessions using the Session logs, Debugger, and Workflow Monitor
• Supported migration of ETL code from lower to production environments
• Provided production support on On-Call basis and supported several defect fixes in production

Confidential, Frisco, TX

ETL Developer

Responsibilities:

• Involved in building the ETL framework using Informatica 9.6.1/ 9.5.1 and Source to Target mapping to load data into Data warehouse
• Developed complex workflows using joiner, aggregator, update strategy, expression, rank transformation based on business logic required
• Prepared automated workflows to load clinical data into targeted data mart tables for reporting purposes
• Providing periodic update to customer on the coding, unit testing, release and act as Coordinator between development and business team
• Created Stored procedures, collections and packages
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy etc.,
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer and Designers
• Developed automation scripts to integrate the process
• Scheduled automated jobs using CA workload automation tool
• Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases

Confidential

Developer

Responsibilities:

• Worked on collecting and documenting requirements
• Created mapping documents to outline data flow from sources to targets.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extracted data from Flat files, DB2 and Oracle to data warehouse
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.