Job ID: SRJ_6331Posted: 2024-07-31Location: 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·
...global theme park destinations, consumer products, and experiences. We own and operate leading entertainment and news brands, including NBC, NBC News, NBC Sports, Telemundo, NBC Local Stations, Bravo, and Peacock, our premium ad-supported streaming service. We produce and...
...Job Description Job Description HVAC SERVICE MANAGER FIELD & OFFICE OPERATIONS Run Rite Mechanical is seeking an experienced, hands-on HVAC Service Manager to oversee our service department and support our technicians in the field. This is not an office-only...
...Job Description Job Description Senior Travel Coordinator Healthcare Staffing We at Palm Health Resources, a Growing National Healthcare Recruitment Staffing Firm, are hiring a Travel Coordinator for our growing firm! The Travel Agent is responsible for coordinating...
...for outstanding service, strong leadership, and a team-first culture, we are growing rapidly and looking for an experienced HVAC Service Manager to lead the next phase of our success. This is your opportunity to step into a key leadership role where your experience...
...part of CNBC, is building the next generation of AI-powered equity research for individual investors. We continueoperatinglike a startup... ...looking for a highly driven and intellectually curious equity analyst to join our team to build a new generation of AI-powered...