Job Description

Project Role :

Application Lead

Project Role Description :

Lead the effort to design, build and configure applications, acting as the primary point of contact.

Must have skills :

Microsoft SQL Server Integration Services (SSIS)

Good to have skills :

NA

Minimum

5

year(s) of experience is required

Educational Qualification :

15 years full time education



Summary: As an Application Lead, you will lead the effort to design, build, and configure applications, acting as the primary point of contact. Your typical day will involve collaborating with various teams to ensure that application requirements are met, overseeing the development process, and providing guidance to team members. You will also engage in problem-solving activities, ensuring that the applications are functioning optimally and meeting the needs of stakeholders. Your role will require you to balance technical expertise with effective communication, ensuring that all parties are aligned and informed throughout the project lifecycle. Key Responsibilities: o ETL Development: Design, develop, and maintain ETL processes using SSIS to extract data from various sources, transform it according to business rules, and load it into target databases or data warehouses. oStored Procedures & SQL Optimization: Create and optimize SQL queries, stored procedures, and functions for efficient data retrieval and manipulation oData Warehousing: Build and manage data warehouses to support reporting and analytics initiatives. oPerformance Tuning: Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data. oDocumentation: Document data flows using tools like Visio, Draw.io, and source-to-target mapping documents in Excel. oCollaboration: Work closely with cross-functional teams to understand data requirements and deliver scalable data solutions. Required Skills & Qualifications: oTechnical Skills: o Proficiency in SSIS for ETL development. o Strong experience with SQL Server, including writing and optimizing stored procedures. Queries and Schema o Experience with data warehousing concepts and design. o Familiarity with SSRS for reporting purposes. o Knowledge of data governance, data architecture, and data quality validation. o Solid understanding of .NET and ability to write, debug, and optimize .NET code o Experience: o 4+ years of experience in ETL development using SSIS. o Hands-on experience with stored procedures and T-SQL. o Hands on experience in .NET development o Soft Skills: o Strong analytical and problem-solving skills. o Excellent communication and collaboration abilities. Preferred Skills: o Experience with cloud platforms (e.g., AWS, Azure). o Familiarity with BI tools like Power BI or Tableau. o Exposure to Agile methodologies. Additional Information: - The candidate should have minimum 5 years of experience in Microsoft SQL Server Integration Services (SSIS). - This position is based at our Bengaluru office. - A 15 years full time education is required.




15 years full time education