Job Description

JLL empowers you to shape a brighter way.Our people at JLL and JLL Technologies are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients. We are committed to hiring the best, most talented people and empowering them to thrive, grow meaningful careers and to find a place where they belong. Whether youve got deep experience in commercial real estate, skilled trades or technology, or youre looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward.ETL Developer - DatabricksJLL Technologies Centre of ExpertiseWhat this job involves:#JLLTechAmbitionsAbout the roleJLL, an international real estate management company, is seeking an ETL Developer to join our JLL Technologies Team. We are seeking candidates that are self-starters who can work in a diverse and fast-paced environment. We are looking for a candidate to provide Azure Databricks, Python, PySpark, SparkSQL, Azure functions, Delta Lake, Azure DevOps CI/CD along with Informatica PowerCenter, Data Quality, Control M, SSMS expertise to design and build the required Solutions for our Clients.Responsibilities

• Act as a Lead Engineer to drive project solutions and the team & mentoring them on technical expertise as required
• Independently plans, designs, develop, executes and monitor complex data integration activities to support project delivery and daily operation.

• Expert in defining, implementing, debugging and optimizing data integration mappings and scripts from a variety of data sources.
• Spearheads development of ETL code, metadata definition and models, queries, scripts, schedules, work processes and maintenance procedures and identify opportunities to optimize the sizing, performance and efficiency of existing processes/procedures.
• Mentors less experienced analysts on proper standards/techniques to improve their accuracy and efficiency.
• Perform the unit testing, system integration testing, regression testing and assist with user acceptance testing.
• Articulates business requirements in a technical solution that can be designed and engineered.

• Consults with the business to develop documentation and communication materials to ensure accurate usage and interpretation of JLL data.
• Develops technical understanding of how the data flows from various source systems and source types to fine tune data integration solution.
• Work independently or as part of a team to deliver data warehouse ETL projects.
• Adhere to established standards and best practices and provide input for improvement of those processes.
• Self-motivated team player who can work with minimal supervision and can adapt to a quickly changing environment.

• Maintain a high-volume data warehouse application.
• Ability to work on multiple tasks simultaneously, ability to switch between tasks and work in conflicting priorities

Sounds like you? To apply you need to be:Experience & EducationAt least 8 to 10 years of relevant experience is desired.Having a Bachelors/Masters degree in Computer Science/Information Systems from a reputed UniversityStrong computer science fundamentals.Strong in communications with business stakeholders:Requires strong ability to communicate and manage stakeholders, and to drive collaboration between the business team and the various project teams including application support teams, network teams, database teams, and storage and server teams across the regions.Excellent technical, analytical, and organizational skills.Effective written and verbal communication skills, including technical writing.Technical Skills & Competencies

• Azure Databricks
• ETL knowledge
• SQL knowledge
• Python
• PySpark
• SparkSQL
• Azure functions
• Delta Lake
• Azure Data Factory
• Azure DevOps CI/CD
• Good to have knowledge on ADLS Gen2, Kafka stream processing
• Good communication

• Self-starter and willingness to learn other technology including Informatica and Go Anywhere
• Must have hands-on experience with commercial Integration products including Informatica PowerCenter 10.x, Data Integration Hub, Power Exchange, Informatica Cloud, Data Quality, Master Data Management, Address Doctor
• Must have experience in Windows PowerShell / UNIX Shell Scripting, Control-M to automate the job runs.

• Must have basic hands on MSSQL Server Database development experiences including:

• Stored Procedures
• Explain Plans
• Constraints
• Views

• Materialized Views
• Export/Import Utilities

• Must have strong knowledge of Software Development Life Cycle including requirement analysis, design, development, testing, and implementation. Hands on experience in performance tuning of sources, targets, mappings and sessions.
• Support:

• Ability to identify critical system health issue and flag them for discussion and resolution.

• Constantly questioning due to fluid processes and complexity of environment.
• Proven experience in common support activities including

• User Management
• Access management
• Object management (folder, connections, rules etc..)

• Backing up the repositories
• Code migration across multiple environments
• Performance diagnosis/improvement
• Ability to handle and co-ordinate Sev1 tickets

• Maintaining standards:

• Proven experience in following standards and helping other adopt standards
• Making sure that code is sync across all three environments.
• Ensure development teams are following appropriate standards

What we can do for you:At JLL, we make sure that you become the best version of yourself by helping you realise your full potential in a fully entrepreneurial and inclusive work environment. If you harbour passion for learning and adapting new technologies, JLL will continuously provide you with platforms to enrich your technical domains. We will empower your ambitions through our dedicated Total Rewards Program, competitive pay and benefits package. Its no surprise that JLL has been recognized by the Ethisphere Institute as one of the 2021 Worlds Most Ethical Companies for the 14th consecutive year.Apply today!Location:On-site xe2x80x93Bengaluru, KAIf this job description resonates with you, we encourage you to apply even if you dont meet all of the requirements. Were interested in getting to know you and what you bring to the table!JLL Privacy NoticeJones Lang LaSalle (JLL), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services. We take our responsibility to protect the personal information provided to us seriously. Generally the personal information we collect from you are for the purposes of processing in connection with JLLs recruitment process. We endeavour to keep your personal information secure with appropriate level of security and keep for as long as we need it for legitimate business or legal reasons. We will then delete it safely and securely.For more information about how JLL processes your personal data, please view our .For additional details please see our career site pages for each country.For candidates in the United States, please see a full copy of our Equal Employment Opportunity and Affirmative Action policy .Jones Lang LaSalle (JLL) is an Equal Opportunity Employer and is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process xe2x80x93 including the online application and/or overall selection process xe2x80x93 you may contact us at . This email is only to request an accommodation. Please direct any other general recruiting inquiries to our page
I want to work for JLL.

Jones Lang LaSalle