VINAY KUMAR TEDLA Little Rock, Arkansas -*****

816-***-**** adiv6j@r.postjobfree.com

www.linkedin.com/in/vinaytedla

Analytical software developer who possesses strong knowledge of Informatica Power Center, SQL and a self-directed leader who fosters a collaborative and supportive team environment. Skilled at technical leadership, communication and presentations and experienced a full project development life cycle from design to implementation to integration.

Skills

Programming Languages: SQL, UNIX/Linux, Shell Scripting, PL/SQL.

Tools: WinSCP, Tortoise SVN, Service Now, Power BI, SQL Developer, Data Studio, JIRA, Opcon Enterprise.

Databases: MySQL, DB2, Oracle, SQL Server.

ETL Tool: Informatica Power Center, Informatica MDM.

Experience

Deloitte Little Rock, AR

Sr. ETL Developer, Aug 2019 – Present

•Worked on robust framework application project called ARIES handled by State of Arkansas for ensuring Medicaid, SNAP and TEA benefits for state of Arkansas people by migrating the heterogeneous data settled in various legacy systems for 30 years to brand new cloud architecture-based framework called Next Gen.

•Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data.

•Built and maintained SQL scripts, complex queries for benefit match data analysis after conversion of data.

•Automated Informatica runs through OpCon Enterprise configurations and made feasible for smooth batch runs.

•Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.

•Effectively developed mappings, Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

•Effectively worked on Informatica MDM console to crate Master Data merging data from multiple legacy systems.

Educational Testing Services Princeton, NJ

Software Developer II, Feb 2017 – Aug 2019

•Worked as part Data Quality Services team to ensure quality of data passage across upstream and downstream systems.

•Developed and maintained data marts on a student data warehouse to support TEXAS STAAR Project.

•Communicated with business customers to discuss the issues and requirements.

•Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.

•Involved in extracting the data from the Flat Files and Relational databases into staging area.

•Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.

•Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.

•Production Support has been done to resolve the ongoing issues and troubleshoot the problems.

Tech Observer Ewing, NJ

Developer Intern, Aug 2016 – Feb 2017

•Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.

•Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load.

•Installed and Configured the Informatica Client tools.

•Designed the procedures for getting the data from all systems to Data Warehousing system.

•Created the environment for Staging area, loading the Staging area with data from multiple sources.

•Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.

•Used workflow manager for session management, database connection management and scheduling of jobs.

•Created UNIX shell scripts for Informatica ETL tool to automate sessions.

•Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.

Education

MASTER OF SCIENCE, COMPUTER SCIENCE

UNIVERSITY OF CENTRAL MISSOURI WARRENSBURG, MO Dec 2016

•Recipient of Global STEM Scholarship, Merit Scholarship and Computer Science Achievement Award.

BACHELOR OF TECHNOLOGY, COMPUTER SCIENCE,

JAWARHARLAL NEHRU TECHNOLOGICAL UNIVERSITY INDIA MAY 2015

•Recipient of Best Student Award 2015.

Contact this candidate