Job ID: SRJ_6331Posted: Location: Atlanta, GA, 30377; Richmond, VA, 23218; Addison, TX, 75001; Chicago, IL, 60691Employment Type: Full TimeIndustry: Computer SoftwareClient: WiproContact: Bharath Gampa, Ram MaddulaCompany: SRI Tech SolutionsRole ETLJob Type : Full-Time Location : Location : Atlanta, GA/Richmond, VA/ Chicago, IL / Addison, TX (one of the mentioned is ok)Position Summary:The role is responsible for the design, development, coding, testing, debugging and documentation of data-warehouse/database/business intelligence applications.Duties include hands-on new development as well as support, maintenance, or enhancement of existing applications.Translate business requirements into technical specifications.Design and implement ETL (Informatica) process using SQL, ETL tool and Linux shell scripting to deliver high quality solutions.Strong data analysis, advance SQL query writing skill and resolving the defects by working across multiple teamsCollaborate with other development teams to manage interdependency, set up test cases, debug and maintain data quality.Ensure software stability via documentation, code reviews, regression, unit and user acceptance testing.Hands on logical and physical data modeling and database design responsibilities. Good understanding of Dimensional modelingBe able to lead and develop Informatica PowerCenter ETL complex flows connecting to heterogenous database such as oracle/MS SQL server.Develop complex oracle procedures ,functions, and packages to support database applications(API calls / DW reporting )Conduct both proactive and reactive performance tuning activities during course of development of new applications and existing legacy applications. Hands on experience to develop and support Unix Shell Scripting.Should have understanding of scheduler (Autosys)Perform data analysis and data profiling. Identify data quality Mandate to have submission with the below table filled out – should include as self-rating on each parameter b/w 1 to 10 and number of years of exp on each. A brief write up on each skill is a must too.InformaticaPL SQL & writing/optimizing advanced SQL queriesData/Business analysisUnix shell scriptingPython expUnderstanding and comfortable troubleshooting complex oracle procedures, functions, and packagesVertica DB ExpAgile/Scrum methodology/routinesData Federation or vendor tools like Starburst exp·
ETL in richmond at Unknown Company
This position is listed as full time and onsite.