Soumya Chandupatla

ETL Developer

Various Clients

07.2015 - 07.2022

Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large-scale Data warehouses by Using Informatica Power Center 10.4/10.1/9.6.
Experience in creating High Level Design and Detailed Design in the Design phase.
Experienced with industry standard methodologies like Agile, Scrum and Waterfall methodology within the Software Development Life Cycle (SDLC).
Developed complex mappings using various transformations.
Experienced working on various databases like Oracle 12c/11g/10g, SQL Server, XML, Flat Files, Teradata and Netezza.
Created and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Partitions.
Worked on optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets, SQL scripts and triggers and PL/SQL stored procedures.
Worked with AWS services such as Redshift for data warehousing and S3 for staging files in a cloud based analytics pipeline.
Experience in Oracle database Performance Tuning of SQL statements and in SQL
Loader Imports/Exports.
Experienced in Creating folders, Groups, Roles, Users in Admin console and granting them permissions.
Strong conceptual skills in Data Warehousing Concepts like Star Schema and Snowflakes Schema methodologies used in relational, dimensional modeling and multidimensional modeling.
Implemented Data extracting, Data profiling, Data cleansing, Data integration, Data transformation and loading into Data marts using Informatica.
Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
Designed and developed UNIX shell scripts as part of the ETL process to automate the data load processes to target and created Post UNIX scripts to perform the operations like copy, remove and touch files.
Expertise in using Scheduling tools like Informatica Job Scheduler, Control-M, Tidal, Autosys to automate running of Informatica Workflows on a daily/ weekly/ Monthly Batch Jobs.
Worked extensively on JIRA for issue tracking and project management.
Successful code migration from Development to Testing & Production environment.
With both On-site and Off-shore model experience have developed skills in system analysis, troubleshooting, debugging, deployment, Team management, prioritizing tasks and customer handling.