BHANU TEJA

Proactive ETL developer with 5.6 years of experience carefully handling and transforming data loads to suit customer needs. Versed in all dominant information modeling designs and mapping technologies. Dedicated to flawless ETL integrity and impeccable data security during all database maintenance and modification tasks.

DataStage, Informatica Developer & Datastage Administrator, Mercedes Benz, 2019, 2021:

• Primarily responsible for integration data from different geographical regions to Business Data warehouse.
• Collaborated with Data Architect to gather requirements, conduct analysis on data and prioritize requests.
• Developed new technical specifications from functional specifications.
• Designed, developed job sequences to run multiple jobs, Documented ETL Process following the standard naming conventions, business vocabulary, transformation rules and related enterprise consistency specifications
• Used Restart able option to re-run the sequence from the point at which it left off, Developed changes on existent DataStage Jobs and sequences regarding manager needs.
• Created new DataStage Jobs and sequences for data validation to detect inconsistency on the data loaded by existence ETL process using different stages in DataStage like link collector, join, merge, lookup, remove duplicates, filter, dataset, transformer, aggregator.
• Developing ETL processes using DataStage Designer to capture reject rows, to control figures and to data comparisons between source and target Data Bases like transactional data bases, staging area, transformation area, ODS and Datawarehouse.
• Solve execution incidents on the processes developed in DataStage, Find the root cause of data inconsistency loaded by ETL process developed in DataStage.
• Completing information load by executing jobs manually if needed.
• Unlock DataStage Jobs and run queries using DataStage Console, Analyze processes to suggest improvements thereof, Administration of BI tools, DataStage 11.7 Infosphere 11.7.
• Manage production servers on the DSS area on UNIX servers, Unlock DataStage Jobs and run queries using DataStage Console.
• Maintain, monitor, and manage systems in productive use, Maintain and update the knowledge database, technical documentation, and user manuals.
• Create release jobs to use them on production environment, Re-compile Jobs to improve the performance on process already done.
• Purge jobs log manually when the automatic purge component failed.
• Create new projects, configure environment variables, set permissions and role user, do all the project setting using DataStage Administrator.
• Running scripts to create tables in the Datawarehouse on production environment.
• Analyze data loaded by the ETL's process looking for data inconsistency.
• Used the DataStage Director and the runtime engine to schedule job execution, testing and debugging its components and monitoring jobs, Set parameters in DataStage ETL Process

DataStage Developer & Lead, OPTUM UHG, 2021 Dec,

• Present, Responsible for the analysis of the user stories created by client and estimate the story points required for the completion and assign to the other team members.
• Working as lead and making sure that every sprint is running without missing any SLA.
• Developed new technical specifications from functional specifications, Designed, developed job sequences to run multiple jobs.
• Implemented Python scripts for Airflow scheduler to run and maintain DataStage jobs, Monitoring jobs and identifying bottlenecks in the data processing pipeline.
• Testing and troubleshooting in ETL system design and processes.
• Providing support to customers about issues relating to the storage, handling and access of data.
• Develop the logic to load the dimensional tables to Teradata.
• Creating mapping documents for the new as well as old batches.
• Provide technical assistance to team and evaluate all codes whenever needed.

I hereby declare that the above written particulars are true and correct to the best of my knowledge and belief.

• Received star performer award for best performance within the project team.
• Received Titan award for the best performance within the project account for two consecutive years