SUMMARY:

• Confidential has around 13 years of experience in Information Technology and currently performs the role of Architect at Confidential .
• Expertise in leading, architecting and implementing end to end ETL, BigData, Cloud, Data warehouse & BI Solutions.
• Played as a liaison between Business and IT team in transforming Data/Reporting requirements to build software solutions
• Expertise in Hadoop/BigData concepts and APACHE tools like SQOOP, PIG, HIVE and FLUME.
• Good knowledge about AWS cloud - S3, EC2, GLUE, Redshift, DynamoDB, Amazon RDS, VPC, Security Groups, Lambda, Athena, Lake Formation Service, Encryption.
• Designed Data Lake in AWS S3 to integrate data from multiple systems and enable cross system analytics.
• Owns the Informatica product tower for a Confidential 100 company and part of the enterprise architect team for defining enterprise solutions and product selection.
• Expertise in building enterprise data warehouse and designing ETL solutions for data ingestion.
• Excellent Relationship Management skills, with the ability to conceive profitable and efficient solutions utilizing technology.
• Highly skilled in performance tuning of ETL pipelines by fine tuning the mappings, sessions, database, Unix/Linux servers and storage devices.
• Hands on experience across different areas in project development like requirement gathering, designing, unit testing, system testing, scheduling and deployment.
• Proficient in building ETL processes using Teradata and Informatica (8.6,9.1,9.6,10.2) to load and maintain the enterprise wide Data warehouses
• Expertise in Data Modeling: Conceptual, logical and Physical
• 5+yrs of expertise in agile projects and very familiar with agile ceremonies
• Expertise in building CI-CD solutions for ETL code migrations using Gitlab and Ansible.
• Developed multiple reusable codes for deployment across ETL projects.
• Very good knowledge on Insurance (LOMA certified), Healthcare and Retail Domain.

TECHNICAL SKILLS:

Languages: Python, SQL, UNIX Shell Scripting, Windows Batch

Database : Teradata, Oracle, SQL server, DB2 UDB, HIVE

Cloud Service Providers: Amazon Web Service (AWS), AZURE

ETL tools: Informatica PowerCenter, Informatica Power Exchange, Informatica Data Validation Option, Informatica Proactive Monitoring, Informatica Data Quality

Dev-Ops Tools : Jenkins, Gitlab

Hadoop Tools : SQOOP, PIG, HIVE,PYSPARK and FLUME

BI Tools: PowerBI, Business Objects and Crystal Reports

Teradata Tools : Teradata Administrator, Teradata Performance Monitor

Teradata Utility : Teradata utilities like BTEQ, Fastload, Multiload, and Fastexport.

Domain: Insurance, Retail, Healthcare

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Developer

Responsibilities:

• Define solutions for integrating data from various data systems and loading to on premise and cloud data stores.
• Product owner for Data Integration tower and provides guidance to enterprise for tool adoption, automation and monitoring.
• Contributor to enterprise wide programs for AWS cloud adoption, platform modernization and help setting long term vision
• Designed Data DevOps (CI/CD) for ETL code migration using Gitlab and Ansible tools
• Ensure compliance with all architecture directions and frameworks including technical, security, and regulatory standards
• Designed AWS Data Lake (s3) to provide a platform for analytics. Used Lake Formation service and KMS encryption to control the access to data.
• Integrated data to hadoop cluster (Data Lake) from various relational data systems using SQOOP and transformation using Pyspark
• Assist the Enterprise Architecture team in the development of future state information architecture strategy.
• Hands on experience in fine tuning ETL data pipelines by resolving the bottlenecks at mappings, sessions, database, Unix/Linux servers and storage level.
• Design and Develop ETL data pipelines in AWS glue after considering the ETL best practices.
• Modernize financial data flow pipelines by replacing legacy Informatica+DB2 solutions with SPARK+HIVE solution.

Informatica Architect/ Administrator

Confidential

Responsibilities:

• Installed and Configured Informatica PowerCenter and PowerExchange 9.6, 10 in AIX/LINUX.
• Setup Informatica PowerCenter High Availability and Grid on a platform that process 5billion records in a day.
• Developed automated solution for migrating 120+ ETL applications from HP-UX to RedHat Linux.
• Designed log analytic solutions by injecting Informatica system logs and job logs to ELK for effective alerting and dashboard reporting.
• Highly skilled in performance tuning of Informatica ETL process and go-to person for issues that get attention of senior leadership
• Developed automated solutions for PowerCenter installation, Configuration, Administration (Backup, Monitoring, Housekeeping and Recycle)
• Developed multiple PowerBI dashboards to identify long running workflows and jobs rejecting more records.

ETL Designer/ Data Architect

Confidential

Responsibilities:

• Worked with business, IT architects and SME’s to model tables in Claim Datawarehouse (CDW) considering the needs for ETL process and reporting.
• Designed multiple claim data flows that consolidate data from multiple 3 rd party systems to enterprise warehouse.
• Worked with business stakeholders to design BI reports
• Lead a team of 15+ associates to maintain the data integrity in claim Datawarehouse.
• Lead the transition of 40+ applications that deals with Claim Datawarehouse from a different vendor to Cognizant.
• Innovation Lead: Develop Re-usable objects for Data balancing, Data integrity and Error processing.

Onshore project Lead / Data Modeler

Confidential

Responsibilities:

• Worked with SME’s, business analyst, business users and implemented end to end ETL solution (green field project) for loading ODS of a leading insurance company in HongKong.
• Build ODS for P&C data and General Insurance data with an innovative ETL solution to handle late arriving dimension. This design brought an additional business of 1million to Cognizant.
• Modeled an Operational Data Store (ODS) with Party, Policy and Claim domain with 50+ tables.
• Lead the delivery of ETL projects using best practices like Error Processing, Auditing, Data Validation, Restartability and Monitoring.
• Performance Tuning of Informatica ETL jobs by applying various techniques at server, network, storage ETL code and Database side.
• Technical Lead in sales proposal: Provide technical solutions for new Data Integration engagements in Asia (HongKong, Singapore and Malaysia).

ETL Project Lead / Designer

Confidential

Responsibilities:

• Design ETL solutions to load/read data from Datawarehouse/ODS by applying ETL best practices like auditing, error processing.
• Developed 500+ Informatica PowerCenter and PowerExchange workflows for data movement between databases like Teradata, Oracle, UDB.
• Developed Teradata BTEQ, FastLoad, FastExport and MultiLoad scripts for loading data to Datawarehouse.
• Worked with Type 1 and 2 dimensions, fact tables, star schema design, Operational Data Store (ODS) and other data warehouse concepts.
• Informatica/Teradata Corporate Trainer: Train, Evaluate and deploy the new joiners to various data warehousing projects.
• Lead teams with a size of 20+ for Insurance and HealthCare customers.
• Leading, training & monitoring the performance of team members to ensure efficiency.
• Develop Re-usable objects for Data balancing, Data integrity and Error processing.

Teradata Developer

Confidential

Responsibilities:

• Build efficient ETL mappings for processing fact and dimension tables with complex transformations and type 1, type 2 changes.
• Develop Teradata BTEQ, FastLoad, and MultiLoad scripts to load data to Teradata database.
• Co-ordinate with the testing team for system testing, business users for user acceptance testing and production control team for the production deployment.
• Performance tuning of ETL process by addressing the bottlenecks at Database, ETL code, server and storage layer.
• Conducted design and code reviews and extensive use of standards, best practices, and ETL procedures.
• Coordinated with all the concerned parties (Database team/Project Teams/Application Team) in trouble shooting issues and worked with support team for business critical issues.
• Developed business flow diagrams, Activity/State diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
• Train and mentor new joiners in team.