Senior Analyst - Technology Data and Information Management
We’re JLL. We’re a professional services and investment management firm specializing in real estate. We help organizations around the world achieve their ambitions by owning, occupying and investing in real estate.
We’re a Fortune 500 company. We work across 80 countries, in 280 different offices, with a team of over 77,000 individuals.
And we look after a property portfolio of over 4bn square feet, all on behalf of our clients.
If you’re looking to step up your career, JLL is the perfect professional home. At JLL, you’ll have a chance to innovate with the world’s leading businesses, put that expertise into action on landmark projects, and work on game-
changing real estate initiatives. You’ll also make long-lasting professional connections through sharing different perspectives, and you’ll be inspired by the best.
We’re focused on opportunity and want to help you make the most of yours. Achieve your ambitions join us at JLL!
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 sufficient detail such that a technical solution 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.
Maintain a high-volume data warehouse application.
At least 4 years of relevant experience is desired.
Having a Bachelors / Master’s degree in Computer Science / Information Systems from a reputed University
Strong 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.
Must have hands-on experience with commercial integration products including,PowerCenter 10.xData Integration HubPowerExchangeInformatica CloudData QualityMaster Data ManagementAddress DoctorGo Anywhere
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 ProceduresExplain PlansConstraintsViewsMaterialized ViewsExport / 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 includingUser ManagementAccess managementObject management (folder, connections, rules etc.
Backing up the repositoriesCode migration across multiple environmentsPerformance diagnosis / improvementAbility to handle and co-ordinate Sev1 tickets
Maintaining standards : Proven experience in following standards and helping other adopt standardsMaking sure that code is sync across all three environments.
Ensure development teams are following appropriate standards
Teamwork : Must have experience in working in 24x7 onshore / offshore team environmentAbility work independently and as part of teamAbility to collaborate work in shift timing with the offshore admin team of different time zones.
Personality Traits Required Ability to work on multiple task simultaneously, ability switch between tasks and work in conflicting prioritiesExcellent communication skillsExcellent organization skillQuick learner
What you can expect from us
You’ll join an entrepreneurial, inclusive culture. One where we succeed together across the desk and around the globe.
Where like-minded people work naturally together to achieve great things.
Our Total Rewards program reflects our commitment to helping you achieve your ambitions in career, recognition, well being, benefits and pay.
We’ll offer you a competitive salary and benefits package.
Join us to develop your strengths and enjoy a fulfilling career full of varied experiences. Keep those ambitions in sights and imagine where JLL can take you...
Location : Bangalore (Limited travel may be required as per project needs).
Hours : 08 : 30 17 : 00 hrs Monday Friday. Regularly and reliably, work when scheduled and perform essential job functions.
This would include normal business hours, extended hours and travel when required.