Posted Aug 16, 2014
- Excellent written and verbal communication skills - must be able to communicate with our US staff
- Author code for projects that meet functional and technical requirements within project timelines. Toolsets required for this development are Informatica PowerCenter and SQL Server.
- Participate in team standups providing status on development activities.
- Participate in providing estimates for development efforts.
- Develop technical designs for implementation on assigned features in collaboration with dev team lead, and provide supporting documentation as needed.
- Communicate with development team on technical decisions, to facilitate understanding and consensus on approach.
- Write code that adheres to best practices and company standards with a philosophy of “simpler is better”, but also ensuring the security, scalability, and performance of the application.
- Demonstrate a high level of effectiveness in issue resolution and performance tuning.
- Write unit tests and test code thoroughly before checking into repository.
- Determine appropriate updates to data warehouse landing, staging and data mart tables and develop SQL scripts to update data as required to maintain dimensions and address issues. Understand impacts of updates and identify proper approach applying understanding of Type 1 and Type 2 changes and CDC.
- Write supporting documentation for deployment of software, assist in deployments, and develop deployment communications as required.
- Debug and find root cause of bugs found in software; troubleshoot and fix complex issues. Find root cause and fix performance issues relating to reports, queries and ETL processes.
- Identify opportunities to improve code and provide cost effective solutions for those opportunities.
- Identify ways to automate coding processes and make recommendations to manager.
- Work well with external team members to facilitate the development of synergies between the EDW/BI team, other IT teams and customer groups. Address job failures, monitor ETL processes to ensure data will be available on time for all BI users.
- Provide 3rd level support to BI users which will be in the form of analyzing data in the data warehouse to identify root cause of problem or validate as non-issue.
- Act as first point of contact for 3rd level on call for the network operations center (NOC) and address failed or stopped ETL processes accordingly to ensure data will be available for users by 8 a.m. CST.
- Advanced ETL development experience (Informatica PowerCenter) is mandatory.
- SQL server development experience is required.
- SQL query and performance tuning skills are highly preferred.
- Prior experience working with these tools in a data warehouse environment is highly preferred
- Knowledge of OLAP data sources and SSIS is a plus, but not required.
- Data Quality tools experience is a plus.
- Prior experience with OBIEE, BIP, or Siebel is a plus, but not a requirement and lack of these will not inhibit the candidate from being exceptional in the role.
- Prior experience with agile methodology and TFS, also a plus but not required.
Job Details
Stewart Pakistan Pvt. Ltd.
“With over a decade long presence that still stands strong, Stewart Pakistan offers IT, Consulting, Process Improvement and Business Process Services to clients all across the globe. Stewart Pakistan has established itself as a front-runner in delivering projects of varied magnitude and businesses. Stewart Pakistan is a result-oriented company that strives for complete customer satisfaction with a proven track-record of quality, and professionalism. Our core strength lies in the group of people who work in our company and avidly ensure that the highest possible standards and principles are incorporated for the development of business solutions and services” Our Vision: “To be the global technology and operational support services company that enables Stewart to become the most admired real estate services company” Our Philosophy: “As a Stewart Operations Services Center, Stewart Pakistan has been directed to focus on initiatives that enable business units to increase customer satisfaction, drive revenue, decrease cost, and reduce risk. We develop, execute and support offshore strategies to deliver cost savings while ensuring consistent service level expectations. We strive for the integration of local and remote workers into seamless project teams with integrated processes – One Global Stewart”
What is your Competitive Advantage?
Similar Job Titles
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Muzammil Baig
Digital Marketing Manager
IT Services Group
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Aqib Irshad
Head of HR, Training & OD
FINCA
Ali Aziz
CEO
Shopistan
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Zohaib Ali
Marketing Manager
Digital Online Devices
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
